FME Form

Hi, I have one column in my excel file that show tha values like below: VARIEDADE ABB4, ABB2, ABB4, ABB5ABB4ABB2, ABB5ABB2, ABB2ABB4, ABB4, ABB4, ABB4 The two last lines have the same value separated by comma. I would like to simplify like below: ABB2ABB4 How Can I do this? Thank´s

We just a installed a new ArcGIS Enterprise (11.4) environment and want to connect to it with FME 2024.2I successfully configured a Web Connection to the ArcGIS Portal using this guide.When I try retrieve Features Services from Portal this takes very long (4min) and eventually I get the an "Error Retrieving Selections” as below  I tried connecting to https://mydomain/portal/sharing/rest/portals/self directly with an HttpCaller and the same Web Connection and that gives a good response✅. So my web connection

I’m working on a data inventory project and need to figure out what data sources are being used in a large number of aprx’s. Is there a way to determine the data sources of an ArcGIS project by directing a workbench to an aprx file path?

Hi everyone, i have few questions about coordinate systems1. How can i know in which coordinate system is file that i upload2. And how can i reproject that coordinate system into 32634(I have been trying with reprojector but it’s not exactly right when i add project in qgis on my map)3.Which ever coordinate system i tried, it never is 100% matchSo i need help if someone can tell me what should i do?Thank you in advanced 

Hello Forum,. I would like to connect to files stored in SharePoint. This is a redacted example of one of the URLs…. I’ve seen the ‘SharePointOnlineConnector’ transformer from https://support.safe.com/hc/en-us/articles/25407532347661-Reading-and-Writing-SharePoint-Libraries-with-FME. However that only works on build FME Build 24577 or higher. We’re on build 23619 - note that we are planning to upgrade in Summer 2025, but that’s a while off. Is there a way of reading from SharePoint without the SharePointOnlineConnector transformer? I see I can select Microsoft SharePoint List as a reader format in FeatureReader. However when I

Working in FME Workbench  (Form ) 2024.2.When I disable all transformers inside a Bookmark (via right-click => “Disable all Objects in Bookmark”) and then enable them again using the same method, those transformers are still all listed as ‘Disabled’ in the Navigator. FME “knows” they are enabled because the right-click now allows me to “disable” them. But this seems like a bug.How do you disable a disabled transformer?!Not a functionality issue but kinda annoying, as I’m upgrading a bunch of large workbenches and like to turn things on/off for testing. 

Hi everybody I have FME Flow 2024.2.3 installed on a virtual machine in Azure.I'm trying to publish a workspace from my computer using FME Form (FME Workbench 2024.2.3), and the WAF blocks it. I get the following error:requestUri_s /fmeapiv4/repositories/Samples/items/upload?overwrite=trueMessage: Illegal Content-Type headerdetails_message_s Pattern match ^[\w\d/\.\-\+]+(?:\s?;\s?(?boundary|charset)\s?=\s?[‘”\w\d\,\-]+)details_data_s {found within [REQUEST_HEADERS:]}How can I view the header content to determine what is illegal? Thank you for the help!Gerard 

Hello everyone,I recently got my computer running FME Form replaced and made some observations regarding performance that I wanted to lay out since I am not sure that everything runs as it should.I am testing with a big workspace with close to 1000 transformers.Coming from an aging Intel i5 6th Gen with 32 gigs of RAM and now sporting an Intel i7 14700-K with 128GB of RAM I was expecting some substantial performance uplifts.The observation I made is this:Yes, when I only read and write locally I am seeing a good boost in performance (a little over 2 times faster). However, in production this workspace is meant to write to a PostgreSQL database over the network. In this scenario my new computer is very close in performance to the old machine, even getting beaten by a few % in overall processing time (writing to the same database over the network). Here is the numbers.  New Computer Old Comp

Hello Forum, I’ve been provided with a set of json files (note, not geojson, but json). Within each json file I know there are geometry coordinates pairs. See this screenshot of the json in Notepad++… How can utilise FME to open each json file and pull out the geojson elements to create a geojson showing the polygons? I’ve attached an example project json file. Note that I’ve changed the extension from .json to .txt to get through the Forum blocker not allowing json files. Thanks,  

Hello, I am facing problems with my Bentley V8 Writer :  The Writer offsets my text (labels) and I don’t know why. I just upgraded the Writer from 2022 to 2024.In the earlier version (2022) I didnt have this kind of problem.As I am not very familiar to Microstation I ask you to share your idea. :)Thanks in advance !In the attachements you’ll find an image showing the error and a an exemple for tests. 

Dear All,I am attempting to spatially join the nearest points based on a one-to-one relationship but cannot get it to work. Below is a graphical example of my query:I aim to join the closest yellow dot (627 records) to the nearest black dot (71,533 records). Essentially, I want the Neighbourfinder to identify the closest one-to-one relationship and disregard the others. The default settings of the transformer calculate the nearest points for all 71,533 records, which I wish to avoid. My objective is to integrate the information from the yellow dots into the black dots for only the 627 closest records. Any ideas? Thanks :)

Hi ExpertsI would like to suggestion and GuidanceDoes FME Form has Time as field type  I’m using FME 2024Thanks

