FME Form

In a process that deals with GPS messages that are received every 15 minutes, I have two User Parameters that set a Start- and an End date, in order to prevent having to process a couple of million rows from the database every time. These are configured as DateTime parameters, with the Datetime Format set to Date only.The GPS Fix time is copied to a new attribute while converting to a Date, using a DateTimeConvertor. Format selected is FME date (%Y%m%d). If I then use a Tester to check whether the GPS fix time falls between the start- and end date (with Comparison Mode set to Date/Time), they all fail, because the parameters value is 2026-01-01, while the attributes value is 20260101. So the Tester’s comparisonDate >= $(StartDate)(where Date is the by DateTimeConvertor created attribute) does not work anymore, since our upgrade to 2026.1.2. Before (when we used 2025.0.3) this was working without a problem. Upgrading the DateTimeConvertor and the Tester (this is an older workspace) d

I have a non-spatial Oracle table fifteen attribute columns, two of which columns store images.One column is called “image” and the other column is called “thumbnail”Both store images in jpeg format.All of the jpegs are less than 1MB in file sizeI want to write this table to PostGISI have constructed a table in PostGIS with the columns “image” and “thumbnail” both defined as bytea How do I write the workspace that Reads from Oracle and Writes to PostGIS? I made an attempt, but now FME fails to display the data from the PostGIS table, so there is something wrong. My version of FME Desktop isFME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64) 

Hi team,In my workbench, I'm snapping line endpoints to the device X,Y.To do this, I stored the point's X,Y in the line's attributes and used the VertexCreator transformer with "Replace point at vertex" set to −1 (the end point), passing in the device's X,Y.This moves the line's end point to the device's X,Y as expected, but it also changes the line's start point to what was previously the line's end point.To avoid this, I tried using VertexRemover to remove the end point, then VertexCreator with "Add point at vertex" set to −1, again passing in the device's X,Y. With this approach, the line's start and end points end up swapped.I need the start and end point order preserved as-is, since that order is used for terminal assignments in the Utility Network. Someone please suggest a solution for this? ​@redgeographics  ​@radek.cervenka  ​@hkingsbury 

Quick question.Are there alternatives to using AttributeManager to manually sort attributes by name?Sort of an AttributeSorterByName or AttributeSortedReexposer transformers ?Cheers.

I’m using FME Form 2026.2. I have date and time strings that I need to convert into a date field in ArcGIS Online. It seems like this should be easy, but I can’t get it to work. What format does ArcGIS require to create a date field.I create a new datetime attribute then write it to a AGOL Feature Service. The field is created in AGOL, but the value are null.@ParseDateTime(@Value(LocationDate) @Value(LocationTime), %m/%d/%Y %H:%M,repair) In ArcGIS Online all values are null. I attached an FME workspace and CSV file to reproduce the issue. I searched for documentation and forum posts. I think that I’m missing something simple.I must have a date field in AGOL because I’m creating a dashboard and need to filter dates.

Hi all.I just created a new custom transformer, and need to apply it multiple times (10-20 times).It basically just has a name and three parameters, all of which can be deduced from a database query.So I thought it to be a good idea to create and paste the definitions from a query result (using some sql magic). Instead of copy/pasting the many transformers as I would normally, editing each by hand.So I experimented at bit first.I can copy a transformer from FME Form, and paste it right back. I can also paste the definition into a text editor, as the copied content is just text (FME file syntax).But when I just copy the complete transformer (without changes) back from the text editor (Ctrl-A,Ctrl-C), FME Form will not paste it into the workspace.I used Ditto clipboard to look for differencies, and I can barely find any. The two attached images shows the properties for the original and the text editor copy.original from FME Formtext editor copyThe only difference I can find are the sligh

