Best Answers

I am not that familiar with the SQLexecutor, but I was wondering something. When I am running the SQLexecutor, I don't get any feedback, so therefore I was wondering if I can get some kind of feedback mechanism that the database operations have occurred succesfully or not

I have a table in which some rows have identical values. I would merge the identical rows into one by using aggrator.I want the sum of row values ​​to be written to a new row.the aggragator does not calculate a sum of the values.Attached you will find the pictures that may help you to better understand my description.column Anzahl_Gas_HA must be 2177 after using aggregator.

I have two polygons which overlaps and I use transformers to have the intersection (I tried Clipper, AreaOnareaoverlayer, spatialrelator and intersection) . So, it created a new polygon (the overlap of the two polygon.) The problem is that this new polygon belongs (in the attribute table) to one of the two polygon (The feature name of the new polygon is the name of one of the polygon) but I would like the name of the both polygon even if it created two overlap (the same but one with the name of the first polygon and one witch the second). Thanks you 

Hi,   I have to transform a series of points to a line consisting of cubic Bezier curves. I couldn't find a function to do that in existing transformers or the Python API of FME Objects. The Generalizer (NURBfit algotirhm) creates a spline curve, but it's not exact cubic Bezier curves. The expected line has to pass through the both ends of each 3 segments.     So, I wrote the following script. Is this the "re-invention of the wheel"? If you know an existing function (transformer or Python function) that creates cubic Bezier curves based on control points, please let me know.    -----  import fmeobjects   class CubicBezierCurveReplacer(object):     def __init__(self):         self.set_coefficients(32)              def set_coefficients(self, n):         self.n = n         r = 1.0 / float(self.n)         s = range(0, self.n)         self.k0 = [(1.0 - (r * m))**3 for m in s]         self.k1 = [3.0 * (r * m) * (1.0

is there any Geometry smoothing function in FME needs polygons edges smooth  

Hi everyone, I have a XML question.I got an XML structure from filegdb_polygon via GeometryExtractor (GML 3.2.1) and XMLFragmenter:<gml:Surface gml:id="ID_1" srsName="MysrsName" srsDimension="2"><gml:patches><gml:PolygonPatch><gml:exterior><gml:LinearRing><gml:posList>"list of xy coordinates"</gml:posList></gml:LinearRing></gml:exterior></gml:PolygonPatch></gml:patches></gml:Surface>However, my XML structure should look like this:<gml:MultiSurface srsName="MysrsName" gml:id="ID_1">  <gml:surfaceMember>    <gml:Polygon srsName="MysrsName" gml:id="ID_2">      <gml:exterior>        <gml:LinearRing>          <gml:posList srsDimension="2" count="####">"list of xy coordinates"</gml:posList>        </gml:LinearRing>      </gml:exterior>    </gml:Polygon>  </gml:surfaceMember></gml:MultiSurface>I used XMLUpdater to delete the attribute/gml:Surface/@srs

Hi all.I'm trying to consume a WFS service (Geoserver), which for some reason only works as version 1.0.0. This even though that the capabilities document clearly says 2.0, and accepts all versions.In versions 1.0.0 (and 1.1.0?) the parameter "typeName" is used to specify the layer (feature type), but this is later renamed to "typeNames" (with an S).I get an HTTP error 401 from the service when attempting to fetch data in version 1.0.0, but the very same URL works if I just add an "s" to "typeName".Can FME be tricked into instead using or adding the "typeNames" parameter?Actually, URLs may contain both "typeName" and "typeNames" parameters with the same value, which would make the requests robust against version problems. Can this be achieved?Cheers.

I try to retrieve Data from the Microsoft Intune MDM using OData. The OData FME Reader only supports Basic and NTLM Authentication thought and dhe OData REST API only supports OAuth so I had to resort to the HTTPCaller. This is similar to this Question I created a new Web-Service from the "Microsoft Azure Active Directory (Template)" template and extended the API Permissions in the Azure Portal for the Client App with the get_data_warehouse Permission. I already created it for the "Microsoft SharePoint Online" Web-Service (which works fine using the SharePoint Lists Reader).Authentication URL:https://api.manage.microsoft.com/get_data_warehouse" alt="https://login.microsoftonline.com/e0aedced-9266-403b-b320-a41XXXXXXX/oauth2/v2.0/authorize?scope=https://api.manage.microsoft.com/get_data_warehouse" target="_blank">https://login.microsoftonline.com/e0aedced-9266-403b-b320-a41XXXXXXX/oauth2/v2.0/authorize?scope=https://api.manage.microsoft.com/get_data_warehouse offline_access&respo

Hi.I'm exploring the possibility of making request to a secure server using FME.The webservices to be called require that the requests are accompanied by a company or function certificate. It will typically be stored in a certificate repository on the machine.I can make it work manually using HttpCaller with authentication = "Single Sign-On", but this prompts me for a certificate password every time, and the final script needs to run fully autonomously (on an FME Server).Any help is appreciated.Cheers.

Hello  I have 4 different IFC models and wish to merge them into one.  Could you please help me ?  thanks in advance.

I am trying to clip a point cloud using the values of a csv using the reader, but the PointCloudFilter transformer does not accept the @Value() field. I am at a loss now. Any help would be great. 

I'm trying to convert datetime values in ISO format to FME, because PostgreSQL database refuses to write that value as "timestampz". I have tried to both autodect and %Y-%m-%dT%H:%M:%S$The preview show correctly the conversion:But the ouptup stays the same:Any hints? Thanks

On this picture, i have a circle which contain a polygon.I would like to know how i can obtain this circle when i have the coordinates like in this picture.The circle doen't pass by all the points.Any tips and trick ?Thanks

I have an OBJ file that I am converting to a Multipatch in an Esri FileGeodatabase. The process mostly works but the colored mesh in the georeferenced OBJ file appears as a white mesh, with no color, in ArcGIS Pro. How can I preserve the detailed colors?

Hi Safe team, Do we have an idea on which formats support mesh vertex colors? I can't see Information in the quick facts area for formats (e.g., OBJ) about vertex color support. It seems like it's becoming more an more common to see mesh objects with vertex colors instead of a texture. I'm just wondering what formats FME can read and write to where vertex colors are supported. So far form testing I can see OBJ supports reading them? A follow up question, is there anyway to convert these to regular appearances or a texture atlas for formats where the vertex colors aren't supported? Perhaps @daveatsafe​  has an idea? 

I am running a workbench to split transactional work orders onto different worksheets in an .xlsx writer using FME 32-bit 2021.1.6 We have hit the 2gb memory ceiling due to the number of rows, as a work around I have installed the 64-bit version, but now i find where before it took a few minutes to write out the .xlsx output in 32bit the 64-bit seems to slowly parse through the feautres as it write them out, its much slower over an hour and I stopped the tranlsation. Is the performance really so different in 64-bit?

I have this workbench in which I combine multiple CSV-files and write out to one Excel-file. the file contains aprox. 190K rows. In the previous FME version (2020.x) I used this workbench it took a few minutes. Now the XLSXW is taking hours to write the output.  Did something change in the way the XLSXW writer functions? I did a test by writing to a CSV file, this took seconds to complete, so clearly the problem lies with the Excel writer. Hopefully someone knows about a fix. Cheers, Jaap

Hi,I am wanting to upload files to an instance of NextCloud as part of a distribution service for an department; this would consist of uploading a zipped folder/files to nextcloud, before emailing a link with the data (with shared permissions) to the requester.I am running FME Desktop 2020.0.3.0, I am able to figure out how to download via the HTTPCaller (GET with specific URLs), but uploading (PUT or POST) does not work.Has anyone figured out how to utilize HTTPCaller with NextCloud fully?Thanks! https://docs.nextcloud.com/server/20/user_manual/en/files/access_webdav.html

Hello community, I have a street dataset with 2139 records, with each one being a line (for those in UK LAs, note that it is the LSG). It includes a field called ‘street or numbered street’.  For 2040 of the records the value in the ‘street or numbered street’ field is a named street (e.g.: Acacia Avenue). For 28 of the records the value in the ‘street or numbered street’ field is an A road (e.g.: A312). For 14 of the records the value in the ‘street or numbered street’ field is an B road (e.g.: B204). For 57 of the records the value in the ‘street or numbered street field is an C road (e.g.: C5840044).  I want to filter out the three separate road types: A roads, B roads and C roads. I want to ignore the 2040 named street records.  What’s the best way to do this? A filter? Query via the Text Editor within the Writer? What would the code be?

I have a series of 2D polygons with attributes for slope and aspect. I want to rotate them about a horizontal plane (using a 3DRotator) so that they become 3D shapes with these properties of slope and aspect. However, I want the spatial extent of the shape to stay the same, i.e. if I were to force it to 2D them again, they would look identical to how they did before. Effectively, this means that all of the vertices need to be elevated/dropped in the vertical plane. This is not so much a rotation as a stretch. As an example, if the polygon has a slope attribute of 80 degrees, by the time the shape has been made into a 3D sloping polygon, the planar extent of the shape would be much smaller and, if it were forced to 2D again, it would be also much smaller. The higher the "slope" value, the more the shape would shrink in its planar extent. Does anyone have any suggestions for how to achieve this? I effectively want the reverse of a 2D forcer.

Hi, The GoogleBigQueryConnector return the error of Python Exception. I'm not too sure what should I do to resolve this exception. I'm using the new version of FME 2022.1. Previously this transformer is working well in the FME 2020.Message error detail:Python Exception <ImportError>: cannot import name 'decodeWWJDString' from 'fmegeneral.fmeutil' (/Library/FME/2022.1/python/python39/fmegeneral/fmeutil.pyc)PythonFactory failed to load python symbol `fmepy_google_bigquery.connector.GoogleBigQueryConnector'Factory proxy not initializedGoogleBigQueryConnector_CALLER (PythonFactory): PythonFactory failed to process feature Can someone help me on this please. Thanks

Is it possible to move files to an error directory when a FeatureWriter fails? Unfortunately, I have not found a way so far. Is there any other way than to use an FMEServer Automation that triggers another FME Workbench in case of an error, which only moves files to a directory? Is it possible to achieve this with only one FME Workbench?

I am attempting to build schema features, with coded value domains, from a schema specification in Excel and to write them out to geodatabase with a dynamic writer. I am almost there, but I am missing something, and I do not understand the structure and requirements for schema features quite deeply enough to solve the problem. I have read through the set of Dynamic Workflow tutorials and other pages, like Deriving Destination Schema from Schema Feature, but none of them quiiite go far enough to address my situation. As I am building and writing out coded value domains, I am specifying the fme_format_short_name (= GEODATABASE_FILE) attribute on the schema features and including the attribute{}.native_data_type on all attributes in the list, with the value in the required "coded_domain( ... )" in the case of attributes with a domain. I also want to include the attribute alias in the attribute{} list. Finally, I have set fme_geometry{0} accordingly for each schema feature.

Hi, I am migrating my fme server installation to a new server, but I encountered error during the restoration process in the new fme server environment. The backup is from FME Server 2021, and I am restoring the backup in FME Server 2022. I have captured the error message and attached in this post. I would like to ask for some guidance here and hope to hear from the others who faced the same problem before.. Thanks.

Hi, Need to transfer a csv file to the vendor SFTP site.The vendor provided the following specs:Account: xyzftpPassword: xxxxxxxxxServer Name FTPCA1.xyz.comIP Address 22.222.22.222Location Microsoft Canada Azure CloudClient IP Restrictions Not SupportedProtocols SFTP (SSH File Transfer Protocol)FTPS (FTP over SSL), Passive ports 5000-5099Certificate Yes. For FTPS SSL EncryptionAdditional Notes - You must use an FTP client which supports SFTP or FTPS for connection to our servers.- Do not use a web browser. - Do not use the DOS/CMD FTP program. It does not support SSL.- Supported Protocols--SFTP - SSH File Transfer Protocol)--Automated login by public key is supported by request. --FTPS (FTP over SSL)--Both the FTPS Explicit and FTPS Implicit protocols are supported. --F13Passive ports 5000-5099 are randomly used for FTPS encrypted data transfers. Clients must be permitted to connect outbound on these ports. See below my FTPCaller Transformer based on the above:Does it looks correct? No