FME Form

Hi everyone,I have a feature class in a File Geodatabase that I need to update. I have two sources for these updates: a CSV file with codes of the changed features, which I should use to remove those features from the main dataset, and separate shapefiles for each changed feature that needs to be added back to the main dataset. (I shouldn’t delete and update the whole dataset, I should update the changed features only.)What is the best way to approach this in FME?Thank u in advance for your time. 

Hi there, I am a new user so this may be a newbie error. I have just tried to install FME on my Ubuntu Workstation. It is running the latest version, 24.10.  The latest version that FME lists has isfme-form-2024_2024.1.3.24627~ubuntu.22.04_amd64.debso I downloaded that.  It fails to install with a long list of failed dependencies. Is this install going to be possible?  TIA.Kerry

I have a FME workspace reader that reads in the various attributes of a particular workbench and want to send the results to an excel spreadsheet with one sheet per feature. Each feature has a different set of attributes and can’t figure out how to get each sheet to be only the attributes of that feature.  Do I just need to have a separate reader for each feature_type or is there a way to channel all features into a single reader?

I have a large number of points, which I would like to join by simple lines (point-to-point), minimizing the overall summed length of the generated lines. There's no preferred path, but all points must be connected to each other by a single network of lines.My output just needs to be a set of simple lines.Do anyone have an idea on how to accomplish that, other than grinding it out in a PythonCaller ?CheersLars I

Hello I need help to get it right , i would like to convert 3D Room model into 2D (like how it looks from top).  I am using 2D Forcer and outputting IFC , i could see the output in FME Inspector but, when i open the same file in Navisworks etc. it does not get opened...not sure what is wrong.   

Hello,I use PythonCaller to create dynamically seveval attributes. But how can I get them outside the pythonCaller because I can’t described them in advance in the following area : Thank in advanceBest regardsBruno

Hi,When running a workspace with cache mode activated i can see in the Translation log that fme form writes ffs, and writes and index and so starts it with a process i am not familiar with: “Destination Feature Type Routing Correlator” and it takes so long to go through.What is this process about? is it possible to avoid?Thanks in advance!

How can I download file from ftpes:// to specified folder? I’m using the script below.import fmeobjectsimport osfrom ftplib import FTP_TLSimport ssldef processFeature(feature): path = '/lsms/' filename = 'apples.zip' ftp = FTP_TLS('FTP-SERVER') ftp.ssl_version = ssl.PROTOCOL_TLS ftp.login('name', 'pass') ftp.prot_p() ftp.cwd(path) ftp.retrbinary("RETR " + filename, open(filename, 'wb').write) ftp.quit() feature.setAttribute('name', filename) 

Hello, we have inherited a range of very large workbenches and was wondering if there is a way to get a summary report of the major components like parameters, database connections,  inputs,  outputs and names of bookmarks. 

Has anyone else noticed when creating a list using the AttributeExploder it truncates the last two characters of the list name, resulting in complications when using a ListExploder downstream because the list doesn’t exist.Using the default settings:Default List Settings in the AttributeExploder Transfomer The resulting list:List Name Is Truncated In Feature Information This broke a workspace that was previously working. It was a niggly one to catch as the only thing that had changed was the FME version.As a workaround, we created a user parameter which had the default value “_attr_li{}” and used that in the ListExplod

I am able to read a Oracle Spatial geometry using FME "Oracle Spatial Object" reader. However when I am trying to read a SDO_GEOMTERY using SQL_Executor, I am not able to expose the geometry attribute. How do I read a SDO_GEOMTERY in FME in between the flow?  Regards, Ananda

For speed of running the statistical calculator, is it possible to skip the Complete and Cumulative outputs and only output the Summary ?

I had a pair of coordinates stored in a single column named "geometry." I used the Attribute Splitter to separate these coordinates and then exploded the list. Now, I have each latitude and longitude in the same column. Is there a way to copy these latitude and longitude values into separate columns labeled "Latitude" and "Longitude" while maintaining the same order?

Hey! I’m trying to do something that in my mind is very tricky, mainly because I don’t know how to do this. I have a table with bird “routes”. For some reason, each bird species is in a separate column, with a value for the number of individuals in that column. It can look something like this:  In row 2, at one given location, 1 “Stare” and 1 “Grönfink” have been spotted. There are around 190 columns, making this table a bit odd to work with. To work with this data in a different project, I would like the table structured differently. What i would like as an output is a seperate row for each observation, with number of individuals as a seperate column. So, in this case, row 2 would be 2 rows, one for the “Stare”-observation and one for the “Grönfink”-observation. Basically, turning the column names into attribute values.

