FME Form

Good day,I have the following parameters in my script:AVE_AVENUEBLVD_BOULEVARDCTR_CENTREPL_PLACERD_ROADEach parameter is set up as a choice, when running the script you have the option to chose YES or NO for each parameter.Later in the script I want to retrieve the parameters for which YES has been chosen. I want to create a new attribute whose value is a list of the parameter names (keep only the letters before the underscore). Let’s say AVE_AVENUE, BLVD_BOULEVARD and CTR_CENTRE are set to YES ; PL_PLACE and RD_ROAD are set to NO. A new attribute called “address” is created and its value should be: ‘AVE’, ‘BLVD’, ‘CTR’. How can I do so ? Thanks for your help.

I’m fairly new to FME and need help to get started on a workbench. I have a text file i need to convert into a readable format. Each line has information about a specific device and should be parsed into separate columns. The blank spaces also need to be removed. What transformer should I use? Any help is appreciated!

Hello,so far we are transforming IFC models to geodatabase feature class, which works fine so far. Unfortunately this IFC export step seems one step to many in the overall workflow and I was asked to change the workflow, so that revit project files can be used directly. As fme does have a revit reader I thought it would be possible, but unfortunately despite trying every imaginable parameter setting for the reader it was not possible to read more than one feature that did not contain some kind of meta data...but the “survey point” instead. The fme documentation also only focuses on how to export from revit to ifc and after wards use it in FME.Is it therefore impossible to transform from .rvt files to a multipatch geometry feature class in Esri geodatabases? Or am I missing something?

I am using the Schema Scanner with a dynamic writer in my workspace and it is awesome except that it often incorrectly identifies some of my integer fields as date/time fields. If I turn off the date/time detection then my actual date/time fields get written as strings or integers. Right now I am running it with date/time detection on and then I put an attribute manager on the schema and find the ones it has incorrectly identified and manually adjust them but I feel this kind of takes away from the dynamic nature of the schema scanner. Is there a better way to do this? I wish I could tell it to ignore certain fields or specify the fields that it should look for date/time in but again that is taking away from the dynamic nature of the bench. 

Using an Esri ArcGIS Online connection and the Esri ArcGIS Online (AGOL) Feature Service reader, I'm unable to read a feature service that has been shared to our organization.When looking at the select form, i’m only provided my user folder and a groups folder. The feature service i’d like to read isn’t owned by me or shared with a group. Is this as-designed or is there another way to read it? Thank you  

HiI am able download files with the ProjectWiseWSGConnector.Now, I want to download files in a flat set, but this does not work for me.If I treat the flat set as a file and try to download it. The translation is successful, but nothing is download.And I can't list the content, because in list mode the flat set isn' visible, since it is treated as a file by the transformer.Any help would be appreciated.

Ran into an error that I don't know how to approach. The full report line is: ERROR |Cannot have multiple factories with the same name. Multiple factories were assigned the name 'blablabla Output Collector' What does this mean and where should I start looking to solve this? I might ad that this error showed up suddenly. I tried to remove the most recent changes but it persists.

Is there a transformer that dynamically identifies features where all attribute columns are empty? This could be done with a Tester, but that requires the attributes to be known, and a new setup for each dataset. I was curious if it can be done “on the fly”.

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.