FME Form

Hello, I’m trying to convert decimal coordinates into a DMS format with hemisphere indication. Example : 1.4861803 ; 43.5713123 Target format : 1°29’10.2491” E ; 43°34’16.7243” NIn my workflow, i used DMSCalculator transformer to split the coordinates into degrees, minutes and seconds. This part works correctly.However, I am now stuck when trying to reconstruct the final formatted string. Does anyone know the best approach to rebuild this format ?Thanks advanced,

I’m writing data from FME into an existing Excel sheet (XLSX writer) that is later edited by others in Google Sheets. Some columns are manually updated after the file is generated.When the workspace runs again, FME starts writing at Start Row = 2, which overwrites the existing rows and removes those manual edits.Is there a recommended way to append new rows to the bottom of an existing worksheet in FME while preserving existing rows and user edits? I saw a somewhat similar question in a different post, but didn’t know if there was an easier way?

I am working on a project creating building footprints from a lidar point cloud. However, the original lidar point cloud being used has some portions of buildings classified with “unassigned” values which has created incomplete building footprints. Are there any suggestions how I could identify these “unassigned” building values to fix the building footprint?

I need to connect to a PostgreSQL database via an SSH connection. How can I do that ?Thank you

Hello,I am trying to convert decimal coordinates into a DMS format with hemisphere indication.Example:Decimal format:1.4861803 ; 43.5713123Target format:1°29'10.2491" E ; 43°34'16.7243" NIn my workflow, I used the DMSCalculator transformer to split the coordinates into degrees, minutes and seconds. This part works correctly.However, I am now stuck when trying to reconstruct the final formatted string. I am not sure what is the best way to: concatenate degrees, minutes and seconds into a single formatted value add the correct hemisphere suffix (E/W for longitude and N/S for latitude) My goal is to automatically produce a final attribute formatted like:1°29'10.2491" Eand43°34'16.7243" NDoes anyone know the best approach in FME to rebuild this format after using the DMSCalculator?Thanks in advance for your help.

I had a hard time with the integration of GDAL and FME raster transformers. So, for the record, I posted a short tutorial:https://blog.fiorino.fr/index.php/2022/05/11/fme-python-api-working-with-rasters-and-gdal/

I am loading a small raster/tiff into CesiumJS via ion for a limited area of interest, which works, but I am getting a sharp “cliff” between this raster and the surrounding Cesium-terrain (I assume it is the Ellipsoid, it sits at roughly 35m above MSL). My initial idea was to see if I can “lift” the surrounding terrain up to the level of my custom raster-tif, but I guess that’s not possible, so my second idea is to expand my raster to continue outward at a set height (say 80m) for a few hundred meters instead to better mask the impression of the vertical cliff, and maybe have it ramp downhill until it meets the default terrain. However, I have no idea how to do this in FME, and ChatGPT is hallucinating around FME as per usual :)Does anyone have an idea of a solution for this? Ultimately, I just want something nicer than the sharp cliff a la Grand Canyon into something that is not too distracting for users. I’ll include a screenshot of my Cesium-app the way it looks in the browser, as w

I need to update environmental data in our system. The input data comes from an ESRI Shapefile, and I am using FME 2021.2. The output is stored in Oracle Spatial.However, the system that reads the data from Oracle only accepts simple polygons. When I try to insert multipolygons, part of the geometry is ignored by that system.Is there a way in FME to convert multipolygons into single polygons while maintaining a 1:1 relationship between input and output features?If I use the Deaggregator, the number of records grows exponentially, which is not viable for our database.I also started working with FME recently, so I may be missing a simpler or recommended approach.What would be the recommended way in FME to transform multipolygons into valid simple polygons without increasing the number of features?

My long time transformer friend FMEFlowLogFileRetriever is not avaliable in FME 2025. The error asked me to use HTTPCaller to retrieve the job log file. So I used this rest point in the HTTPCaller’s Request URL with GET - https://my-fme-flow-hostname/fmerest/v3/transformations/jobs/@Value(jobid)/log. I tried the Basic and Web Connection authentications, but both gives the error “HTTPCaller (HTTPFactory): An error occurred while accessing the URL 'https://my-fme-flow-hostname/fmerest/v3/transformations/jobs/98/log'”. I have no problem publishing using the same Web Connection for the authentication, so don’t understand what the issue is. The jobid = 98 was run successfully on the FME Flow.