Since a few days two of my FME hub transformers return the error below. I think it mentions that it is not possible to create a folder any more using the TempPathnameCreator. This might be resolved by updating the transformer to the latest version, but this also means that the transformers on FME hub cannot be used on old(er) versions any more. In another recent ticket in contact with Safe, I experienced something similar. Because of the security-changes for Flow several workspaces do not work any more. So I'm pretty sure many people will have similar issues. How can this be fixed without having to update all transformers to the latest version (and making it impossible to use them with older versions)?2026-07-15 13:08:16| 0.0| 0.0|ERROR |@Tcl2 -- failed to evaluate expression `set sampleTempFile [FME_TempFilename]; set ourTempDir {}; append ourTempDir $sampleTempFile {_d}; file mkdir $ourTempDir; set env(InlineGeoJSON_TempPathnameCreator_6e0c2906_d797_4636_928a_fa984000ecc45_dir) $o

If I have an MS SQL Writer that I have disabled for whatever reason, all the features in the workspace turn grey. Perfect, is a very good indication that it is disabled. However: if I import another table, that writer is added to the Main canvas and to the Navigator in full color!Which caused me quite a bit of head scratching this morning: why was nothing written to the database? It seems to me that this is a bug in FME Form (FME(R) 2026.1.2.0 (20260512 - Build 26124 - WIN64), but maybe I am overlooking/overthinking something…To reproduce: Add an MS SQL Server Writer, use Import from Dataset to select a table. Right-click on the Writer in the Navigator, and select Disable [writer_name]. Table on the canvas turns grey, as it should. From the menu select Build - Writers - Import Feature Types. Select another table, click OK. Now I see one grey table and one in full color… 

Hi all, When sending a test request with a HTTPCaller, the Test Response Preview shows the response. When you close this window and reopen it later after closing and re-opening the workspace (even on another date) this response is still there (cached?). Depending on the URL used, this can lead to an unreasonably large workspace file. Is this an intended feature, or an oversight that can slow down workspace performance if a user isn’t aware of this?If there is a benefit to being able to revisit this test response at a later date, maybe it’s a good idea to be able to enable/disable this feature entirely. Or at least be able to ‘clear’ this Test Response Preview. Kind regards, Rob de Groot An example URL that leads to a +20MB size increase of your workspace if a test response preview is opened:https://services1.arcgis.com/ug8NBKcLHVNmdmdt/arcgis/rest/services/Peilvakken/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=jsonIf you do this for multiple HTTPCallers it ca

 Good Evening! I have a problem i would like to share with this amazing community and i hope ill get an answer that solves it. I am writing data to an Microsoft Excel file. I use the feature writer to dynamically write 3 datasets to Excel. The normal Microsoft Excel writer does this without a problem. Now i want to do it with an Feature Writer set to Microsoft Excel, but when i run the feature writer with, i believe, the same settings as the Excel writer, it results in a fatal error, where it states FME daemon is shutting down. Can anyone help me? That would be greatly appreciated. Thanks!Error log TranslationOther settings are default.Interesting here: number 164. I dont know why of what. 

I am trying to make a workspace that generates information reports, but the featureReader give me unexpected output. Sometimes it works, but sometimes it gives me "stale caches”, where it should work. I am trying to let the user choose which attributes to expose by using a UserParameter, so they can choose what information attributes they want to use or not, but it gives me weird results.  If i run it, it might do it and give me the required information, but if i run it another time, with other attributes selected to expose, it gives me the result that was asked before. Or, if i run it again with the same configuration it gives me the "stale or incomplete cached data”. since Users can select multiple layers out of the 500 we have, i think i have to use the generic port, and let the users choose what attributes they want, because they dont need everything and their needs change from time to time. How do i change this process so that it will be reliable? That my users can get any attribu

I need to download one or more PDF documents from Sharepoint as part of an export process. These PDF’s have random titles and filenames, in the Sharepoint library an extra column was added containing a unique ID. It’s this ID I have to use in order to download the correct PDF.Problem is that I can get this ID from Sharepoint using the Sharepoint Online List Reader, but that cannot give me the download URL. Conversely I can get the download url from the SharepontOnlineConnector transformer, but that one does not allow me to get the added custom ID.So in order to get all the info I need,  have to use the reader AND the connector and join the results from both together, which is rather ugly.Am I missing something? Is there a way either of these can be configured where I get all the necessary info in one go? Or is this as designed? If the last, I’ll file an Idea I suppose...

I'm constantly getting an error in FME 2026.2 whenever I use the 'Conditional Value' option in CoordinateSystemSetter transformer, regardless of the input values. Could this be a bug?

In 2026 build, the new ArcGIS Feature Services package replaces the older Portal Feature Service reader. The change is well documented in the article Working with Esri ArcGIS Feature Services in FME – FME Support CenterMy question to a Safer is, how/when are 2026 deprecated formats like PORTALFEATURESERVICE listed in the article FME Deprecations – FME Support Center.the new unified ARCGISFEATURESERVICE package replaced arcgis x feature service formatsCan these now older ArcGIS Feature Service formats be added to the article; along with Recommendation actions listing out sections/bookmarks from the support article Question about deprecations articleWhen do components get included to the article and how is it updated?  is this a manual task or can the development team inform earlier updates when components are planned to be replaced?Recently for example, randomly FME Date Time functions got added to the article, where it was listed as affecting in 2026.1…. yet we were already at 2026.2 r

Dear community, I have implemented a workflow with FME and ArcGIS Enterprise, in which an automation is triggered in FME via a referenced feature service with a webhook. Based on the entries in the ArcGIS Field Maps App, an e-mail is then to be sent via FME.This is set up accordingly according to the following documentation: https://support.safe.com/hc/en-us/articles/25407414850061-Integrating-ArcGIS-Enterprise-Feature-Service-Webhooks-With-FME The connection from the application in ArcGIS Enterprise to FME is also set up accordingly: https://support.safe.com/hc/en-us/articles/25407772142733-How-to-Create-an-ArcGIS-Enterprise-Portal-Web-Connection-OAuth-2-0 The problem that arose is that the OAuth refresh token created in ArcGIS Enterprise has a default lifetime of 2 weeks and I therefore have to authorize myself every 2 weeks (see https://enterprise.arcgis.com/de/portal/latest/administer/windows/specify-the-default-token-expiration-time.htm).Based on this community entry: https://comm

Hi, I followed this guide (How to Connect to Microsoft Exchange Online using OAuth 2.0 (Microsoft Modern Authentication)) for setting up MS Exchange with FME Form 2026.1.2.0. Once I worked out things are a little different with a Personal Database for Connection Storage, I ran into an issue where I couldn’t set the Redirect URI unless I used the old Embedded Browser Redirect method.As this method is deprecated what’s the option going forward, as the other two options don’t let a user edit the Redirect URI:Thanks

I have encountered an issue where using a Snowflake writer will either cause errors or corrupt data if the text field contains emoji characters. This is occurring with FME Form 2025.2.3.0 on Windows 11. If I am writing to a VARCHAR column in Snowflake, the emoji characters will be corrupted but the field will write. If I am writing JSON to a VARIANT column, the workspace will fail with an error. In the past I have just let this issue go because I have been writing to VARCHAR fields. Now that I’m writing JSON to a VARIANT, I need to find a better solution. Although I believe FME 2025 and Snowflake are both using UTF-8, it looks like it is getting converted to something else somewhere along the line. The easiest way I have to test this is to create a Snowflake table:create table mm_temp_utf8_test (text_col varchar, json_col variant);Then I can use a SQLExecutor.If the SQLExecutor just populates the VARCHAR column, it will succeed but the data will be corrupted:insert into mm_temp_utf8_te

Hello Group, I'm wanting to see if I can can create lines from what may be well known binary (WKB) strings (e.g.: 0xE61000000114297C137101D7B2BFE65D8A76C0BF494030842DCBFFD3B2BF70EC7899C0BF4940). To be honest I'm not 100% certain that they are WKB. I have a csv containing these potential WKB values. The workspace is... Creator>FeatureReader (reads in the csv setting the field called 'sp_geography', which contains the WKB value to varchar>GeometryReplacer (with encoding as OGC Well Known Binary and the geometry source set to 'sp_geography'). When I run it all 171 records goi to the Rejected port. There's a curious blue message in the log:  "Invalid WKB encountered.... Last line repeated 170 times ..." This is odd as the WKD values in the csv are, as far as I can see, all unique.

Hi all.I’m experimenting with calling WFS services with custom filtering expressions, including spatial filtering.According to the filtering documentation, spatial filtering is possible with GML, but it doesn’t seem to work in FME ?The geometry column is present but has no value in the output from FeatureReader, and FeatureReader has its own spatial filtering parameter separate from the “normal” filtering parameter (using <Filter/>)Am I correct in assuming, that FME effectively prohibits any spatial filtering via the “normal” filtering parameter, and requires you to always use the special FeatureReader spatial filtering parameter ?And maybe this is neccesitated because FeatureReader removes the WFS geometry column values ?Thanks for any insights.

Hi.This may be a simple or a complex question, I’m not sure which.I’m attempting to use a dynamic expression, that I construct dynamically from values read from a file or table, and evaluate it on all relevant feature read from a database or file. Including AND/OR etc.How can this be achieved in Workbench ?I’ve tried to utilize ExpressionEvaluator with the expression @Value(@Value(expr)), but it doesn’t return any value in the “_result” variable.What am I doing wrong, and is it even feasable ?Are there better ways to achieve this ?Using 2025.2.4Cheers

I have a workspace where FeatureMerger_2 and 1/3 connection is disabled, but when I trigger a Partial Run from the upstream reader BODENBEDECKUNG_A, I get the "Caches required to run translation are missing or stale" prompt, listing all the transformers that feed into that disabled FeatureMerger (See attached screenshot)Since the FeatureMerger itself won't execute, I'd expect its exclusive upstream feeders to be treated as dead and excluded from the run, but apparently they are still requiredIf I instead disable each incoming connection to the FeatureMerger, the feeders correctly drop out of the run and I don't get the prompt, even when Feature Merger is enabled.Can someone explain the logic here? Why does disabling a transformer and the relevant connections (the one coming from the reader where the Translation is started) not back-propagate to exclude its upstream feeders, while disabling the connections does?

When I try to connect the .sde file on FME, I got the this Error. 

 Hello,I would like to remove attributes (or columns?) from my data stream that have no value (missing or null)In below example that means “eindegrarantieperiode” and “integraalproject” need to be removed. Note: can we do this dynamically? I don't want to manually go through 50+ attributes to check if they contain a value or not.(FME 2025.0) 

In >2026 to connect to AGOL or Portal enterprise from FME, we utilise the “unified” Esri ArcGIS Enterprise OAuth (Template)(safe.esri-agol) web service   ARCGISFEATURESERVICESWorking with Esri ArcGIS Feature Services in FME – FME Support CenterThe article perhaps fails to mention how to handle the web service Loopback Interface Redirect or Proxy Redirect Strategy, as the Embedded Browser is deprecated in FME Form 2025.2The arcgis registered application needs to have http://localhost as redirect URIWhat about FME Flow redirect URI?My suggestion is in Connections & Parameters - FME Flow for any given safe.esri.agol newest Esri web service in Flow >26It needs a default Redirect URI of “ self “? 

After the June 2026 ArcGIS Online update last week, the Esri ArcGIS Connector stopped working when attempting to download .csv admin reports. Prior to last week’s update, the connector would download these .csv files without issue. As of last Friday (6/26), FME returns the following:fme_rejection_message: 400 Client Error: Bad Request fme_rejection_code: INVALID_FILEwhen attempting to download .csv file. These errors persisted over the weekend and today. It fails both in FME Form and FME Flow. Versions I am using:FME Form: 2025.1.2.0 (Build 25630) FME Flow: 2025.1.2.0 (Build 25630) Esri ArcGIS Connector: 3.25.1Note: This exact error is returned for multiple types of .csv files generated within AGOL. I have dug into Chrome Developer’s tools to compare and confirm URLs and Payload being sent to the API and everything looks the same on both ends (Chrome and FME).Something might have changed with AGOL API’ backend. Is anyone else seeing these same issue? If so, how did you resolve it? Or,