FME Form

Hi There, I am trying to consume and Arcgis date field in Form but FME can seem to understand the datatype.  Specifically, the Date Converter transformation just errors out (please see attached).  I have tried every option from the drop down menu and have even tried using a String Convertor transformer and the Attribute Creator to (successfully) convert the field to a Datetime field in FME but the Date Converter can not read and I need to use this datatype for downstream use (I want to compare how new records have been added to the dataset by comparing this date field to the current time).  Any help would be super appreciated.  Thanks!  Louie

Today I placed a default value for a date User Parameter as@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-14,'day'),'%Y%m%d')essentially the date widget in FME flow would go back 2 weeks, this used to work fine…. But alas, in 2026 it is now returning something wild Where is this highlight in Change logs? I read something about ‘better support for SQL date’… but nothing about Date\Time functionsAm I supposed to use this now ?a new datatime function?Here is the help documentation https://docs.safe.com/fme/2026.1/html/FME-Form-Documentation/FME-Form/!Transformer_Parameters/Date-Time-Functions.htmWhen we upgrade transformers, will the @DateTimeNow() functions get transformed into @CurrentDateTime ?Also the @DateTImeAdd is this going to be converted to @AddDateTime I can see the syntax @AddDateTime(<datetime>,<interval>)https://en.wikipedia.org/wiki/ISO_8601#Durations So this @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-14,'day'),'%Y%m%d')has become@DateTimeFormat(@AddDateTime(@Cu

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

HelloWe have a workspace that connects to Sharepoint using a WebConnection.It works in FME Form and on one of our two FME Flow instances, which is installed on a second server.However, it does not work on the other FME Flow instance, which is installed on a third server.The error message is as follows:Access token not found for connection ‘aaa@Sharepoint_bbb’Unable to obtain updated authorization for web connection ‘aaa@Sharepoint_bbb’; credentials may be invalidObviously, there’s something wrong with the access credentials, but why does it only fail on one of the FME Flow instances?The web connection was set up by someone who no longer works for us. Where can I get the access token for the connection?Thanks in advanceVera

I have a excel file with photo link to Fulcrum (a different app). I have to create a template with photo link from my shared resources and id from the excel. I have created the FME process successful. But there are some extra photos that are not mapped to the ID which I need to delete. Which transformer shall i apply.Image above shows my FME process, I want to delete the 6 photos from unused supplier from my original folder. Which transformer shall i apply. and can it access my folder and Delete the photos.

I've found not documentation around any name formatting limitations for Attributes for the Hyper file Writer. When I work in Tableau Prep, I have no issues writing a file with a field name like "Budget$" to a hyper file. I've found in FME that when writing to an Excel file, it also takes such a name, but when using the Hyper writer, it drops the "$" and replaces it with underscore "_". Why is it doing this? Is this a mistake in creating the code for the Writer or is it a Necessity and if it is a necessity, shouldn't this be documented?

Hello there,The coordinate system Irish National Grid TM65 (EPSG 29902 previously 29900) is not depreciated. It is also not the same CRS as TM75, there are mathematical differences which can effect the coordinate locations. They are both Irish National Grid. The southern Irish Ordnance Survey has moved to using Irish Traverse Mercator (EPSG 2157) but the Northern Ireland state mapping agency is still serving basemapping in TM65. There has been previous posts on this issue but the suggested fix has not worked. I followed the instructions in this post but I could not select EPSG 29902/29903.The only way we can get the translations to work in a workbench is by not setting the CRS on the Reader or the Writer. If we set try to set the CRS in the Reader or try to apply a projection using the ESRIReprojector it won't work.  

