- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,677 Posts
50,716 Replies

When you subscribe we will email you when there is a new topic in this category

12677 Posts

Recently active

Most replies Most views Newest first

brunoContributor

asked in Transformers

How to add IFC property

Hello to all,I need to add a missing property into an existing Pset. I tried the workbench shown by Liz in the post “Updating IFC example” but it doesn’t work in my case. Before testing with an Excel sheet contaning GUID and properties to add, I just test to add manually a single property:First, I created 2 attributes:Then I used the GeometryPropertySetter:With the XQuery:I find my previous properties in the “Proprietes” Pset, but I don’t have the new one “TypeVitrage”. Did I forget something or do I have to use “IfcPropertySetDefinitionCreator” ? Thank in advanceBest regardsBruno

889

2 months ago

jackfanzhangContributor

asked in Transformers

Why do I get FME_SUCCESS == badLuck

557

2 months ago

eric_armitageContributor

asked in Transformers

XMLTemplater issue - missing comma "," between expressions

Hi I am trying to use the XMLTemplater with a SUB template. The start of the ROOT expression looks like this (from an existing xml file that it valid)When I run the workspace I get this message. Does anyone know what the syntax error is and how to correct it?

445

2 months ago

james_c_452Supporter

asked in Transformers

Convert cubemap image equirectangular panorama

Hi,I’ve tried a few times to do this over the years but I haven’t been successful. What I want to do is convert a set of cubemap images into on equirectangular panorama. Kind of like this:I know there are a lot of free python solutions of Github, but I haven’t been able to get any of them to successfully work. I’m not particularly good a python and I don’t want to install any script packages. I’d prefer to do this entirely within FME as I am already loading in the images.Would anyone know a solution?

2096

2 months ago

gogopotter90Contributor

asked in Transformers

vmqurstion relates to Custom Transformer

Hello ,I am running workbench with caches .to check the result of each transformer . I have main custom transformer includes many custom transformers .when I make any changes inside the custom transformer so I have to run the main custom transformer to see the results of changes for the inside custom transformers .but it takes long time and I have each time to wait when I make small changes inside it .Could I run the transformers or custom transformers inside the main custom transformer without running the main custom transformer for each time ? if possible ,How ? thanks in advance Fme 2021

362

2 months ago

gis_person

asked in Transformers

Generate polygon features from coordinates stored in a .JSON file

I have been given a .JSON file to try and convert into an output Esri File Geodatabase format. I have managed to flatten the nested JSON values into attributes, and can view these ok. However, I am having a real issue trying to get my workbench to read the coordinate values that make up the polygon geometry objects. If someone could assist that would be much appreciated. I have attached a file, but stripped it back just to include the line containing the coordinate information for one polygon. Thanks, R

86112

2 months ago

helmoetzContributor

asked in Transformers

Failure when receiving data from the peer (WFS FeatureReader)

I use a workspace that reads a list of data sources in an Excel file. The data sources are either a gml file, in url format or not, or wfs urls. The workspace reads the data and converts and merges it into one filegdb.In total, the workspace processes approx. 50,000 features. Nevertheless, the following error message often occurs: HTTP transfer error: 'Failure when receiving data from the peer' when reading (with a FeatureReader) the WFS sources. See also the discussion in: problem-wfs-query-5215.Findings (including those based on) this last discussion:Increasing Timeout values or limiting the maximum number of features to be read does not seem to have any effect. Another suggestion to read the GetFeature request via a browser resulted in the expected XML content for most services, but for the wfs that gives the HTTP transfer error, in an image with only coordinates and attribute values in text format. It can take a while for the browser (Chrome in this case) to convert the read v

683

2 months ago

scottshenbergerContributor

asked in Transformers

AGOL Writer Error

Hello, Hope I am posting thing in the correct area! I have an FME workbench that takes a series of inputs, overlays them and sends them to point feature on our AGOL server. This process worked until yesterday when all of a sudden I keep getting an error message saying that it cannot find the REST service.“ArcGIS Online Feature Service Writer: Could not find a layer/table matching feature type 'Utility Side _ Customer Side'”What is weird is that I have a reader for the exact same service that can see and read the service the writer cannot seem to find.

