FME Form

I have a very basic dynamic workbench that is reading data from SQL Server. Before writing data to a postgis database it is changing an attriubte name with SubstringExtractor. But it is extremely slow doing so after almost 3 hours 150 000 objects has been read by the reader. Typically 100 000’s of objects is handled in matters of minutes. It is reading about 25 different feature classes I need to migrate daily.I cant wait hours for the workbench to be complete. 2024-09-27 15:11:02|6056.7|  0.8|INFORM|Reading source feature # 470002024-09-27 15:11:53|6106.9| 50.2|INFORM|Reading source feature # 47500It takes 50 seconds to read 500 features? What is wrong? Why is the process so slow? I cannot understand where the bottle neck is.  

Hi! I have a FME workspace using FeatureWriter to write record to some tables. When running it from desktop, it populates the tables as expected. However, if I look at the log after job is completed, the "Features Written Summary" section at the end seem to be misleading by show "0", while I know that there are actually features written.Do I need to do any change in my FME workspace to add the count to the summary? Thank you!Below is the summary part of the log:Below is the part of log for FeatureWriter, which does give the count:

Hi! I’m new to FME. I’m trying to replace an existing feature class with data from a SQL query. I got it to work by using a Reader that specifies the existing table, SQLCreator then a Writer. When I add the writer, it’s using the “Copy from reader” option. Is there a way to use the FeatureWriter transformer and specify an existing feature class instead of using a Writer?

Hello,For the logged known issue in FME Form “FMEENGINE-82549” with “Excel Writer: Field Names row not written” the solution described is to Set the Row Height to 0 on the Feature Type, as discussed here. But what are the steps to do that?  Is it to simply just use transformer “ExcelStyler” and use setttings for “apply style to”?  Thanks!

I was wondering where the FME wallpapers are moved to? The old link does not work anymore.https://www.safe.com/support/support-resources/fme-downloads/wallpaper/

Dear All, Could you please let me know is there any transformer to do Radiometric calibration and Atmospheric correction in FME?  Kindly let me know the details. Thanks, Siva 

Is there a solution to correctly read sharepoint list attributes that are multi-select columns?When reading a sharepoint list with relevant permissions to read,write etc. the data table returned shows only <NULL> values for any column that has multi-selection enabled - adjacent columns with single select settings that hold the same data type (username) are returning the expected values - only the column settings differ.[Note the column setting for allow selection of {people only / people and groups} may also play a part in this question]The column that is returning NULL only has settings as below: List columns that return the expected values have settings: 

I could use some help in understanding how donuts are stored in OSM XML. Or more specifically, why FME Data Inspector is not constructing the donut from the XML. Here is the simple shapefile test data I’ve created.In FME, I’m writing out the OSM using the normal writer:When I read that OSM back into Data Inspector, it doesn’t recognize the shape as a multipolygon. The geometry type is fme_no_geom:The XML code is below. I’m seeing the relation present, so I’m not sure what else is required.<?xml version="1.0" encoding="UTF-8"?><osm version="0.6"> <node lat="34.6596384" lon="-87.0320968" id="-7"/> <node lat="34.5631538" lon="-86.8849822" id="-10"/> <node lat="34.7427899" lon="-86.9769288" id="-8"/> <node lat="34.4741373" lon="-86.9217608" id="-4"/> <node lat="34.6293808" lon="-86.7401662" id="-2"/> <node lat="34.5063457" lon="-87.0619795" id="-5"/> <node lat="34.5536885" lon="-86.9194622" id="-16"/> <node lat="34.5669396" lon="-87.

I was able to do a cumulative count of duplicate values (where duplicate is “-1” only) using a Group By on a Counter transformer shown below. (Added note: I should have added this to remove ambiguity - SORRY. The output as shown below in the Preview is the desired output. I only care to know the number of consecutive sequential values when the value is “-1”. If the pattern changes and another series of duplicate “-1” appears, the count starts with “1” again. I don’t care if the pattern for duplicate values are greater than “0”, like “2420” on the Preview.)  Since I have more than a dozen of these attributes, I’d like to use an AttributeCreator instead but I can’t seem to use the CurrentAttribute() to accumulate duplicate values.In addition, everytime a sequence of “-1”s begin (as shown in row 143 above), count starts at 1 again.Any suggestions?

