FME Form

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?

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 

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 ArcGIS Pro with this same sa-pandora-fme account. The instructions we have been following are here - https://community.safe.com/s/article/Using-ArcGIS-Pro-with-FM

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? 

When using a FeatureReader transformer to read Snowflake spatial data, the following warning is posted into the log.Snowflake Spatial Reader: Skipping data in column '.GEOG' due to error (JDBC Type = VARCHAR, Vendor Type Name = GEOGRAPHY, Error: class java.lang.String cannot be cast to class [B (java.lang.String and [B are in module java.base of loader 'bootstrap'))The process does complete normally, but the geometry is not read automatically. Has anyone else encountered a problem like this? I’m using FME Form 2024.0.1.0, Build 24202.

Hi All,I have a survey asking participants to rank their favourite colours—Red, Blue, and Green—in numerical order (1, 2, 3).I want to use the results to create a workflow that counts how many times each colour has been picked based on the ranking.Here is some example data.Sample Data Unique_ID Colour Rank 1 Red 3 1 Blue 2 1 Green 1 2 Red 1 2 Blue 2 2 Green 3 3 Red 1 3 Blue 2 3 Green 3  What I am trying to achieve Colour  Rank_ 1_Count Rank_2_Count Rank _3_Count Red 2 0 1 Blue 0 3 0 Green 1 0 2

Hi, I have scanned a map and saved it as a raster image. I need to compress this PDF using FME. I have tried RasterMappers and RasterResampler, but both are making my map smaller without actually reducing the file size. Do you have any recommendations, please?