Best Answers

We are wondering which version of FME Flow will support ArcGIS Enterprise 11.5. Looking on the history in Notes on FME and Esri Versions and Compatibility I would guess it might be 2025.1?

I am trying to use a template file in an excel writer for my data. The data is collected from a number of sites, so I was aiming to use the site id attribute as the sheet name to export a new sheet per site. Unfortunately the template is only being used for the first site which passes through my writer, and the other sheets are unformatted. Has anyone encountered this and found a solution to apply the template to all sheets if multiple are being written in the same feature writer? 

I’m using an FME FeatureReader to read a content of an Excel file containing various values, including decimal numbers, some of them small with more then 5 decimal zeroes.The FME, apparently, handles these small numbers using scientific e notation.After processing the data, I write it into a CSV file using a FeatureWriter. The problem is, that the small numbers are written in their scientific notation form, and not as real decimal numbers. This is causing an issue further down the line.I tried various things to force the FME to write the numbers as decimals:forcing datatype of the affected attributes in the FeatureWriter to Decimal or Real using AttributeManager to change the datatype of the affected attributes to Real, Decimal and even String forcing the datatype of the affected attributes in the FeatureWriter to String changing the datatype of the affected cells in the Excel file to TextNothing helped.I tried to find a String or Math function that would achieve that, but I’m not sure

Hi All,I'm still somewhat new to FME and am hoping someone can advise me.Through another workbench I have been able to gather a a list of service URLs from an AGOL. I would now like to automate the process of creating a new item in ArcGIS Portal via the New Item > URL workflow.I have looked through the Esri ArcGIS Portal Feature Service Reader/Writer and a few other transformers but none seem to accommodate for creating a referenced item via URL. Google is leading me nowhere either.Any advice or pointers?Thanks very much for your time! 

Greetings all!I searched for similar questions but wasn’t able to find any pertaining to this, so apologies if I missed them. I’m using the NeighborFinder transformer to locate points along measure-aware polylines to acquire the Measure value of all lines within 5 meters and merging all attributes and generating a list when multiple candidates are found. When there are multiple candidates, it’s assigning the Measure value of the point from one of the lines at random (possible the closest?). However, when I use the ListExploder transformer to create features from all elements in the list, while all other attributes appear to be specific per feature, the Measure values are the same for all features spawning from the same feature. Hopefully this make sense. I assume I have a parameter set incorrectly or something, but how do I ensure each feature has the measure value specific to the line it was matched to?

I have a FME workbench that is scheduled to run late in the evening, and it is a lengthy process, so it can sometimes run over midnight.Is there a way I can capture the date of the day that the workbench started to run and to store that date in a parameter?I tried DateTimeStamper but it re-captures the date for every single feature, so if the process runs over midnight, the date changes

Hi,I created a workspace that uses an Esri ArcGIS Online (AGOL) Feature Service. The workspace run on FME Form and on FME Flow if i run it. However, once I make an workspace app from the workspace on FME Form I get the following error and my workspace fails: 89 2025-7-2 14:58:39 | ArcGIS Online Feature Service Reader: Connection 'AGOL service' does not exist. Check connection parameter and connection definitions in FME options and try again  Here is a screenshot from my jobs. Lower one is of my run and top one is through the workspace app.  We are running on FME Flow 2023.2.4

I know I can restart a map service in ArcGIS Server Manager. Is it possible to restart a map service in ArcGIS Server using FME? if yes, how is this done?

Im trying to work with the Cityworks API to create Work Orders using FME desktop.I used the http caller to create the Work order and populate the necessary fields. However, my next challenge is to upload an attachment to the Work Order that comes from the attachment in the AGOL feature Layer created from Survey123. To do that I have used another HTTP caller set to POST with the URL.../services/Ams/Attachments/AddWorkOrderAttachment? I know I have the Query string correct but I'm doing something wrong in the Multipart Upload section. Also, Do I need to use a token if I'm using a web connection for Authentication?       

