Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
vassok
Contributor
vassokContributor
asked in Data
Field Data Type Issue when writing to Microsoft SQL Server

Hi! I have encountered the following error when using Feature Writer transformer (dynamic workspace) writing a Microsoft SQL Server Spatial table.  2025-08-06 16:11:20| 148.0|  0.0|ERROR |Microsoft SQL Server Spatial Writer: Query failed, possibly due to a malformed statement.  Query Text `CREATE TABLE [Infrastructure].[Fire_Hydrants_Audit] ([FH_ID] bigint, [Work_Required] bit, [Paint_Post] bit, [New_Post] bit, [Paint_Surround] bit, [Clear_Vegetation] bit, [Post_Reflector] bit, [Inspection_Date] datetime2, [Inspected_By] varchar_max, [Works_Completed] bit, [MI_PRINX] integer, [SP_GEOMETRY] geometry)'. Provider error `(2715) Column, parameter, or variable #9: Cannot find data type varchar_max.'Any thoughts how to resolve this? Thanks!

225
vassok
Contributor
jackyd
Contributor
jackydContributor
asked in Transformers
SchemaMapper missing Microsoft SQL Server database format

I am upgrading a workbench from 2022 to 2025, this is updating the Schema mapper from 2 to 3, but SchemaMapper version 3 does not appear to have Microsoft SQL Server as a format type. Am i missing something?SchemaMapper Version 3SchemaMapper Version 2 

172
jackyd
Contributor
francisco_1988
Contributor
francisco_1988Contributor
asked in Transformers
AttributeExposer

How can I automatically add all attributes in AttributeExposer after AttributeTransposer without having to manually select each one?

194
danilo_fme
Evangelist
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Authoring
Any way to propagate attribute renaming to downstream references?

I have a workspace and I want to turn it into a CutsomTransformer - as part of that process I want to rename a bunch of attributes to include a prefix (e.g., from a JSONFlattener) - This is mostly for readability.For example I have several attributes which are coming from a JSONFlattner - in the original I never added a prefix, however, now I want to prefix with something like “layer.” - so something like “extent” would become “layer.extent”. The issues is that when I add that prefix in then all the downstream transformers which use the properties break. Obviously going through and changing them would have taken me less time than writing this question but it’s certainly not the first time I’ve had this kind of issue.In similar situations in the past I’ve been lazy and have simply renamed the new attribute to the old value. There are quite a few situations where I think having this kind of functionality would do a lot to improve workspaces readability with little effort on the authors p

495
hkingsbury
Celebrity
francisco_1988
Contributor
francisco_1988Contributor
asked in Transformers
Formatting Problems with XML Output Header and Footer in FME

Hello, I’m new to this forum and have been working with ETL and FME Workbench for a short time.I’m facing an issue with my XML output: the header and footer formatting come out messed up.This formatting problem does not appear inside the XMLFormatter transformer, but after saving the physical file, the formatting issue becomes clear.Has anyone experienced this or knows how to fix it?

232
francisco_1988
Contributor
arepsherbentear
Contributor
arepsherbentearContributor
asked in Authoring
ArcGIS Online Feature Service Writer Error Code '1000' - Conversion failed when converting date and/or time from character string

Edition: Data Interoperability, Fixed OEM LicenseVersion: FME(R) 2025.0.0.0 (20250228 - Build 25208 - WIN64)OS Locale Name: en_USOS Encoding: windows-1252Process Encoding: UTF-8FME API version: 4.0 20240722Home Folder: C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\Operating System: Microsoft Windows 11 64-bit (Build 26100)For clarity, I am working with FME Workbench provided by Esri in both the Data Interoperability extension for Pro - and Server.  The server situation is worse at this point, so to start, I am just going to address the problems that I am seeing on my laptop.I am calling a number of different API endpoints with an HTTPCaller, manipulating the data, and then pushing (updating) the data in an ArcGIS Online (AGOL) Feature Service.  When I was building this workflow, I was successful in writing changes to the Feature Service.  I can step through transformers, check the cached data and then click on the ‘Run To This” to run the cached data from the previous tr

