Best Answers

I have a zipped File GDB that I have uploaded to AGOL using the ArcGISOnlineConnector. The next step is for me to update the data. See 2nd screencapture in red circle, “Update Data”. Is it possible to update data in AGOL using FME? if yes, what transformer do I need to use?

I’d like to use FME to query ArcGIS Enterprise map services (content) and, if a new service has been published that day, post a link to the new map service in Slack. Has anyone ever done this?

I need to transpose an attribute table and tried so far the StatisticsCalculator as well as the AttributePivoter, but do not get the result I need. In addition I was following the advice of Mark (@mark2atsafe​ ) in this posting at StackExchange. While the advice from mark looks 'straight' forward, I struggle with the reader-as-resource since the data are produce through analysis within the workspace where I need to transpose the attributes. After sorting my results I get the following attribute table and what I need is a structure like So, the attribute values from the 'label' column have the provide colum names, while 'Area_perc' has to provide the corresponding values for these columns, and everything is grouped by 'Sectorname'. How can I achieve that within FME?

I have been able to extract polylines from esri fgdb, combine the lines into one record but I cannot seem to figure out how to now recalculate all the M-measures in that line. In arcmap I would manually use the Route Measure editing tools, Set As Distance to 0 and Apply Factor of 0.00018939 to recalculate the line M-measures in miles for the line. I couldn’t seem to get the measure transformers to get the result I was looking for. This was probably user error. Thanks, Ryan

I have a SharePoint Teams Channel that has Documents; a single zip file is the only document that I update. I am using FME Form 2021. I created a workspace using the Path Reader and SharePointOnlineConnector. It uploads a file to SharePointOnline and overwrites the file already there. I run the workspace with no errors. When I go into SharePoint Online, I check the file and the Date Modified does not change. The Date Modified should say “a few seconds ago” or have a timestamp. This is not a SharePoint List. Is there a way to modify the timestamp in SharePoint Online so that I know the file uploaded using FME was updated (overwritten) in SharePoint Online?

I am using FME Form 2021. I have completely re-written this post. What is the best approach to zip all Feature Classes in a File GDB without having each Feature Class show up individually in the workspace? I have 25+ Feature Classes and do not want them all to show up separately. Just want to zip up my File GDB. Sorry about the incorrect subject header.

Hello, I need your help. I'm looking for a workflow to transform my keys and values into a list. Here is an example: I have this table: Key Value a 1 b 2 c 3 a 4 b 5 c 6 a 7 b 8 c 9 and I wanna transform it to a b c 1 2 3 4 5 6 7 8 9 Thank you

I am going to read Data from ProjectWise. FME could read Folder trees (as attached picture) but accessing to folders is not possible. (my user name and passsword are correct) (Also I have the Bentley CONNECTION Client installed and logged in.) The IT guys said that they useAPI version 2.8. Is there any solution to solve this issue? Thanks in advanced

I am fairly new to FME and I am trying to pass an Excel file pathname to systemCaller so I can use it in a Python script. I need to use the SystemCaller as I am using a bat file to change virtual environment and then call Python. What I am trying to do is get FME to just pass the Excel filename via a user parameter to SystemCaller using this statement "C:\temp\Excel_processing.bat" --input "$(excel_infil)" where excel_infil = “C:\temp\Excel_processing\infile.xls” But I get a “File path is incorrect” error in the logger (not in english, so the error is a translation). I have even tried to just hardcode the input filename to the statement but get the same error. I tried this: "C:\temp\Excel_processing.bat" --input “C:\temp\Excel_processing\infile.xls” If i just use the statement "C:\temp\Excel_processing.bat" in SystemCaller, then I dont have any issues and the .bat/python script works as expected but I need FME to pass the filename along. I have a bunch of echo statements in the .bat fi

I have a file A from which I am reading the creation date through a “Directory and File Pathnames Reader”. Now I want to add the date as data in a column of file B. It should look like this: ID path_created_date 1 2025-04-04 2 2025-04-04 I tried using AttributeManager, but what I get is this: ID path_created_date <missing> 2025-04-04 1 <missing> 2 <missing> I am very thankful for any other ideas or solutions.