Hello everyoneI need to run a test process that reads a file in netCDF format and clips it using a Clipper. I am using a shapefile for clipping, but the Clipper is giving me the following error:Clipper_<Rejected> (TeeFactory): Clipper_<Rejected>: Termination Message: 'Clipper output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' Here is an example of the process I'm trying to test.I want to write two output files, one in NetCDF format and the other in Geotiff format.Afterwards, I need to open one of the result files and the original netCDF file in QGIS to check the values.The goal of this test is to verify why, in another process, the clipped result is altering some values related to the original global input file (netCDF). Thank you in advance for any assistance you can provide.

Hi,For the writer ArcGIS Portal Feature Service why using by default a deprecated WKID (102100) ? It’s even written in the FME doc  : hereAccordingly to the Spatial Reference organization, this WKID has been deprecated for quite a while now (before covid!) We need to use 3857 instead. So I don’t understand why FME continues to use the old one by default. Why don’t we see his replacement : 3857 ?Thanks ! 

Hello,There have been some previous posts about converting OSM data in FME, but I’m hoping to breath some new life into the conversation. I have an Overpass Turbo query here meant to query ski area boundaries, lifts, and runs within Colorado. The query works just fine in Overpass Turbo, and I’m able to read the raw XML data into FME with the HTTP Caller no problem. The issue I’m running into is visualizing the data beyond that. I’m aware of the example workflow that is similar to my process, but I don’t understand how the XSLT Processor and XML Fragmenter transformers work. If I use those transformers in my workflow, all the coordinate information seems to disappear when the data is fragmented.Does anyone know how to properly display the XML data in FME? I might need a geometry filter to split out points, lines, and polygons, but I don’t think that’s what is holding me back currently. Any help would be greatly appreciated!

I have data stored in a SQL server database in a native geomtry type format. I would need to migrate this data to a postgis database and store the data using simple geometry (point, lines and polygons instead of the generic geometry datatype).I have seen options how to modify the destination schema. But it does not include how i can specify the geomety type. https://support.safe.com/hc/en-us/articles/25407537293069-Dynamic-Workflows-Destination-Schema-is-Derived-from-a-Schema-FeatureMy data is stored as geometry but it is known and expected that specific tables will polygon or lines. Is there a somewhat simple way to do this without creating the destination tables beforehand?  

Hi All,I’m creating an archiving workbench for our Esri Enterprise SDE databases. I’m trying to automate checking for an existing version of a raster in either our shared or archived databases and then assigning a version suffix according to if the data already exists in one of the databases. I have the majority of the workbench sorted but struggling to automate renaming the raster to include the version suffix when writing to archive.In my example below I’ve identified that there are two existing versions of the test data “gen_aaa_aaa_test_ras” so I’ve created a name field “archhiveddataname”, which contains the the name I want to give the raster when I write it to Archived “gen_aaa_aaa_test_ras_2”. I can access this information from the schema port but not from the generic. If I include the information from the schema port I get an error saying that I’m trying to write non-raster geometry and the workbench fails. I’m using FME 2023.1.2.0 (20231110 - Build 23641 - WIN64) Thanks in adv

Reading the documentation and online search regarding this transformer - ArcGISOnlineConnector I have some questions. The Actions are pretty self-explanatory and it seems possible to both upload and download data from AGOL. However that does not seem to be the case. I can list every Group and item. However when I try to Download it just says: cannot download file of type 'Web Scene'cannot download file of type 'Scene Service'cannot download file of type 'Feature Service'cannot download file of type 'WMS'cannot download file of type 'Geocoding Service' I was hoping to download a Geopackage or something else. Is there anything that CAN be downloade? Any other usage areas for this Transformer?

Hello,We have an excel file with different first lines.For this reason, we have defined the featurereader in the excel file, which allows us to have the column names in A, B, C ... and not the column name with the values of the first line.This works very well, but as soon as we put a parameter in the dataset (instead of a hard-coded directory path), we lose the A, B, C field names and can't use them generically.do you think there's a solution for keeping column names in A, B, C?Best regards

