Data

Hi, I am new to read the CAD files in FME. May I please get an example of a CAD file and how to read in FME - basic steps to follow  

Hi,Regarding FME 2026.3.I have a WFS reader that retrieves geometric data. When I attempt to save this to Oracle, the geometry is not being saved, although the attribute (non-geometric) data is.In the writer, if I set the schema definition to "Manual" under the "User Attributes" tab, the name of the geometry field is highlighted in red—indicating that it is not being recognized. It appears that the Oracle writer fails to recognize the geometry (the same applies to the Oracle Feature Writer). With the GeometryNameSetter the goemetry is found but the geoemtry type is not found.If I save the data as a Shapefile or a GeoPackage, the geometry is recognized correctly.if I perform the exact same process in FME 2025.2, the Oracle writer successfully writes the geometry. It seems that the Oracle writer has been modified in version 2026.3. (or some 2026.x version before) and does not recognize wfs geometry.How can I ensure that the Oracle writer recognizes the geometry?

If I understand correctly, since the latest update, FME can include multiple geometry columns from an Oracle table in the workflow without much hassle.Previously, it was necessary to manually set "Handle Multiple Spatial Columns" to Yes in the reader settings (if I remember correctly). Now, it seems that this option is set to Yes by default for readers, as my version of FME now loads all geometry columns without me having to configure anything. I also can't seem to find the option to enable or disable this anymore.This is actually quite useful, but in my case, all geometry columns under User Attributes → Geometry Definition are greyed out, so I have no way to specify that I don't want to include all geometry columns.When I try to specify which geometry column I want to use under Parameters → Spatial Column, I get the following error:|ERROR |Error running translation: ORACLE Reader: 'Spatial Column' and 'Handle Multiple Spatial Columns' cannot be specified togetherAm I just missing some

Hi,I was hoping to use the new IFC writer available in FME 2026.1 to update the IfcPresentationLayer attribute values from IFC to IFC.The idea was to disregard the current layers exported from Revit from others and define our own layer presentation for the models so we can turn certain layers on and off in our platform (Trimble Connect). I used the reader to load the IFC file (in 2x3 format), and it successfully retrieved all layer attributes into FME. However, I don’t seem to be able to write the updated layers.In fact, even without adding any transformers—just using the reader and writer from IFC to IFC—the layers are lost. So I’m wondering if anyone has had success using the latest FME reader and writer for rewrite the layersThanks!

Microsoft Azure SQL Database (JDBC MSSQL) User Attributes has a varchar(max)Microsoft Azure Synapse SQL (Data Warehouse) does not!I need to write WKT and GeoJson to my Fabric data warehouse and I think I need to use the Microsoft Azure Synapse SQL (Data Warehouse) writer to do that.  Data type varchar(8000) may not be sufficiently long for a line or a polygon for WKT or GeoJson.Is there something I am missing?  Is a varchar(max) on the roadmap for Microsoft Azure Synapse SQL (Data Warehouse)?I am using Form 2026.2.

Hi,We have installed FME 2026.3 on both Desktop and Flow. However, it looks like there is a bug in FME 2026.3. No matter what I do in a workbench, I get the same error message. If I open a blank workspace and drop in a random file, I already get the following error message during the initial file read:Error running translation: Unknown FME Geometry 'fme_voxel_grid' specified. A fatal error occurred during translation. FME Daemon is shutting downWorkspace generation failed.

Hello ! I try to write into my feature service. I got an error wich say “The error code from the server was '1016' and the message was: 'Setting of value for SIREN failed.'”I try to write into my feature service but I got this error. The attribute type into “User Attribute” is the same as into the feature service.When i run the writer, the script “failed” but I got some result into the feature service. At the beginning I was thinking that was my SIREN attribute wich broke everything. The error “1016” is not an usual error (for me) and I dpon’t find any advice about this error.In the attribute manager just before my writer, everything is allright (except OBJECTID) but at the end I got this error =>Every help will be gratefull ! Thanks a lot !

Hello,I am currently working with OpenCities Map 2025 and processing geometry as well as attribute information in FME. The Documentation of the Bentley Map XFM Design (V8) Reader states that XFM data exists and that the newer version uses XAttributes associated with Bentley Select Series 3 and newer design files. It also states that “the DGN V8 Writer currently only writes XFM data in the Select Series 1 form”.My experience so far is that I can write a DGN file and and OpenCities Map can show without problems the geometry, but the attribute information gets distorted. What I mean by that: in native DGN files the properties display that an element is indeed a native feature, but the in FME created DGN file shows the elements are inferred features containing associated elements. Further in the FME created DGN file it’s possible to create a Map Model but when using the Browse Tool it displays the exception window: Object reference not set to an instance of an object.This lead to inspectin