Hello everyone I've been designing a new custom transformer to sum up part of my workflow (in FME Form 2025.0). The issue is that I can't add any of my attributes to the text editor even though all attributes are selected to be exposed in the input parametres. Moreso, If I edit it individually, no attributes appear (as obvious), but if I edit them inside a workbench session and I choose specific attributes to expose, they are still not availaible in the text editor, but they get instead automatically added as user parametres for the custom transformer. Can anyone explain me how this works? I don't get a clear answer from looking at https://docs.safe.com/fme/2025.0/html/FME-Form-Documentation/FME-Form/Workbench/Using_Custom_Transformers.htm#Editing_Input_Output_Ports It also irritates me that it’s theoretically a copy of another transformer with a couple of changes (only adding transformers or changing their parametres, none with the inputs) and that transformer allows to add feature at

FME Form 2024.2.4 on Windows Server 2016 I’ve been using the SlackConnector transformer for quite some time to send messages when jobs have finished in both FME Form and Flow. It’s been working without fail for the past two years. Just recently we had to reinstall a few things on our VM which caused our user accounts to be wiped. This meant all our existing connections had to be recreated. Unfortunately I’m no longer able to create the webconnection in FME for Slack as it keeps failing on the authentication step telling me “your browser is not supported”. Slack stopped supporting older browser on 15 March 2025 I initially thought the default browser was causing issues so I set it again to Chrome, but I think FME Form must be running an in-built version of IE or something. I’ve also tried recreating to connection of various other machines running windows, but same issue. I can’t seem to find any way of forcing FME to use another browser. I saw on the FME known issues page a workaround b

Unable to connect to IBM DB2 in FME form 2024.2. I’ve checked with other members of my organizations’ logins and those work fine on my machine; it’s just this particular user that is having issues. Please see attached screenshots

I am using the CoordinateSystemExtractor to extract CRS from shape files. The output attribute _coordsys is an abbreviated name and hard to make use of it downstream. For example. the shape file prj file has the name “NAD_1927_BLM_Zone_15N”, which is an ESRI standard name. But the _coordsys value is _NAD27.BLM-15N.ft_0. I would hope the output is NAD_1927_BLM_Zone_15N so that I can use it directly in EsriReprojector. Any idea to achieve this? I have an excel file with over 150 global CRSs that need to reprojected to WGS 84. Both the sources and transformations in this excel file use standard ESRI names. Want to use this excel file to reproject all source datasets (shape files) into WGS 84 using just one EsriReprojector for which both the source and destination CRS parameters are set directly from the excel file. If you know a solution, please send reply to my work email - allen.guan@woodside.com. Appreciate the help.

The above error is the error am having running a workspace on FME Flow. Log ErrorThe log file for job ID "6" does not exist.

I have a routine that extracts property boundaries from a web service and outputs to shp to be imported into our Property and Rating system. I do have a Geometry Validation process to repair geometries where they may self intersect or are corrupted, however there are two polygons that are not repairing, even though they pass the test. Both are like the below. The polygon doesn’t actually cross over itself. Rather, this is two separate vertices where the bottom section meets the top section, and it’s all one polygon. Is there a way to automatically fix these with FME as we can’t edit the original. My workaround is to have the tiniest buffer and dissolve so the vertices don’t touch which passes the validation test in our P&R import, but ideally we should have clean geometries. Any help appreciated. Regards, Josh

Hi, I have one column in my excel file that show tha values like below: VARIEDADE ABB4, ABB2, ABB4, ABB5 ABB4 ABB2, ABB5 ABB2, ABB2 ABB4, ABB4, ABB4, ABB4 The two last lines have the same value separated by comma. I would like to simplify like below: ABB2 ABB4 How Can I do this? Thank´s

We just a installed a new ArcGIS Enterprise (11.4) environment and want to connect to it with FME 2024.2 I successfully configured a Web Connection to the ArcGIS Portal using this guide. When I try retrieve Features Services from Portal this takes very long (4min) and eventually I get the an "Error Retrieving Selections” as below I tried connecting to https://mydomain/portal/sharing/rest/portals/self directly with an HttpCaller and the same Web Connection and that gives a good response✅. So my web connection is able to connect to ArcGIS Portal successfully. Just not with the FeatureReader. And also not with a traditional reader. Any ideas on how to solve this?