Hello fellow FME form users,I had a script which worked in FME 2022.2, but not in FME 2023.2. I then get the following error:<WMTS> An error occurred while generating the GetTile URL, please check the dataset URL and selected parameters Another weird thing is when I make a fme workspace app based on this fme script, then I don't get the error at all and I manage to get results. It's just not clear  to mer why the script doesn work in fme workbench 2023.2I have checked the following parameter to yes: “Prefer Dataset to URL” This is our curernt fme form build:FME(R) 2023.2.0.0 (20231201 - Build 23764 - WIN64) and this is our curernt fme flow build:FME Flow 2023.2.1Build 23774 - win64I have attached the workspace, so that others can also test with my workspace.

We recently upgraded both Form and Flow to 2023.1 after we ran some workspace from form and flow we encountered that they were failing on the writer part with the following error message: "Too many values to bind. Found '127' when expecting a max of '100' ".It seems that FME is not able to write the data to an Oracle Spatial DB if the amount of attributes is greater than 100. When we reduce the amount of attributes to lower then 100 there is no such message and the writing is succesful. The problem is that I cannot reduce the amount of columns below 100 (the DB design is debatable I know ;-) ). Is this supposed to work like this or is it a bug in the writer? 

Hello Forum, I have an attribute in a gpkg dataset containing year values (e.g.: 2016). Where a year is unknown the value is <null>. When this dataset is translated into tab or geojson any values of <null> get shown as -9999. I assume that's how the MapInfo tab translator sees <null> values. But instead of -9999 this I want any <null> value to be blank. With StringReplacer I know I can replace a value such as 2016 with 3016, not that I would want to do that!. But when I type in <null> as the 'Text to replace' and leave 'Replacement text' blank, the output still shows -9999 instead of it being blank. I wonder if there is a special way of specifying <null>. How do I effectively replace <null> value in an integer attribute with blank? I've seen https://community.safe.com/transformers-9/replace-value-with-a-null-1778 but that doesn’t quite cover it. Thanks,Stuart

Hello FME Community,In order to retrieve the list of fields from Shapefiles, I am currently using the following workflow: SchemaScanner => ListExploder => AttributeManager(Name).csv.My objective is to perform this process on a set of Shapefiles contained in a folder and output the CSV files into another folder while keeping their original filenames.However, I encountered some issues with this setup:Filename Issues: I am having trouble preserving the original filename for each output CSV file. The current workflow doesn't seem to carry over the original Shapefile name correctly. AttributeManager: I'm using AttributeManager to manage field names, but I'm unsure if I'm configuring it correctly for this task. It doesn't seem to handle the filename dynamically.Do you have any suggestions or solutions to address these issues? 

Hello,my challenge may have already been solved, or it may be difficult for me. Maybe I'm just missing something:i have a line dataset and a point dataset. the points are measurement points of the lines. in our convention, a line has 2 measurement points, an arc has three measurement points and splines have at least 4. there is no attributive connection between the two datasets. the measurement points are identical to the corresponding veritces of the lines 3D.the line represents the upper edge of the sidewalk and i derive the lower edge of the sidewalk (street level) from a point cloud. due to the point cloud, the lines jump at the vertices in height along the line. i want to interpolate the line and have so far fed the 3D interpolator with the start and end point of the line and let it interpolate the line. so far so good.but now i want the lines to be interpolated not only at the start and end points, but always exactly at the vertices at which a measuring point from the point data

I have followed the documentation on setting a custom OAuth2.0 web service connection and all steps work within the Test… flow until it comes to redirecting to https://localhost . Is FME listening to a specific port on the localhost or should it be registering itself as a temporary server? This is the returned screen.Following the same flow within a external browser window also ends up here but the returned access_code is present in the URL.How is this being retrieved by FME - I’m kinda stuck here. 

Hi, I want to migrate my data from geometric network to utility network. Can someone help me?

Can you provide guidance on how to convert a DWG file to a PNG image and then embed that PNG into an HTML PDF using FME? Specifically, I'm interested in preserving the visual elements like colors, hatch styles, and line widths from the original DWG file.Here are my transformers.Thank you.

I am trying to see if I can update a feature layer in our ESRI Portal from a FGDB. We know we can insert, update, and delete features and have success on those fronts. However, we will like to also have dynamic schema available as we may change the data in our FGDB by removing/adding fields. I have tried several times to get a dynamic writer working to account for a schema change but without luck. I have tried to delete data in the feature layer to then insert but that had errors. Does anyone have advice or has done this? The FGDB is a testing stage as eventually we would want to update directly from SDE.