Hi everyone,I’m new to the FME world and trying to implement one of the automation workflows for Survey123 Report Generation and I’m wondering if anyone has run into this similar issue.I’ve followed the workflow here: https://support.safe.com/hc/en-us/articles/25407476227725-Emailing-a-Survey123-Report-using-FME-Flow but I’m having issues on Part 2, Step 4: Run the workspace.I can run the workspace but it’s failing on the Survey123ReportGetter transformer. It’s a general error stating ‘ArcGIS Online report job failed or returned an unknown status’. I can see in Survey123 within ArcGIS Online that the report has indeed kicked off and is generated, but my belief is that it is taking too much time to return that info back to FME so FME says its a failure. Currently in my workbench, that failure is occuring within a minute and I know that the Survey123 report process can take a little bit more time than that.Has anyone seen if there is a way to let this Survey123ReportGetter transformer pr

Hi,In a workbench, I created a Custom Transformer to loop batch of features.It is a workaround to prevent machine reboot on large feature datasets processing. At least, writing-along features in the Output to .csv. file help to recover features processed in PythonCaller and it is easier to resume for the remaining features… Here is the workbench, with Inputs:batch = 10counter = 54000 (total of features)loop = 0 (to keep track of iteration)offset = 0The Tester_counter transformer filter out batches 10 features at each iteration, sent to PythonCaller. At the end of processing the Tester_Loop tests if there is remaining features to process. Anything processed is sent to the Output and written in a .csv Writer transformer in the ‘Main’ workbench, whereas ‘failed’ remaining features from Tester_counter have their attributes incremented for variables loop and offset for the next iteration.However, when running the workbench, the output .csv file is created but kept empty. Also, each iteratio

Hi there,We recently installed ArcPro 3.3 with the data interoperability extension FME version 2024.0.1.0.I have succesfully used WorkspaceRunner in the previous version of ArcGIS PRO 2.8.But now, when I use the WorkspaceRunner transformer to run a simple workspace the transformer fails to read the published parameter, it says "Specified workspace has no parameters or could not be read". The workspace I am loading into workspacerunner does have a published user parameter. Does this happen because of the new version of ArcGIS? Anyone else have this experience? Thanks, Winonah

