Authoring

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?  

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

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’ve been a big of a hater of the Parameter Editor window for a while - I’ve always had it disabled in favor for more canvas space, plus I just like bigger windows to work with in general.Today though, while working in the PythonCaller, I really wanted to look at my log file - I always had to keep closing the editor to scroll though the log. Then I remembered about the Parameter Editor window and it made things waaay easier. I’m not sure I’ll keep it like this but for now I’m really liking it. 

Hello everyone,I am having difficulty adding data to an existing DGN file.I have a CSV containing X, Y, Z and a Matricule.I want to add this data into a DGN that already contains points and predefined layers (levels).I just want to complete the DGN with my CSV data, putting the new elements into the correct layers.I find DGN handling in FME much harder compared to working with simple shapefile layers.I have managed to roughly merge my points, but the values do not go into the correct layers and they don’t take the original DGN styling.For example, I want the Z value from my CSV to go into the layer “CALC_PTTOPO_ALT”On paper I thought this would be simple, but I can’t find the solution.Can you help me, or tell me if there is an easier way?In the long run, I would just like to update my DGN regularly when I have new points.Thanks in advance,

This is a quick rough guide on how to print your workspace as a PDF. This should be a standard feature of FME, but it is not. Printing off a workbench is very useful when creating documentation about workbenches. I am surprised at the lengths I had to go to for this. Step 1:Follow this, or any other guide, on how to set up CUSTOM Paper Size for PDFs I recommend adding size: *Option: CUSTOMSIZE{*rcNameID: =USER_DEFINED_SIZE_DISPLAY*MinSize: PAIR(936000, 1332000)*MaxSize: PAIR(109728000, 164592000)*MaxPrintableWidth: 109728000}Then, printing the item requires another bit of jankyness to make this work:  click landscape make sure there is only 1 page press fit to scree now it looks “ok” to print, but it isnt yet. hit the print button (mine is missing for some reason) select print to pdf hit preferences hit advanced  choose your newly defined page size hit apply DO NOT PRINT YET. exit the window.Finally, hit the fit to page once again (step 3)Now, hit print again, and print your item to p

I have a json file that holds coordinates in the following format: How an I extract these coordinates to make the polygon that they form? I have tried reading the data through a text reader instead of a JSON reader and I have tried the JSONFragementor/JSONExtractor transformers but I can’t get the json query right, everything gets rejected.Any ideas?​​​​​​​

Does anyone know how to delete an FME Flow connection in FME Form 2025+?FME Flow connections used to be configured in the FME Options dialog under the Web Connections tab but they are no longer there in FME 2025. Instead, they are now available from the main FME Form toolbar.Using the toolbar I can create a new connection, select and edit an existing connection, but I don’t see any option to delete an existing connection. Even the FME Form documentation does not provide any help.

I have a field Filename where the naming convention is usually 2025 May Report.xlsx or 2025 January Report.xlsx I have used the filenamepart extractor transformer to fetch the filename along with a string searcher transformer just to extract the year and month  from the filename. Now I want to create an additional field where I can flip the year and month -→ Month Year. How can i build the regex to achieve this? Also I might be expecting different scenarios where January is written as Jan, JAN or january

I want to Create a choice User Parameter that will show column list details from database, This will enable me to select my choice column field that when I run the workflow, I will be able to get the output result for only the column in a fanout dataset.

I wonder if there’s a way for me to hack the web connection during run time to expose the AGOL Organization URL and token so I can use this URL downstream.The ArcGISOnline Connector returns these as format attributes but I have the extra overhead of running the right action item to expose them. Submitted an Idea related to this:  

We currently have an .asp script that builds a url/uri based on a selected prefix and document ID.When the OK button is clicked, the url/uri is opened in a new browser tab.The server where the asp script is located is being retired so we need to come up with an alternative.The parameters are Plan Type and Plan Number.The parameters are used to generate a path to the document to open. Eg. \\sample.file.path\resources\SCIMsPlans\pm12345.pdfI have converted the ASP to Python and made a self contained executable that works well but staff are used to accessing the plan search via a web link. I thought a FME web app may be suitable for this.Can anyone point me to the correct transformers to use for this or even better, a sample workspace.In case it helps, below is a snippet from the python script that builds the file path and opens the document.        # The Plan document ID number        name = self.plan_input.text().strip()                # If 'dp' is selected, use 'DP_DepositedPlans' to b

Hi,I get the following error when attempting to publish a workbench from FME form to FME Flow:User is not authorized.The specified user credentials were not authorized to perform this action. Ensure with your server administrator that your user credentials are authorized to perform this action.Publish Failed (Not Authorized) - Ensure that credentials are correct, and that user has sufficient privileges. I’m publishing using an account with superuser access. I’ve also managed to upload the workbench directly to a the folder using the FME Flow interfaceFME Form: 2025.0.1.0 (20250327 - Build 25220 - WIN64)FME Flow: FME Flow 2025.0.1

I have an export of an MS Whiteboard in pdf form. (I also have the JSON and HTML. The JSON doesn’t store the note contents).  PDF reader is spotting text, but I’m struggling to pull it out ‘per note’. Any ideas? 

