Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
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

7036
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. 

281
takashi
Celebrity
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

514
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. 

220
virtualcitymatt
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,

191
j.botterill
Influencer
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 

2706
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

741
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

403
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. 

36523
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

26419
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!

28610
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.

1014
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

250
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

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

262
geomancer
Evangelist
tp_atkins
Contributor
tp_atkinsContributor
asked in Transformers
Unable to connect to PostgreSQL database server - FME Form 2025.1 - No module named psycopg2._psycopg

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 

452
tp_atkins
Contributor
fiona1112
Contributor
fiona1112Contributor
asked in Integration
Table in SDE can't be loaded

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? 

637
fiona1112
Contributor
tsirkuse
Contributor
tsirkuseContributor
asked in Transformers
Copying folder structure only with FileCopy ?

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 

713
geomancer
Evangelist
nic_ran
Contributor
nic_ranContributor
asked in Authoring
How do you delete an FME Flow connection in FME Form 2025?

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.

8412
hkingsbury
Celebrity
ed-progres
Contributor
ed-progresContributor
asked in Data
How to visualize GeoJSON data?

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

553
alexbiz
Influencer
bubblebeb
Contributor
bubblebebContributor
asked in Transformers
Emailer - Improve detection of HTML content in message body. (FMEENGINE-86584)

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. 

453
alexbiz
Influencer
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Transpose Excel Columns & Rows / AttributePivoter

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 

413
lambertus
Enthusiast
evoteck
Enthusiast
evoteckEnthusiast
asked in Data
Excel wr

  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            

7314
evoteck
Enthusiast
couch
Contributor
couchContributor
asked in Data
dgn styler - 3D symbols

Hi, Has anyone had any issues placing in 3D symbols via cell file into FME DGN styler? It seems as soon as a solid or surface is involved the symbol dies not show correctly i.e these elements are missing. any advice thanks?

151
j.botterill
Influencer
aashnaparikh
Contributor
aashnaparikhContributor
asked in Authoring
Regex for flipping year month to month year

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

533
takashi
Celebrity

Badge Winners

  • FME Flow Authoring Training
    janethas earned the badge FME Flow Authoring Training
  • Webinar Watcher (Grey)
    ks1345has earned the badge Webinar Watcher (Grey)
  • Expert (Grey)
    hawaiialexhas earned the badge Expert (Grey)
  • Canada Day
    mark2atsafehas earned the badge Canada Day
  • Webinar Watcher (Grey)
    kaylavoxhas earned the badge Webinar Watcher (Grey)
Show all badges

Community Stats

31,835
Posts
120,911
Replies
39,470
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.