Transformers

When running an old script in FME 2024.1.1.0 we get 58 errors “The object at location ___ was previously deleted and cannot be retrieved from the Object Stash” (see attached log file). It doesn’t appear to affect the output, the log file says “Translation was SUCCESSFUL” and CPU and Memory usage don’t get close to 100%. Can we ignore these errors? This is part of a much larger script but only this part is producing the errors. We updated the transformers and saved the script to FME 2024 but still get the errors at the transformer FeatureJoiner_13. The only way to not get the errors is to run the script up to the 2 preceding transformers (“Run to this”) and then run FeatureJoiner_13. The output appears to be the same as when we were getting the errors. We tried adding in FeatureHolders before FeatureJoiner_13 but still got the errors. Bye Doug

When a database is updated using SpatialRelator, FeatureTypeFilter, and DatabaseUpdater Transformers from feature classes inherited from two different readers, the _relationship attribute disappears when the FeatureTypeFilter Update button is used. All DatabaseUpdater transformers are in the "incomplete transformer" status. When examining the DatabaseUpdater transformers, the _relationship values are red. Copying and pasting the same value fixes this. To avoid this issue, you must manually edit the FeatureTypeFilter, which is time-consuming.

Hi, I’m trying to put an URL in a table using the new DocumentPDFStyler and I can’t make it work. One of my issue is that the URL breaks because it doesn’t fit in the table box, also it doesn’t show up as an url. I tested many things to make it work: Image Link, add the pdf_url attribute (doesn’t work because this is the documentpdf writer), put quotes around it. I’m trying to make this work without having to use the wkhtmltopdf 😅

I’m using the rasterdemgenerator and I can’t get the fme_basename passed it. I have some lidar tiles and I want to make a DTM from them. I can do everything, but I cant get the DTM named like the input las file. It has either no name or it has the name of the transformer. There is an old forum post where Takashi tell’s someone to expose the FME_feauture_type, fill it with the FME_basename, use a group by (using the FME_feauture_type) in the rasterdemgenerator and than use it as the raster file name. It doesn’t work for me… Any other suggestions? I’m on FME 2025.0

Hello Safers, I have a CAD file that has annotations inserted within it that should be one annotation but, for whatever reason, they were created as separate annotations: Above is an example of what I am struggling with. The text should simply read 10.88, but FME reads it as 1, and 0, decimal , 8, 8, and 0. What I would like to do is treat this as one annotation, and be able to round or eliminate extra numbers where needed (i.e. I only need two decimal precision, not three). Please note I already figured out the precision and rounding….I just need help with these multi-part annotations. How would I go about doing this in FME? Thanks!

Hi All, I have tried to implement several suggestions from the community regarding date filtering; however, I have not been successful so far. I am trying to filter dates in a CSV file based on the "last login" within the past three months. The date format in the file is as follows: 18/07/2025 09:16 08/07/2025 12:46 01/02/2024 10:07 16/01/2025 10:33 I have converted those dates to %Y%m%d resulting ‘20230403’ then add an AttributeManager to change the ‘last_loging’ attribute to ‘date’ and finally used the following expression to filter the "last login" within the past three months: @Evaluate(@DateTimeFormat(@DateTimeSubtract(@DateTimeNow(), '3', 'months'), '%Y%m%d')) ...but for some reason doesn’t work, Any guidance or support would be greatly appreciated.

Hey everyone, I hope I am just missing a very obvious point here. I am trying to compare two SQL input data sources One with these columns And the other with these columns The customer and account number combination is going to be my primary key. I need to extract the email addresses of customers based on that combination. I have tried the feature merger which seemed to be the obvious solution, but I am not getting any matches? Any idea where I am going wrong?

When I create a Custom Transformer in FME, and (manually) create parameters within that custom transformer, it seems that I can't assign an attribute value for these parameters from outside of the custom transformer. So for example, I created 3 distinct parameters (text, number and (single) choide) inside of a custom transformer, all of them with the setting 'Disable Attribute Assignment' unchecked. then outside of the custom transformer I don't get an option to provide an attribute value for each of these parameters; Interestingly, if I expose attributes at the input port of the custom transformer, like so; then a text parameter is automatically created (in this case 'ATTR1'), whose value can be set outside of the custom transformer: It seems like a bit of a bug to me. I'm using FME 2021.2.2.0 (b21806 - win64). I found some ways to work around this, like in case of the text parameter, you can open the Text Editor window, and manually type @Value(attr1) (also in the Text Editor window,

