FME Form

Hello, I am exporting addresses from an Enterprise GDB into an Excel spreadsheet. I have created the Excel Writer, and it successfully writes the data to the spreadsheet. But when I open the spreadsheet, the column widths are crazy wide, and the names are not bold or centered. Is there a way to control the column widths and column names (make them bold and centered)? The screenshot below shows the Excel Writer (“Template”) and the parameters I have set.  

Using FME 2025 and ArcPro 3.1.7 and the python environment located in C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3, (3.9.16) the python code below works.Using FM 2025, and ArcPro 3.3.5 and the python environment C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3 (3.11.8), it fails to load the necessary DLLs when importing fmeobjects and crashes.Switching back to ArcPro 3.1.7 it works again. Can anyone help me import fmeobjects using ArcPro 3.3.5? What am I missing? import osimport sysos.environ['PATH'] = r'C:\Program Files\FME' + os.pathsep + os.environ['PATH'] sys.path.append(r'C:\Program Files\FME\python')try: import fmeobjects print(dir(fmeobjects)) runner = fmeobjects.FMEWorkspaceRunner()except ImportError as e: print(f"Error: {e}") 

I'm trying to use RasterClipOverlay to extract an area on GeoTIFF defined by a polygon.  FME is currently giving me the incorrect area.  The Workspace: The workspace has a polygon coming from a POSTGIS layer which is filtered. It also has an GeoTIFF  both of which are inputs to the RasterClipOverlay.  The results are output to a GEOTIFF.  As a test I have also added a simple output image that does not come from the RasterClipOverlay. Both the polygon and image are in the same projection EPSG:3395.The original image (displayed in QGIS):   The polygon (in QGIS):The results: Displayed in QGIS with Open Street Map behind and the polygon overlaid.​​​​As you see from the results, the area of the map is not correctly extracted.  The polygon is supposed to cut out the sea, however, it also cuts the map boundaries and part of the land. The shape of the cut is correct however the map is “shrunk” hence the area of the map is incorrect. This is just one example, I have various other maps I’m worki

Im wanting to see the http it’s generating so i can understand where its going wrong. Is there a way to see this - without it being submitted? Or even if it’s being submitted? Im sure im missing something. JKW

I am using FME Form 2024.0 to read an excel file for processing.  The reader is not determining the correct max length of multiple text fields in the XLSX file.I have set the max rows to scan to a value larger than the total row but short of manually setting these values I cannot get the reader to detect the correct field length.The FME Help for the MS Excel Reader states to leave this setting blank to scan all rows but the transformer will not except a blank value.I also tried to use the FeatureReader rather than a standard Excel Reader with the same results.  I want this to be dynamic as the data being read is variable.  Any suggestions or workarounds?

Hi,How can create a published reader parameter for gdb feature classes?The gdb conation Point, line Polygon feature 

Apparently this feature was finally introduced 5 months ago, yay. I’ve been waiting for this for 5 years.I’ve just tested it today, with a PKCS#12 certificate, and unfortunately it doesn’t work.We’ve sofar been using our own C# service provider for this, and the certificate is used here on a daily basis with success. And I’ve verified the private key password.Has anyone tried this feature (with PKCS#12) yet with success ?Using 2024.2.3 (build 24825).Cheers.

Hello everyone,I was wondering if there is a simple way to filter one Dataset by comparing key-values with another Dataset. Basically a Join but onlky keeping Left Attributes.Example:Dataset1 Project SubID moreAttributes from Dataset1 ABC 1 ... ABC 2 ... DE 1 ... DE 2 ...  Dataset 2: Project SubID different Attributes from Dataset2 ABC 1 ... ABC 1 ... ABC 3 ... ABC 3 ... DE 2 ... FG 3 ...  I want to Filter Dataset 2 to only keep the ABC|1 and DE|2 rows because they match dataset 1. I am sure I could accomplish this via join and subsequently throw out all the Attributes that were introduced from dataset 1, but I was wondering if there is an easier way. Thanks all

Difference in feature count of Neighborhood Finder transformer after upgrading from FME 2020 to 2024. The count differs even though the input data and projection are same. Similarly for lineonlineoverlay transformer the tolerance 0 and automatic gives the same output while the expected was different as FME 2024 does not have an option to give “none” in tolerance.

