Data

I am updating an existing table with a feature writer.All data is well updated on all columns of my destination table. However, I have a lot of warning telling me that the column xxxxxx does not exist in table XXXXXXX.In the database, the columns exist, of course.Connecting to ORACLE database `GRISS-RAC-SCAN.smartwork.br.it:1521/ORCLSW_SVIL' with user name of `DAFIF' and password of `***'Connected to ORACLE database `GRISS-RAC-SCAN.smartwork.br.it:1521/ORCLSW_SVIL'Oracle Writer: Going to Oracle Workspace `LIVE'...Using existing column `GEOM' to store geometry in table `WPT'Oracle table 'WPT' already exists. Using existing tableColumn 'DISTANCE' does not exist in table 'WPT'Column 'NAV_CTRY' does not exist in table 'WPT'Column 'NAV_FLAG' does not exist in table 'WPT'Column 'NAV_IDENT' does not exist in table 'WPT'The same error is in different version of FME 2025.1 2026.2I’ve read that another user had had the same error, and he resolved creating different features.  

Hello everyone,I am dealing now with something weird in FME after importing a DGN file (see image below). Some text get really huge and some stay the same as in the original DGN file. I have no clue why this happens. I included a small portion of the dgn file as attachment to this post. In the DGNStyler I can change the size, however I would prefer the the text is already shown with the correct text size and I wouldn't like to determine the text sizes depended on the levelname 

I am trying to load Dimensions in the ArcGIS Pro Dimensioning Feature Class as described in https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/geodatabase/Feature_Representation.htm#Dimensions, but FME simply stops running without any error message. Target is File Geodatabase.Before investing time in resolving a problem, can someone please tell me if writing to a ArcGIS Pro Dimensioning Feature Class is supported by FME?I am using FME Workbench 2025.1 and ArcGIS Pro 3.5.6.

I have a excel file with photo link to Fulcrum (a different app). I have to create a template with photo link from my shared resources and id from the excel. I have created the FME process successful. But there are some extra photos that are not mapped to the ID which I need to delete. Which transformer shall i apply.Image above shows my FME process, I want to delete the 6 photos from unused supplier from my original folder. Which transformer shall i apply. and can it access my folder and Delete the photos.

Hello there,The coordinate system Irish National Grid TM65 (EPSG 29902 previously 29900) is not depreciated. It is also not the same CRS as TM75, there are mathematical differences which can effect the coordinate locations. They are both Irish National Grid. The southern Irish Ordnance Survey has moved to using Irish Traverse Mercator (EPSG 2157) but the Northern Ireland state mapping agency is still serving basemapping in TM65. There has been previous posts on this issue but the suggested fix has not worked. I followed the instructions in this post but I could not select EPSG 29902/29903.The only way we can get the translations to work in a workbench is by not setting the CRS on the Reader or the Writer. If we set try to set the CRS in the Reader or try to apply a projection using the ESRIReprojector it won't work.  

Is this a bug? I am trying to list and download several files (some have dependencies-- references-- and some don't) and noticed that I cant download files that have an associated reference file.Any thoughts or suggestions?Thanks

I would like to copy an existing file geodatabase and rename it to a different location.  I have been reading up on the FILECOPY but can’t make sense of what I’ve seen.  Any help is greatly appreciated. 

Hello everyone,I have an FME script that processes various data. Upon output, everything goes to a feature service. So far, so good; I have no problems during processing.My issue is very simple to solve, I think, but I can't find the solution.I'm working with agricultural data. For example, when using my script, I might request to use data labeled "18/19/11". Everything works fine, and everything displays perfectly.The problem arises when I only want to work with data labeled "18". The script works perfectly again, and the data is correct up to the last transformer before the writer. However, the data in the writer isn't replaced by the new dataset, and I still get the "18/19/11" data when I only want "11"!What type should I choose in "Feature operation" (insert/update/upsert/etc.) and in "feature type handling"?Do I need to integrate a transformerbefore the writer that will update the datar, or is this problem solved solely within the writer? I'm a bit lost and frustrated...Thank you

I notice that when writing GIS to CAD, in this case a KMZ to DGN using FME, that the output often tends to have mismatched units and the scaling is often much smaller in the output. I know that a seed file is ideal but I often find that this doesn’t always solve the problem in FME. Is there any way to make sure that the units are not mismatched when going from GIS to CAD?

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!

Hello, I’m updating a number of workspaces from FME 2021 to FME 2026, and some of them have a dynamic writer outputting to a file geodatabase. As part of the update, we had to change the format of the writers away from File Geodb Open API due to it becoming deprecated. We’re trying to use the OpenFile Geodb format, but we’re running into a problem regarding the geometry of the resulting features. Before, our dynamic writers would output features with 2D geometry such as Polygon. However, with the new format, it’s only outputting features with 3D geometry such as Polygon ZM. This doesn’t occur with our static writers, those output 2D geometry just fine, and it doesn’t occur if we use a different format such as File Geodb. It’s only with a dynamic writer with the OpenFile Geodb format that this issue occurs. I’ve tried adding a 2DForcer and MeasureRemover transformer to the workspace just before the writer, but the features are still being written as Polygon ZM. I can’t manually set the

Good day,I am reading several datasets of different files which I transform. After the transformation I want to insert the data into two different arcgis db. I have approx 200 000 records to insert. I would like to insert in batches of 10 000 then pause for 5-10min and then insert the next 10 000 records. I haven’t found yet an approach that is working. What could be working ?

Hi,I have classified LiDAR data containing low, medium, and high vegetation points, and I need to convert the vegetation point clouds into canopy polygons.What is the recommended FME workflow for this?I have tested the HullAccumulator transformer, and the results look reasonably good and follow the vegetation points quite well. However, I’m not sure whether this is the most appropriate or reliable method for producing canopy polygons, especially for canopy coverage calculations.Would a raster-based workflow be more suitable, or is HullAccumulator commonly used for this purpose? Thanks. 

Hi i have 3d buildings LOD 2.3 (roofs and stufff) stored as open data multipatch shapefile real 3d geometry.I think this “Feature type 'd_y_n_point' has unrecognized geometry type 'fme_no_map', defaulting to cesium_3d_object“And then in map “deck: initialization of ScenegraphLayer({id: '3d-buildings-tiles1-scenegraph-https://gis.pcr.cz/vector/tileset2/data/data298.b3dm'}): size: 1 Error: size: 1    at kA.makeVertexFormat (deck-gl.js:7:21331)    at kA.getVertexFormatFromAttribute (deck-gl.js:7:21889)    at O7 (deck-gl.js:4938:33481)    at K2 (deck-gl.js:4938:32798)    at uT.setGeometry (deck-gl.js:4938:55130)    at new uT (deck-gl.js:4938:52407)    at CD (deck-gl.js:7369:840)    at boe (deck-gl.js:7369:3191)    at deck-gl.js:7369:2753    at Array.map (<anonymous>)onError @ deck-gl.js:4996raiseError @ deck-gl.js:5076_handleError @ deck-gl.js:4996_initializeLayer @ deck-gl.js:4996_updateSublayersRecursively @ deck-gl.js:4996_updateSublayersRecursively @ deck-gl.js:4996_updateLayers

I’m able to update metadata elements in multiple feature classes within esri file geodatabases using the very helpful article at Working with Geodatabase Metadata: Writing/Updating Metadata – FME Support Center. This gets me most of the way to where I need to be.After reading through the article and numerous posts on the Community, I’m stuck on how to use this or another workflow to update the metadata for the file geodatabase itself. There is metadata associated with each feature class, but there is also geodatabase-level metadata.The FeatureReader using the Metadata Feature Read Mode was new to me - very useful, along with the XMLUpdater and the methods outlined in the article. But it seems to only work for the contents of a geodatabase. Any thoughts on how to work with the metadata on the container, as well?Thanks in advance.

I want to convert shape files to DGN map squares(tiles). For the output I use FANOUT. As input I use a csv file with coordinates of map squares to determine the naming and boundaries of the DGNs. I also want to use the same naming convention for the multiple input seedfiles. I have added SEEDFILE as an attribute in the workflow. I get an error message that: DESIGN WRITER: Failed to copy seed file ‘@Value(SEEDFILE)’.dgn to the destination data file @Value(FILENAME).dgn…. Either the path to destination does not exist or the file is in use by other programs. IT looks that ii is not recognized in Parameter Seed File…PS:@Value(FILENAME).dgn I use for the FANOUT is recognised but not when I use it for the seed-file such as seed_@Value(FILENAME).dgnEXAMPLE:seed_100200.dgn → 100200.dgnseed_100200.dgn → 100201.dgn 

HiI recently upgraded FME Form from 2025.0 to 2026.1.1 and my workspace for processing IFC files no longer seems to work. So far, I have noticed these issues:FME 2026 does not detect the same attributes, such as BIP.IfcGUID.NominalValue I removed the reader and added it again and FME now seems to replace BIP.IfcGUID.NominalValue with BIP.IfcGUID. The “Door” subset now seems to cointain thousands of attributes, which was not the case in FME 2025. This makes FME very slow to work with. Saving the workspace now takes several minutes and the .fmw file has grown from around 0,9 MB to 21 MB. Opening the workspace takes several minutes as well. Has anyone else noticed these issues?

Hi all,I have a table in Redshift that is JDBC (not the spatial version of Redshift); it has a column that is in WKB.  I need to extract this and create points in Lat Long.  I’ve tried the geometry extractor but getting nowhere fast.  Have also tried sql executer to use the ST_geometry to get the coords, nowhere again.  When I tried to use the Redshift connections, the username/pwd and related connection data did not connect.  It is only with JDBC that I can create the connection.Anyone had any experience with this?Thanks,Lorinda

Hi allI want to define the Geometry Type in PostGIS-Writer. I recently changed from an old version of FME to version 2025.2 In the user dialog of the writer there ist still a field for the definition (feature type/user attributes/spatial definition/geometry type, but the field is de-activated (grayed out).Is there a way to “manually” define the geometry type for postgis tables?  Thank you for any help.

Linked to this query, that i believe is now closed, it would be great to be able to export GOCAD TS files.

Hi all,I’m working with FME 2025.1 on a LandXML export-import workflow and encountering an issue: LandXML Reader and Writer do not have a Version 1.2 option. My goal is to export a corridor alignment, but the vertical alignment (profile) data is not coming through correctly. Without 1.2 support, how can I tolerate or work around these missing elements in FME? Specifically, I’m wondering: Is there a way to properly bring vertical alignment data from a LandXML 1.2 file into FME? Are there alternative formats or preprocessing steps to compensate for missing data? How can I avoid data loss on the Writer side, since 1.2 is not supported for export? Thanks in advance for any guidance!

Hello,I have a workbench that converts GIS data to an AutoCAD Map 3D object data file. In this workbench, I’m creating new layers that don’t exist in the template file being used, and would like to set their default lineweight of these new layers to “Default” or “ByLayer”. I am able to successfully define an “autocad_lineweight” attribute in the workbench and set it equal to -3 or -1 and the GIS line features that are translated receive the correct lineweight value.However, the layers themselves do not. The layer default lineweight appears to be controlled by the “Default Lineweight” parameter in the writer feature type. Unfortunately, there doesn’t appear to an option to select -3 or -1. Additionally, attempting to set that parameter to the previously defined attribute leads to a failure w/the following messages (xyz is the path & file name of the output):AutoCAD Writer: An error occurred for dataset ‘xyz’ in function RealDWGWriter::checkToCreateDynamicObjectDataTable. Unknown exc

Hello ,I would like to create a complete review list of all FME workspaces and processes in our environment.The first requirement is to generate a list of all FME names available in FME Server, including: Which users have access to export them Whether they are automated If automated, on which day and at what time they run  Where is the FME output stored? If they are manually exported, which users have permission or access to perform the export The second requirement is to create a list of all FME workspaces built and stored on local Windows environments.I would also like to export all names and related information into Excel files.What would be the best solution or approach to manage both requirements and create a complete review list of all active and working FME .Thanks in advance 

With the now depreciated IFC with Data Views, I was able to extract colour properties using an Appearance Extractor which I could then write to the resulting multipatch. Having looked at the IFC_API reader, it doesn’t seem to have any of the colour properties and all fail in the Appearance Extractor. Can anyone advise on how to access the colour using this reader? 

Hello FME-Communtiy,With the advent of the new IFC-Writer we wanted to update and hopefully slim down our FME Workspace, which reads Multipatch Geometries via an Esri Geodatabase (File Geodb) Reader and writes IFC-Features via an IFC XML/STEP (deprecated) writer. Sadly we’ve not managed to get the new writer working as needed and have found the documentation rather lackluster, which is why I’d appreciate any pointers from the knowledgeable people on here.The new workspace has managed to correctly export the feature geometries, but the attributes seem to be missing/not written at all. Inside the new Workspace the features have the correct attributes and values up until the very end where they are sent to the IFC-writer (In this Case I tried Slab as the Element Type, BuildingElementProxy gave the same results and SpatialZone doesn’t work at all anymore).New Workspace final export inside Data Inspector (red color intentional)Old Workspace final export inside Data InspectorIn the old Works