581

2 months ago

maktContributor

asked in Transformers

How to change NaN to NoData?

I have a workflow where I am creating a raster using SurfaceModeler. As documented, this transformer may output some NaN values when using PLANAR interpolation. I indeed have a few cells that come out with a NaN value. I am not certain what transformer can change my NaN values to NoData values (or any other values)? I read through this article: http://blog.safe.com/2013/11/fmeevangelist119/ and thought the NullAttributeMapper would be the answer, but it does not seem so.

11410

2 months ago

pgammieContributor

asked in Transformers

Deleting a folder/file at Beginning of Workbench

I have created a series of workbenches that populate an ESRI File Geodatabase. Each workbench corresponds to an individual feature dataset. I have created a workbench with Workspace Runners for each of the individual workbenches so I can run them from there instead of individually.I have used a schemaScanner in the individual workbenches because the schema may change on the incoming datasets without my knowledge. For this reason I had set the first workbench run to overwrite the geodatabase instead of truncate to account for schema changes when doing geodatabase updates. However when I try to run it, I get an error that the geodatabase is locked. To get around this, at the beginning of the workbench I’d like to delete the existing geodatabase and then run each of the workbenches to recreate it. To do this I have read I should move the geodatabase to a temporary folder that FME will then delete at the end of the workbench run. I am have used the temp path creator to create an attribute

523

2 months ago

messagemauriContributor

asked in Transformers

Writer configuration for Excel

I have an excel file with 100 records (100 rows) with 5 columns. I have a process that will filter one record to update one column field called ‘Last Update’ in that particular record row. So The column ‘Last Update’ for that 1 record should be updated and the rest of the 99 records will remain the same. Keep in mind that the one record being updated, only one column is to be updated which is the Last Update column and the rest of the columns fields will remain the same. How can I configure the FeatureWriter?I currently have the following set in the FeatureWriter Parameters and in the configuration but this does nothing. The excel sheet looks the same as before with all 100 records the same and the one record that Im looking to update does not have the Last Update column updated. If I do an Insert, it updates that one record column ‘Last Update’ but the rest of the 99 records are deleted, which I don’t want. So the Insert is not working for my purpose.Thank you.

411

2 months ago

mahapandianContributor

asked in Transformers

Ground classification using Point cloud data

Hi, I'm attempting to classify the ground from point cloud data using FME transformers, but I haven't been able to achieve the expected results. Could you please provide a detailed workflow for ground classification in FME? I specifically want to generate a Digital Terrain Model (DTM) of the ground, excluding other features. Thanks! Classification Point cloud Orthomosaic

1045

2 months ago

kongadrummerParticipant

asked in Transformers

Group same values in different features and attributes by id

Hello everyone,I have the following data structure and I don’t know which solution would be the best in FME Form to get the required result:attribute1; attribute2; attribute3Kreuzberg; Rom; group 1Berlin; Kreuzberg; group 1England; London; group 4London; England; group 4Lissabon; Carrer; group 2Carrer; Lissabon; group 1Kreuzberg1; Rom; group 1Rom; Kreuzberg2; group 1I need to create a group_id attribute that has the same id where attribute1 values reappear in attribute 2 and vice versa + the features need to have the same attribute3 to get the same group_id. This is how the output should look like:attribute1; attribute2; attribute3;group_idKreuzberg; Rom; group 1;1Berlin; Kreuzberg; group 1;1England; London; group 4;2London; England; group 4;2Lissabon; Carrer; group 2;3Carrer; Lissabon; group 1;4Kreuzberg1; Rom; group 1;5Rom; Kreuzberg2; group 1;5Thanks for helping!

642

2 months ago

jonvelcoContributor

asked in Transformers

Generating Access Token with HTTPCaller

