FME Form

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?

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