Is this a bug? I am trying to list and download several files (some have dependencies-- references-- and some don't) and noticed that I cant download files that have an associated reference file.Any thoughts or suggestions?Thanks

I’d like to maintain my database documentation in an Excel spreadsheet like this:Attribute Name FME Data Type LandID int32 Acres real32 Name varchar(128)  And then I’d like to import that into an AttributeCreator. When I try importing, the attribute names come through, but FME Form sets all the data types to varchar(200) instead of what I specified in the field ‘FME Data Type’ and imported in the import dialog.How can I fix this or set up my spreadsheet differently?

Hello All,There may be a bug (or least a less user-friendly transformer) in Form 2026.1.2Choosing specifically the Esri ArcGIS Feature Service as the Format, the Dataset parameter is by default disabled: I’m unable to determine what the “related parameter” is that is *disabled.I can setup my feature types by importing the schema of my intended target data, but saving all the changes in the transformer puts it in an error state.If you visit the navigator window you can see where the “Dataset” parameter is in error.The only way I’ve found so far to get around this issue is to go into the Manage User Parameters setting and create a new user parameter for Dataset which needs to be the feature id of the online feature, inclusive of the parentheses around the id number.  This is definitely adding more configuration steps to the Feature Writer than before as the Dataset used to be configurable directly inside the transformer and you didn’t have to remember to copy the feature id from Esri.Any

Hello, I have a question regarding the DGN Reader/Writer about reading and writing external reference files.I am using the DGN Reader that contains a reference to another DGN file. In that referenced file there is a rectangle (an igds_shape element). In the DGN Reader parameters I enable the options "Read Elements From Reference Files" and "Keep Elements That Represent Reference Files".My goal is to move that rectangle to a different location and save it into a DGN file in such a way that:the rectangle appears at the new (correct) position - this part is not a problem; I already have a workbench for moving the geometry but it still keeps the link to the original referenced DGN file, and the referenced DGN file itself remains unchanged.In other words, I want to move the geometry in the main DGN while keeping the external reference link attached to it, so that any future changes in the referenced file (e.g., adding an image inside that rectangle) automatically appear in the main DGN at t

I encountered an error when writing data to a geodatabase because the file path contains a dot (period), even though this naming convention is completely valid. Everything worked fine in previous versions, but it fails in FME 2026.1. For example, I want to write to a Geodatabase named 'Geo.A1.2552.gdb'.Is this a known bug?

I would like to copy an existing file geodatabase and rename it to a different location.  I have been reading up on the FILECOPY but can’t make sense of what I’ve seen.  Any help is greatly appreciated. 

Hello, I am currently working on adding data (a source file in Geopackage format containing point and polygon tables) to our Oracle enterprise database. I am using a dynamic workspace to process the data and an external table (CSV file) to define the required schema in the FeatureWriter. When writing the data to the database, three additional attributes (not defined in my schema) were recorded. They are called “rotation”, “textstring” and “height”. After some research, I realised that these are likely linked to the following FME attributes: fme_rotation, fme_text_string and fme_text_size and that this is related to the “fme_point” geometry. I have tried several ways to remove these attributes but have not succeeded (exposing the attributes and removing them before the writer, telling the writer not to write them in ‘attribute to remove’, writing the tables containing polygons and those containing points separately in different writers.Do you have any ideas to guide me in this task, or

https://support.safe.com/hc/en-us/articles/25407427123597-Reading-and-Writing-SharePoint-Lists-with-FMEGuidance states: “1. Add the SharePoint List ReaderAdd the SharePoint List Reader to your Canvas, in the Dataset parameter enter the domain of your SharePoint site (for example, https://safesoftware.sharepoint.com). Click Parameters. Select your desired Authentication Method. In this tutorial we are using the Microsoft SharePoint Online (Template) Web Service configured to Safe Software’s SharePoint. You can choose either Basic, Web Connection, NTLM, and Kerberos. “However, I get error message when selecting The Microsoft SharePoint Online (Template) option; doesn’t this need to be configured in a certain way..?  

Hello all,I’m quite impressed by the descriptions AI assist can give for a workspace. Trivial things like input- and output-schema and even some description on the transformations on attribute-level.Now, I would like to ask these kinds of questions to a bunch of workspaces, and use the results in an automated way.Giving me access to the model behind AI assist could end up quite costly for Safe, so is there another way to get these answers?Kind regards,Martin

Hi everyone,I just started using FME and am already getting stuck. In my workspace, I import an excel sheet that contains a list of column names in one of it's cells. The list is in the following format: [“Column1”,“Column2,”Column3”].I also import a larger dataframe from a .csv file that contains a lot of columns, more than there are in the list of column names.Now I’d like to have a transformer completely remove all the columns in the larger dataframe that aren’t also in the list of names. I’ve already worked with AttributeKeepers and AttributeMappers, yet these can’t seem to receive a dynamic input.If anyone has an idea on how to solve this problem (Preferably using solely transformers and without PythonCallers) I'd love to know! 

Hey there,I tried to pass on the wfs url as well as the feature types to read both as an attribute value in order to get fetched via a FeatureReader-transformer. Although the output contains the geometry, it contains a lot of unexposed features. So far so good.My question is if there is a simple way to generically expose these attributes and assign it to the geometry again? I do not want to manually expose them in the aftermath.Many thanks! 

Hello everyone,I want to create hosted feature view layers on arcgis enterprise with REST API, httpcaller in FME. Although a new hosted view item is successfully created, the resulting view layer always remains empty (no layers inside it), and all attempts to attach the source layer fail.Below is a clear explanation of what i am doing, what works, and where the process fails. 1. EnvironmentArcGIS Enterprise 11.5 Hosted feature layer (source) Attempting to create hosted feature layer views programmatically The account performing the request is now: Owner of the hosted feature layer Administrator  2. What worksI successfully create a hosted feature layer view item using:content/users/<owner>/createServicewith parameters including:isView=truesourceItemId=<item_id_of_hosted_feature_layer>The REST response confirms:"success": true,"isView": trueA new view item appears in the Enterprise Content page.However:The created view contains zero layers, every time.Even though the source

Hello,I seem to be outputting multiple folders when I run my app through data stream or data download.Tried connecting all connections to one feature writer but it seems to be limiting me to one excel file if I do that so I did multiple feature writers for each excel file that I want.Tested running my app through data download and data stream and it outputs multiple folders - one folder per feature writer.Was wondering if I am able to simply download all excel files right away without putting them into a folder or just output them all into one folder.Screenshot below.Feature writers under Microsoft excel format. Basically 2 sheet type. 1 is based on a value and other is count sheetNot much configuring except the name of the excel, sheet names, and drop/truncate both yesHere’s an example of what it outputs - 4 Folders(I suppose 1 folder for a specific feature writer) 

Hi everyone,While reviewing one of our workspaces, I noticed that one of my developers used the SystemCaller to launch a Python script as an external process instead of using the PythonCaller transformer. The workspace runs fine today, but I'm worried about unforeseen consequences down the road, and I'd like to hear from people who have run both approaches in production.I'm wondering about maintainability (the scripts live outside of FME), Error handling and logging and versioning.If you've dealt with this situation, I'd really appreciate hearing how it played out.

I have 400 rasters i would like to convert to a single combined pointcloud for more efficient processing. Each raster has a specific piece of information about the hydrology of the subsoil (horizontal resistance, top of geologic layer, bottom of geologic layer, top of aquifer, bottom of aquifer, etc). To preserve the meaning of the individual values i would like to keep the name and type of the source raster as component values. This is where my problem/challenge lies. I can rename the original rater bands to a meaningful name, but because each raster only has a single band, the band value is by default used as the z-value. If I set the attributes to keep as component to an attribute containing the layer name, these are not kept on the pointcloud. I think this is because they contain string values and components in a pointcloud usually only contain numeric values , but then why can i configure it as being a string datatype? The rasters are 2800 x 3250 Pixels with each pixel 100 x 100 m

Hello everyone,I have an FME script that processes various data. Upon output, everything goes to a feature service. So far, so good; I have no problems during processing.My issue is very simple to solve, I think, but I can't find the solution.I'm working with agricultural data. For example, when using my script, I might request to use data labeled "18/19/11". Everything works fine, and everything displays perfectly.The problem arises when I only want to work with data labeled "18". The script works perfectly again, and the data is correct up to the last transformer before the writer. However, the data in the writer isn't replaced by the new dataset, and I still get the "18/19/11" data when I only want "11"!What type should I choose in "Feature operation" (insert/update/upsert/etc.) and in "feature type handling"?Do I need to integrate a transformerbefore the writer that will update the datar, or is this problem solved solely within the writer? I'm a bit lost and frustrated...Thank you

I notice that when writing GIS to CAD, in this case a KMZ to DGN using FME, that the output often tends to have mismatched units and the scaling is often much smaller in the output. I know that a seed file is ideal but I often find that this doesn’t always solve the problem in FME. Is there any way to make sure that the units are not mismatched when going from GIS to CAD?

Hi there, has anyone upgraded the previously community provided workspaces that bring additional dashboards to Flow?From REST v3ToREST v4Workspaces can be found from the article from V3 Monitoring FME Flow Job Activity using the REST API – FME Support Center which is a different article to Submitting a Job through the FME Flow REST API V3 – FME Support Center and ultimately the latest article Submitting a Job through the FME Flow REST API V4 – FME Support Center could do with have version 4 fo the statistics workspaces edited last in 2021