I see there’s already an Idea for providing the option for versioning Automations in FME Flow but the Idea was created 5 years ago and there doesn’t seem to have been any traction on it.So, in the absence of any official support from Safe, what are people doing with regard to creating and saving versions of Automations?Currently, if I make a change to an Automation but then need to revert that change there’s no way of doing it once it’s been saved.The only workaround for this I can think of is to make a Project containing the Automation and then manually exporting the project (and saving it to a version control system) before making any changes to the Automation. The obvious problem with this is that it relies on:remembering to export a Project before making any Automation changes making sure the Project name is consistent (hard to do with multiple people editing)There does not seem to be any System Event that is triggered on Automation change and no API call available for downloading

I was wondering if I can hide the input field that comes with the Geometry Parameter when creating a workspace app in FME Flow.My users are all over the place, some of them understand that they have to set a point on the map and are confused thereafter when a whole GeoJSON syntax shows up instead of coordinates they expect, others think they should write a street address in the input field (mistaking the input field for a geolocator), etc…I can leave a message for them but hey, how many will read it...

Hello everyone,I have some experience with Workspace apps, but not as much with Automation apps. In my previous work with Workspace apps, I created an app that is based on user input on a map. When a user clicks on the Run button, the "Running..." button appears. Once the script finishes successfully, the user can download a ZIP file by clicking on the Datadownload URL.Now, I’m trying to build something similar using an Automation app, but I’ve found the process to be quite different.Based on the following post, I’ve set up the following: I have a manual trigger that includes a manual parameter called "Geometry" (GEOM). This GEOM parameter is then used in the subsequent Workspace. Similar to the Workspace app, I want to show a "Running..." button while the script is running, and once it finishes, makes a download URL available to the user. However, the only feedback to the user is the green "Automation Triggered." message.There’s no further feedback for the user, that the script is r

Is there any fundamental differences between the CoordinateSystemSetter in FME and defining projection i ArcGIS Pro?  I have attempted both separately in an IFC-file. ArcGIS Pro doesn’t automatically recognize the coordinate system of the file. Using the tool “Define Projection” in ArcGIS Pro manages to place the model in the correct area, while using CoordinateSystemSetter places the model approximately 30 km away. I have also tried to remove the coordinate system from the IFC-file before using CoordinateSystemSetter, but I still get the same results.  Any workarounds or tips for troubleshooting? The IFC-file is in version 2x3.

Hello,I am hoping to get a little guidance on how to properly extract m-values from a ESRI line feature class. In ArcGIS Pro, I can confirm that my feature class is m-value enabled. I need to extract the m-value locations in FME, convert all the vertex locations (with associated m-value) to points, then use the neighbor finder transformer to join the m-value to my point data.I’m having trouble isolating and exposing the m-values from my source line data. In the Feature Information for the line data, I can see a “Measure (1)” value under Geometry > Line (screenshot below). Under Coordinates, if I click into an individual coordinate the value is displayed as: -11697066.4549, 4955884.293300003Measures:<default_measure> = 0.035799999997834675 How can use an AttributeExposer (or other transformer) to properly isolated the coordinate and associated m-value data into a list? Once it’s in the list I’ll be off and running and can also handle any unit conversion that is necessary. Any i

Hello,I have automation which triggers a workbench and has to send result file on email in the end.The resulted excel file has dynamic name with @DateTimeNow parameter.How to set that automation takes the correct file? If I add fixed name, it works fine but I don’t know how to make it for dynamic name. Could anyone help, please?

Hi there,I am trying to calculate a rolling average across a dynamic number of features for a certain attribute. I saw this post here explaining that you can do it using the adjacent features parameter in the attribute creator:Calculating moving average (3 rolling points) in FME. | CommunityHowever my issue is that the number of features that the rolling average needs to be calculated over is dynamic, it could change depending on the requirement of the incoming data. This number of features required is stored in an attribute called ‘consec_avg_requirement’. I therefore need to be able to set the number of prior features to use in the rolling average to be whatever the value is in that field -1. The only option shown here is to use a user parameter… but is it possible to assign an attribute to a user parameter that could vary with each run?  