I’m trying to read a text file with settings in it then, use the settings in the WS. The settings are formatted on lines like name = value. There are lines with other stuff on them like comments that I just want to ignore. The WS that I have seems to work up to the AttributeSplitter. I think it splits right because it shows 30 features created but it doesn’t fully fill the list{}. I think the list{} should have 60 items but it only has 2. The AttributeCreator just creates one attribute for the list{2}. I’m a bit confused how this should be configured. Also, if there is a better way of doing this (reading settings) then, please let me know. I have attached my WS (zipped) and my txt settings file. AttributeCreator: only one attribute gets created ‘APP_EXIT’. AttributeCreator

I’m working through a data cleaning process in a workspace. I have multiple files that are different from each other in schema and attributes, but are essentially all saying similar things. Hence the cleaning. I’m working in one workspace to make re-use of transformers a little easier, but when I’m using the FirenameParkExtractor transformer I need to identify a user parameter source for it to gather up a name to chop up. This is what that dropdown looks like: The names here do not align with how I’ve named the readers and associated files so I’m a little confused about how to make this situation easier to work with. I’d like to be able to rename the source datasets, but I’m not sure where I’d do that. Can you tell me? As an aside, is it a bad idea to process many things in one workspace? Should each file get it’s own? Is there some helpful documentation out there about designing workflows? (I’ll be searching on that just now, but I thought of the question as I was writing the post!) H

Not sure if it’s an issue as such, although I struggle to think of a scenario where you would want this functionality, and it might be obvious to some but just as an FYI If you send multipolygons into a Dissolver with Aggregate Handling set to Deaggregate and choose attributes to sum, the polygons will be deaggregated first, this means that each constituent part inherits the attributes of the original multipolygon feature and this will then be summed to leading to unexpected values. So from this You get this

Hello, I have two tables with the same field names. Both tables have 2 date fields, with a start date and a end date and other fields which has the same name in both files. The only thing is that the date segmenst (time between start and end) has a overlap. Example: TABLE 1: DATUM_INGANG DATUM_EINDE ID REPLACER 19921101 20040119 0502010000027183 OWNER 20040119 20160930 0502010000027183 OWNER 20160930 99991231 0502010000027183 OWNER TABLE 2: DATE_START DATE_END ID REPLACER 19921101 20060716 0502010000027183 USER 20060716 20061008 0502010000027183 USER 20061008 20070220 0502010000027183 USER 20070220 20100616 0502010000027183 USER 20100616 20110709 0502010000027183 USER 20110709 20111001 0502010000027183 USER 20111001 20190325 0502010000027183 USER 20190325 20190617 0502010000027183 USER 20190617 99991231 0502010000027183 USER I want to combine them to one table, this should be the outcome: DATE_START DATE_END ID REPLACER 19921101 20040119 0502010000027183 EIGENAAR 20040119 20060716 0502

I am processing a large amount of simple data: Points with attributes. I want to filter the data by a specific set of attributes, some of which have wild cards. e.g., "T", "T BASE", "T BENT" should all pass through. For each run, a user will be specifying the valid attributes by putting them into a file (probably text), which will be read in at the start of the process. I mention using a list, but they could go into a table as well if that would work better.

I have a workspace created in 2023.2 that reads an Excel workbook from a SharePoint library. It is working perfectly. I have upgraded to 2024.1 and the reader no longer works as expected. If I use the 2024 Data Inspector I can connect to the workbook and see the data. The FeatureReader obtains the schema and the number of records in each sheet and gives a “Translation was SUCCESSFUL” in the log. The issue happens after that - I get some sort of (possibly) Python related error. Log file of messages after the successful log entry is attached. I have tried changing the Python version but it didn’t make any difference. Has anyone had the same issue or any ideas what I could try to get it working again.

This issue seems to appear again in FME 2025.1!

I am using FME Workbench 2022.1 along with ArcGIS Pro 3.0. I recently noted an issue when copying data from an AGOL MapService to a local GDB - if the feature class does not exist in the GDB, the Workbench will fail, only reporting "Error running the translation" and no further details in the log file. However, if I create a feature class in the GDB, even without any attributes, and change the writer to "Drop and Create" from "Create If Needed," the Workbench runs. Any Ideas? Log File attached

