FME Form

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!

I have a single dataset containing a set of polygons. Some of these polygons are touching each other. I would like to dissolve polygons which are touching (of orverlapping) into one large polygon. However, I would also like the new large polygon to take over the attributes from a specific feature. The feature from which the attributes are to be taken has a specific name in one of the attributes. Let's call this attribute “NAME". Hence, I sorted the features based on “NAME” before feeding to the Dissolver. However, it seems the Dissolver does not choose my first sorted feature to take the attributes from, but it seems to choose the feature (polygon) with the largest surface area. There does not seem to be a setting in the Dissolver which allows me to choose how the attributes are handled and how it chooses from which feature to take the attritubes. How do I dissolve my polygons, taking the attributes from the polygon where “NAME” has the value lowest in the alphabet? I don't know on bef

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 everyone,I'm seeing some unexpected behaviour when writing repaired geometries to a GeoPackage.My workflow is:GeometryValidator (Attempt Repair = Yes)       → GeoPackage Writer       → GeoPackage Reader       → GeometryValidatorBefore writing:Input: 32,572 Passed: 10,720 Repaired: 21,852 Failed: 0After reading the GeoPackage back:Input: 32,572 Passed: 31,789 Failed: 783 (Invalid Parts)I also noticed another behaviour:When Spatial Standard Compliance is included in the first GeometryValidator, the written GeoPackage appears to preserve more polygon coverage. When I disable Spatial Standard Compliance, all features still pass after repair, but after writing and reading the GeoPackage back, more features fail validation.Has anyone experienced this before?Is this expected behaviour of GeometryValidator/GeoPackage, or should the repaired geometries remain valid after being written and read back?Before writingAfter writing 

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... 

My org recently upgraded Flow and Form from 2025.1 to 2026.1  We have heaps of translations that involve both Enterprise Portal and ArcGIS online.  The web connections and services had all been upgraded to use the newer version of the ArcGIS Connector package (the safe.esri-agol versions). I’ve re-used all the safe.esri-agol web services built in Form 2025 in 2026. Everything authenticates and grabs a token as it should in testing the connections.Actually using the ArcGIS OnlineConnector is a different story. It works great in 2025 still, and reads everything available to the account: In 2026 however: 2026 version is trying to use a proxy to connect and eventually just times out without reading anything.Is anyone else seeing this behavior, and if so how to correct it?  The Proxy settings in both versions of Form are both the same (use system settings).Thanks!Chad

Hello everyone,The funny thing is, I am trying to read .docx files which apparently I have never done until now in FME Form I am trying to convert several .docx files to html pages.I tried reading the help page of the Word reader, but unfortunately I don't get much wiser. It says to use the Word reader in conjunction with the transformer MSWordStyler. I looked into the MSWordStyler, but I also don't get much wiser. When I just connect a word reader with a html writer, I don't get any output (which I kind of expected). However, I really have no clue how to get from .docx → htmlIf I import all docx files in FME form, I kind of get a mess of all word pages meshed together in the Data Inspector 

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, In FME Form, I am trying to generate a line from 3 parameters: lon/lat (WGS 84) length geographic orientation (from geographic north, in degrees)I have tried several ways to build this line (2DDirectionExtender, VertexCreator + Offsetter (tested polar coordinates or spherical coordinates), VertexCreator + Rotator)Always the same result, when I measure the angle from geographic north, there is a difference for instance, with my input:lon/lat : -4.49027778, 48.02000000 length : 0.002 orientation : 100.478°In both methods, FME gives me this result:When I calculate the bearing from start point to generated end point, it gives me the same result 105.411° (same with online bearing calculators using coords)Any idea on what could be wrong? Thank you

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 have a bathymetric shapefile that I’ve adapted for eventual 3D printing. Part of my challenge is the sparsity of contour lines, which creates substantial space between contours. I previously tried GRASS/QGIS/SAGA/etc with limited success. Now I’m trying FME. FME processing is much easier, but the issue I’m trying to solve now is roughness at contour edges. This is the workflow I’m using:It produces a reasonable DEM output that I’m processing through QGIS with DEMto3D:Banding from contours:A closer look at the .stl shows hard contour line edges instead of smoother transitions:I’ve read some about using PointCloudCombiner and NumericRasterizer, but don’t know if that will address this situation. I also tried a workflow with NumericRasterizer, but the results were similar. In the past I’ve tried gaussian filters, or other smoothing techniques, but that really disrupts the shorelines. Feedback is appreciated.  

