FME Form

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 is

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

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 on

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

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 i

Nevermind.I was deceived by a cookie. I was already loged in. Turns out the server required a login form. 

Hi, I’m getting thrown this error by my feature writer when trying to write to a dwg. I have not changed my workspace and used it a hundred times with no issue, except this one case. I am getting this error:AutoCAD Writer: An error occurred for dataset '.\QHPRW_Tiles11,12_QA.dwg', in function AutoCAD2004Writer::writeBlockHeader. Exception thrown: 'Invalid Symbol Table name' (Invalid Symbol Table name) I have no symbols/cells/block to write. I am using a template file to set the right colours and display. I am able to write the file if I remove the comma from the name. However, I have another file the works fine that has a comma in it. So that can’t be the real issue. Does anyone have any ideas? I am using FME 2023.2.1 Thanks 

Hello, I am set of 168 pipe segments with Global ID which is failing to write to database when using Esri ArcGIS Portal Feature Service. I am sure that the whole write process is failing due to 1 or 2 pipe segments. In order to debug this, Is it possible to write(commit) each pipe segment one by one to the database and figure out which pipe segment is causing the issue.  Thanks,Naveen

I have a workspace in FME that reads data from a PostGIS database and updates a Feature Service in ArcGIS Online (AGOL). Since the PostGIS data is updated frequently, I use the ChangeDetector transformer to update only the modified features instead of overwriting the entire dataset (to avoid the "413 Request Entity Too Large" error).Currently, each time I run the workspace, I need to enter my AGOL credentials. I want a solution where anyone in my organization can run the workspace, even if the Feature Service is not in their My Content.What are the best ways to handle authentication in FME for AGOL updates?Is there a way to store credentials securely for automation? Can I use API keys or OAuth2 authentication? How do I allow others to update the Feature Service without adding it to their My Content?

Hi All,  50 2022-2-2 18:19:13 | The Esri Product license used by this machine does not include licenses for the 'Advanced' licensing level51 2022-2-2 18:19:13 | Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details52 2022-2-2 18:19:13 | A fatal error has occurred. Check the logfile above for details We have FME Server 2021.2.2 running with ArcGIS Pro. We have logged into Pro with a ESRI named user 'gisadmin_acc', this has an advance level license assigned to it. Pro opens and runs fine on the server machine.  We installed FME Server using an admin account called sa-pandora-fmeWe also installed

FeatureReader setup with a parameterized connection.If an incorrect connection is selected, the errors are reported “The error number from ArcObjects is: '-2147216100'. The error message from ArcObjects is: {Insufficient permissions” But the workspace doesn’t terminate and nothing exits the rejected port of the FeatureReader. Rejected Feature Handling is set to Terminate Translation. I would expect the workspace to fail/and or output from the rejected port on this sort of error FME 2024.1 (Form & Flow)

Hello all,I have a Workspace that makes the reverse geocoding using PythonCaller.import fme import fmeobjects import json ,urllib2 # def processFeature(feature): att = urllib2.urlopen('http://maps.googleapis.com/maps/api/geocode/json?latlng=-23.2186725,-45.9056706') data = json.load(att) print "o json é ", dataWhen i run my workspace i see the results on the log file because i put the Print: How can i get this result with a new attribute?Thanks in Advance,Danilo de Lima

In 2024.1 it appears that a Directory and File Pathnames reader with a Path Filter set to *.tab only reads tab files with a lowercase extension.In 2021.2 both .tab and .TAB files are readA MapInfo TAB file reader pointing at a folder path such as "E:\Mapinfo\**\*.tab" still reads both .TAB and .tab filesIs this expected behaviour?

HiIn FME 2025.1, can multiple feature classes containing the same fields and needing to be updated with the same data be developed to use a single DatabaseUpdater converter?For example;A function can be added that allows feature classes or tables to be selected in the parameters, as in the reader. The additions can be seen as a list above the Match On list.

I’m trying to upload a raster to Mapbox, but no matter what I do, the output file always turns the nodata cells to black. I have tried fixing this using RasterBandNodataSetter and RasterPaletteResolver. If I look at the feature cached output from those transformers the nodata cells are still transparent. The issue arises when I use the MBTILES writer. No matter what, it writes nodata as black. I also tried removing the nodata (RasterBandNodataRemover), doesn’t work. I have tried outputting the data both as png, png8, and jpeg. Does anyone have any other suggestions? Thank you in advance!

Hi, I just upgraded FME Form and FME Flow from 2024.0 to 2024.2.3. One of my jobs failed using a FeatureReader with the Directory and File Pathnames due to the extension not being in all caps because the extension on the file it’s looking for is in all caps (.CSV). Originally the parameter was set to filename.csv and the FeatureReader would have no issues finding the file on 2024.0. Now the FeatureReader is not able to find the file in 2024.2.3. I changed the parameter to all caps .CSV in the featureReader and it finds the file with no issue. Anyone else noticing this with 2024.2.3?