Data

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?

Hi, I have a query that reads data from a view. When I run the workspace that executes the query locally, it executes.If I then set the workspace to FMEflow, the query no longer works. Local and FMEflow use the same Oracle client version.The error message is meaningless: SQLCreator_11_<Rejected>: Termination Message: 'SQLCreator_11 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''The query does an select with a group by on a view. The same query runs in SQLdeveloper without errors.The only strange thing i see is when i skip the 'group by' that there are fields with the value "<Missing>" Normally i see Null.

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,

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

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 brow

Hi everyone,I’m currently building a tool in FME to compare a point cloud with a .000 layer that contains point soundings.Because the two datasets have different geometry types, I rounded the coordinates in both datasets to the same decimal precision (0 decimal places), using the CoordinateRounder. After that, I extracted the X and Y coordinates as attributes so that I could compare them directly using the CoordinateExtractor.When using the Matcher, I intentionally excluded the geometries and matched the features purely based on the coordinate attributes. The matcher does find some matches between the two datasets, but it does not capture all of them.I also tried using both FeatureJoiner and FeatureMerger, but these transformers merge all attributes, which I would prefer to avoid for this workflow.Initially, I suspected the issue might be related t

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": [ { "asset

Hi FME gurus. I am trying to extract values from a list to populate columns with the associated values in the fields.  In my list (called _columns) I have a caption field which has the name of the column I want to create and the date value I want to populate into the field so the example I have in the screenshot I want to look like this: Application ID Last Inspection Next Inspn Due 648343 2025-06-23 2026-06-16 15456.. 2025…. 2026….  The list exploding only brings out the name of the original column ‘caption’ but I am looking to use the values in the list itself to build the attributes and populate the values. There are rec

Hello all!I have a question regarding accessing data in an Enterprise Geodatabase in a branch-versioned Feature Service scenario:Using FME’s Esri Geodatabase (ArcSDE Geodb) Reader, can I read branch-versioned feature classes directly from my Enterprise Geodatabase (SDE connection) now that I have published a branch-versioned Feature Service? If I point it to the “sde.DEFAULT” version, will it access the features correctly?I would like to perform some heavy geoprocessing tasks, and my Feature Service performance isn’t keeping up, so the Esri ArcGIS Connector is a no-go

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.

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 have a source SDE Geodatabase reader and destination File Geodatabase writer, both with the exact same attributed relationship classe schemas. The File Geodatabase being written to is blank (I’m using a template) and I don’t need to re-establish any relationships, I want to write the records exactly as they appear in the SDE Geodatabase, to the File Geodatabase. I’ve read in feature types using Ignore relationships, making them type geodb_table, and the destination feature types are also geodb_table (though obviously both are in fact attributed relationship classes).FME (2024.1.1.1) seems to want to recognize the writer feature types as relationship classes, no matter how I define them. I don’t want to have to establish the whole geodb_rel_origin_oid and geodb_rel_destination_oid values since I know what they should be already from the source (and there is no common attribute between the two source relationship class tables anyways). Is there a way to forc

a file like the following.I am reading it using a Text Reader dataset in XML format.I would like to use XML Fragment / XML Flattener to extract the Name attribute and its value, but I always get no result from the XML Fragment.I am not sure what the reason is. Could someone please help me?Thanks in advance.FME 2021<processXMLRequest  ><field ><name>text1</name><value>value1</value></field><field ><name>text2</name><value>value2</value></field><field ><name>text3</name><value>value3</value></field><field ><name>text4</name><value>value4</value></field><field ><name>text5</name><valu

Hi.I have built a workspace for data generation that runs for several hours. To log the process input for documentation purposes, I write them to an FFS file, that is about 765 Mb. It includes both spatial and non-spatial data.I now try to open it in Workbench (2025.2.1), but it fails with this error message:No geometry mapping entry found for 'varchar(200)' in metafile 'C:\Program Files\FME 2025\metafile\FFS.fmf'. Please visit http://www.safe.com/supportHowever, the curious/funny thing is, that I can open the file in the Data Inspector program without any errors:What can be done to remedy this ? Are there any work-arounds for this error ?