I have a workspace that reads an excel spreadsheet that contains 20,000+ rows with file names and paths to DWG files which works 99.9% of the time.  The simplified process is as follows:Filter the list of files from the spreadsheet to remove certain filename patterns Read the dwg model space, but only keep lines that are on layers that starts with BND Test to see that they fit in a polygon using spatialfilter clean up attributers and write the results to shp fileFor some reason when it hits a certain file, the process stops when it hits an error (even it is set to continue on rejected feature and ignore failed readers is set to Yes.  I have attached a zip with the log file as well as a FFS file it create which contains a single line that doesn't appear to be anything unusual or unexpected.  My work-around for now is to skip the offending file by using the “features to read” settings on the reader.  Given that there are 20,000+ files, I tend to run 5000 at a time.

I want to change paths for readers in multiple FME workbench files and Ive been trying all day without success to do so without doing it manually. Does anyone know how to do this :) ?For example from \\192.168.221.35\ftp\hofn\Höfn-skolplagnir.shp to \\192.168.221.50\ftp\hofn\Höfn-skolplagnir.shpwith the only change being the ip path from ending at 35 to ending with 50 but for multible at once :)I already tried changing in Notepad as suggested here with all the paths but it doesnt work for some reason. Also consulted chatgpt for Powershell scripts of different variety...Thank you for reading :)

Hi All,I have a folder of csv files with the naming convention like this : Insp1.csv, Obsv1.csv, Insp2.csv, Obsv2.csv etc etc.I have written a workbench to read in Insp1.csv and Obsv1.csv and derive the outputs i want. These csv files are pairs and both are needed to create the output. I have a folder of many InspX.csv and ObsvX.csv files that I want to process. I have set up a Directory and File Pathnames reader than I think I want to pass into a workspace runner that calls the workbench to process the files with parameters.  How to I get FME to iterate over my files and each time the runner is called iterate to the next pair of csv’s? ie first time is run use Insp1.csv and Obsv1.csv, the second time use Insp2.csv and Obsv2.cvs etc etcMany Thanks Goatboy

I was having a bit of a poke around with how Workbench calls the AI APIs and noticed that the method of sending the workspace was to first convert it to graphviz format. I had initially thought the fmw would’ve been passed and parsed instead,Converting to graphviz is a pretty cool step and could be used when producing reports or documentation on workspaces. I know people have asked for similar functionalities in the past re exporting the workspace as a graphic: Is that conversion something that the end user can tap into? I’m going to shamelessly tag ​@rylanatsafe ​@mark2atsafe and ​@NickAtSafe here, as while they might not be the people directly responsible for answering such a question, I feel like they might be able to point this question in the right direction!

I would like to use the AI assist feature in a programmatic way.  Is this possible?Currently it is available only as a GUI inside FME workbenchI would like to provide a prompt + workspace file, call an API, and then get a response based on the workspace context

Hi,Situation - Oracle Writer will not work, so I need a workaround to overcome this. The tables in the workspace have many attribute fields, 2100 or thereabouts, and the Oracle writer falls over. 😕 Safe recommend upgrading to a newer Oracle, so the client will get that sorted eventually… but meanwhile I need to get the workbench working.The workbench prepares delta files to be written into the Oracle db. Once the data is ready for writing to the db I have used FeatureReader to read 13 Oracle tables into the workspace, then use a FeatureMerger with the existing workspace table to identify if the features already exist in the 13 db tables or not. If they are UsedSupplier they exist and are then designated to be an “Update”, if they are UnusedSupplier then they are new features and are sent as an “Insert”.As a further complication, we need to write to CSV files to overcome the issue with not being able to write to Oracle from FME. So we need a batch of csv files for Insert, and another f

Using FME Flow with Esri ArcGIS Software – FME Support Center If you are using version 2025.1+, you must download the Esri ArcGIS Connector from the Hub and use the new readers and writers. Workspaces authored in previous versions will need to be upgraded. For steps to upgrade, please see Working with Esri ArcGIS Feature Services in FME.  Am I interpreting this statement correctly? There is effectively no backwards compatibility in 2025.1 for workspaces that connect e.g. to an ArcGIS portal?

Hello everyone,I have a question regarding a workflow/tool. I work in the railway sector and would like to automatically place overhead line masts on points and then rotate them in the direction of the tracks so that they stand perpendicular to the track axis. I have an FFS file of the 3D object, a point file, and a polyline that represents the track centerline. The placement of the 3D object works perfectly, but I'm having trouble rotating the object as desired.At the moment, I’m using the "NeighborFinder" tool to obtain the track alignment information, then the "CenterPointExtractor" tool, and finally the "3DRotator" tool to rotate the mast accordingly. I do manage to rotate the masts, but not in the correct direction so that they are perpendicular to the track axis.Does someone has an idea how I could proceed?Thanks in advance and best regards  

The AttributeValidator fails nulls when validating for various types.  Most of the time I would like it to pass nulls.The obvious work-around is using the NullAttributeMapper to map nulls to some acceptable value for the validation but:a) this is a pain because you have to do it for all attributes you want to checkb) you have to change these values back to null afterwards so as to not send spurious data to the writerAny more elegant way to do this?Perhaps a custom transformer to do the work-around and the AttributeValidator within?Or should this be an “Idea” for the AttributeValidator, i.e. Option: pass nulls?

Hello:)This is incredibly petty, but as someone who lives in a country where “Commonwealth English” is the standard for spelling (and not the Simplified English of North America), I wondered if there’s a switch in the UI somewhere so that menu items and transformers are spelled correctly (correctly for me). For example: the NeighbourFinder, which, as is pointed out in the docs, is an alias of the NeighborFinder. I’m waging my own campaign against the normalisation of N.Am. English in software across the English-speaking world.