Hi, i am copying files using the FeatureWriter with FileCopy and but some of them are missing but i dont get an attribute telling me which files are missing. All i get is this in the log:File Copy Writer: Skipped 401 features that contained invalid source datasetsBut what i would like is to route those with invalid source data set and have them write to an excel ark or similar so i know which files cant be found.But right now the features all come out of the same port with no distinction of wheter or not the copy was actually succesful. Which is not very useful for me. Any help is very much appriciated :)

Hi everyone! Today I’d like to share a new approach to building reports in FME, along with an entire family of custom transformers I’ve created to support it. Why I built BRG I’m a long-time fan of the HTMLReportGenerator. It lets me craft reports quickly, and I love the versatility of HTML compared with, say, PDF. I even demo it in every Intro to FME course as a great example of “let FME handle the code.” But as much as I love it, I’ve always hit three pain points: 1. Plain styling – it could really use a dash of CSS/Bootstrap.2. Hard-coded content types – adding a new chart or HTML element isn’t trivial.3. Cumbersome feature ordering – managing Sorters and AttributeCreators just to control layout can get messy. Earlier this year I had to build a highly procedural report with lots of HTMLLayouters, AttributeCreators, and Sorters, and the workspace quickly turned into spaghetti. That’s when I thought: I already improved SystemCaller with BetterSystemCaller … why not do the same for rep

Hey guys, So I ran into a problem I shouldn't have. For my workspace I'm trying to subtract two integers from one another. The problem that I'm facing is that the arithmatic expression is not giving me any usable data. This is also the case when slightly change the expression. Below is the most recent attempt. Can anybody point out how I might be able to make this work? I have performed similar expressions in older versions of FME with no problems whatsoeverI I'm currently running FME 2024.2.4.0. The data type is originally Real64 but I converted it to Int32. Any help would appreciated.

I have land parcels that are currently separate features in ArcGIS SDE. Below highlights 2 parcels that that belong to the same property 1st and 2nd floors. (2nd floor is the smaller shape) I want to aggregate these into a multi part single feature grouped by an ID that they share called LANDNO. After using the aggregator transformer, it looks like the below where the second floor has been totally cut out leaving nothing. I haven’t tried a Disslove yet but I reckon that would remove all vectors of the second floor which I still want to keep. Here are the settings in Aggregator. Any suggestions to achieve my objective ?

I’m building a value for the Longitude of a point feature. The field type I have defined is number (20,6) I create the value using this in the text editor: @Format(%.5f,@XValue()) So I want 5 decimal places. eg. 15436225.30510 However, what I see in my result table viewer is 15436225.3051 (no trailing zero) But when I double click on that value, it displays the value “with” the zero. 15436225.30510 The value that gets written to the writer (to AGOL) is the one without trailing zero. Works fine until I use a change detector, then it decides that the trailing zero is causing a difference and wants to update the value to have the trailing zero. So my question is, can I enforce the trailing zero in the table result? Then I will rewrite my destination records one time again and hopefully my change detector will realise they are the same from that point on. My original format statement again is : @Format(%.5f,@XValue())

I have been able to successfully connect to Asana by using two resources (attached at the bottom) and extract a list of task names and custom field names, but I have been unsuccessful in using the JSONFormatter, JSONFlattener, and the JSONExtractor tools to create a list of tasks and their corresponding custom field values for a specific Asana project. If anyone is experienced in working with the Asana API to collect this kind of data from a particular Asana project, I’d be really appreciative of any helpful tips to create a final output of a project’s tasks and their custom fields. Thank you so much! https://hub.safe.com/publishers/safe-sandbox/web-connections/asana)

Hi I am doing a comparison of multiple AGOL feature services and am using a workspace runner to iterated through the feature services. I have created a published user parameter for the feature service name, which is populated by the workbench with the workspace runner. This appears to work fine but the problem is I cannot seem to make the layer name a parameter so it keeps reading the layer name from the feature service that the agol reader was set up with originally. Does anyone know a way round this please? Or perhaps it is resolved in a newer version of FME desktop (Im currently using 2023.1)?

Hello all, is it possible to use one AttributeRounder to round different attributes to different accuracies? Let’s assume i have two attributes, A and B. I want to round A to 2 decimal places, whereas i want to round B to three decimal places. Is this possible with one AttributeRounder or do I need to use the AttributeManager. Cheers!