FME Form

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% match So 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 enter the URL (the un-redacted one in the image above) I’m then asked what features to read. When I then select the ellipsis I get this error Am I misunderstanding how the reader works? Do I need to present the reader with a different set of information per file in SharePoint? Is there another way of doing this? Thanks, Stuart

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 Computer Writing around 430.000 Features to database over network 1hr 39m 1hr 29m Writing around 4

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 Experts I would like to suggestion and Guidance Does FME Form has Time as field type I’m using FME 2024 Thanks

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!

Description I 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?

Hello everyone, We just upgraded to FME Form 2024.2.1 and we currently encounter one problem. For the users, the personal database- and web connections were inititally not migrated. Thus we sent first a mail to the users that they coud export the database- and webconnections in FME Form 2023 and then import the exported file in FME Form 2024. It looked like it solved the problem, however when the users logged in the next day on an new machine, they lost all their personal database- and webconnections. We read the following link: Changes to Connection Storage in FME Form 2024 – FME Support Center and it became clear to us that's due to the new way that personal database- and webconnections are stored. They are stored in fme_userconnection.data and the machineID is hardcoded in this file. In our organization we work on a virtual machine and thus also everytime we log into a new machine. It's now clear why the database- and webconnections are not visible in FME Form 2024. I was wondering

Is it possible to save the frame of the data inspectors?I mean, I have this: Two layers overlapped Is 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 intersections are within our County. All rows/addresses are rejected with the FME Rejection Code ERROR_DURING_PROCESSING. The County Locator Service works properly in ArcGIS Pro or when an address is presented to the Address Candid

@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 just had a job on our FME server 2022.2.2 go haywire. When reading from one or more database tables, it suddenly spews out a _lot_ of error messages, repeating the same two lines from line 319 to line 865997 (on page 1734): Microsoft SQL Server Spatial Reader: An internal error has occurred. Please visit http://www.safe.com/support Microsoft SQL Server Spatial Reader: Failed to parse datetime, attribute set as null What gives ? Should I be concerned ? I've occasionally encountered huge log files before, but haven't had any idea why. Next time I'll see if it's the same issue. The job took several minutes (as opposed to normally a handful of seconds) to finish, which is not good. Cheers.

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 Renewal Kent Bryan 333 Queen St Y File 1 113 Renewal Kayla Jan 333 Queen St Y File 1 114 Renewal Jung Chen 5 Queen St Y File 1 115 Renewal Jung Chen 5 King St N File 2 116 Manual Ray Ban 5 abc st N File 2 116 Manual Kan Can 6 xyz st N File 2 116 Manual Harry Potter 8 niagara st N File 2 116 Manual Rob Smith 9 India St N File 2 116 Manual Tony Stark 10 peter st N File 2 116 Manual John Snow 11 sandwich st N File 2 2000 New Melanie Joy 275 Rankin Avenue N File 2 2001 New Melanie Joy 275 Rankin Avenue N Fil

Hi, I have 50 SQL queries stored in a excel file. Column A: Name_SQL_Query Column B: SQL_Query I 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 past suggestions, but then I hit a wall (pun unintended) becacuse SpatialRelator and SpatialFilter don’t work for 3D Data (INVALID_GEOMETRY will be written). The only transformer that seems to

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

To provide context, I’m trying to read tables from Amazon Redshift DBs, because our IT Dept does not allow direct connections to our Oracle Nonspatial DBs. We’re using Amazon Redshift as a “clone” of our Oracle data, refreshed daily. Problem is that when I access Amazon Redshift via FME Reader, tables in those schemas that are DDL-enabled are not visible to me (I can see the schemas just fine, but when trying to specify the specific tables, this below error appears). Fig. 01 - Tables not accessible in FME Amazon Redshift Reader The following image is when I click the “Show Log...” button. Fig. 02 - Logs from “Fetching Feature Types Error” But when using DBeaver (with the same connection details and credentials), i can view the tables and data just fine. Fig. 03 - Dbeaver Database Navigator I’ve shown this behavior to both the ArcGIS Pro vendor and our IT personnel, and they’re both stumped. What would be the probable problem here, and where should we start looking? See the following fo