I have a fairly complex shapefile/contour source that I’m converting to a DEM raster. It involves a lake bathy that has large islands. This process is complicated by the lack of good smoothing for widely separated contours and also islands within the lake.With the lake bathy I’ve created very smoothed rasters, but for the land I need to have a sharp edge to represent the shoreline. I have 2 separate raster generators for this. I clip the rasters to isolate lakebed, land around the lake and land on islands.The last complexity is inputing 2 rasters into a RasterMosaicker (both have alpha channels) and have the island rasters bands 0,1,2 set to RGBs of 255:255:255 while retaining the alpha channels for overlaying.I tried setting the RBG bands for the islands to 255:255:255 prior to the RasterMosaicker, (since islands are lost after the RM), but after removing the alpha channel with a RasterInterpretationCoercer the island RGBs are reset to either 0:0:0 or arbitrary values (such as 113:113

Hi Brains TrustI’m trying to setup a web connection to Oracle Integration Cloud and have been given the client ID, secret, token url and scope url.In testing the connection I keep getting this message but tje Integration Engineer is telling me there is no need to sign-in, and also no browser window is popping up for a sign-in.  Other posts had suggestions such as:Change to System default instead of FME default Change to proxy redirect instead of loopback.I’ve tried those things and still nothing. Any tips on how can I troubleshoot this to get it to work? Previously we used a basic username & password to connect but there’s a push from IT to move to OAuth. Thanks

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.

Hi There, I am trying to consume and Arcgis date field in Form but FME can seem to understand the datatype.  Specifically, the Date Converter transformation just errors out (please see attached).  I have tried every option from the drop down menu and have even tried using a String Convertor transformer and the Attribute Creator to (successfully) convert the field to a Datetime field in FME but the Date Converter can not read and I need to use this datatype for downstream use (I want to compare how new records have been added to the dataset by comparing this date field to the current time).  Any help would be super appreciated.  Thanks!  Louie

HelloWe have a workspace that connects to Sharepoint using a WebConnection.It works in FME Form and on one of our two FME Flow instances, which is installed on a second server.However, it does not work on the other FME Flow instance, which is installed on a third server.The error message is as follows:Access token not found for connection ‘aaa@Sharepoint_bbb’Unable to obtain updated authorization for web connection ‘aaa@Sharepoint_bbb’; credentials may be invalidObviously, there’s something wrong with the access credentials, but why does it only fail on one of the FME Flow instances?The web connection was set up by someone who no longer works for us. Where can I get the access token for the connection?Thanks in advanceVera

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.

I've found not documentation around any name formatting limitations for Attributes for the Hyper file Writer. When I work in Tableau Prep, I have no issues writing a file with a field name like "Budget$" to a hyper file. I've found in FME that when writing to an Excel file, it also takes such a name, but when using the Hyper writer, it drops the "$" and replaces it with underscore "_". Why is it doing this? Is this a mistake in creating the code for the Writer or is it a Necessity and if it is a necessity, shouldn't this be documented?

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’d like to maintain my database documentation in an Excel spreadsheet like this:Attribute Name FME Data Type LandID int32 Acres real32 Name varchar(128)  And then I’d like to import that into an AttributeCreator. When I try importing, the attribute names come through, but FME Form sets all the data types to varchar(200) instead of what I specified in the field ‘FME Data Type’ and imported in the import dialog.How can I fix this or set up my spreadsheet differently?

Hello All,There may be a bug (or least a less user-friendly transformer) in Form 2026.1.2Choosing specifically the Esri ArcGIS Feature Service as the Format, the Dataset parameter is by default disabled: I’m unable to determine what the “related parameter” is that is *disabled.I can setup my feature types by importing the schema of my intended target data, but saving all the changes in the transformer puts it in an error state.If you visit the navigator window you can see where the “Dataset” parameter is in error.The only way I’ve found so far to get around this issue is to go into the Manage User Parameters setting and create a new user parameter for Dataset which needs to be the feature id of the online feature, inclusive of the parentheses around the id number.  This is definitely adding more configuration steps to the Feature Writer than before as the Dataset used to be configurable directly inside the transformer and you didn’t have to remember to copy the feature id from Esri.Any

Hello, I have a question regarding the DGN Reader/Writer about reading and writing external reference files.I am using the DGN Reader that contains a reference to another DGN file. In that referenced file there is a rectangle (an igds_shape element). In the DGN Reader parameters I enable the options "Read Elements From Reference Files" and "Keep Elements That Represent Reference Files".My goal is to move that rectangle to a different location and save it into a DGN file in such a way that:the rectangle appears at the new (correct) position - this part is not a problem; I already have a workbench for moving the geometry but it still keeps the link to the original referenced DGN file, and the referenced DGN file itself remains unchanged.In other words, I want to move the geometry in the main DGN while keeping the external reference link attached to it, so that any future changes in the referenced file (e.g., adding an image inside that rectangle) automatically appear in the main DGN at t

I encountered an error when writing data to a geodatabase because the file path contains a dot (period), even though this naming convention is completely valid. Everything worked fine in previous versions, but it fails in FME 2026.1. For example, I want to write to a Geodatabase named 'Geo.A1.2552.gdb'.Is this a known bug?