Using transformers to modify data.
Recently active
Hi,I am currently working on an assignment in FME and have run into some difficulties regarding how to structure the workflow to meet all the required criteria.In particular, I am unsure how to best combine the distance requirements. For example, how to approach buffering and overlay operations to ensure the area is within the correct distance from both the sandy beach and a major road, while also being sufficiently far from buildings. I am also uncertain about the most logical order of steps to avoid creating an unnecessarily complex workflow.I would really appreciate any advice on how to approach the structure of this task in FME in a clear and efficient way. I am mainly looking to better understand if there is any other transformers who would make the workflow more efficient?Thank you in advance for your help.Best Regards Anton
I am using the Precisely MapInfo Extended TAB Writer to generate a MapInfo table that is over 2GB (total) in file size. I estimate it should be between 3GB and 4GB in size.I am indexing five attribute columns in the table.And the process of indexing the attribute columns is extremely slow.When I do not index any columns, it takes about 20 minutes to Write the tableWith indexing the columns, it can run for twelve hours before I halt the process in frustration to check my process.Does anyone have any experience of this? Is the Precisely MapInfo Extended TAB Writer just bad at generating indexes?
Hi everyone,In FME 2023, does anyone know the correct way to create a 3D vector starting from a list of 3D coordinates referring to two different moments in time?In the past, it was possible to connect two Vertex Creator transformers to generate a 3D vector by linking two 3D points. However, it seems that this is no longer possible in the same way.Any suggestions or alternative solutions?
I'm trying to read a OGC geopackage which contains fields of the type 'datetime'.In FME 2025.1 (which uses version 16 of the FeatureReader) something unexpected happens: in case the number of seconds starts with a 0 (zero), this zero gets dropped after reading the data. See record 21 in the screenshots for an example:In FME 2025 the field ‘tijdstipRegistratieLV' misses a 0 after the '1009' (10 hour 9 minutes).In FME 2023 the readout is correct: 20101214100907 (2010 december 14th, 10 hour 09 minutes 07Is this a known issue/bug?
I have a simple job reads points from a spreadsheet and buffers my pipeline. I would like to set up the SpatialFilter to see which points on the spreadsheet are outside my buffer. For some reason, all points go to the Failed port. I have exported the buffer that is created and verified they correct and most of the points fall within the buffers. Any tips are appreciated!
Has anyone had success with using the updated 2025.2 Excel writer to write data to a table in Excel? I see that this idea was implemented with 2025.2: Excel Writer: Explicit Table Support | CommunityHowever, the instructions for the writer don’t go into a lot of detail on how to have the writer create a new table on a sheet and load it with the incoming data.I personally tried to follow some of the older demo’s that walk throughs for writing to a named range. Those walkthroughs require you to create a template xlsx file with the named range already created. So for my 2025.2 test, I create a new template.xlsx file, then created a table named tData on Sheet1. The table is blank. After that I created some dummy data in FME and tried to write it to a new excel file using the template. The output excel file does load the dummy data onto the sheet, but it doesn’t go into the table. And actually my table disappeared from the sheet.It would be great if there were some tutorials out the
Hi All,I am currently working an automation process to convert XYZ files into LAS format for use in ArcGIS. I have successfully generated the point cloud and exported it to LAS; however, the classification information is not being retained.The custom classifications are based on codes contained in the original XYZ files as text, and these values are stored in a table, an example of which is shown below: How can I convert the XYZ files to LAS while preserving the Feature attribute as the classification?Attached fmwt fileThanks :)
Dear community,I am currently working on FME Workbench 2025.0. My project take into entry areas in 3D that represent buildings roofs. It then spreads the data into two datasets: roofs and building using the latest ground footprint. In order to do that, I am using the 'Dissolver' Transformer with the Group Processing option on. My issue is that some of the edges inside the building are remaining because they do no fit on the Z axis (see screenshots below). Dissolver operation: purple edges are classified as ‘Remanents’ after the operation, red one remain.Result of Dissolver : on a 2D perspective, internal edges are remaining.For better context: the result of the Dissolver from another perspective in 3D.I tried to flatten the surfaces before proceeding to disolving the objects (these objects corresponding to 'Building' will be flattened at some point of the workbench anyway), but still the same edges are remaining. Thank you for your help.
Hi all, I’m fairly new to FME learning a lot but still get stuck at the odd point.II’m using attribute manager to set 2 attribute values to later be used in httpcaller. here I am setting the values and trying to use the values in the below url. this is going through to the url without the actual value. I have tried both the ${myvalue} and @value() methods but both simply put what i’ve written below into the actual url but not actually the values. I used the logger to view the above values and they are definitely showing as 100 and 1 but I can’t get them to show up in the below url. Can anyone direct me to what I’m doing wrong here?
Hi I am using projectwise wgs connector to upload a file into pw. I was wondering if their a way to uprev the version metadata attribute within pw. When the file is uploaded to pw.
I wanted to make all my attribute to camelCase, currently they are separated by underscore.I wanted to change my attribute name to camelCase, so using regular expression in BulkAttributeRenamer transformer to find text following underscore using regular expression replace: _([a-z]) However, i am not sure what String parameter i have to put to make the selected character Capital letter. I have tried \U\1 and also few other but its not working. Basically wanting to find String parameter value?
Hi, I read xlsx files and want to write the name of the file in to an attribute. The writer I use is a feature writer to use the result in ARCGIS online. Thank you!
I’m using the Gemini Connector (Transformer) in FME and facing an issue with initiator (upstream) attributes.My requirement is:The attributes coming into the Gemini Connector (initiator attributes) Need to be merged with the Gemini response/output, so that the final feature contains both the original attributes and the Gemini result Current behavior: The Gemini Connector output only contains response-related attributes Initiator attributes are not carried through or merged automatically Question: Is there a supported way to merge or carry initiator attributes along with the Gemini response? Is this a limitation of the Gemini Connector transformer? What is the recommended pattern (FeatureMerger, Joiner, correlation ID, etc.) to achieve this? Any guidance, best practices, or examples would be really helpful. Thanks in advance!
Hican someone advise if there is a replacement for the PhotoCoordinateExtractor transformer?I’ve not used FME for about 15 months, but now have a new laptop with FME Form installed (rather than the old FME Desktop previously)I had a workspace set-up to load and extract exif imformation from images, then generate a point table, but when i run this in FME Form the PhotoCoordinateExtractor is rejected.I’ve looked in the transformers but can’t identify one that replicates what the PhotoCoordinateExtractor didThanks
I recently tried to update an older workspace with a TestFilter that is used to branch data out using basic logic. After the update, the workspace failed in an odd fashion and after a bit of troubleshooting it turned out that one of the tested attributes, “fme_feature_type” in this case, was getting changed to nulls for many, but not all of the resulting rows. The change was from TestFilter Version 2 to Version 3. Has anyone else experienced anything similar? I’m running FME Form Build 25815.
XML Parser error: 'unable to open primary document entity 'C:\FME_TEMP\wbrun_1770387492402_18548\fmetmp_13\1770389629687_17428_d\importedModel390.dae''An error has occurred. Check the logfile above for detailsThe below feature caused the translation to be terminatedglTFReader_FeatureReader_3_<Rejected> (TeeFactory): glTFReader_FeatureReader_3_<Rejected>: Termination Message: 'glTFReader_FeatureReader_3 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''
Hi all, I would like to trim the first 7 characters from all the columns in my dataset. I think this can be accomplished with the BulkAttributeRenamer. But I'm struggling with the String Parameter. Any ideas?
Hi there,I don’t know if I am doing something wrong but I am trying to use the new ESRI ArcGIS Feature Service connection to read a public layer from another organisations AGOL account. I have it working using Standalone Server as the source type. I can’t seem to get it working using the ArcGIS Online source type as I don’t have a login to their AGOL and I don’t need one as it’s public data. I can only login to our own AGOL account.Anyway I have this working - it’s reading the data but I am now coming across the whole reading dates as Epoc time again and my DateTImeConverter is spitting the dummy.I have updated the reader to v3.20.1 and I have checked out the article below:Esri ArcGIS Feature Service - Reads Dates as Epoch Milliseconds | CommunityIt is showing that you need to change the Date format in the parameters to FME Default however it seems this option only shows when you use ArcGIS Online as the source type. I am not getting that option when using Standalone Server.Is there an
Whenever I try to open the AttributeRenamer transform properties, FME Form crashes. It doesnt matter if it is an existing workflow or if I start a new one woth nothing but only one AttributeRenamer. Any thoughts, anyone? The screenshot below if from FME Academy: But it also happens on an otherwise empty workflow:
Hi.This is either a no-brainer that I haven’t figured out, or not doable, I think. But it’s a simple task.I need to count the items in a JSON array, but I need to do it in a looping custom transformer, so it needs to be non-blocking.In a custom transformer, I use a HttpCaller to get a JSON response, which includes an array of items. I may have to issue more http calls within the custom transformer, so it contains a loop back to its input.JSONFragmenter can easily find the array items, but as features, not in a list format, so I need to use a blocking transformer like Aggregator to count them. This is no-go.So either I need to extract the JSON array items into a list, and use ListElementCounter to find the length, or count the JSON array items in a different non-blocking way.Does anyone have a solution for either of these tasks ?Cheers.
Apologies if this has already been asked - seems like it should already have been reported.FME Form 2025.0.1FeatureWriter Version 0Writing to Esri Geodatabase on MSSQL Server 2019When using either Create if Needed, or Drop and Create table handling, the geodatabase_sde writer appears to ignore the table qualifier set on the feature type. The table gets successfully created, visible in SSMS - but under the default user database schema eg: domain\john.smith.FeatureClass1 However the flow then fails because at some stage it does take into account the table qualifier and is looking for a table called sde.FeatureClass1An error occurred while attempting to create the table 'sde.FeatureClass1'. The error number from ArcObjects is: '-2147220655'. The error message from ArcObjects is: {DBMS table not found [{dbname}.sde.FeatureClass1]}The user has appropriate permissions on the sde schema(Note: It is an Esri requirement that the users default database schema name matches the username, so the de
If you have ArcGIS Pro installed on your machine then you have access to the arcpy.geocoding module with its Locator class, which can be serverless. This puts geocoding in the hands of anyone with (say) a file-based locator.
In the Esri ArcGIS Portal Feature Service I can reference a Feature Service in the parameters with the service name and an ide.g.But in the Esri ArcGIS Feature Service it’s not possible without a group? Is this correct?Is there some secret syntax i’m missing?
Hello all,I want to build a Tester that detects if an attribute value has a left-bracket in the stringFor example;ASCOT (TOOWOOMBA REGIONAL)Would be detected, because it has brackets surrounding TOOWOOMBA REGIONALI then want to extract just ASCOT and throw away that part of the string in brackets
hi everyone! some of my line features (ex. pipes) have text features floating above (top left) of the line, describing what type of pipe it is. I want to add that text as an attribute field to that feature. but also not all of the lines have one and I want it to only match if it's describing that feature (not grabbing a random text field nearby). This is my workflow so far, with some brief descriptions. I'll also note that everytime I've tried to use neighborfinder, the autocad_text_string AND fme_text_string values of certain lines show numbers (ex. 356.77, 623.44) instead of the descriptive text it should have shown. im guessing those are possible distance values it’s grabbing….I've been trying this for hours and would appreciate any help given. thanks in advance! my workflow is attached below.