Transformers

I have a dataset with spikes, and I want to flag records with spikes for manual inspection.I am aware of the SpikeRemover transformer. Is there a method of just detecting spikes? Not removing them but just flagging them? I would prefer to do a manual fix.

Wondering if FME can read QR-codes from images. Input is folder with images with QR-codes and some other content. FME should determine where to save those files based on the QR-code so just be able to read the code within workspace. Has anyone tried doing something like this? 

I have been unable to find a up to date compilation of the AI transformers and connections available in FME, is there such a thing?Specifically, I want to do some experiments with reverse image lookups.

I have a featurereader after a featurewriter which is writing 4 feature types. I have configured the dataset parameter as _dataset as per the output of the reader. What do i need as the feature types to read? I have tried _feature_types{0}.name _feature_types{1}.name _feature_types{2}.name _feature_types{3}.name and _feature_types{*}.name but neither work. _feature_types{0}.name by itself does work on the first of the 4 in that same parameter.

Hello everyone,I am using the StringPairReplacer to find and replace short codes with their corresponding fulltext from a string that may contain multiple codes. It looks something like thisA1, A2(A3), A4 → Fulltext1, Fulltext2(Fulltext3), Fulltext4with the Replacement Pairs: A1 Fulltext1 A2 Fulltext2 A3 Fulltext4 A4 Fulltext4 This works fine, however the lookup table containing codes-fulltext translations may change in the future and I would like to implement a dynamic solution which doesnt rely on changing the workspace everytime something changes in the translation. I managed to create the correct text for the replacement pairs field using the SQL Creator from my translation database but am having trouble inserting this string into the appropriate field as it only accepts text and user parameter input. I am not too familiar with user parameters and cant seem to work out a solution to insert the dynamically created string into the StringPairReplacer.Does anyone have an idea how to do

Hello,I would like to use FME to search for partial name matches (essentially a fuzzy string comparison) between two columns in different datasets.The challenge I'm facing is that it’s not a straightforward ID-based comparison. I want to pick a name from a row in one dataset and search for the closest match in a column of names in another dataset.Does anyone know a way to achieve this in FME, perhaps without relying on IDs?Thank you!

I have lines and their vertices should be written to XML (using XSD-driven XML-Writer).I extract the vertices coordinates into lists using the “coordinate extractor” .Now I need to find a way to output those coordinate pairs to xml, so that the output looks like this:Is there a way using the “list concatenator”?

Good day,I have a featurewriter and I want to give the dataset the same name as the display value (and not the value itself) of a parameter for which I used a choice configuration. How can I do it ?

I am trying to find a functionality within FME that allows me to replace substrings based on a lookup table. Since I have several hundred mappings, chaining string replacers together isn’t really an option.Basically something like an AttributeValueMapper that looks at substrings instead of the whole value only or a string replacer that accepts multiple string/replacement inputs.Is there such a transformer or any workaround to do this?Thank you! 

Hello,i’ve recently worked with a raster from a NetCDF file and noticed, that loading the raster in FME gives a different raster than loading it in QGIS or ArcGIS-Pro (see Screenshots).Data can be found here: https://opendata.dwd.de/climate_environment/CDC/grids_germany/daily/hyras_de/precipitation/ My question is why? Has anyone experienced this behavior before?     

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) 

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.  Does anyone on this forum have any experience from this? Any help would be greatly appreciated!  Cheers!/Alex