I am new to FME and I wish to make the following transformation.From:IDColAColBColC1A1B1C12A2B2C23A3B3C34A4B4C45A5B5C5 To:IDColumnNameValue1ColAA11ColBB11ColCC12ColAA22ColBB22ColCC23ColAA33ColBB33ColCC34ColAA44ColBB44ColCC45ColAA55ColBB55ColCC5 Can anyone help me out?

Hello Safers,I have a layer of tie points, and another layer of line segments. I was wondering how would get FME to snap segments to these tie points? I believe I have to use the line extender, and intersector without incorporating my tie points. Or, is there another way? Basically, I have roadcentrelines from various locales and I have to snap lines together from them to make an unified dataset. Thanks!

DescriptionI have a excel template file which I have in the excel reader dataset as a reader file. This file only has the name of the attributes and no features. I am trying to implement this job for the end user where every month they can upload the excel file with the same template structure, however different features month on month basis.  I want to set up my parameters in a way that based off the template populated, it reads the file every month when uploaded by the end user and also give an ability to the end user to mention the sheet name in the prompt. 

I have a new attribute named EXPORT_YEAR. I want the Attribute Value to automatically change to 2026 at 12:00AM Jan 1, 2026. Until then it will stay 2025. Is this possible? if yes, what expression do I use?   

Is it possible to save the frame of the data inspectors?I mean, I have this:Two layers overlappedIs it possible to save this image at certain zoom directly in FME from data inspector or the regular translation environment?

Hello FME Community, can someone help me configure the Geocoder transformer to use our County geolocator service?  I’m using a single-line address, with the locator on an ArcGIS Server.  The URL is https://gis3.montgomerycountymd.gov/arcgis/rest/services/geocode/Composite_Locator/GeocodeServer.  This is a public-facing locator service for Montgomery County, MD. I’ve tried:   Using the above URL   Using the locator as an AGOl item in the transformer, both fail.     Setting the URL with different paths to the operation or the base geocode folder.   Setting the transformer geocoding service parameter as ArcGIS Server or ArcGIS Online.  I can successfully use the geocoder transformer with the ArcGIS Global geocoder, but I prefer the County geocoder to ensure the addresses and inters

@safe I just recognized that the SpatialRelator in 2025 does not release my Requestor attributes as before (2024 and any older version I remember).I’m used to use the SpatialRelator with the setting ‘Generate List’ checked (incl. some selected attributes) and keeping the ‘Merge Attributes’ unchecked. As a result I see all my Requestor attributes and where applicable the list attributes according to the spatial relation I’m looking for.Now in 2025 the above setting ONLY releases the list attributes and all my Requestor attributes are removed. The only way to bring it back is to check the ‘Merge Attributes’ checkbox as well, which is not my intention.I guess it’s a bug since the Transformer page still states for ‘Output’: These are the Requestor features with the new attributes added. One list entry is made for each of the Suppliers that has at least one matching predicate. FME Form 2025.0 build 25208

Hi,I’m finding that the date shown for data updates on ArcGIS Online Hub is misleading and not showing the date that we are actually updating the data, has anyone used the Metadata Updater to update any of the dates in metadata?  I don’t see it listed in the dropdowns for the updater. Or should I be using the XMLUpdater?Thanks,Lorinda

Hi, Based on the sample table, I want to implement a logic. Same name, different policy # and same address - Goes to file 2 Same name, different address and different policy number - The first record goes to file 1 and rest of the records go to file 2.  All the manual should again go to the file 2.Policy Number New/ Renewal/ Manual Name Address To process Split  123 New John Chris 123 Oxford St Y File 1 110 New Mary Jane 45 Caron ave Y File 1 111 New Mary Jane 360 Caron ave N File 2 112

Hi, I have 50 SQL queries stored in a excel file.Column A: Name_SQL_QueryColumn B: SQL_QueryI am having a hard time find ways to execute the query and export to a CSV file with Name_SQL_Query. I set the csv writer to dynamic exposed. however, when i run the workspace i only repeated sql 6016 times (this is the number of rows I get when i execute the sql by itself). it seems like the first Query from the excel list is working when i sampled the first 1. However, I am getting the repeating of column A and B. How do i export the result straight from the SQLExecutor?  

Hello,Do you know why autocad_color parameter is allowed from 0 to 256 for Autodesk Autocad DWG/DWF writer but is strictely limited to 1-255 for Autodesk Autocad Map 3D Object Data writer ?It prevents to write entities with ByLayer (256) or ByBlock (0) Color parameter in addition with OD tables 

Hello everyone, I’ve been working with 3D Buildings recently and I’d like to add some info to the walls (e.g. indicating which wall has an entrance door). I could set up this information with the 2D Footprints by using the BoundingBoxReplacer and HorizontalAngleCalculator (I’d have used it with my 3D Buildings themselves, but it only works for 2D lines). But I can’t find the right way to add this information to my 3D walls.If I directly extrude the 2D walls instead of the 2D polygons, I lose the classification of Building_IDs that I want. If I reconvert the 2D walls into 2D polygons with an aggregator, all my info goes away and I’m back at the starting point. I tried converting the walls into points with snipping and then converting them into 3D Features with Offsetter and Bufferer such as other pas

Can you please let me know how I can switch and select the workflow based on the value of Attribute? For example I need to select and continue between continuing PythonCaller or PythonCaller_2 based on the value of operation IF ‘operation’ == ‘ADD’ THEN Continue with PythonCaller IF ‘operation’ == ‘REMOVE’ THEN Continue with PythonCaller_2