FME Form

Hi all,The data in my geodatabase file has an attached layer for each data layerI want to perform some transformer in FME and got the error:“An error occurred while attempting to open an insert cursor on the table 'XXX'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [DMA]}GEODATABASE_FILE writer: An error has occurred. Check the logfile above for details”I found the solution is to change the setting in Transactions Type to Edit SessionBut after setting, some layers can perform the conversion but some layers get the error:“An error occurred while attempting to stop an edit operation. The error number from ArcObjects is: '-2147220975'. The error message from ArcObjects is: {File read/write error occurred. [XXXXXX]}GEODATABASE_FILE writer: An error has occurred. Check the logfile above for details”Can anyone please advise me what I need to do now to fix these errors

Hi all,I’m having issues trying to generate links within a kml file to a photos in the same folder.First I generate the Hyperlink:<a href="@Value(fme_basename).jpg">@Value(fme_basename)</a> Then I use the KMLPropertySetter The link comes into Google Earth: But the link doesn’t work:\\img_2416.jpgNot sure why there are two extra slashes!  Weirdly if I copy and paste the link into outlook or even this post, the link works, but it doesn’t work when you click on it in Google Earth.  Please can someone help me with the syntax?  Thanks. p.s. I’m after a relative link so I can zip up the folder and send it on  

 Hi there,This is a follow up question to one I asked last year around the FTPCaller transformer:Our security team granted a 12 month exemption to our FME workspace and have asked for an update on the issue.Is there any change in the ability of the FTPCaller transformer to be able to view or configuring the cryptographic algorithms used? Thank you,Jonathan

Hi,I’am using FME Workbench 2022 with ArcGIS desktop 10.8.1 and ArcGIS Pro 3 on the same machine. When I try to load a feature class only compatible with ArcGIS Pro (containing arcade expression), FME continues to use ArcGIS Desktop 10.8.1 librairies despite the transation / Esri ArcGIS Compatibility set  to Auto or ArcGIS Pro. 

Please be careful when using web connections:I think for most users this is probably a given, however, I’ve just seen something used practice which I thought was a little risky.When using web connections in FME, FME is not checking the hostname when making the request to an end point. This is true at least for some types of FME Server web connections but I assume it’s also true for others. If you have defined a service which uses a web connection you should only use that web connection when you actually need it. For example if you are dynamically requesting a list of URLs and only one of them requires authentication do not use the web connection for every request - especially if it’s to a different host. You will be sending the token or (in the case of basic HTTP Authentication) the username and password to those other servers. If you are not even checking the list of URLs then of course you could be making requests and sending out your credentials to who knows where.  

HiI have recently upgraded the OS of the machine FME Form runs on to Win Server 2022 and upgraded to FME 2025.1.1Since this, I have been unable to connect to amazon s3 and get the following message:S3Connector: The specified AWS connection does not have permission to perform the requested action (Key: '', Bucket: ''). Please check the connection parameters and the relevant AWS security settingsDoes anyone know what the issue may be? Thanks

I have a workbench that converts CAD drawings to GIS, writing to both a FGDB and SDE. SDE was recently upgraded to 11.4. This workbench has run just fine for the past 8-9 years, with enterprise and FME updates and upgrades happening over the years. Recently however, it continues to fail if I run it on all DWGs I need. Either to the FGDB or SDE, or isolated to either one. It processes all the drawings, and then I get this error at the end.An error occurred while attempting to stop an edit operation. The error number from ArcObjects is: '-2147215975'. The error message from ArcObjects is: {The number of points is less than required for feature}Trouble is, I can run it on the drawings in chunks. So I ran it on the drawings modified in the last 6 months. Ran and wrote just fine. I ran it on the drawings modified 6 months prior to that, ran and wrote just fine. Going back until I ran it eventually on all the drawings. It fails on all drawings whether I choose the DWGs individually or use a

In my FME Form, I am trying to view my output against the default Stadia background maps. It says the servers may be unavailable. Does anyone else have this problem?   

Hi I am using the schema scanner to extract the schema of data in both the original and revised datasets by comparing with a change detector.  This is working fine and i can get everything into a single table from the insert output, however i want to be able to show delete and updated as separate tables within the email.Any ideas of the best way to do this?  

How can I automatically add all attributes in AttributeExposer after AttributeTransposer without having to manually select each one?

Can it be possible that key descriptive words be extracted from a document to process vast quantities of data using FME with the help of ChatGPT 5.0?For example: 3000 parcels with information from Costar (real Estate database) extracted for 10000 sq ft with property owners who are on the market to sell their land/properties.A query posed like that using ChatGPT 5.0 and n FME processing tool. Can that be done?

