FME Form

I have a workspace created in 2023.2 that reads an Excel workbook from a SharePoint library. It is working perfectly.I have upgraded to 2024.1 and the reader no longer works as expected. If I use the 2024 Data Inspector I can connect to the workbook and see the data. The FeatureReader obtains the schema and the number of records in each sheet and gives a “Translation was SUCCESSFUL” in the log. The issue happens after that - I get some sort of (possibly) Python related error. Log file of messages after the successful log entry is attached.I have tried changing the Python version but it didn’t make any difference. Has anyone had the same issue or any ideas what I could try to get it working again. 

We are migrating to FME 2025.1 and I have a question about arcpy and the Emailer.I have a workbench with a Creator and a PythonCaller. In the PythonCaller I added import arcpy. Python Compatibility is set to Esri ArcGIS Python 3.11. This works.Now I want to add the Emailer transformer and I get the following screen:If I Choose Cancel, I get no Emailer.If I Choose Change Python Compatibility, I can add the Emailer. But now I the PythonCaller fails.To solve that, I need to Change the Python Compatibility back to Esri ArcGIS Python 3.11. But if I do this, I get the following screen:How can I configure my workbench to have both a working PythonCaller using arcpy and the Emailer transformer?I need this on desktop (combined with ArcGIS Pro 3.5) and on server (combined with ArcGIS Enterprise 11.5).The following transformers are problematic as well:SharePointOnlineConnector HTMLReportGenerator AutodeskDocsConnector