I’m following this API documentation to authenticate and can successfully do so in Postman. However, with the HTTPCaller it keeps returning a 400 error: "error": { "code": "no_grant_type_provided", "message": "Bad Request", "status": 400 },I feel like I’m close but can’t crack this nut...what am I doing wrong?? Postman:Postman HTTPCaller:HTTPCaller

473

2 months ago

repas4411Contributor

asked in Transformers

Merge polygons with gaps

I have several polygons. They follow a line pattern where tre long polygons should be one large, and by that i mean that there should be no space between them, and instead of three long polygons it should be one large. The following image shows three pairs, so these nine polygons should be three larger polygons. Any idea how to do this?

975

2 months ago

philippebEnthusiast

posted in Transformers

Transformer Parameter Menu Options

Hi,Using 2024.1 : not sure if I’m supposed to feel zen about that, but I don’t. Before I just had to click once to get into parameters.Now I have to click twice to get into parameters. I am more frustrated than zen.My personal feeling.

321

2 months ago

so_much_moreContributor

asked in Transformers

Spatial Filter - disjoint unexpected result

I need to find lines which are completely outside polygonsI am using the Spatialfilter with “Filter is OGC-Disjoint From Candidate”. All of them pass and I dont understand why?Current workflow This is my dummy data i am using. As you can see, the line highlighted with the red box is clearly the only line disjointed from the polygon. So why does all candidate pass, it make no sense to me? What form of transformer should i use if what I do is wrong? Its obvious to me that it qualifies os OGC disjoint?https://docs.safe.com/fme/2023.2/html/FME-Form-Documentation/FME-Transformers/Transformers/spatialrelations.htm

654

2 months ago

erikboehmContributor

asked in Transformers

How to loop through to corresponding lists using xquery

I have a JSON template that I want to fill with values from two corresponding lists using xquery.The two lists look like this:keywords_thematic_en = ["test", "trial","error","datapool","API","REST"]keywords_thematic_de = ["Test", "Versuch","Fehler","Datenpool","API","REST"]keywords_thematic = {"en":keywords_thematic_en,"de":keywords_thematic_de} The JSON template I want to fill looks like this:{"keywords": [ { "value":keywords_thematic_en,"valueDE": keywords_thematic_de,"type": "THEMATIC" }]} In python, this looks like this:keywords_thematic_en = ["test", "trial","error","datapool","API","REST"]keywords_thematic_de = ["Test", "Versuch","Fehler","Datenpool","API","REST"]keywords_thematic = {"en":keywords_thematic_en,"de":keywords_thematic_de}jsonSnippet = '{"keywords": []}'jsonSnippetKW=''for keyword in keywords_thematic["en"]: jsonSnippetKW = jsonSnippetKW +'{ "value":'+ keyword + ',"valueDE": '+ keywords_thematic["de"][keywords_thematic["en"].index(keyword)]+',"type": "THEMATIC" }

892

2 months ago

jugoslaviaaSupporter

asked in Transformers

Checking if Polygons from Dataset A Overlap with Polygons from Dataset B

Hi everyone,I'm trying to check if polygons from Dataset A overlap with polygons from Dataset B in FME. I’ve attempted to use the SpatialFilter, but it only offers options like "intersects" or "touches." However, I specifically need to determine if the polygons are overlapping.Has anyone encountered this issue or found a way to achieve this in FME? Any suggestions would be appreciated!Thanks in advance!

838

2 months ago

cpedronContributor

asked in Transformers

Translation successful 0 Features output

