FME Form

Hi folks, I’m trying to setup a writer to a MySQL database table with a calculated column. When importing the table from the data source, FME (correctly) ignores the calculated field, so when I look at the table’s attributes (screenshot below), the column is not listed. However, when I try to use the writer, the calculated field gets included in the generated SQL insert and so the write itself fails with an error that a calculated field can’t be written to:Error executing SQL query ('INSERT INTO `StageDate` (`Date`,`Year`,`MonthNumber`,`MonthName`,`Day`,`Weekday`,`WeekdayName`,`IsWeekend`,`AcademicYearCode`,`AcademicYearDescription`,`FiscalYearDescription`,`Checksum`) VALUES ('19000103','1900','1','January','3','3','Wednesday','0','1899','1899-1900','1899-1900',NULL),...: 'The value specified for generated column 'Checksum' in table 'StageDate' is not allowed.' Note the `Checksum` in the column list and the NULL at the end of the feature values.

We have been running FME Desktop 2022.2 on Windows Server 2019 machines for over a year, but found out last week any function calls to datetime or datetime reformating fails with this error “Failed to load timezone data. current_zone() failed: A mapping from the Windows Time Zone id "" was not found in the time zone mapping database”. For example, in the AttributeCreator, an attribute creation with the value being @DateTimeNow() got the above error. Anybody experienced this before and knew of a fix? Unfortunately I don’t have the option to reinstall FME on those machines.

Hello, A related question & answer to mine is here:However, in my case, the layer being updated will likely contain features already.  In the DWG Writer, selecting to “Preserve Template File Model Space Data” will add data to the layer being updated, but of course will also preserve the existing features already present on that layer.  This essentially is just adding more data to the desired layer (resulting in many duplicate features) - which I don’t want.  I want to replace the features on that layer and preserve the features on the other layers.  Because I want to preserve other layers as they exist already in the template, I can’t select to not “Preserve Template File Model Space Data” in the DWG Writer.Wh

I have a dataset that contains the “_related_suppliers” field that contains either 1 or 0; I would like to add a counter that will increment, whenever the _related_suppliers field changes;  Is this possible?

Hello,I am abeginner with FME.I created a workplace test with a reader component PostgreSQL, a transformer component et a CSV Writer component.All it's works.I would like catch errors if there is un problem with de connexion to database or to write the csv file in a log file or send mail but there isn't a connection error like Talend to catch errors.How can I catch errors with writer or reader component?Thanks for your help

I have two workbenches, in which the emailers fail every night, the error being:Emailer_<Rejected> (TeeFactory): Emailer_<Rejected>: Termination Message: 'Emailer output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''Error encountered while calling method `input'for the one that runs first, and:Emailer: <class 'TimeoutError'>: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respondfor the second. First is an all out error that terminates the workbench, the second just being a warning, but the outcome is the same - no ema

Is it possible to write lines into IFC4x3 with FME and how to do that since IFC4x3 now supports lines?

Hi there,Today I noticed something peculiar when working with data from a PostgreSQL DB (that includes the PostGIS extension).Initially I used the PostgreSQL reader in an SQLExecutor to query for some specific data, and also included the geometry column 'standardized_location’ in the select statement.That seems to output the geometry column in a ‘Hex Encoded OGC Well Known Binary’ encoding. Using the GeometryReplacer I turned this back into a ~'fme geometry object’. If I then however filtered on the GeometryType, it shows up as a Polygon, where I knew in the PostGIS DB the standardized_location geometry column was defined with type ‘geometry(MultiPolygon, 4258)’.I then used the ST_AsEWKT(), ST_AsGML() and ST_AsGeoJSON() functions to return the geometry from the database in some different encodings. If I use the GeoJSON or GML encoding in the GeometryReplacer, the geometry does still show up as a MultiPolygon feature. Also the EWKT encoding d

Hi allFirst time poster, long time reader of all the great advice on this forum.using FME 2021.2.6 (work limitation)I am currently having issues regrinding my CSAR (Raster and Pointcloud) files while keeping the lowest value in its original XY position in the regirded area. Example of regirded squares with the smallest values being picked.Note: the gridded squares are just a visual example, I have potential looked at applying a Buffer to the soundings based on the (SCALE) area they fall into but have had no success yet. 

I have a summary query with GROUP BY, HAVING, and ORDER BY clauses and I would like to send an email with the results from this query. My workspace can send html results of a query of listing all the records but that is not the summary I’m looking for. The Aggregator transformer doesn’t seem to have what I’m looking for either. Is there a way to send the result of this query shown below? My data is in SQL Server.  SELECT caseID 'ID', count(*) 'Count'  FROM my_table  group by caseID  having count(*) > 1  order by count(*) desc 

Hello, i need some help here.I recently had my workbenches stop working. I am pushing updated into to referenced feature services in arcgis portal. I have re-created every reader, wriiter and parameter but cant get the same process to work again.I have made new workbenchs and new connection where i have just Readers and Writers (No Transformer) and i cant FME to push changes to featuer services.The error’s i am get is :ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Unable to complete operation.'. Details: 'No edits ('adds', 'updates', 'deletes', 'attachment edits', or 'asset maps edits') were specified.'BADNEWS: ARCGISPORTALFEATURES writer:Or“Could not find a layer/table matching the feature type”It Seem to JUST be a FME issues as i can access the Rest end point and use post to make edits, using fme i can update hosted serivces. It

Hello, I am struggling with conversion of several thousands of XML files (same scheme, but different attributes) in to single Excel/CSVThe tool works fine for single XML but not for multiple at once,The XML has nested levels so I am using xml_Id and xml_parent_id to navigate thru and join tohether with featurMerger tool.This is on the other hand the reason why I am struggling with the batch processing - since when  multiple files are processed at once, the xml_parent_id is the same among files and the so data are ovewriting themself, or they are rejected in the feature merge with multi-reference error. Don’t you know if there os a way how to proceed? To run one by one, for example with Loop in ArcGIS works but it’s soooo slow. Thank you!  

Hi everyone,I am currently comparing lines in database A and database B, and I want to categorize them based on distance from each other:If line A < 10cm line B → class 1If line A 10 - 30cm line B → class 2If line A < 30cm line B → class 3I thought I'd do this using the Clipper transformer: if part of line A is within 10cm of line B, and another part of line A is 12cm from line B, I want line A to be split. See my workflow below:I have my Clippers grouped by ‘type’ and ‘level’, so [railroads on level 1] are compared to [railroads on level 1] and [road lines on level 2] are compared to [road lines on level 2]. I have Overlapping Clippers set to ‘Clip Interim Results’ and I am generating a list of IDs from line B on line A. This is the situation im currently facing:

As title says, unable to convert lat/long to MGRS when latitude is -80.01 through -81. e.g., x= ‘100’, y= ’-80.1’ . I’m sure this isn’t the exact range but am able to reproduce the error.Was wondering if someone had additional information on how transformer calculated polar zones and, if there is preprocessing required for points located in south and north polar regions?Additionally, lmk as comment if you’re able to reproduce error in other FME versionFME Form 2023.2 

Hello, I’m trying to migrate data from a SQL Server 2016 spatial to a ArcSDE on SQL Server 2022. Using ArcGIS Pro 3.2 on same machine. I am using FeatureReader with schema and featureWriter with dynamic writer.   I don’t get any errors but I get thousands of this warning:GEODATABASE_SDE Writer: Renamed user attribute 'attribute{109}.name' to 'attribute_109__name' based on format constraints for invalid characters, length, and caseIf this waring occure the feature with this schema will not be written to the database, so it should yield an error not warning. yield waring on FME version 2023.2yields none-traceable error in version 2024.1Anyway I can’t figure out what it means. Any clues?  

I am transforming an IFC file to CityGML to upload the CityGML model to the 3DCityDB. I used the workspace published by Liz (https://support.safe.com/hc/en-us/articles/25407718003341-BIM-to-GIS-Intermediate-IFC-LOD-300-to-LOD-4-CityGML). The CityGML file created looks fine in the FME inspector. However, when I try to import the CityGML into the database, I get a lot of errors saying, “Failed to resolve XLink reference”. I was doing some research, and it seems the problem is that 3DCityDB does not support a gml:MultiGeometry with different dimensions (This is what they mention in the GitHub: In general, a gml:MultiGeometry is a collection of geometries that are allowed to have mixed dimensions: points (0D), curves (1D), surfaces (2D) and solids (3D). The 3DCityDB can handle geometries

Hello, Here is what I need to do: I have a workspace that includes the Emailer Transformer. When a file is placed in a folder and email is sent to the recipients notifying them that there is a file in the folder. The workspace works great. But, if one of the email recipients changes or needs to be removed for whatever reason, I am contacted and must go into the Emailer Transformer and manually delete the recipient. I would like to allow a user to open a spreadsheet of the email addresses and alter/delete them there rather than having to contact me. I need some help in getting started: If I have a list of email addresses in a spreadsheet, how do I include it or reference it with the Emailer Transformer? For example, if an email address is deleted or added to the spreadsheet, when the Emailer is going to send an email it will send the email to the list of recipients in the spreadsheet. Looking for some ideas on what transformer(s) I would need

I have installed FME Server on a machine called "fmeserver-dev.com" and also used this as the hostname.Later we switched everything to SSL (including the Websockets) and the external web host name to "(https://)fmeserver-prod.com".  Now, everything (Web UI, Services, Websockets...) is working fine, except the Topic Monitoring!  Using the Developer Tools of a web browser, I have identified that there is still a parameter 'webSocketServerName' set to the old hostname "fmeserver-dev.com". This must be causing the issue as the SSL certificate is not configured for that domain. How can I fix this?

Hi there,Can you please help me with this? Every time when a new report came in, I’d have to manually open the “FreatureReader” dialogbox and hit “Ok” (to close) so that the new attributes that are added in new report at the new folder location are emerged. Otherwise, it would just read previous attributes from the new report (in below case, up to the end of June, not the July columns). I’m just trying read an MS Access file that is stored dynamically in different folder each month.   

I am attempting to add a Geocoder transformer to spatialize address data using a published geocoding service on ArcGIS Server. When running the address data to the transformer, it rejects every feature with “Code 403: Access to this resource is not allowed”. The REST URL and Portal credentials are all correct and I am able to get to the service in a browser, as well as access and use the Locator in ArcGIS Pro to geocode addresses. With that being said, I don’t know why access to the resource would be disabled in FME but nothing else. Any insight or suggestions would be appreciated, thank you!

Hi!I would like to create a workbench with a lot of flexibility for the users. I use a FeatureReader with a spatial filter. I create a user parameter to chose the system of coordinates. So I would like to use it on the Featurereader but there are no option. Do you know a way to indicate to this transformer the system of coordinates? I suppose the spatial filter will work if the datas are in the same system but I would prefered to force it.Thanks !

I need to warp some data, so I'm using the RubberSheeter. This works fine except that in certain parts of the data I also need to create a gap. In broad terms the situation is as shown here: I need to cut along a line (the red line) and then use the control vectors (green) to pull things apart, leaving an empty void in the middle. What I've done is use a Bufferer / Clipper to remove a little bit from the original feature, along the cut line. Then I've added a bunch of control vectors, making sure they don't start exactly on the cut line but just a little bit on either side. However, FME is still showing data inside the gap and I really don't want to have to manually edit that. Does anybody have a suggestion?

I have had success in connecting to my corporate Sharepoint with the SharePointOnlineConnector using the web connection as set up in this HowTo: How to create a Sharepoint Web Connection (safe.com). Now I want to connect to another Tenant for which I have been granted access, but the connector only presents me with the Safe Template version for my web connection - even though I have set up and succesfully tested a new connection with a new name. I tried testing on a new machine, with no previous connections, and imported the new connection via xml then tried to add the web connection from within the transformer - same issue - the dropdown list doesn't show me the newly created connection (no matter what I call it):

What I try to do is to download a raster from a WMTS to use it as a background image for a report. I do not want to download the entire service, only a part to use as background. The result I get is only working on very zoomed out tile matrices, like 04, where the resolution is not useful: On deeper levels the FeatureReader is downloading a lot of tiles, which takes a very long time.The WMTS I use is a Dutch one, in epsg:28992. I wonder if I am doing something wrong, or this is never developed / tested for this coordinate system?The point is on 147513.92, 523126.09.The WMTS is 

Hi,I would like to merge polygons based on area up to a certain point. For example if I had 1000 polygons I would like to reduce that number to 100 keeping them as close as possible in size to one another. Does anyone know if this is possible in FME?Thanks for any help!B