I have a HTTP caller that brings back over 9000 records but the json fragmenter only seems to handle 1000 records.

I have a workspace using a ChangeDetector to maintain data in a SharePoint Online list, using a Microsoft SharePoint Server List writer (we are blocked from using the Graph API, so the Microsoft SharePoint Online List reader/writer are not options for us).When a value has been written to a field in the list but is later removed in the source/revised data, the ChangeDetector recognizes this and sends either a null or blank/empty value to the writer, without error. But, the null/empty/blank value is not actually written or accepted, and the stale value persists.I’ve found that if I use a NullAttributeMapper and map Empty, Missing, and Null values to a New Value and set that to a single space character, that SharePoint actually writes the null/blank value over the existing value. For anyone trying to do the same, this might be an important point.The issue that I’ve run into is that Date/DateTime-type fields will not accept a space as input. I’ve tried writing in 00000000 and it is also re

Hi FME Folks,I’m working with a georeferenced PDF that contains several annotations/marked-up text. I also have an existing point shapefile/point feature class.My requirement is to:Read the georeferenced PDF in FME. Extract the annotation text. Get the location/coordinates of each annotation. Transfer the extracted annotation text to the corresponding point feature in the shapefile. Write the annotation text into an attribute field of the point feature class.Has anyone implemented a similar workflow in FME?I would appreciate any suggestions on the appropriate FME reader/transformers or the best approach to extract both the annotation text and its spatial location from a georeferenced PDF.Thanks in advance for your suggestions!Anand 

I have created a very simple workspace with a creator which creates a line and writes it to a GeoPackage using a FeatureWriter.The line is 2D, no measures, but the geometry type in the resulting GeoPackage is reported by ogrinfo as “3D Measured Multi Curve”.I would expect the result to be a 2D LineString instead - or maybe just LineString. As seen in the image I have exported the geometry to WKT and it indeed reports it as “LINESTRING (400000 6040000,900000 6400000)”.Is this the expected behaviour and is the FeatureWriter geometry type detection headed towards the broadest category for data instead of a more narrow approach?The test has been done using FME Form 2026.2 (26333) on Windows.

as I consider using fme to convert filegdb to geojson, facing problem in attribute length = 65536 for string, those attributes will truncate in geojson. how to fix it.Thank you very much

Dear allCould anyone of you and your experience give me some clues, ideas how recover XML-Driven XML that suddenly gone missing from reader/writer format?grateful/egm

Dear FME colleagues, I am working on a workbench that needs to read an Excel file and keep (write out) only those attributes listed in a second Excel file. The workbench must be fully dynamic; this means that after publication and scheduling on FME Flow, the user only needs to maintain the second Excel file to generate the correct output. To do this, the user simply needs to indicate in that Excel file which attributes should be kept and which should be removed. I haven't quite managed to configure this yet!Can anyone point me in the right direction? I’ve tried using the SchemaMapper and AttributeManager, as suggested in other articles, but I haven't quite succeeded.Below are screenshots of both Excel files: the first shows a portion of the data (128 attributes in total), and the second image is an example of the attributes that need to be kept or removed.  

When we’re using FME Flow as our Connection Store. We’ve been noticing that some parameters of webservices start to disappear or change. Examples: Redirect URLs go blank, configuration of headers change, etc. We’ve been seeing this phenomenon in our AGOL web services and SharePoint List web services. Has anyone else seen this type of behavior?Here is our setup:FME Form/Flow: 2025.1.2 (Build 25630) FME Flow is a distributed deployment (1 core + 5 engine machines) Accessing FME Form (and the Connection Store) via Citrix/Azure Virtual DesktopTo resolve the issue: We either have to fill the in blanks/fix the issues or drop the web connection and web service completely and start from scratch.We’re just trying to understand what might be causing this.Thanks in advance!(I am sure this isn’t the correct Category, but nothing else fit as an option here.)

I’m using FMW Reader to read and analyze FME workspaces, and I have a question about custom transformers.There is an attribute called Custom Parent Name. When this field exists, it shows me the connection to the custom transformer inside it. However, how can I determine whether that specific custom transformer is enabled or disabled in the main FME workspace?For example, suppose an FME workspace contains multiple instances of the same custom transformer, such as: LineDivider LineDivider_2 LineDivider_3 The Custom Parent Name attribute may contain only LineDivider, without the _2 or _3 suffix.In this case, how can I distinguish which specific instance of the custom transformer the connection belongs to?More specifically, how can I reliably identify: The exact instance of the custom transformer in the main workspace. Whether that specific instance is enabled or disabled. The relationship between the transformer instance and its Custom Parent Name, especially when multiple instanc