333
arepsherbentear
Contributor
probert1968
Contributor
probert1968Contributor
asked in Data
How can I fix the Annoation scale to readable ?

I am working on a lot of the DWG we got from a contractor and I have to deal with it because our forest is using a different projection and the units are different.  However, I have no troube with write to a new DWG with the correct projection and units.The only one probem I have here  is the Annotation which is different between the FME Data Inspector and ArcGIS Pro I have here.  The Annotation scale is way big and all over that I cannot read in ArcGIS Pro.Is there a work around to fix the problem ?I am in Colorado and work for a forest service.  I have two screenshot that will be helpful  This picture is in FME : and this is in ArcGIS Pro  Can anyone out there that have had similiar issues or a problem solved in the past ? Thanks !

473
crystalatsafe
Safer
thijsknapen
Contributor
thijsknapenContributor
asked in Transformers
How to differentiate Empty String and <null> value in XQuery/XMLTemplator

Hi, I was wondering if there is a way in which it is possible to differentiate between an Empty String and a <null> value when using (XQuery in) the XMLTemplator. As an example I created 4 features. The first having a regular string value, and the latter 3 having 'no value', but each a different type of 'no value' (empty string, <null>, <missing>);When creating a dummyXML, I would like to be able to be able to handle/create a different 'b' element, based on the value of the attribute b. Let's say I have two fixed elements 'a' and 'c', and I want my dynamic 'b' element to be placed in between these two, then iterating over the different 4 features I would like to obtain the following result;<dummyXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">    <a>value_a</a>    <b>value_b</b>    <c>value_c</c></dummyXML><dummyXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">    <a>value_a</a>    &l

6736
thijsknapen
Contributor
dustin
Influencer
dustinInfluencer
asked in Data
OSM tag ordering

What controls the order in which tags are written in the OSM XML writer? I have a set of attributes that are ordered alphabetically in the writer. The attributes are even ‘ordered’ on the features (which shouldn’t matter?).  As you can see 'smoothness’ was assigned as the second tag, when I would have expected ‘highway’ to be the second tag.Inspecting the written dataViewing the XML file in Notepad++Attributes are listed alphabetically on the OSM XML writer. 

211
takashi
Evangelist
ssmith_ftr
Contributor
ssmith_ftrContributor
asked in Transformers
JSONUpdater and JSONiq

I’m trying to make use of the JSONUpdater transformer since it seems more clear than doing a search & replace. My issue is I just can’t understand the JSONiq enough to know what I need to do to always find the right JSON Path. I’m reading in a JSON template and in this template are 3 objects at json[“flowcontents”][“processors”]. The problem is the order can change for the processors. I might want 0, 1, or 2. The key is the object # I want always has “name : Build-Parameters”.I’m thinking I have two options.Is there a way with JSONiq to always specify the correct JSON Path in the JSONUpdater, based on the name of each object. Maybe I sort the processors objects in the JSON prior to the JSONUpdater transformer. Then I always specify the correct one to find path. (Thankfully the order doesn’t matter when I push the results back.)I went ahead and made a very simple Workbench which demonstrates my JSON and the problem. Could someone help with either solution or maybe something else I d

364
ebygomm
Influencer
virtualcitymatt
Celebrity
virtualcitymattCelebrity
posted in Authoring
Parameter Editor - It has it's uses.

I’ve been a big of a hater of the Parameter Editor window for a while - I’ve always had it disabled in favor for more canvas space, plus I just like bigger windows to work with in general.Today though, while working in the PythonCaller, I really wanted to look at my log file - I always had to keep closing the editor to scroll though the log. Then I remembered about the Parameter Editor window and it made things waaay easier. I’m not sure I’ll keep it like this but for now I’m really liking it. 