I have a spreadsheet with Address, Street Name, City, and Zip Code fields with 500 addresses. I need to create mailing labels for each address in this format: Occupant1234 Main StCity A, 54433 The output would be a Word/Text doc with the list of labels. What Transformer(s) would be used to create these?

Reading laz from Local / Network drive throws error: LAS reader: Failed to open file for reading. Please ensure that the file exists and you have sufficient privileges to read it.Any ideas why this happens?

Hi,I am converting SHP data to DGN using DGNV8 writer dynamically (via FeatureWriter). Everything works fine, but I don´t understand why it always uses ACAD writer first, throws this error and warning:AutoCAD Writer: An error occurred for dataset 'dgn\DI\vydej_di_L1.dgn', in function AutoCAD2004Writer::write. Unknown exception thrown. Aborting methodBADNEWS: ACAD writer: An error has occurred. Check the logfile above for details(D:\code\fme\source\engine\engine_api_impl\cpp\pluginbuilder\dynawch.cpp:129) class StatusInfo __cdecl DynaWriteChannel::putFeature(class STFFeature *&)DESIGN WRITER: Failed to write '3D elements' data through a proxy. Skipping such data for all elements writtenThen it writes everything using DGNV8 writer and the output DGN looks good, nothing seems to be missing. The only issue is that it throws quite big number of errors like this. I publish and use this workbench in FME Flow and the number of errors doesn´t look good in the finished jobs.Any idea how to a

For my client we run a lot of translations on their FME server that write to Snowflake. For like 99% of the time that runs without any failures. However, occasionally we are getting the following run time error: "COM.safe.fme.jdbc.TranslationFailureException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: {0}." Unfortunately this is a rather non-descript error (I wonder what {0} is). Also this error only occurred after our upgrade from FME Server 2020 to 2022.2. Rerunning the exact same translation the next day so far did not result into this error. So, does anyone have an idea how to prevent this from happening? Frank

Hi,I have a very basic workbench in FME 2022.2.8Reading features from a MSSQL table and writing to another, it is a FeatureReader/FeatureWriter combon in a dynamic workflow using the schema from the FeatureReader. This is using JDBC MSSQL Spatial.If the geometry column is set to EMPTY the writing fails with the message:MS SQL Server Spatial (JDBC) Writer: Error writing feature. Error: IFMEFeature.exportGeometryToOGCWKB: Unable to export geometry to OGC WKBExamining the feature in the database one can find it using SHAPE.STIsEmpty() = 1 and  SHAPE.STAsText() returns “GEOMETRYCOLLECTION EMPTY”

Hi, It seems there is no easy way to do this from what I have read on this topic. I really wish for a way to extract coded domains from feature classes in an SDE geodatabase.  I don’t even have to have the field names since I have named the domains after the featureclass, subtype and field it is attatched to. How can I get a hold of domain lists within FME? The point for me is to regularly be able to pull out lists of the options my users have in different fields since these need to be looked over now and then.

Hello, parameter newbie here apologies... but could anyone provide a link or information on how to configure parameters dynamically from a csv so that users can identify the Address column they want to use for the geocoder in the app-- as users will typically bring their own csv schema to the app for geocoding.  Thanks for any help here!!

I’ve been dabbling in the latest release of FME Form 2024 for a little while now and I’m just not getting the benefits of the new look, specifically the removal of colour from most icons.I could go into personal reasons why colour helps myself with attention to detail, concentration and focus but I’m just wondering if it’s possible to get a classic look while utilising any new functionality.

Hi, I have FME 2023.0.2.1 (64 bit) and ArcGIS Pro 3.1 with Python 3.9.16 installed on my machines.The FME workspaces I run uses Arcpy 3, so I specified the “python compatibility” parameter in the workspace (under scripting) as “Esri ArcGIS Python 3.7+” and the “Preferred Python Interpreter” under FME options - Translation as “Esri ArcGIS Python 3.9”.This setting works for all other machines (incl. local and VM) except one machine.With one machine, I get this python compatibility error: ERROR : A compatible ArcGIS application could not be found or is not licensed for Python Compatibility 'Esri ArcGIS Python 3.7+' The strange thing is, if I set the python compatibility parameter as Esri ArcGIS Python 3.9 with this machine, it works just fine. The only difference I can think of is maybe the normal python 3.11.4 which is also installed on this machine.Maybe this is somehow interrupting when FME is searching for python...? The problem is that I am calling many FME workspaces in one workspac