Occasionally the upstream service from external provider might not retuning any features, in those cases, there will be 0 features going to the “Revised” stream. How do I stop ChangeDectector instead of keep running and delete existing features.   

Hi, I’ve got two polygon datasets A and B, and I’d like to identify which polygons from dataset B that touch polygons from dataset A, but only edge to edge contact count as touch. How can I get the ideal result or exclude vertex touches?

Dear all, I am trying to do something that seems very simple :I have a table that has 3 columns “id”, “category”, “value”  and I would like to reshape it in wide format “id”, “category.A”, “category.B”, etc. (in R, it would be reshape(dt, direction=”wide”, idvar=”id”, timevar=”category”)I have tried the AttributePivoter with the settings : Group rows=id, group columns =category, attribute to analyze = valuebut it does not work, in the output I still get the 3 columns id, category, value with missing values everywhere in the category and value columns what am I doing wrong ? would another transformer do the job ? thanks in advance 

How to trace downstream in the network with multiple sources and accumulate the value from the intersected nodes of each trace? To Illustrate please see below. Black circles are the starting points.  Appreciate your help.

Is there any way to get the “path” of a transformer so that it can be reported for a custom error logging solution. The standard FME log file has this information but I can’t find any way of getting at it inside a workspace.For example, in the image below we can see log lines being reported from a ParameterFetcher transformer which is inside the Log_Error custom transformer.  If I could even just get the name/instance of the custom transformer that would be helpful but something really useful would be to have access to the <prior> transformer.I’ve seen some other posts on this topic which talk about hard-coding log messages but it would be nice to have a more automated approach and those posts are all from before Safe changed the way log files work to include the links to the transformers….I guess what I’m really looking for is access to something like the FME equivalent of a stack trace from any point within a workspace.

I’m creating an automatic process to read in data in a feature reader and then output same attributes in the same order that they were read in, to an oracle spatial writer.I have set up user parameters in the FeatureReader for both the data to be read in and attributes to expose(.csv) however the order of attributes is not retained and neither is the data type. Currently, the attributes are alphabetised and they are all given the same data type of “varchar2”.Any suggestions on this would be appreciated.

I am trying to figure out how to parameterise the layer name for a Portal Feature Service reader. In the screenshot below you can see the highlighted Layer Name field. However it does not seem to have the ability to set it as a user parameter. You can see it is possible to set other layer variables as parameters, eg Input Geometry Type, etc. Just wondering how I might do the same for the layer name?

We have several Database Connections for our workflows, and most of them are for our county ArcSDE geodatabases. Each one has a Default version and a Sync version for editing, and we have all of the connection strings saved with the Sync version.We use FME through a Data Interoperability license, and after FME updated to 2025.0.0.0 (with the ArcGIS Pro update to 3.5 from 3.3) the Version Type is now set to ‘NONE’ for all of them instead of ‘Version from SDE Connection’ like it was before, and the Transactional Version is set to Default automatically. Plus, it seems to us that our connections strings have changed too. We found this the hard way, after changes were written straight to Default.So I guess I’m writing to see if anyone else had this problem, or to see if we’re missing something - I haven’t found any posts or fixes in the changelog about it yet. And, are there tips for how we should be storing these database connections? (I am aware it could just be a Data Interop issue - we’

Hello everyone,I already looked at the following post, but this post is already 6 years old. Myself I don't have any experience with the the FMEServerJobSubmitter and I was wondering if there are other ways to pass the job-id from one workspace to another workspace in an automation.  I tried using the automation writer as a method to pass a job-id from one workspace to another workspace, but that doesn't seem to work, the job-id is empty in the second workspace.