140
virtualcitymatt
Celebrity
sbnikkou
Participant
sbnikkouParticipant
asked in Transformers
InlineQuerier Fails When One Input Port Receives No Data in FME Form 2024.2.1

Hi all,I’m encountering an issue with the InlineQuerier transformer in FME Form 2024.2.1 (pre-production environment) that seems to differ from previous behavior.(FME Form 2024.1.3 in developement environment)🔧 Workspace Setup:The InlineQuerier has two input ports:tubes (can sometimes receive no features)parametre_generique (always receives data)I’m using this request :❗ Problem:When no data arrives at the tube input port, the transformer throws the following errors:InlineQuerier_2 (InlineQueryFactory): Generating output 'tubes_statuts_inactifs' using query 'SELECT * FROM "tubes"WHERE (    UPPER("statut_administratif") NOT IN (        SELECT TRIM(UPPER(value))        FROM "parametre_generique",             json_each(                 '["' || REPLACE("valeur_parametre_text", '|', '","') || '"]'             )        WHERE code_parametre = 'STATUT_ADMINISTRATIF_RETENU_TUBES'    )    OR    UPPER("statut_operationnel") NOT IN (        SELECT TRIM(UPPER(value))        FROM "parametre_generiq

202
redgeographics
Celebrity
charlesdollat
Contributor
charlesdollatContributor
asked in Authoring
Add CSV data to an existing DGN in the correct levels

Hello everyone,I am having difficulty adding data to an existing DGN file.I have a CSV containing X, Y, Z and a Matricule.I want to add this data into a DGN that already contains points and predefined layers (levels).I just want to complete the DGN with my CSV data, putting the new elements into the correct layers.I find DGN handling in FME much harder compared to working with simple shapefile layers.I have managed to roughly merge my points, but the values do not go into the correct layers and they don’t take the original DGN styling.For example, I want the Z value from my CSV to go into the layer “CALC_PTTOPO_ALT”On paper I thought this would be simple, but I can’t find the solution.Can you help me, or tell me if there is an easier way?In the long run, I would just like to update my DGN regularly when I have new points.Thanks in advance,

111
j.botterill
Influencer
hieutran
Contributor
hieutranContributor
asked in Data
Error when converting data have relationship

Hi all,The data in my geodatabase file has an attached layer for each data layerI want to perform some transformer in FME and got the error:“An error occurred while attempting to open an insert cursor on the table 'XXX'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [DMA]}GEODATABASE_FILE writer: An error has occurred. Check the logfile above for details”I found the solution is to change the setting in Transactions Type to Edit SessionBut after setting, some layers can perform the conversion but some layers get the error:“An error occurred while attempting to stop an edit operation. The error number from ArcObjects is: '-2147220975'. The error message from ArcObjects is: {File read/write error occurred. [XXXXXX]}GEODATABASE_FILE writer: An error has occurred. Check the logfile above for details”Can anyone please advise me what I need to do now to fix these errors

1121
mapmonkeythe2nd
Participant
larue
Contributor
larueContributor
asked in Authoring
Package Development: How Do They Work? (on a Mac).

I have been trying to set up a Package dev environment on a Mac (Sonoma 14.7.7) and it crashes every time I get to the ‘import fmeobjects’ test in the venv.  Just getting that far was a huge hassle.  It appears that the SDK instructions and fme-packager library are geared for Windows. I had to modify the fme_env.pth file to only show the FME Home path and get rid of the rest, for instance.  The issue seems to be that the native FME python 3.13.5 library does not like the Python.org 3.13.5 library, but can’t say for sure. Are Macs even supported for this?  I currently don’t have access to v2025 on Windows.If anyone has had success making packages using MacOS, any insight is appreciated.  Bonus points if you have a good ICP reference! Thanks,-Loren

80
larue
Contributor
lance
Contributor
lanceContributor
asked in Transformers
Creating a new feature class in a GEODATABASE from an ARCGISFEATURES source fails.