I have a flat table from a survey that is conducted by clients. I want to aggregate this data at the end of the month and send it to various staff that has had a survey submitted by our clients for their work. I’ve aggregated this data accordingly which produces a list. The aggregated results may differ based on how many surveys get submitted for each staff member that helps our clients. I have also generated a basic email template using the “HTMLReportGenerator” transformer. However, I’m having a hard time iterating through the list populate the HTMLReportGenerator. I’m looking to email each staff member their survey results from the month.Any help or guidance on this matter would be much appreciated. Thanks

I need to use FeatureMerger or FeatureJoiner based on two varchar(200) attributes.Visually those values do match. No white spaces trailing anywhere, the strings are the same, yet neither FeatureMerger nor FeatureJoiner are able to combine the data. settings for FeatureJoinerAs an example from the the Feature Information pane right attribute to join onleft attribute to join onThe join/merge is supposed to happen within a custom transformer, but I also tried it in the main workflow, where I received the same results. FeatureMerger is in version 21, andFeatureJoiner is in version 1001. Any suggestion on how I can identify the culprit and get these features to join/merge?

Is it possible to create a unified editor for both text and arithmetic?It would simplify the process of assigning variables to text rules or mathematical calculations, visible in a function dropdown box.For example: A rule definition can begin with a codeword, like Calc(....), to be processed as arithmetic or recognized by AI?

I am trying to set up a Web Connection to an OpenID server using the HTTPCaller. According to the documentation there should be an option to set up a new Web Connectionhttps://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/httpcaller.htmBut unfortunately I can not find the settings to create new web connections in the HTTPCaller, could someone please point me in the right direction?

In earlier versions of FME desktop/form i was able to filter log messages from options → translation → log settings. I know i can disable them in traslation log but we used those settings to control if server/flow logged warning messages. We have process that creates massive amounts of unnecessary warning messages that generates gigabytes of logs. Log message filter option doesn’t seem to be available anymore? Is it moved some other place?FME 2024FME 2022  

Hey, I’ve been trying to get FME (Feature Manipulation Engine) by Safe Software to use Python libraries from QGIS (like qgis.core) so I can mix their cool features in my temp.fmw workspace. The idea is to use QGIS’s Python (version 3.9) inside FME by setting it up with PowerShell commands. But it’s not working, and here’s why, explained like I’m talking to a 5-year-old and then a bit more grown-up:The Toy Box Story (Simple Version)Imagine Python is a kid who needs toy helpers to do jobs—like QGIS toys (for maps) and FME toys (for data tricks). These toys are called DLLs (little helper files). I want Python to borrow toys from both QGIS’s toy box and FME’s toy box at the same time.Step 1: I told Python, “Look in QGIS’s box (C:\Program Files\QGIS 3.32.0\apps\Python39) and FME’s box (C:\Program Files\FME\python)!” That’s like setting PYTHONHOME and PYTHONPATH.Step 2: Python found some QGIS toys (like qgis.core), but then it yelled, “Where’s my Qt5Core.dll toy? I can’t play!” It’s like a t

Hi All,I have been trying to put a workflow together to linear referencing a few event tables in GIS. I usually do the task in ArcGIS but this time I want to automate the process as much I can.I have been checking a few of the LRS FME tutorials online but can’t get it to work. The aim is to linear referencing speeds along a railway route (line) using an event table that relates the lines and speeds.The input of my workflow as follows:Event table (xls) that shows the Line and speeds, example below: Line geometry with the line ID as well the ‘From_Chain’ and ‘To_Chain’ fields as parts of the attribute I have got to this point in the automation but can’t get the Snipper to work for some reason since doesn’t split the lines according to the speed lengths:  Any advise how to accomplish the task?Thanks