Transformers

I am using SystemCaller Transformer to unzip the folders to particular directory using this command""C:\Program Files\7-Zip\7z" x "@Value(source_directory)" -o"@Value(_unzip_directory)" -aoa" This process usually runs at night as subprocess within a FME Workspace. All Zipped folders are at same location. My concern is it skipped to extract one of the zipped folder. To check if there is any issue with the zipped folder I checked by running the FME process Manually and it worked fine(extracted all the zipped folder).I also checked by running the same through task scheduler from same user with which the process runs at night, and again it worked fine and was able to unzip all the folders. What could be the cause of FME skipping it? Any help would be highly appreciated.

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. 

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

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?

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

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) 

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 ?

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.   

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.

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) 

Hello everyone,This question has been asked before, but for some reason using the following transformers mentioned in the following post  (Geometrypartextractor > GeometryFilter > Chopper) didn't help me to split certain shapes into lines and arcs respectively. The situation is as follows for me: I read a dgn file (thus a CAD format) in FME in which I have exploded cells. Then I do some transforming on the data in fme before writing to a table in a database. The final step is that I use GeoServer to look on the table i which I have created in order to create a WMS. However in Geoserver, I get the following error: “ORA-13346: the coordinates defining an arc are collinear.".In my dgn, I have the following kind of shapes and I think these shapes are the causes of this error. So, I am now trying to split  s

Hi All,I'm experiencing a bug in the Excel writer in the new FME 2024.0. I've made a script that outputs multiple data categories I need to process in a particular order to ensure my calculations are fed as desired. The bug causes the attribute names to not be written in the first row in Excel; it just starts with the data in the second row. Whenever I open the exact same script in FME 2023.2, the writer does write the field row names, without me changing anything in the writer settings.For now, my solution is to not use FME 2024, but since my customer does use 2024, it's not desirable. Does anyone have any ideas?Here is a preview of Excel. I can't scroll up to the first row, the data is not hidden, and the navigator also won't allow me to go to row 1. 

Hello ,i would like to insert some new points into ArcSDE, where each point will be positioned on and connected to various lines.How can I establish a relationship between each point and its corresponding connecting lines?Is it possible to set up this relationship in FME, so I can view the relationship class later in ArcMap?there is already a relationship exist between feature class lines and feature class points.But what  about the new points from FME?Could anyone advise me on a solution?Thanks in advance .FME 2023

I have a pair of longitude latitude coordinates that I’m trying to measure the distance between in KMIf I cross-reference this “distance” result in ArcGIS Pro, I get approximately 1.44kmThis is also roughly the same result if I use a online calculator;My question, is how does the result 0.01630799258600798 translate to 1.44km? is there something I’m missing??

I have an FMW that writes a CSV file and then uploads that CSV to Azure BLOB. The CSV that's created on the server's disk is okay. It has 201 records as expected and opens up just fine. That CSV--after FME uploads it to Azure BLOB via AzureBlobStorageConnector has about 25 less records--seemingly randomly removed. To rule out Azure BLOB itself as the problem, I used Microsoft Azure Storage Explorer to upload the CSV--when I do that, all records are in the CSV file when downloaded back down from Azure. I have experimented w/ a folder upload (upload the file w/ a containing folder) vs. a file upload--no luck w/ that, same result. What really bothers me about this is how it makes no sense. The CSV that gets uploaded should be the CSV that's on disk. It's a file and file-upload process. What could possibly be removing certain lines/records from the file?