I am using FME Workbench 2022.1 along with ArcGIS Pro 3.0. I recently noted an issue when copying data from an AGOL MapService to a local GDB - if the feature class does not exist in the GDB, the Workbench will fail, only reporting "Error running the translation" and no further details in the log file. However, if I create a feature class in the GDB, even without any attributes, and change the writer to "Drop and Create" from "Create If Needed," the Workbench runs. Any Ideas?  Log File attached 

2606
crystalatsafe
Safer
ecx
Supporter
ecxSupporter
posted in Authoring
How to Actually print a workspace as a PDF

This is a quick rough guide on how to print your workspace as a PDF. This should be a standard feature of FME, but it is not. Printing off a workbench is very useful when creating documentation about workbenches. I am surprised at the lengths I had to go to for this. Step 1:Follow this, or any other guide, on how to set up CUSTOM Paper Size for PDFs I recommend adding size: *Option: CUSTOMSIZE{*rcNameID: =USER_DEFINED_SIZE_DISPLAY*MinSize: PAIR(936000, 1332000)*MaxSize: PAIR(109728000, 164592000)*MaxPrintableWidth: 109728000}Then, printing the item requires another bit of jankyness to make this work:  click landscape make sure there is only 1 page press fit to scree now it looks “ok” to print, but it isnt yet. hit the print button (mine is missing for some reason) select print to pdf hit preferences hit advanced  choose your newly defined page size hit apply DO NOT PRINT YET. exit the window.Finally, hit the fit to page once again (step 3)Now, hit print again, and print your item to p

631
crutledge
Influencer
probert1968
Contributor
probert1968Contributor
asked in Data
Preserver lines from change after saving to a new DWG

Hello ! I have a DWG that has a different type of feature that I cannot convert to ArcGIS Pro because it does not recongize it or unable to keep it preserve the line..This is an oiginial DWG I have here : After I save them to a new DWG with set to ESPG 26913.  I got this It looks like a feature change for line from an oroginal to a new one above the picures here… Is there a way for me to preserve the lines from  change it ? Thanks

383
probert1968
Contributor
jacintasomers
Contributor
jacintasomersContributor
asked in Transformers
FME 2024.1 SharePoint Reader

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. 

32523
clang
Contributor
nielsgerrits
VIP
nielsgerrits
asked in Integration
FME 2025.1 + PythonCaller + arcpy + Emailer fails

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

22019
crystalatsafe
Safer
rtreecare
Contributor
rtreecareContributor
asked in General
ArcGISOnlineConnector - Export and Download?

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!

26010
salvaleonrp
Enthusiast
nielsgerrits
VIP
nielsgerrits
asked in Integration
FME 2025.1 PythonCaller can't run arcpy?

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.

924
crystalatsafe
Safer
messagemauri
Contributor
messagemauriContributor
asked in Transformers
Esri Feature Service Insert operation failing

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

140
messagemauri
Contributor
telfma
Contributor
telfmaContributor
asked in Data
Reading WMS service with scale threshold

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

172
telfma
Contributor
emerson_styles
Contributor
emerson_stylesContributor
asked in Authoring
How to extract coordinates from json file and create geometry?

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?​​​​​​​

182
geomancer
Evangelist

Badge Winners

  • Summer Bingo 2025 Participant Badge
    jackydhas earned the badge Summer Bingo 2025 Participant Badge
  • Summer Bingo 2025 Participant Badge
    baylyshas earned the badge Summer Bingo 2025 Participant Badge
  • Summer Bingo 2025 Bronze Badge
    crutledgehas earned the badge Summer Bingo 2025 Bronze Badge
  • Summer Bingo 2025 Participant Badge
    df_coshas earned the badge Summer Bingo 2025 Participant Badge
  • Summer Bingo 2025 Participant Badge
    spatialqueryhas earned the badge Summer Bingo 2025 Participant Badge
Show all badges

Community Stats

31,632
Posts
119,904
Replies
39,275
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.