Using readers and writers to extract and load data.
Recently active
I'm seeing the following lines in the Translation Log:AutoCAD Reader: Entity type of 'AeccDbAlignmentStationLabeling' found, but not supported. Skipping entityAutoCAD Reader: Entity type of 'AeccDbAlignmentMinorStationLabeling' found, but not supported. Skipping entityI'm reading a .DWG in as an AutoCAD Civil 3D format file. Am I interpreting this correctly that station labels are not supported by FME?
I am writing AutoCAD DWG with changing areas/extents. My template file defines the styling. When opening the file in CAD it zooms to a blank area (possibly from the extents of the template file) and I need to zoom to extents to find my current area. Is it possible to either remove any extent information from the template file, or force the output DWG file to zoom in on the current area extents?
I am using FME to write to microstation DGN. The FME workbench file is using the fanout option to write different areas to the microstation DGN file, based on the same seed file. At the moment I have to use a microstation macro to "fitview" of each produced file in order to have the microstation file centered at each specific area. I rather use only FME to avoid this additonal step.Is there a way / transformer in FME to save the microstation file centered in the written data?
Has anyone successfully connected to Snowflake using OAuth? We have been using a local account to connect to Snowflake but have recently been requested to use an Azure based OAuth connection. We have an assigned client ID, key and refresh url available but need to understand how to make the calls. Thanks!
Has anyone been able to mine Oracle redo logs using logminer? I’m beginner to Oracle but it seems to me that it should be possible. I’m trying to create cdc process from Oracle to postgres and I’m able to query insert and update operations sufficiently enough from date fields that tell me when rows are updated or inserted. However, I can’t catch delete operations that way and it would be beneficial to be able to read the redo logs for the actual operations. I know I can query and compare id’s from source and target to detect deleted rows. However, this is time consuming because that would mean querying hundreds of millions of rows for the workflow.If I understood correctly, I need to setup DBMS_LOGMNR package and session for the logminer to be able to query V$LOGMNR_CONTENTS that would hold the transaction information. I guess DBMS_LOGMNR is part of Oracle database? Would that mean that I need Oracle database installed with license to be able to use logminer? The source Oracle database
Has anyone already added the following coordinate systems to FME:For Bonaire: EPSG:10759 (2D) or EPSG:10764 (3D)For Saba: EPSG:10641 (2D) or EPSG:10645 (3D)For St. Eustatius: EPSG:10745 (2D) or EPSG:10747 (3D)
Hi,I’m currently struggling to figure out how to convert a LOD2 3D-Multipatch from a FileGDB into CityGML. I do currently not have a program available to open or edit CityGML files, but it might be important at a later stage to be able to convert the data back into CityGML. Is it generally possible to convert any multipatch into a CityGML file at a later stage, or is important information lost in the process?How do I ensure that a distinction is made between Wall, Roof, Ground, and Closure Surface? Or is it all simply classified as Building?I've already looked at the website Writing CityGML from FME, but unfortunately, I still don't know how to proceed. How do I know which ‘citygml_lod_name’ value to use? If multiple values yield a result, should I use all of them parallel?I would be grateful for any tips to help me understand this better…Thank you! My first attempt of a workbench...
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?
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.