Hello everyone, I recently got my computer running FME Form replaced and made some observations regarding performance that I wanted to lay out since I am not sure that everything runs as it should. I am testing with a big workspace with close to 1000 transformers. Coming from an aging Intel i5 6th Gen with 32 gigs of RAM and now sporting an Intel i7 14700-K with 128GB of RAM I was expecting some substantial performance uplifts. The observation I made is this: Yes, when I only read and write locally I am seeing a good boost in performance (a little over 2 times faster). However, in production this workspace is meant to write to a PostgreSQL database over the network. In this scenario my new computer is very close in performance to the old machine, even getting beaten by a few % in overall processing time (writing to the same database over the network). Here is the numbers. New Computer Old Computer Writing around 430.000 Features to database over network 1hr 39m 1hr 29m Writing around 4

Dear All, I am attempting to spatially join the nearest points based on a one-to-one relationship but cannot get it to work. Below is a graphical example of my query: I aim to join the closest yellow dot (627 records) to the nearest black dot (71,533 records). Essentially, I want the Neighbourfinder to identify the closest one-to-one relationship and disregard the others. The default settings of the transformer calculate the nearest points for all 71,533 records, which I wish to avoid. My objective is to integrate the information from the yellow dots into the black dots for only the 627 closest records. Any ideas? Thanks :)

I am new to FME and I wish to make the following transformation. From:IDColAColBColC1A1B1C12A2B2C23A3B3C34A4B4C45A5B5C5 To:IDColumnNameValue1ColAA11ColBB11ColCC12ColAA22ColBB22ColCC23ColAA33ColBB33ColCC34ColAA44ColBB44ColCC45ColAA55ColBB55ColCC5 Can anyone help me out?

I have a new attribute named EXPORT_YEAR. I want the Attribute Value to automatically change to 2026 at 12:00AM Jan 1, 2026. Until then it will stay 2025. Is this possible? if yes, what expression do I use?

Hi, we are silent installing FME Flow for the first time. We used to install FME Server using a silent install script, which uses the next installation properties: FMESERVERHOSTNAMEINSTALLDIRFMESERVERSHAREDDATAPGDATAWEBSERVERHOSTNAMESERVLETPORTDATABASEPASSWORD In the new FME Flow silent install instructions, a different set of installation properties is used. I think the properties above compare to COREHOSTNAME (changed)INSTALLDIR (unchanged)FMEFLOWSHAREDDATA (changed)PGDATA (unchanged)EXTERNALHOSTNAME (changed)SERVLETPORT (unchanged)DATABASEPASSWORD (unchanged). My questions: Can this be confirmed? Would it be possible to get a link to the location where this is documented?

@safe I just recognized that the SpatialRelator in 2025 does not release my Requestor attributes as before (2024 and any older version I remember). I’m used to use the SpatialRelator with the setting ‘Generate List’ checked (incl. some selected attributes) and keeping the ‘Merge Attributes’ unchecked. As a result I see all my Requestor attributes and where applicable the list attributes according to the spatial relation I’m looking for. Now in 2025 the above setting ONLY releases the list attributes and all my Requestor attributes are removed. The only way to bring it back is to check the ‘Merge Attributes’ checkbox as well, which is not my intention. I guess it’s a bug since the Transformer page still states for ‘Output’: These are the Requestor features with the new attributes added. One list entry is made for each of the Suppliers that has at least one matching predicate. FME Form 2025.0 build 25208

We are converting a number of GIS-focused Automations in FME Flow 2024.0 to use the new SDE Database Connections instead of the old PATH resource. FME Flow is returning an error when attempting to read the new database connection properties: ‘An error occurred while attempting to retrieve the connection parameters from the connection file’ For each of the FME Flow Database Connections, we used an FME Resource, ‘SDE_GISD’, for the path reference for the connection file. We found if we use a UNC path instead of the FME Flow resource it works as expected. Is this a limitation or are we doing something wrong? Connection works as expected on local host, local server host, and with UNC path for the database connection within FME Flow. Just not with using a Resource path in the connection. Error: 315 2024-7-31 11:51:25 | Opening the Esri Geodatabase reader 316 2024-7-31 11:51:25 | An ArcGIS license is already checked out. The product checked out is 'ArcServer' 317 2024-7-31 11:51:25 | Install