Skip to main content
  • EN

Authoring

Creating and organizing workspaces. How to use Workbench.

  • 3,292 Posts
  • 13,501 Replies
3292 Posts
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Authoring
ArcObject Error while inserting rows in a feature class

Hi, I am getting this error:An error occurred while attempting to insert a row into the table ‘ABC’ using a cursor. The error number from ArcObjects is: '-2147217323'. The error message from ArcObjects is: {The cursor has been invalidated by an edit operation.} I am experiencing an issue when trying to insert features into a feature class stored in an enterprise geodatabase. Specifically, I am both reading from and writing to the same dataset. I haven't encountered this problem before, but it began after I set the Feature Operations to "Upsert" while updating existing records and inserting new records that are not yet present in the database. I suspect that performing inserts and updates simultaneously may be causing a disruption with the cursor. I also attempted to use the Feature holder, but I received the same error. This disruption is affecting the automated process. Does anyone know what might be causing this error or how to fix it? I would greatly appreciate any assistance!Thank

1224
j.botterill
Influencer
nath
Contributor
nathContributor
asked in Authoring
Fanout in writer fails 2025.1.1

HiSomething strange. I just wanted to write shapefiles with a fanout based on a field in the attributes, and that no longer works.  No errors, it creates the folders in the specified location but does not fill them.  It selects one and ignores the rest. I don't understand. I've used it a million times and never had any problems.  Has anyone else noticed this? Is it the version or is it me?

38419
DanAtSafe
Safer
gis_track4c
Participant
gis_track4cParticipant
asked in Authoring
how to setup data migration from MySQL to IOT Hono-Dittio system

We would like to migrate IOT sensors event data, which is exist in MySQL to Hono-Ditto system.Can you please help us with the process? Thank you.

131
crystalatsafe
Safer
scarter
Contributor
scarterContributor
asked in Authoring
'Feature Types to Read' not listing all selected input files

Hello Forum, I have read in 45 tif files into a single FeatureReader via Select Multiple Folders/Files> Add Files. But when I click three dots next to Feature Types to Read, in order to ensure that all 45 files are listed separately, I can only see one listed. And that doesn't appear to be a input file, but instead it just states ‘TIFF’... What I am doing wrong here? I use this function quite often and it usually lists all selected input files, but on this occasion it is not. How do I get Select Feature Types To Read to list all the selected input files?  Thanks,

222
scarter
Contributor
lifalin2016
Supporter
lifalin2016Supporter
asked in Authoring
Questions about PROJ in FME ?

Hi.I’ve been tasked with projecting data from a local coordinate system to an official one.The local coordinate system transformation can be handled with PROJ, but is not necessarily part of the standard PROJ deployment.Q1: If I add these files to the Reproject/ProjData folder, will FME/PROJReprojector then automatically use them for the transformation ?Q2: Will FME automatically download any necessary (standard) files from PROJ if they’re not found locally ?Q3: And am I correct in understanding that FME 2025.1 and 2025.2 (beta) embeds PROJ 9.5.0 ?Cheers.

150
lifalin2016
Supporter
stadimarmiladi
Contributor
stadimarmiladiContributor
asked in Authoring
Git diff launches wrong/oldest installed version of FME

Hi everyone,on my local machine, I have installed multiple FME versions (2023.2.6, 2024.2.4 & 2025.0). In our company we work extensively with git and i use the Workbench Git integration from the command line. However, if I want to diff Workspaces that were modified with the newer versions (only tested for 2025.0) the command “git diff” launches FME 2023.2.6. This is not useful, because if there are e.g. Transformers that have a newer version, i guess one that is not supported in the older versions, the “Compare Workspace” Tool (2023.2.6 version) cannot display them.Is there a way to specify which version of FME should be used when executing the git diff command? Thanks for your helpCheers!

261
martinkoch
Supporter
annette2
Contributor
annette2Contributor
asked in Authoring
Certification - Talview experiences

Hi, I am looking into renewing my FME certification in the coming months. It is the first time I will do it proctored. Does anyone have negative experiences with Talview where you couldn’t use FME Form, FME Flow as described here: https://www.reddit.com/r/fme/comments/1dl0647/has_anyone_completed_fme_certified_professional/I understand you are supposed to be able to use the applications and help documentation during the exam. Thanks,Annette 

644
_jacques_
Supporter
lifalin2016
Supporter
lifalin2016Supporter
asked in Authoring
Dynamic SQL in the InlineQuerier ?

Hi.Is it possible to execute dynamic SQL in the InlineQuerier ?I tried something like: SELECT * FROM Merged WHERE @Value(“sql_where”)but it doesn’t seem to work.Are there not substitution done in the “SQL Query” window in InlineQuerier ?Yes, I know it has to be SQLite syntax, and it is.Cheers.

291
desiree_at_safe
Safer
lifalin2016
Supporter
lifalin2016Supporter
asked in Authoring
Dynamically expose all attributes with a prefix ?