Hello everyone, I have an XML file containing the registered real-estate data and want to export it as an IFC file. What is the procedure to get the geometries and their atributes out of that file. As I have read, the first step is to use the XMLFlattener. But I do not know on which level do I have to flatten it (Elements to match). There are a lot of nested paths. If I select one path, do I have to select the paths under it? And this flattening process takes a really long time! What is the solution? I would appreciate your help.   

Hi, I have a SQL Executor calling a stored procedure.  I am running FME Form FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64) and am getting this issue:Microsoft SQL Server Non-Spatial Reader: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'The transformer is not failing, but its not producing a result either. Not sure how to move forward with this one. Any thoughts?Thanks 

Hi, I used an AttributeFilter transformer to split attributes. I want to write each of them as a feature class in a new file geodatabase. What is the best way to do that?Thank you for your assistance.

I have around 340 .las files and im just truing to split them. As you see in the picture i have a fair amount of distance between these files 

Hello,I would like to test a variable before running a workspaceRunner or not.if attribute ‘recetteCouche’ = 1 then running workspaceRunner ‘000_recetteCouche..’0’ else if attribute ‘ecritureLivrable’ = 1 then running workspace ‘0000_ecritureLivra...’, etcmy configuration for each  WSR is : ‘wait job job to complete = YES’Please, someone have an idea ?Olivier.

Hello. I have a workbench that reads an XML and splits it into attributes with their values (with one spatial attribute). I am trying to write this data to an existing, empty SQL Server table. If I set the writer to create a new table, it runs fine, but I can't seem to get it to populate my existing table. The workspace runs, and passes with warnings, but when I go to my SQL Server table it is still empty. Any ideas?  My writer is configured as follows: Feature operation: Insert Table Handling: Use existing  The translation log claims that all of my features have been written, and the data inspector shows them fine, but it just won't populate my table.  Thanks! 

Using the Httpcaller i can successfully make a rest api call to retrieve a token for an ArcGIS Portal Featureservice. A proxy server is set up but is not used for this url so the call bypasses the proxy. However, I can only set up and use an ArcGIS Portal Feature Service connection if there is no proxy set up at all. If the proxy is enabled, the connection tries to use the proxy even though the base url is on the exception list.

Hi,I have an URL that I’d like to read in, but it contains the current date and thus is being updated everyday. How may I change the URL within the reader so that it’s automatically up-to-date?I’ve tried define a user parameter as a URL but I don’t manage to make it dynamic there. I thought I could replace the date e.g. 2024-11-05 with @DateTimeFormat(@DateTimeNow(),%Y-%m-%d) in the Default Value URL but it doesn’t work.Any help appreciated! 

When using the FeatureWriter to write to an Esri Geodatabase (ArcSDE Geodb) Feature Class why is there no option to use an Attribute Value for the ‘Feature Class or Table Qualifier’ setting?There’s only the option to use a User Parameter. I am trying to make this dynamic as the Qualifier would change depending on the environment I am trying to write to. The value I want to use is coming from an attribute. The option is available in the ‘Feature Class or Table Name’: Just curious why this format is set up this way in the FeatureWriter. Could this be addressed in future versions please?Version: 2024.1.1.0 (20240729 - Build 24619 - WIN64) 

Hi,I want to fill the User Param Choice with data from a table in MS SQL. This works fine with the 'Import->From dataset...' option. but this function only populates data statically. Is there any way to 'hack' this to fetch data dynamically? The idea is that this Workspace should work in a App in FME Flow.  

My organization has a platform that allows users to collect spatial data. We have a forest plot survey that allows users to collect information about forest characteristics. The form is intense, with many nested layers, many-to-one relationships, and repeating sections. I have developed a workbench that reads the JSON from our organization website and ‘unpacks’ it into it’s individual tables, all with id’s to perform the necessary joins down the road. Previously I was just writing all the tables to their own sheet in an excel document, but now my managers are asking me to populate the data into their preferred format, so they have given me an excel table to show what they want the output to look like. It’s not a data friendly format. Essentially, they want all the data to populate onto a single sheet where the sheet has multiple instances of different fields names in the same column. Think like multiple tables stacked on top of each other in one sheet.  My