On the item page of a hosted service you can export to fgdb and other formats. The benefit of this over an fme reader and writer workflow is the easy preservation of unique ids, relationships and attachments. The also take no local compute power/time. Is there a way perform the "Export To FGDB" or other formats within FME?I see that there is a method to download items from arcgis online with the use of the ArcGISOnlineConnector (https://docs.safe.com/fme/2020.1/html/FME_Desktop_Documentation/FME_Transformers/Transformers/arcgisonlineconnector.htm)If I could create the fgdb through fme, I'm pretty sure I could also download and manipulate it within a workspace. I'm doing some lengthy transformations on a million+ records. Performing these actions through the Online Readers/Writers is taking hours (90% is reading from the REST API) and I need to reduce that time.  Thanks!

We are migrating to FME 2025.1 and I have a question about arcpy.I set the Python Compatibility to Esri ArcGIS Python 3.11. I then add a PythonCaller. Now workbench asks me to change the Python Compatibility to Python 3.13+?  If I choose Cancel, I won’t get a PythonCaller.If I choose Change Python Compatibility, and I add “import arcpy” the workbench fails.What am I supposed to do to let FME 2025.1 run arcpy? Also for FME server.

In ArcGIS Pro, I have a published a map service as a feature layer service to our ArcGIS Portal. I have published it as the owner and Admin with enable editing permissions etc. The layer source comes from an SDE with SELECT, INSERT, UPDATE, DELETE privileges.In FME Desktop 2025.1, I have a FeatureWriter using the new Esri ArcGIS Feature Service format. I have it successfully connected to our Portal via OAuth (safe.esri-agol) and with the the writer settings for Feature Operation set to Insert and feature type handling set to Truncate Existing. See image below.When I run the workbench, after a period of time, it outputs back an error: ArcGISFeatureServiceWriter: Feature Service 'Sample Layer(7ea7230cca1f4aeb9316ed1735cca5c2)' does not support feature operation 'INSERT'. Its owner may have disabled inserting or editing features. Writes may fail if the current user is not the owner or administrator.This process used to work at some point when it was using the old format Esri ArcGIS Portal

Hi,I am trying to read from a publicly available WMS service (https://environment.data.gov.uk/spatialdata/nafra2-risk-of-flooding-from-surface-water/wms), layerrofsw_4band.I have connected to the service in FME Form using a reader and bounding box for my area of interest. The reader runs, reporting success, but returns only a single line entry and a white dotted square in the preview.Adding the layer to ArcPro works fine and data can be viewed as expected.I believe the issue is due to scale thresholding applied to the service by the provider. No features are returned unless the map scale is less than 1:50k. My bounding box is much bigger.This forum post is the closest to my problem, Problems reading WMS layers? | Community, but doesn't suggest a solution.In the reader it does not seem possible to set the scale to operate at.Would the workflow required to access the features be something like:Split my area of interest into a grid, where each square is <1:50k. Somehow call the WMS ser

I have a json file that holds coordinates in the following format: How an I extract these coordinates to make the polygon that they form? I have tried reading the data through a text reader instead of a JSON reader and I have tried the JSONFragementor/JSONExtractor transformers but I can’t get the json query right, everything gets rejected.Any ideas?​​​​​​​

We have a PythonCaller which uses the psycopg2 import statement and then uses the pgsql server parameters to connect to a pgsql server and create database ((eg: https://wiki.postgresql.org/wiki/Using_psycopg2_with_PostgreSQL). This works fine in FME Desktop 2021.1 and FME Server 2021.1Currently we are migrating to FME Flow 2025.1 and this caller fails when run in Flow (server) and local desktop in Form, both in 2025.1. The location of the psycopg2 package is in \Documents\FME\Plugins\Python folder in the local desktop. With same setting, it works in 2021.1, but not in 2025.1Have I missed anything?The specifc error is: No module named psycopg2._psycopg 

Hi,I am using FME workbench 2024.1 to read an SDE database, every ting looks good, but tables can not be loaded. SDE database works in ArcGIS Pro, and the testing data connection in FME are also good. Anyone has experienced the same? 

Hello,I am looking for additional insights on File CopyIs it possible to copy folder structure without copying files inside ? How do I set the writer ? What is the filecopy_type parameter ? and what are it’s possible values ? The parameter exists on the writer but I can’t find any information.Thank you 

Does anyone know how to delete an FME Flow connection in FME Form 2025+?FME Flow connections used to be configured in the FME Options dialog under the Web Connections tab but they are no longer there in FME 2025. Instead, they are now available from the main FME Form toolbar.Using the toolbar I can create a new connection, select and edit an existing connection, but I don’t see any option to delete an existing connection. Even the FME Form documentation does not provide any help.

Hello,I'm scraping data using an HTTPCaller.One of the attributes contains GeoJSON data:{"type":"FeatureCollection","features":[{"type":"Feature","properties":{},"geometry":{"coordinates":[[[5.96266096723135, 51.9996241913007],[5.96267141231219, 51.9996290142943],[5.96315710713663, 51.999175649922],[5.96290120337337, 51.9991708268575],[5.96266096723135, 51.9996241913007]]],"type":"Polygon"}}]}I'd like to visualize these polygons in the Data Inspector but I don't know how to convert this data into an actual polygon.What transformers do I need?Thanks

I have an emailer in a routine which has html content and it has been working fine for years. I have just updated the emailer package and it is now emailing all the html code to the recipient rather than rendering the email using the code. I noticed in the change log that this version has “Improve detection of HTML content in message body. (FMEENGINE-86584)” but it looks like it has less detection of HTML. has anyone else come across this issue and how to resolve it. There doesn't appear to be any guidance on how to manage this change in the package / transformer. 

Hi All,I’m not able to transpose rows to column and complete a count in the end of the workflow, I have followed the technical article but couldn’t make it to work:https://support.safe.com/hc/en-us/articles/25407761369741-Transpose-a-Table-Using-FMEAlso below an screenshot of the requested output which a excel pivot table: Attached a sample of the raw table that needs to be transposed (or pivoted!)Can I achieve this with the AttributePivoter?Thanks 

  Which Fme Transformer will enable me write an Excel Output Data to accept Large Numbers  (e.g. No1 below)                                                      No1 4111101101005601100102002                                                              No2 Instead of this Scientific Notation of Enconded Number (e.g. No 2 below)       4.1111011010056E+24            

I have a field Filename where the naming convention is usually 2025 May Report.xlsx or 2025 January Report.xlsx I have used the filenamepart extractor transformer to fetch the filename along with a string searcher transformer just to extract the year and month  from the filename. Now I want to create an additional field where I can flip the year and month -→ Month Year. How can i build the regex to achieve this? Also I might be expecting different scenarios where January is written as Jan, JAN or january

Hi,  How can we set the set the limit for max features to write in the feature writer? I have set the limit of 10,000 in max features to read in the feature reader; will that automatically imply to write 10,000 to the feature writer

Hello,Sorry for the inconvenience. We've never installed a floating license. Is there a process, or do I just need to specify where it's located?Thank you for your help.Regards.

I want to Create a choice User Parameter that will show column list details from database, This will enable me to select my choice column field that when I run the workflow, I will be able to get the output result for only the column in a fanout dataset.

Bonjour,Je souhaite calculer une statistique zonale afin d’obtenir la moyenne des valeurs de pixels d’un raster, sur une couche polygone (vecteur), comme on a l’habitude de le faire dans un logiciel SIG (voir capture ci-dessous).Merci pour votre aide. 

Hello Folks,I have been presented with an interesting issue.I have a CSV which consist of data with multiple headers and related data for those headers.  #header 1 and valuesobservationId,broid,_response_body_new,_http_status_codeid_01682157639,GLD000000036023,"""BRO-ID"",""bronhouder"",,""kwaliteitsregime"",""datum eerste meting"",""datum recentste meting""GLD000000036023"",""50200097"",,""IMBRO"",""(2005-11-27, JJJJ-MM-DD)"",""(2025-04-10, JJJJ-MM-DD)"",,,,,#header 2 and values""put BRO-ID"",""put buisnummer"",,""monitoringnet BRO-ID"",,GMW000000074173"",""2"",,,,,,,,,#header 3 and valuesobservatie ID"",""start observatieperiode"",""eind observatieperiode"",""observatietype"",""mate beoordeling"",""observatieproces ID""id_OMO_95135"",""(2024-07-18, JJJJ-MM-DD)"",""(2025-04-10, JJJJ-MM-DD)"",""reguliereMeting"",""volledigBeoordeeld"",""id_OP_95135"",,,,,#header 4 and values""tijdstip meting"",""waterstand"",""status kwaliteitscontrole"",""censuurreden"",""censuurlimietwaarde"",""inter

I wonder if there’s a way for me to hack the web connection during run time to expose the AGOL Organization URL and token so I can use this URL downstream.The ArcGISOnline Connector returns these as format attributes but I have the extra overhead of running the right action item to expose them. Submitted an Idea related to this:  

Hi.I built a workspace in 2024.1, that fetches a number of files from a customer Sharepoint site. It works (in 2024.1) without problems.I just installed 2024.2, and ran the workspace (with no changes).Now it issues an error with a SyntaxWarning from the package “safe.microsoft-sharepoint”:C:\Users\xxx\AppData\Roaming\Safe Software\FME\Packages\24783-win64\python\safe.microsoft-sharepoint\stringcase.py:247: SyntaxWarning: invalid escape sequence '\W' return re.sub("\W+", "", string)Is this something that I should worry about ?SharepointOnlineConnector is not listed as an upgradable transformer in 2024.2Cheers.

SOLVED - I found the error Hello!I've been working on a script that has 56 columns (client needs all the fields of information), and now I need to write it using an Esri File Geodatabase writer. I have double- and triplechecked whether there is an invalid character (since gdbs are quite strict with field names) or a duplicate of one of the fields, but I cannot find it. Is there a tool in FME that let's you identify a duplicate of a whole column in the attribute table? Or a duplicate field name? Or does anyone know if there is another common solution to this error?This is the error code:ERROR |An error occurred while attempting to create the feature class 'Test'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column. [Test]} I am using FME form 2024.1.Thank you in advance!

Hello!Is there a way to change the displayed date in a datetime userparameter as DD-MM-YYYY?The chooser interface is helpful to check if it is the right date, but it can still be quite confusing, especially in Flow, when not every user knows about the picker and just enters the date. Is there an option I am missing or is a text-field instead my only alternative? Many thanks in advance!