Hi all.Is it possible to expose all attributes with a specific prefix with a transformer ?E.g. x_kjhkjhgk, x_iuyiuytiuyt and x_nmbvmnbvmnbvcAll attributes are read by FeatureReaders and renamed with a BulkAttributeRenamer.Or most I delve into doing some Python magic using the schema features and fmeobjects ??Cheers.

533
ebygomm
Influencer
lifalin2016
Supporter
lifalin2016Supporter
asked in Authoring
Lost access to Server and Database Connections, How to restore ?

Hi.After installing the latest beta, all my 2024 and 2025 workbenches have lost all access to our shared server and database connections.How can I restore the access without compromising everything. Will a regenerate work ?The access still works in versions 2020 and 2022.Cheers.

161
lifalin2016
Supporter
nordpil
Supporter
nordpilSupporter
asked in Authoring
Data streaming/download server app - role restricted

I am looking at implementing something like this: https://support.safe.com/hc/en-us/articles/25407459193613-HTML-Page-with-Link-to-Download-Excel-File-FME-Flow-AppBut I don’t want to create a webhook for public access for the data streaming link, I want this restricted to the same role/group that has access to the server app - is that possible?

343
nordpil
Supporter
aaron
Contributor
aaronContributor
asked in Authoring
How to add another member to a GeoJSON file