I recently upgraded to version 2025.1.0.1 and am seeing an odd error with the H3HexagonalIndexer, as follows:H3HexagonalIndexer (H3IndexerFactory): The clause 'GEOMETRY_HANDLING_Filling_Indexes Replace' within 'FACTORY_DEF {*} H3IndexerFactory FACTORY_NAME { H3HexagonalIndexer } INPUT FEATURE_TYPE Creator_CREATED INDEX_OPERATION { Index } DST_ATTR { _h3index } GEOMETRY_HANDLING { Replace } H3_RESOLUTION { 15 } GEOMETRY_HANDLING_Filling_Indexes { Replace } DST_ATTR_Index { _h3index } OUTPUT { OUTPUT FEATURE_TYPE H3HexagonalIndexer_OUTPUT } OUTPUT { <REJECTED> FEATURE_TYPE H3HexagonalIndexer_<REJECTED> }' is not recognized by the factory 'H3IndexerFactory'Has anyone else experienced something similar?

Hi everyone, I’ve got many excel files and I need to extract some values in specific cells from them, then write these values into a new excel file. These excel file come with same schema, but may with different sheet names.For example, I got resume A, B and C, I want to extract NAME from cell B2, AGE frome cell C4, E-MAIL from D3 and PHONE from D6. And sheets name for resume A is ‘Jack’, for resume B is ‘sheet1’ and for resume C is ‘resume’. And now I want to write these information into a new excel, column A is NAME, column B is AGE, column C is E-MAIL and column D is PHONE.I know this must be a very basic function for FME, but how can I make this possible, I tried to search from the community without any result, maybe I input wrong keywords due to I’m a non-English speaker, please help me out, if would be better for me to understanding if you can attach a screenshot or a workbench file.Thank you very much.

Hi all,I’m trying to figure out how to use the CodedDomainGDB custom transformer in FME to create domains in an Esri Geodatabase dynamically from an Excel input.I understand that FME does allow creating domains, but it’s generally a manual process—similar to what you’d do in ArcGIS Pro—and Safe Software doesn’t recommend creating domain in FME. However, I’d like to automate this process as much as possible. Input: An Excel file containing coded domain values and descriptions.Goal: Take those Excel values and feed them into the CodedDomainGDB transformer to create or update coded value domains in an EGDB or FGDB.I’m not fully clear on how to structure the input features for the transformer so it produces the correct output. These are the references I’ve found:CodedDomainGDB documentation: https://hub.safe.com/publishers/spatialexjames/transformers/codeddomaingdbExample workflow blog: https://www.spatialex.co.uk/blog/automating-coded-domains-geodatabase/ If anyone has an example workspac

I am trying to load data from a previously created ArcGIS geodatabase into another previously created one.Utilizing FME Workbench, I designed the workflow successfully which takes data from the original gdb as a reader, adding some transformers for manipulation and then finally loading the results into the target gdb as a writer.While the loading and translations were successful, but I have noticed that field aliases that were created through ArcGIS pro previously in the destination geodatabase were dropped out.What is the reason behind this ????

I’m taking the opportunity to plug an idea I posted a while ago: I really want the ability to embed linked custom transformers via the command line / automatically. I have a bunch of projects which are just custom transformers - these custom transformers are often part of projects which I deliver to customers. It’s much easier for me to deliver a single workspace with the transformer embedded in the workplace rather than have them deal with linked custom transformers.But in my development I want to be able to reference/use the latest version of the transformer, this is especially true it the transformer is used in a tonne of different workspaces. I have an automated build process which will package up the workspace(s) along with documentation. But what I’m unable to do is to embed these transformers into the workspace - if I want to do that then I need to do it manually and it’s a pain. 

I have a workspace runner that runs a process to do a rough geo-referencing of multiple CAD drawings using a base polygon layer where each polygon matches each drawing.At the end of each drawing, I want to create a simple report with a bunch of attributes and a map / image of the CAD drawing overlayed on my reference polygon to visually see how close it is.I have hundreds of these drawings and don’t want hundreds of reports / images. Is it possible to append a page to a PDF or HTML report after each iteration of the process?   

