Authoring

Anyone ever developed a VS Code “language” for FME logs files? Years ago somone -  I wish I could remember who _ did this for NotePad++ and it was awesome.The defaul VS Code log view is actually not bad so this is really a - “would be nice”

I am trying to use a template file in an excel writer for my data. The data is collected from a number of sites, so I was aiming to use the site id attribute as the sheet name to export a new sheet per site. Unfortunately the template is only being used for the first site which passes through my writer, and the other sheets are unformatted. Has anyone encountered this and found a solution to apply the template to all sheets if multiple are being written in the same feature writer? 

Hello! I’m trying to figure out the best way to aggregate values by the most common words. I’ve found a few threads and documents but not quite what I was looking for.For example, I have a list of building names and numbers where each entry can have a of variation of a building name and number: “1000 The Coolest Building Ever”“1000 Coolest Building”“Coolest Building”“100 Coolest Building Dr.” I would like the output to be “Coolest Building”, as it has common base words across all features. Is this possible? Bonus point if a variation of “Bldg.” “Bldg” can be included. Any advice/guidance is appreciated! 

I built a dynamic workflow to change a attribute for CSV file. It turns out that the attribute name is changed but without value in the output CSV file. Please could you help solve the issue?The input CSV file and workbench has been attached with the post.

I know I can restart a map service in ArcGIS Server Manager. Is it possible to restart a map service in ArcGIS Server using FME? if yes, how is this done?

FME 2025.0.2.0I’ve built an embedded custom transformer which uses a web connection as a parameter.When I initially use the custom transformer in my workspace I’m able to specify a deployment parameter for the value of the web connection.e.g.  However, as soon as I close and re-open the transformer properties the connection becomes invalid and the OK button is disabled: It’s not possible to re-assign the deployment parameter as the connection value unless I first clear it, then re-add it.I’ve tried various workarounds (e.g. creating a standard published parameter to hold the deployment parameter value) but I can’t get this to behave like I think i

Is there any way to get the “path” of a transformer so that it can be reported for a custom error logging solution. The standard FME log file has this information but I can’t find any way of getting at it inside a workspace.For example, in the image below we can see log lines being reported from a ParameterFetcher transformer which is inside the Log_Error custom transformer.  If I could even just get the name/instance of the custom transformer that would be helpful but something really useful would be to have access to the <prior> transformer.I’ve seen some other posts on this topic which talk about hard-coding log messages but it would be nice to have a more automated approach and those posts are all from before Safe changed the way log files work to include the links to the transformers….I gue

I upgraded a workspace with a dynamic writer from FME 2022 to FME 2024. When inspecting the schema before writing there is fme_date and fme_datetime time fields. When writing to geodatabase it created dateonly fields from the fme_date fields when using FME 2024. When writing to SDE we get a ORA-210 / ORA-308 (invalid field type). What is the solution to this problem? I posted this before as addition to another forum topic. However someone from FME suggested to make a new topic. 

Hello Forum, Does FME Form have the concept of creating a layout which could then be saved as a image file or PDF? So, think about how in QGIS I may bring several vector layers and some base mapping together and post to a ‘print layout’. Into that print layout would go the vector layers and base map. I may then add a title, north arrow, map, legend etc. I would then export that layout out as a png or PDF. Does FME Form, have a similar concept. I’ve been looking in FME Form and running online searches but have found nothing, which is surprising. Any thoughts? Thanks,Stuart  

I have a Microsoft Access Database Table. I need to delete all the records in it and just keep the schema. Basically, the output will be an empty table. There are 10,000 records in the table. Delete all records in Table A. Table A will be empty. Just keep the Table A schema. I know I can use the SQLExecutor with a SQL Statement to do this, but how to do this using Transformer(s)?  What is the best way to go about this?

Hi all.Is it possible to use a scripted parameter in a workspace to populate the items for a choice parameter ?So far I’ve had to manually edit the choice list whenever new items needed to be added, but potentially it’s possible to create all the items automatically with a query to a database. This would release me from having to update it manually.The example I’ve found only talks about returning a single text, but a choice parameter needs a list of display+value pairs.Any insight is welcome.Cheers

Hello Forum, I have a workspace which is reading in a csv containing a field called UPRN. Some of the values are full (e.g.: 200003362891) but some values are zero. This is expected in the data and is fine.   But when read into the FeatureReader the values look like this (when set as Number)… And if set as Int64 it comes out like this…

Hello,FME Flow announces the deprecation of the JobWaiter transformer:2024-9-2 10:59:42 | FMEFlowJobWaiter (ServerFactory): FMEFlowJobWaiter was deprecated in 2024.1.0. Its support lifetime is limited because the v3 FME Flow REST API will be removed in future FME releases. When the v3 API is removed, this transformer will stop working. Please update this workspace to use an HTTPCaller to call the relevant REST API directly instead.Question: Is there any ‘how-to’ with a sample workspace which REST call can be used to replace the JobWaiter functionalities? My sample scenario would be: You have 5 jobs running in parallel (wait to complete NO), JobWaiter polls every 20sec until all 5 job_ids are received and completed. all 5 jobs must have _status SUCCESS before Job #6 is called.I tried 

Hello community,Just installed the 2025.1 beta of FME Form [FME(R) 2025.1.0.0 (20250612 - Build 25591 - WIN64)].I'm experiencing a new behaviour compared to all the previous versions: when I open a workbench it automatically fills all caches in, without me running the workbench. Luckily, it stops at the writers and does nor run them.I could not find any information about this in the change log of the latest versions.Is this on purpose or a bug? Is there any way to stop it? I do want the caches, but I want to decide which ones are created.I get these notifications in the data preview while it is doing it and after it is done:Sorry if this is repeated, I couldn't find it here.