In addition to the defaults “name” and “type”, I would like to add a third, custom member named “data_owner” at the start of a GeoJSON file I am creating using the GeoJSON Writer (see example below). Is there an easy way to do this - I can’t find anything in the writer parameters - or do I need to use the JSONTemplater or another transformer? (FME 2023.2.0.0){    "name": "gis_assets",    "type": "FeatureCollection",    "data_owner": "CompanyName",    "features": [      {        "type": "Feature",        "geometry": {          "type": "Point",       etc.

805
takashi
Celebrity
jtr_atx
Contributor
jtr_atxContributor
asked in Authoring
FGDB Feature Class file size

I am attempting to find the file sizes for each Feature Class within a FGDB, both within a Feature Dataset and at the root of the FGDB.  All research yields that the file size is not available via the PythonCaller and we are trying to isolate the FC filesize output via:PythonCaller > getFeatureClassSizeimport os def getFeatureClassSize(feature):    fc_path = feature.getAttribute("FC_path")    total_size = 0     # Common file extensions in a File Geodatabase    valid_extensions = {'.gdbtable', '.gdbtablx', '.atx', '.spx', '.freelist', '.gbx', '.cat', '.gdbindexes'}     if os.path.exists(fc_path):        if os.path.isfile(fc_path):            ext = os.path.splitext(fc_path)[1].lower()            if ext in valid_extensions:                total_size = os.path.getsize(fc_path)        else:            for dirpath, dirnames, filenames in os.walk(fc_path):                for f in filenames:                    ext = os.path.splitext(f)[1].lower()                    if ext in valid_extension

736
jtr_atx
Contributor
D
dheeraj
asked in Authoring
The resource name must not contain any of the following characters: \\ / : * ? " < > | & = ' + % #

Hi,Getting an error while publishing the workbench.Publish failed - FME Server encountered an error and reported the following message. The resource name must not contain any of the following characters: \ / : * ? " < > | & = ' + % #Regards, Dheeraj

7810
nielsgerrits
VIP
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Authoring
Automation: Perform action after a certain about of time

So I’m configuring a service (an automation) which is triggered by an webhook. The automation will process data and then send the requester an email when the job is done.I want to add a little more feedback to the process for the end user. This is in part to reduce the amount or possible duplicate submissions - As I see it I have a couple of options:Send an email when the request comes in confirming that the request is being processed. Most likely this will be enough. (The user will already get a confirmation form the webapp where they submitted the request)Send an email after a certain amount of time (e.g., 15 mins) in case their job is taking a while or they are stuck in a queue.  Try to detect duplicate submissions and send an email to the user that their duplicate request was cancelled.As I see it option 1 is the only one which doesn’t require an extra free engine to run another job. Am I missing something?Are there clever way to do either 2 or 3 without an additional engine? 

362
virtualcitymatt
Celebrity
james_c_452
Enthusiast
james_c_452Enthusiast
asked in Authoring
TIN Not Creating Correctly

Hi,I’m having a issue making a TIN properly in FME. Basically FME is interpolating points/vertexes that don’t actually exist in the original data. What I want to do is make a TIN that considers only the vertexes of the features I give to it (point/lines and breaklines). I do not want FME to make up data that does not exist.Does anyone know a way that I can do this?For example in this example this is one break line. It should only have two TIN vertices (the ends). No triangles should be created from any interpolated points However, when I look at the TIN for the same spot it has created 6 vertices I am using FME workbench/form 2023. I’ve been trying different settings for the SurfaceModeller and the TIN generator

404
james_c_452
Enthusiast
hlynur
Supporter
hlynurSupporter
asked in Authoring
Changing a cell entry in an overly complex Excel document

Hello yet again.This time I am experimenting with a complex Microsoft Excel document, its basically a calculation file that contains quite a lot of sheets, macros, references and formulas. Idea is that instead of sharing the excel document with the people that need to use it that I would just host it on our Flow, people would then have an option to fill out some published parameters in a flow app and then get a single excel sheet returned with their results (cutting out all the underlying datasheets and formulas and macros etc).Or to sum it up: I have a complex excel with formulas, read that excel in FME, change values in cells in FME, write out an excel from FME that would then recalibrate/recalculate based on those changed values.So I have figured out how to single out cells in the excel table where (basically using counter, and tester for that single number, link to attribute manager where the new value can be inserted to replace the old one, back to a FeatureMerger to put the new v

120
hlynur
Supporter
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Authoring
Setting default values for attribtues

NullAttributeMapper, AttributeCreator or otherWhat do people use to set default values for attributes?In the case that I have is a json document - in the case values are missing I need to set a default value. Ideally I’d use an NullAttributeMapper, however, there are upwards of 10 values I need to set and I don’t want to use 10 of these. The other option I see is an AttributeCreator/Manager with conditional values which is what I would normally do.  

474
nielsgerrits
VIP
telfma
Contributor
telfmaContributor
asked in Authoring
FME Form unable to obtain ESRI named user licence

Hi,I recently moved to FME Form 2025.0.3 from FME Workbench 2021.1.2.The install is on a central windows machine. Some workbenches run as other users. ArcMap and ArcPro (3.4) are also installed on this machine.All our workbenches involve ESRI enterprise geodatabase readers or writers, so require an ESRI licence to run.Users of FME all have named user licences for ArcPro, they are able to launch Pro and obtain a licence on the central machine.When I use FME Form there is no issue accessing the ESRI licence and using the readers/writer. However when testing with other users, who have the same type of named user ESRI licence, FME reports the error: “Worker 6428 > Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this art

24716
telfma
Contributor
stevebruton
Contributor
stevebrutonContributor
asked in Authoring
DLL use on customers client machines

New to FME, have a client using FME and want to read and traverse through a MicroStation DGN file on a number of client machines. What’s the best way to achieve this?Does a license allow me to distribute a DLL for use on their clients?Is there a batch interface I can use?Steve @ Hexagon 

575
stevebruton
Contributor
larue
Contributor
larueContributor
asked in Authoring
Package Development: How Do They Work? (on a Mac).

I have been trying to set up a Package dev environment on a Mac (Sonoma 14.7.7) and it crashes every time I get to the ‘import fmeobjects’ test in the venv.  Just getting that far was a huge hassle.  It appears that the SDK instructions and fme-packager library are geared for Windows. I had to modify the fme_env.pth file to only show the FME Home path and get rid of the rest, for instance.  The issue seems to be that the native FME python 3.13.5 library does not like the Python.org 3.13.5 library, but can’t say for sure. Are Macs even supported for this?  I currently don’t have access to v2025 on Windows.If anyone has had success making packages using MacOS, any insight is appreciated.  Bonus points if you have a good ICP reference! Thanks,-Loren

13615
carsonlam
Safer
S
starlet99
asked in Authoring
Extremely slow workbench GUI - any optimization planned?

Hello,FME workbench has a strong tendency to take longer and longer to perform editing tasks (NOT translation) the bigger the workspace gets.Disclaimer: My workspace contains over 2100 transformers and I am aware that editing transformer links upstream will cause FME to recalculate downstream. However, my frustration is due to the fact that even minor modifications to very small independent workflows in the workspace seem to trigger the same recalculation as the workbench becomes unresponsive for 5-15 seconds every time I do something. This even happens when i move a transformer without altering any workspace logic. It even happens when I move an unconnected transformer! Extremely debilitating to productivity.Is this a known issue / any optimization planned?Using FME Workbench on Windows x64 2016.1. Confirmed on multiple PCs.

555
helmoetz
Supporter
jelle
Contributor
jelleContributor
asked in Authoring
Authenticate using certificate

Referring to this (closed) post: https://community.safe.com/ideas/httpcaller-to-specify-client-certificates-31782​@LizAtSafe mentioned that the feature is released. I can find it nowhere in the documentation. Could someone point me to the right direction on how to authenticate at an API,using a certificate?

463
jelle
Contributor
ingalla
Contributor
ingallaContributor
asked in Authoring
Tables from changes detector within email

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?  

291
alexbiz
Influencer
virtualcitymatt
Celebrity
virtualcitymattCelebrity
posted in Authoring
A plug for an old idea

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. 

210
virtualcitymatt
Celebrity

Badge Winners

  • English Speaker
    marhampkhas earned the badge English Speaker
  • Welcome Back
    rbxhas earned the badge Welcome Back
  • English Speaker
    vapedosehas earned the badge English Speaker
  • Welcome Back
    thesarge81anhas earned the badge Welcome Back
  • Student (Grey)
    gurvan777has earned the badge Student (Grey)
Show all badges

Community Stats

31,825
Posts
120,879
Replies
39,463
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.