I’m working on trying to automate some of my company’s reporting, like the one partially shown in this screenshot. So far, I am able to get pretty much most of this information through to the Attribute Pivoter, but I am pretty new to getting this information properly into a Google Sheet. I have the Customer side (left side) and Company side (right side) going through separate channels because they’re from different layers...and I’m starting to wonder if it’s even possible to populate this information in this way from Attribute Pivoter or if I should just switch to separate tabs within the Google Sheet. Second screenshot is what the attribute pivoter summary results look like for the right hand side which is essentially what I want...just not broken down the way I want. 

Hi, I am having a problem with FME doing truncates/inserts to an ArcGIS Online hosted layer. Sometimes the number of records in AGOL is 1000 more than FME says it is writing. If I run FME again it is 2000 records too many, 3000 when run again. This is happening in Workbench and Server 2020.2 but does not happen all the time. Features per request in the writer is set to 1000. This has not been a problem writing to other formats and I have other FME services writing to other AGOL layers without issues. Thanks, David

I’m working in an FME Form workbench reading in CSV files that reflect database updates and then using them to update a central XLSX file. However, when the CSV reader is pulling in a column with values of either ‘TRUE’ or ‘FALSE’, it is automatically converting them to ‘true’ or ‘false’.Has anyone ever noticed this with a CSV reader?Unfortunately the domain I am describing with this data has capitalized values, so reporting the codes as lower case somewhat defeats the purpose. I know the parameter for Case Sensitive Field Names would resolve the issue if i were seeing this in the attribute names but unfortunately i haven’t been able to find a similar parameter for the data itself.Is this just an inherent setting to the CSV reader format?

Hello,My team has developed a workspace for data collection of publicly available GIS-data. The workspace uses HTTP-callers to download the data from different URL:s, and then the data is clipped from a predefined area of interest. The schemas and the features area separated and the rejoined later in the workspace. The output is written to an ESRI Geodatabase. Everything is working fine using FME Flow 2023.2.2.0 - Build 23781, but when I tried upgrading to FME 2025, I get an error:“Esri Geodatabase Writer: Feature Type Definition 'd_y_n' was requested, but not defined. Please visit https://www.safe.com/support”Does anyone have any insights into this issue?Thanks in advance /Ville

Hi , I am working a lot of the DWG files and I had somebody did the work. So when I  received the DWG files and review them.  I have ArcGIS Pro and I looked at them and I was not sure about the  coordinate system there… so I pulled the file in FME Data Inspector and found them that they are not in the right place I am in Colorado…Question first is : What does the red symbol mean here ?Black square with blue point is where the DWG is. The record information shows the coordinate system is Unknown.

Hi,I have a dgn file created from OpenBuildings. Within OpenBuildings you can see attributes attached. However, they only seem to show in OpenBuildings not Microsation or FME (i.e they are not tags or xrecords). Therefore, the attribute data must not be stored as tags or xrecords. Does anyone know how attribute data is stored within OpenBuildings application and how fme can read them? Ta

Hi there,I am assessing a dataset for changes that took place since 2012. This data contains these two fields of interest:change_date reason_for_changechange_date contains multiple dates that a separated by a comma and reason_for_change contains strings of change types separated by a comma.An example of the data structure is Feature 1:change_date: 2016-10-20reason_for_change: New Feature 2:change_date: 2009-06-15, 2013-09-04, 2016-10-05reason_for_change: New, Attributes, Modified Feature 3:change_date: 2010-09-11, 2014-04-09reason_for_change: New, Attributes Is it possible within FME to pair each individual reason for change to a change date and then test if it matches the follow conditions of reason_for_change = New or Modified and change date greater than 2012-12-31?Using the three examples above, feature 1 and 2 should be highlig

Hi everyone,I’m struggling with a limitation in the Excel Reader and I’m hoping someone has a reliable workaround for a fully dynamic workflow.I have an automated FME Flow workspace where multiple users upload Excel files through an FME Flow App. These files contain yearly planning data for different teams. The challenge is that users will sometimes rename existing columns and sometimes add completely new columns to the Excel sheet.Even when I configure the Excel Reader with Dynamic Schema by using Single merged feature type, FME does not refresh the schema at runtime. It only updates the schema if I manually right click the reader in the Navigator pane and click Update reader. Simply running the workspace does not trigger a schema rescan.I have tested using CSV instead of Excel but the schema still remains locked to whatever was detected when the reader was first added. As a result, any renamed columns