I have downloaded  county road network compined the lines via road name I have 2 point datasets a (From and a To). they are intersections of the road network they share many fields but ive been using a count field as a joiner. when I am using feature joiner I keep the roads that the points are touching but i want to keep only the road inbetween the points. after point on area overlayer theyre broken up but the fields are duplicated. so i am unsure how to keep the “inner section”. Im sure its just something simple i am misunderstanding 

My requirement is to calculate the distance in meters from points to nearest road in FME, end output should be one new field should be added in point layer with distance to each points. i have tried to do this with NeighborFinder transformer but i am not getting my desired output. i don’t where i am doing mistake. can any one help me.

Colleagues, I'm looking for a way to sort two text columns in Excel based on a custom classification. I have a dataset with several columns, including X, Y, ID Link, GIS Portal Link, Major Company, and Sub Company. My goal is to sort the "Major Company" and "Sub Company" columns according to my own predefined order.Here's what I attempted:I used the AttributeMapper transformer to assign classification values, followed by a Sorter to sort both columns. However, it seems that FME ignored the initial sorting by "Major Company" and only applied the sort to the "Sub Company" column.What I want is: To first sort the "Major Company" column based on my custom classification. Then, within each "Major Company" group, sort the "Sub Company" column based on another classification. It’s important that the

HelloI have to change the value of a deployment parameter. Is there a way to find out, in which other workspaces this deployment parameters is being used?Thanks, Vera

Hi all,I’m running a workflow that reads a licensed FGDB layer, it’s setup within a custom transformer to take advantage of parallel processing.The problem is I’m getting the following error when the PC spins up 16 instances.025-06-03 22:38:47| 0.3| 0.0|INFORM|2> Opening the Esri Geodatabase reader2025-06-03 22:39:48| 0.4| 0.1|INFORM|2> The ArcObjects license 'Advanced' is being selected from the ESRILicenseInfo ArcObjects call2025-06-03 22:39:48| 0.4| 0.0|INFORM|2> The Esri Product license used by this machine does not include licenses for the 'Advanced' licensing level2025-06-03 22:40:48| 0.5| 0.1|INFORM|2> The ArcObjects license 'Advanced' is being selected from the ESRILicenseInfo ArcObjects call2025-06-03 22:40:48| 0.5| 0.0|INFORM|2> The Esri Product license used by this machine does not include licenses for the 'Advanced' licensing level2025-06-03 22:40:48| 0.5| 0.0|ERROR |2&g

Currently unable to use Feature Reader (version 15) with:Spatial Filter = "Initiator is OGC-Within Result"My initiator is a points layer and the Result layer is a polygon layer, both in the same coordinate system.It gives me a _reader_error of <missing> with no further explanation.This was upgraded from FME 2022.2 Feature Reader Version(13). No changes to any settings.When I copy/paste the version 13 Feature Reader from FME 2022 back into this 2024 workspaces and run it, it works just fine.Has functionality changed? If so, can someone point me to the doc that explains it?Or is this a bug? 

Hi I was particualrly interested in an item that is mentioned in the FME Form Change log for FME 2025.0.2 - “Add support to read workspace parameters.” https://fme.safe.com/changelog/?_change_log_product=FMEFORM&_change_log_version=2022000001%2C2025000200 I was wondering if it is possible to obtain a detailed description of what this change is? It may well address a topic that I have been interested in for some time.RegardsJamie

Hi there,Input data:list with numerous entries, sorted, with changing name excerpt: name from to 947606 2041.020 2045.574 947606 2045.574 2055.574 947606 2055.574 2065.574 947606 2065.574 2079.880 947606 2079.880 2083.168 947606 2083.168 2089.880 947606 2089.880 2099.880 list with ‘exceptions’ excerpt: name from to 947606 108.459 108.7

Hello,I would like to perform queries on a branched electrical network composed of sections interconnected according to the current direction. However, the "TopologyBuilder" and "NetworkTopologyCalculator" transformers facilitate this task, but have limitations regarding the manipulation of downstream sections.  For example, I have the entity "i" and I want to collect and query the values ​​of the entity "i+1" (by analogy with the "for" loop in Python), then "i+2", etc.Do I have to use Python development, or are there other, simpler solutions?Thank you in advance for your valuable assistance.

I’ve reached the workflow stage, but I can’t proceed further. I’m trying to extract multiple tables from a PDF file. I’ve been following https://support.safe.com/hc/en-us/articles/25407564475277-Extracting-Text-and-Tabular-Data-from-PDF#h_01HW3Z9Z37Q33NQQ7R0XBGEVB0, but the structure of my PDF is quite different.I only want to extract the tables—nothing else. In my case, the table has titles on the right and content on the left. I used the StringSearcher to extract the titles, since they are easier to identify (usually one word).The challenge now is that I can’t extract or separate the content, as it’s made up of long sentences that are mixed with the titles. I'm looking for a solution to: Sep

I want to run a batch process to load a series of file-based datasets in a folder, do some simple transformations and export each to a database table.  The workspace in the image below is run by a workspace runner.  The complication is that each source has some standard columns and an unknown quantity of additional columns, which need to be loaded into the database as a new table.  If I configure the workspace with one source file, the schema config will not be correct for another file.  How can I set the schema definition to be dynamic?  I’ve been researching the subject but have not found the answer.