FME Form

I have a csv spreadsheet of arcgis server feaureservice urls with the featureclass, name attribute , and projection attribute. This list is long and has multiple servers and I want to pass this list into my workspace and have the FeatureReader transformer read the url and featureservice with a spatial filter for my area of interest (AOI) and then clip out the data I need inside the AOI and only keep the attribute name field in the result, run some additional analysis, then write out the clipped results to a GDB, then move to the next record url in the spreadsheet.. My plan is to reproject the AOI to each projection listed in the csv and then pass the AOI as the creator to the FeatureReader transformer to only read based on the spatial filter. This works great if I do separate feature readers for each URL but that makes for a gigantic workspace and isn’t very dynamic as the spreadsheet and AOI changes frequently. Is there a way to pass a csv list to the FeatureReader in this way and acc

Hi All,I’m using FME 2021 32Bit on GESW 4.1 and unable to read the tables. Screenshots showing starting of TICS server & modules which I used in GESW along with error from FME are attached for reference. Can someone point out to the location which I’m missing anything such that tables can be read… Thank you

I am encountering an error in FME Workbench when closing the GENERIC Reader. During execution, the translation fails with a transcoding error related to a binary string, and the program terminates unexpectedly. The error message indicates that FME is unable to transcode a binary string containing non-UTF characters (apparently related to a shapefile) into another encoding. As a result, the translation process stops with a “Translation FAILED” message. This issue occurs consistently and prevents successful completion of the workspace. Any guidance on how to handle encoding or binary data in this scenario would be appreciated. Menssage Log:NullAttributeMapperFactory (NullAttributeMapperFactory): Transcoding the binary string '1e\xA8\x83\x16\x00\xE8\xBB\xE9\x96\x1DfH\xC0 -\xB12\x1A9:\xC0\x00\x00\x00\x00\x00\x001\x01\x00\x00\x00\x09\x00\x00\x00shapefile' to another encoding can not be doneOGCGEOPACKAGE writer: Committing transaction of 1451 features to feature types 'AREA_IMOVEL_1'...Closi

N/A

I have a workspace where the DateTimeCalculator is failing for all records. The rejection code is always INVALID_INPUT. And yet, when I view the data in Inspector the two input fields I’m using both list as Date under Data Type. The dates look fine fine (e.g. - 20251216). It fails for any mode - Add or Subtract, Calculate Interval, etc. Any ideas why it’s failing and what I need to do to fix it? (FME Form 2025.1.0.0)

Hi,I need to use many hosted GDB from the web. They aren’t in the same root folder, they all have sub folders.Quebec Hydrographic Network GeobaseIs there a way I could use Multiple URL instead of having to use 15 FeatureReader, one for each GDB?Or a way to download everything from the root folder ?Thank you.

Hi.I just had a job on our FME server 2022.2.2 go haywire.When reading from one or more database tables, it suddenly spews out a _lot_ of error messages, repeating the same two lines from line 319 to line 865997 (on page 1734):Microsoft SQL Server Spatial Reader: An internal error has occurred. Please visit http://www.safe.com/supportMicrosoft SQL Server Spatial Reader: Failed to parse datetime, attribute set as nullWhat gives ? Should I be concerned ?I've occasionally encountered huge log files before, but haven't had any idea why. Next time I'll see if it's the same issue.The job took several minutes (as opposed to normally a handful of seconds) to finish, which is not good.Cheers.