I am attempting to create a workbench to read, process, and convert IFC and 12dxml files into gdb files (multipatch and basic respectively. The output for the IFC/GDB Multipatch is working properly and is set to a dynamic filename without issue. However the output for the 12dxml only runs when targeting a specific location (can’t set filename dynamically) and even then it returns a message saying that 0 features were output. I am fairly new to FME and have not been able to determine why this is failing, short of the possibility that the writer is trying to write polylines and getting information in as polygons, which I am unsure how to fix. I have attached the rather voluminous log on the chance someone is able to point me at the particular error I need to fix.

357

2 months ago

james_c_452Supporter

asked in Transformers

Remove the last n delimeters from a string

Hi,I keep going in circles and can’t think of an easy way to do this. Has anyone got any tipsBasically, I have an attribute such as “TEST_240829_MLS_5_316460_5816230”What I what to do is remove “_316460_5816230” from the end. I’m wanting it to adaptively remove this part of the string from several thousand inputs.Normally I would use the attribute trimmer however the length of this part of the string will change (not a constant thing I can remove). This part of the input string does always start at the second last occurrence on the “_” delimiter and go until the end. The amount of delimiters is not constant in the part of the string I want to keep though, so I also can’t use the attribute splitter and then rebuild the part I want from the parts of a listIs there an easy wany to do this?

262

2 months ago

mesmath

asked in Transformers

Understanding relative paths

I have a workbench set up on a desktop PC that is reading numerous data sets from folders on that computer. The workbench is also saved locally.I have moved a copy of the data and workbench in the same folder structure onto our shared network where the start of the file path is different.eg. C:\\Data\\Workbench.fmw & C:\\Data\\Input\\Data.xlsbecomesP:\\Project\\Projectname\\Data\\Workbench.fmw & P:\\Project\\Projectname\\Data\\Input\\Data.xls How can I set up the workbench so I only need to change the folder path to data sources once, and all the others know that the relative path has changed? Thanks!

2413

2 months ago

timboberooskyContributor

asked in Transformers

Feature Reader from Esri MGDB where clause based on datetime field

I’m attempting to use a Feature Reader and where clause to identify features in a Mobile Geodatabase with a “publish_date” (datetime) greater than the “LAST_UPDATE_TIME” (datetime) from an SDE Geodatabase. With help from the article below, I was able to accomplish this with a File Geodatabase and SDE Geodatabase, but I’ve now migrated my script to FME 2024 and need to use MGDB instead of FGDB. It seems the formatting is different (I validated in FME 2024 against the FGDB instead of MGDB - it works).Feature Reader from Esri FGDB with a where clause based on a last_updated (date/time) field | Community (safe.com)Below is my attempted logic, where the format of publish date and LAST_UPDATE_TIME, as far as FME is showing me, appears identical. The FGDB solution has some not-so-straightforward formatting so there might be something similar here. Any help?

433

2 months ago

mewi

asked in Transformers

How to split an attribute with integer to the first 2 digits

I have an Attribute with integer values (4 Digits) and have to extract the first two Digits and write them to a new Attribute.In RegEx I think it is ^\\d\\d. How can I do that in FME?I tried with ExpressionEvaluator and AttributeSplitter @FindRegEx(@Value(Attributename)^\\d\\d)but it does not working. Thanks for helping.

1607

2 months ago

robotixContributor

asked in Transformers

Writer MSSQL vs SQLExecutor 'Insert'

This has been bothering me for a long time. I keep avoiding it because I just end up using a SQL executor. to find errorsHow is the Writer transformer different than a SQLExecutor when performing MSSQL inserts? [or other functions]. Don’t they use the same driver?Here is an example: I recently inserted a row into a table where the string length was too long got the field. The Writer transformer just inserted the string successfully, but it truncated. The SQLExecutor threw a SQL error saying, ‘string or binary data would be truncated’ and then failed\rejected the insert. I have also run across other odd behavior in the past. Such as the writer having the ability to insert duplicate foreign keys, but the SQLExecutor will fail with error. Is there a good resource for this or a good explanation? Thanks!

532

2 months ago

Page 8 / 508

Badge winners

reedwhithas earned the badge Conversationalist
mwarren_esricahas earned the badge Welcome Back
lcaruthershas earned the badge Student (Grey)
vertiroyhas earned the badge FME Form Advanced Training
stephenjackshas earned the badge Welcome Back

Show all badges

30,149: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.