I have JSON response from an API that looks a bit like this (tidied up for the purpose of showing here):{ "member": [ { "id": "OBF-123", "fieldspec": [ { "assetattrid": "FIELD01", "assetattribute": [ { "datatype": "NUMERIC", "description": "Length" } ], "numvalue": 13.4 }, { "assetattrid": "FIELD02", "assetattribute": [ { "datatype": "ALN", "description": "Fruit type" } ], "alnvalue": "Banana" }, { "assetattrid": "FIELD03", "assetattribute": [ { "datatype": "ALN", "description": "Class" } ], "alnvalue": "N" } ] }, { "id": "OBF-124", "fieldspec": [ { "assetattrid": "FIELD02", "assetattribute": [ { "datatype": "ALN", "description": "Fruit type" } ], "alnvalue": "Apple" }, { "assetattrid": "FIELD01", "assetattribute": [ { "datatype": "NUMERIC", "description": "Length" }

Hi.I'm looking for a way to compute the average while excluding outliers. This average is based on 5 attribute values for each record. To expand, i am QCing pole counts within permits. Each permit is a record. There are a bit over 10k records. I have 5 attributes, with pole counts, each coming from a different source.Example:permit a, pole counts = 1, 4, 5, 28, 6permit b, pole counts = 2, 10, 14, 80, 12Manually, for permit a, i'd exclude 1 and 28 and my avg would be 5. For permit b, i'd exclude 2 and 80 and my avg would be 12. The final goal for this exercise is to pick the value closest to the average computed without outliers. Pls help. Thank you.

Hello I’m experiencing some issues using Dissolver. I want to take a polygon dataset which contains 160,455 independent polygons objects. Some of the polygons overlaps with other polygons. Some are not overlapped by others. I want to merge all of the polygons, whilst dissolving any overlaps, to create just one polygon object. Using Dissolver I am only able to merge polygons where they are overlapping, whilst input polygons that are not overlapped by other are remaining unmerged. This means that I’m getting 80,090 records in the output. But I don’t want that. I want just one polygon object as one record. This diagram illustrates (conceptually) what I have, what I’m getting with Dissolver, and what I require.How do I use Dissolver to do this? Or should I use a different transformer. Thanks,

I am using the AI-assist within FME Workbench very often. last time was yesterday.unfortunately today i am having troubles to see my history and cannot start a new chat.i am getting an unknown error.even when i am logging out and logging in again. we also checked our firewall for any blocked sites and traffic.are there any issues? kind regards.Laurens

hi All, i am currently using FME2015, May i check if we are able to use openJDK to replace JRE so that we do not need to use Java Oracle license? Thank you.

I’m using the Esri Reprojector transformer with a feature reader that reads feature classes from an ArcSDE connection. They all share the same coordinate system and I need to transform them. I can do this successfully using three separate transformers but seems a bit silly. I’m assuming there is a way that I only need to use one and feed the three feature classes through it? I’ve tried doing this and adding a FeatureTypeFilter transformer but this returns no values if I click ‘Update’.  

It seems that any file with a # in the filename won't download when using the SharePoint online connector transformer. I want to download using the _fullpath method.  Simply --> if the filename is FOO_1 it works. If it's FOO#1 it doesn't. The rejection code is SHAREPOINT_ERROR , the URL it's trying to DL is:SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0//sites/ac[HIDDEN]%20November%20#4.jpg: The resource could not be found.Is there any way to get around this? I have tried the URL ENCODER and STRING REPLACER transformers to try and manually encode the # symbol but it doesn't like this. Presumably because it's trying to encode it "again" I can tell my users to stop using a # symbol in the filename but would rather solve it more elegantly and retain the original name.  Link to transformer:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/sharepointonlineconnector-pkg.htm

I’m having an FME workspace that has a custom transformer that is set to parallel running.when running the workspace from FME form there is no issue, everything runs smoothly.If I want to schedule this workspace (due to lack of FME flow) using Windows task scheduler the workspace terminates because none of the cild processes run succesfully.They all crash with the message ‘Access is denied’. This is the commandline for a child process:When not running in parallel, there is no issue.anyone an idea what can cause this issue? it’s really fustrating on how to solve this?

I’m reading Survey123 results into FME where one question allows multiple selections. The answers come through as a comma-delimited string (e.g. Need_PD,Need_TMA,Frozen).I want to validate the responses against a known list of allowed values (CSV/XLSX), so that: each selected value is validated individually any invalid or new value (even if it hasn’t appeared yet) is flagged I don’t need to handle every possible combination of selections I understand that Tester “Cached Values” only shows existing data values and that Survey123/ArcGIS domains aren’t directly usable here.What is the recommended transformer pattern to: split the multi-select field so I can edit testers for looking for certain selected options and not others

This is really strange—I’ve never seen this behavior before.After saving and closing my workbench, all other FMW files in the same folder disappeared automatically.At first, I thought I was imagining things, but other users have reported similar issues before. [Post link]Version: 2024.2.1 (Build 24801)OS: Windows 11 24H2 (26100.2894)The only change I can recall is that I recently uninstalled all old FME versions, but that shouldn’t somehow trigger file deletion, right?

I have a list of points which I want to connect to lines. But one line should contain only points with a specific value in a field. At the end I want to have multiple lines in one feature class. How can I do that?

I think the answer is No, but I hope someone can tell me that I am wrong.I want a user to be able to select any existing database or webconnection for a custom transformers. Is there a parameter that allows me to do that?Why I don’t think it is possible:Existing parameters require you to select a database format first webservices python doesn’t offer the capability to get a connection without knowing its name 

Hi all,I’m currently working with several Revit files hosted on ACC, and I have put together a workflow that can read a specific ACC folder and identify a federated model. The process successfully reads and downloads the host file; however, I have been unable to download the associated linked files.Is there a way to use the AutodeskDocsConnector to access and retrieve the linked files as well?Thanks :)