I'd like to read a DGN file, which contains a terrain model. In version 2025.1.2 it is being read as igds_polygon_collection. The fme_Geometry is “fme_undifined” and the fme_type is “fme_no_geom”.When using a Civil 3D file, it can read a surface model, which is the same principle as the terrain model in a DGN. The terrain model is created in OpenRoads.Or is another option available to read the terrain model directly from a DGN file without converting it to another fileformat or element type?  

Learn From My Mistake:We have a line of business system that is difficult to “pull” data from. I did, however, discover that it has the ability to generate and email data extracts on a schedule. Combine this with the ability to email files to our FME Flow Server, and the job became doable. The only minor hang-up was that the system could only generate these extracts in XLSX format. “No problem,” a more naive me thought, “I can use an Excel reader to pull this tabular data out easily!”The process worked great for our smaller datasets (< 10k rows) and ran most jobs in less than a minute, so I began exporting more data this way. Fast forward a little bit, and I discover that some of my newest extracts are taking up to 4 HOURS to process. Slightly panicked, I disable the extracts and dig-in. Looking at the logs, the workspace first seems to be lagging on a PythonCaller I was using to massage the data after extraction, so I re-tool it into using vanilla transformers. Test locally - works

Hi :)I’m trying to add the vector map from basemap.de as my background map for exports in FME 2026.2. However, I cannot make it work. I used the following link and MVT as my feature reader.I get an error regarding a missing API key. Has anyone ever used basemap.de as their background map and can tell me if there’s a simpler way to add it (and also be able to crop the data to my AOI before reading all of it, which covers the entire country), or if I need to somehow request an API code to use this map?Here’s the link (which I am also not sure if it’s the correct one):https://sgx.geodatenzentrum.de/gdz_basemapde_vektor/tiles/v2/bm_web_de_3857/bm_web_de_3857.jsonThanks!

Hi community.The managed web services are fantastic, especially for sharing connections and data sources through FME Flow.I have a question about how we can recreate a URL call from a token service from an Oauth enabled end point.The web connection I have works as intended in Form and occasionally falls over in Flow (maybe 1 in 10) and I am attempting to troubleshoot.To do so I am trying to connect to the web service endpoint by building the URL that the token service creates through the Web services in FME.Does anyone have a template that can show me where each of the fields are built into a URL call so I can substitute in the values I have in the request URL, request Data, Token Object Key and Header fields?I am assuming I’ll have to strip out some fields that aren’t needed and maybe use some additional fields that form populates automatically but I just need somewhere to start from.This is how I have it set-up but not all of the details are in the request data field.Thank you.Michae

Hi, I read gdb data, simply changed the data attribute type, and when outputting the gdb data, I selected Dynamic Schema Definition, Schema Sources* chose "Schema From Schema Feature", cleared the attributes, why is the output gdb empty?  

We’ve been working through Data Reviewer errors while transitioning our water data to the Utility Network, and FME has been really useful for tackling some of the issues in bulk.I’ve used transformers like the GeometryValidator and SpatialRelator to identify/fix geometry issues and relationships between features, but I’m curious what others have found useful. The ones I’ve used have only helped to an extent and sometimes actually don’t end up getting rid of the errors when I run data reviewer reports in Arc Pro.For anyone who has gone through a UN migration, what FME transformers or workflows helped you clean up Data Reviewer errors before moving into production? Any unexpected transformers that ended up being especially useful?

Today I placed a default value for a date User Parameter as@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-14,'day'),'%Y%m%d')essentially the date widget in FME flow would go back 2 weeks, this used to work fine…. But alas, in 2026 it is now returning something wild Where is this highlight in Change logs? I read something about ‘better support for SQL date’… but nothing about Date\Time functionsAm I supposed to use this now ?a new datatime function?Here is the help documentation https://docs.safe.com/fme/2026.1/html/FME-Form-Documentation/FME-Form/!Transformer_Parameters/Date-Time-Functions.htmWhen we upgrade transformers, will the @DateTimeNow() functions get transformed into @CurrentDateTime ?Also the @DateTImeAdd is this going to be converted to @AddDateTime I can see the syntax @AddDateTime(<datetime>,<interval>)https://en.wikipedia.org/wiki/ISO_8601#Durations So this @DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-14,'day'),'%Y%m%d')has become@DateTimeFormat(@AddDateTime(@Cu

Hi brains trust!Does anyone know how to determine how 2 x polygon geometry might change being passed into Change Detector original vs revised. I’ve set Check Geometry with the parameters to be lenient and using 1.5m tolerance for exampleI know how to explain the change list, exploding and keeping these attributegeometryObject has changed, but how muchI had considered extracting the geometry of orig and revised to an attribute, then passing it into AreaOnAreaOverlayer? GeometryExtractor / Clipper arrangement Calculating the area to attribute and comparing differences in attribute values I’m trying to see if Geometry Concepts traits can be used here?Any thoughts?