I’m getting an error when reading an Oracle database on the Datetime. Error converting from OCI datetime to C character string : `ORA-01805: possible error in date/time operation' These are my current installs 

We have a workbench that runs daily via windows task scheduler which reads data from an Oracle database and ArcGIS Online and then writes to SQL Server. The process has run for some time but the other day there were some issues with the output dataset. On viewing the log file, it appeared that only 2000 of aprximately 50,000 records were read from AGOL. However, there were no error messages to say that it han’t read the whole file. Is there an easy way to build something into the workbench to sent a notification email to check that the whole file has been read in to prevent this issue happening again? Thanks

Hi All,I have a complicated question. I created a custom transformer which can read any table from our Postgres/PostGIS database and write in into a list of desired formats (like Geopackage, Excel, Csv, FileGeodatabase).I have an issue when writing to Excel. A certain attribute is shown in a scientific notation. Ik know how to solf it in an none dynamic way. I could use an ExcelStyler setting the cstom number format to 0, or add an attribute xlsx_row_formatting or apply formatting to a attribute by adding an attribute <attrName>.formatting. I just can't figure out how to do this in a dynamic mode. I wish there was a excel writer to disable scientific notation, but there isn't. Any help or suggestions are appreciated. Arno

I have a schema JSON file that I want to use to validate various JSON files. What transformers can I use to perform this functionality? JSON Validator only validates syntax and not schema so what's the alternative for this?I have added pictures of the sample JSON schema and also the JSON file that needs to be validated against that schema.

Hi everyone!I’m learning about dynamic flows in FME and I’ve encountered two issues that I haven’t been able to resolve yet. I’m reading multiple .gpkg files from a folder, but in the output, all the data is saved in a single .gpkg file. I need FME to generate a separate output file for each .gpkg read. How can I set this up? When I insert the Attribute Manager and rename the attribute from acm_id to id, the values of that attribute (acm_id) turn null after the renaming, and the new attribute (id) does not appear in the final output file. Does anyone know how to prevent this from happening? Thanks in advance for any help or suggestions!

I have used a Directory and File Pathnames reader to generate an attribute holding file paths for the .xlsx files that I need to read in to my workbench. My plan was to use a FeatureReader to subsequently read these files in but I am struggling to get this to work.There are multiple worksheets in each .xlsx and I only need the contents of one - in all cases the applicable worksheet has the same name and an identical schema, the column headers are all on the same row as well.I haven’t been able to work out how to configure the FeatureReader as when specifying the dataset from an attribute the parameters to specify ‘Sheets to Read’ and ‘Field Names Row’ are not available.I would be very grateful for any advice - thanks in advance.

I’m currently updating all of our tools to a new input dataset. In the process, I’m relying on the transformers to tell me when there are issues with the new schema. The issue I have found is the TestFilter is not flagging these as Incomplete Transformers. Build is 25237, and all transformers are up-to-date.I want to believe I have seen this behavior on other transformers, but the TestFilter is by far the most prevalent case and has the potential to cause the most problems in our workflows.Is there a work-around to check for Incomplete Test Conditions? Original configurationWhen the connection is removed, the transformer does not become Incomplete. It’s only when you drill down into the Test Conditions that you see the issue.To rule out something weird going on with my workspace, I created a fresh test from scratch. The issue persisted here as well. 

We are preparing to upgrade to FME Form 2025.  I am running a job in the 2024 and 2025 version to compare the output.  I have found that in 2024 the FeatureReader didn’t reject any records, but now in 2025 some records are being rejected.  FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64)FME(R) 2025.1.3.3 (20251104 - Build 25648 - WIN64)The rejected records say:fme_rejection_message    buffer    Coordinate system does not match first feature's coordinate systemfme_rejection_code    buffer    INVALID_GEOMETRY_COORDINATE_SYSTEM Any thoughts on why the records fail in 2025 but not 2024?I will continue working backwards to see what is unique about these records.

I have an existing process that processes versioned views from an ESRI SQL Server Geodatabase to another SQL Server Database creating SQL Spatial tables with a geometry column that I have reprojected to WGS84 Lat Long. Can I add a second geometry field to the SQL spatial tables and populate that column with Web Mercator geometry? I am trying to figure out a single workflow that would calculate both columns in the same table. Or am I restricted to calculating one geometry column at a time in separate processes?  

Hello Hello,I would like to ask about Custom Transformers.I am a beginner and I am very confused. I have three questions.First question:When I input the value 345/1000 into a Custom Transformer attribute include field, it is automatically divided and get 0.345 as a result . I want to keep the value exactly as 345/1000.Even outside the Custom Transformer, the value is 345/1000. I understand that the Custom transformer is treating it as a number. I tried converting it to text before entering the Custom Transformer, but none of my attempts worked.@Text(@Value(attribute)) does not work.I also checked the shared parameter, and it is set as Text.and another issue if I have value 900 A , custom transformer read it as null .I do not know how to solve issuesSecond question:The Custom Transformer works correctly, but when I check the shared parameters, they all appear in red color in the Manage Parameters window. However, when I run the process, it reads the data and produces the correct output.

Hi, I have set the spike remover to 3D dimensions to read 3D solids however everything is being rejected due to - ‘Invalid Geometry Types’. Any ideas? 

Hello, I am struggling with using the ArcGIS Attachment Connector to upload multiple attachments in an ArcGIS Online Feature ServiceI am able to add one attachment but for some reason it will not add multiple photos. This is for a Survey123 that I set up an automation in FME Flow with webhook to add certain features to a hosted feature layer in ArcGIS Online. It runs fine, adds the data, but the moment there is more than 1 photo that needs to be attached, it only uploads 1 photo. Any advice would be greatly appreciated. Thank you!Edit: This works perfectly fine on the workbench (it will add all attachments) but when I try to run it on flow, it will only add 1 attachment. I do receive the following error message:  158 2026-1-2 10:50:31 | Message Type: fme::internal::_v0::py::Exception 159 2026-1-2 10:50:31 | Python Exception <TypeError>: Unknown output tag 'Output' passed into pyoutput() 160 2026-1-2 10:50:31 | Error encountered while calling method `input' 161 2026-1-2

Why does XML header of the FME generated file displays the XML header as <?xml version="1.0" encoding="UTF-8" > instead of <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

Hi everyone,I have a geometry problem in FME and I’m not sure about the best workflow.In the image below, the red point belongs to a feature that is connected to a black point (the black point is the reference).What I need to do is: Take the line highlighted in green. Starting from the black point, find a position 10 cm along the line. Move (or recreate) the red point exactly at that location — meaning: the new point must lie on the line, and must be 10 cm away from the black point. I know the relationship between the red point and the black point from an ID attribute, but my problem is:How do I calculate this “point on line at 10 cm distance” inside FME?  

Hi, I updated a workspace from FME 2020 to FME 2025, and I have an error in 2025 that I haven’t in 2020, with the same input data.On the Excel writer, I get an error on a specific string regarding the validation as UTF-8.ERROR : XLSXW writer: The encoded string is not a valid UTF-8 string: 'S\x00u\x00r\x00 \x00c\x00h\x00a…….'Any idea why and how I can check the strings before the writer so it doesn’t stop the workspace with an error ?

Hi everyone,does anyone know if there is a way to write directly to an Excel file hosted on Microsoft One Drive, just as it possibile with a Google Sheet file?Thanks! 

Hello, thereI would like to prepend one dataset with other datasets and return other datasets as output. Please refer to the screenshot below, this should be done with only one workbench. Highly appreciate your thoughts.  

FME Form 2025.1SQL Query in SQLExecutor: SELECT * FROM table_name WHERE ID BETWEEN $(polystart) AND $(polyend);Oracle tableWorks fine in DBeaver with actual ID numbersFails in FME with actual ID numbersFails in FME with User Parameters for the numbersError Message:Execution of statement `SELECT * FROM table_name WHERE ID BETWEEN 35480 AND 35484;' did not succeed; error was `ORA-00933: SQL command not properly ended'.Does FME just hate a BETWEEN statement?Going mad trying to figure out where I am going wrong 😂