Hi! I have encountered the following error when using Feature Writer transformer (dynamic workspace) writing a Microsoft SQL Server Spatial table.  2025-08-06 16:11:20| 148.0|  0.0|ERROR |Microsoft SQL Server Spatial Writer: Query failed, possibly due to a malformed statement.  Query Text `CREATE TABLE [Infrastructure].[Fire_Hydrants_Audit] ([FH_ID] bigint, [Work_Required] bit, [Paint_Post] bit, [New_Post] bit, [Paint_Surround] bit, [Clear_Vegetation] bit, [Post_Reflector] bit, [Inspection_Date] datetime2, [Inspected_By] varchar_max, [Works_Completed] bit, [MI_PRINX] integer, [SP_GEOMETRY] geometry)'. Provider error `(2715) Column, parameter, or variable #9: Cannot find data type varchar_max.'Any thoughts how to resolve this? Thanks!

I am upgrading a workbench from 2022 to 2025, this is updating the Schema mapper from 2 to 3, but SchemaMapper version 3 does not appear to have Microsoft SQL Server as a format type. Am i missing something?SchemaMapper Version 3SchemaMapper Version 2 

I have a workspace and I want to turn it into a CutsomTransformer - as part of that process I want to rename a bunch of attributes to include a prefix (e.g., from a JSONFlattener) - This is mostly for readability.For example I have several attributes which are coming from a JSONFlattner - in the original I never added a prefix, however, now I want to prefix with something like “layer.” - so something like “extent” would become “layer.extent”. The issues is that when I add that prefix in then all the downstream transformers which use the properties break. Obviously going through and changing them would have taken me less time than writing this question but it’s certainly not the first time I’ve had this kind of issue.In similar situations in the past I’ve been lazy and have simply renamed the new attribute to the old value. There are quite a few situations where I think having this kind of functionality would do a lot to improve workspaces readability with little effort on the authors p

Hello, I’m new to this forum and have been working with ETL and FME Workbench for a short time.I’m facing an issue with my XML output: the header and footer formatting come out messed up.This formatting problem does not appear inside the XMLFormatter transformer, but after saving the physical file, the formatting issue becomes clear.Has anyone experienced this or knows how to fix it?

Edition: Data Interoperability, Fixed OEM LicenseVersion: FME(R) 2025.0.0.0 (20250228 - Build 25208 - WIN64)OS Locale Name: en_USOS Encoding: windows-1252Process Encoding: UTF-8FME API version: 4.0 20240722Home Folder: C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\Operating System: Microsoft Windows 11 64-bit (Build 26100)For clarity, I am working with FME Workbench provided by Esri in both the Data Interoperability extension for Pro - and Server.  The server situation is worse at this point, so to start, I am just going to address the problems that I am seeing on my laptop.I am calling a number of different API endpoints with an HTTPCaller, manipulating the data, and then pushing (updating) the data in an ArcGIS Online (AGOL) Feature Service.  When I was building this workflow, I was successful in writing changes to the Feature Service.  I can step through transformers, check the cached data and then click on the ‘Run To This” to run the cached data from the previous tr

I am working on a lot of the DWG we got from a contractor and I have to deal with it because our forest is using a different projection and the units are different.  However, I have no troube with write to a new DWG with the correct projection and units.The only one probem I have here  is the Annotation which is different between the FME Data Inspector and ArcGIS Pro I have here.  The Annotation scale is way big and all over that I cannot read in ArcGIS Pro.Is there a work around to fix the problem ?I am in Colorado and work for a forest service.  I have two screenshot that will be helpful  This picture is in FME : and this is in ArcGIS Pro  Can anyone out there that have had similiar issues or a problem solved in the past ? Thanks !

Hi, I was wondering if there is a way in which it is possible to differentiate between an Empty String and a <null> value when using (XQuery in) the XMLTemplator. As an example I created 4 features. The first having a regular string value, and the latter 3 having 'no value', but each a different type of 'no value' (empty string, <null>, <missing>);When creating a dummyXML, I would like to be able to be able to handle/create a different 'b' element, based on the value of the attribute b. Let's say I have two fixed elements 'a' and 'c', and I want my dynamic 'b' element to be placed in between these two, then iterating over the different 4 features I would like to obtain the following result;<dummyXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">    <a>value_a</a>    <b>value_b</b>    <c>value_c</c></dummyXML><dummyXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">    <a>value_a</a>    &l

What controls the order in which tags are written in the OSM XML writer? I have a set of attributes that are ordered alphabetically in the writer. The attributes are even ‘ordered’ on the features (which shouldn’t matter?).  As you can see 'smoothness’ was assigned as the second tag, when I would have expected ‘highway’ to be the second tag.Inspecting the written dataViewing the XML file in Notepad++Attributes are listed alphabetically on the OSM XML writer.