Authoring

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…How do I force FME to bring in those UPRN values as contained in the source data? Thanks, 

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 GET /transformations/jobs/id/{jobid}/result but it failed with 404. Any hint?thanksKlaus 

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 row structure remains intact—meaning if a "Sub Company" row is moved, all its related data (X, Y, ID Link, GIS Portal Link) must move with it. However, I worry that "freezing" or locking 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> Unable to perform any licensing related tasks. Please che

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.747 947606 2070.204 2074.543 947606 6071.987 6100 Goal:I need to find ‘matching’ rows, where from(1) <= from(2) AND to(1) >= to(2) [colored lines].What I already tried:I already attached the second list as an list attribute to every single line to the first list (FeatureMerger) and than tried to find the matching line with two ListSearchers. This is limited as the ListSearcher only finds “First ...”.Can somebody help?

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: Separate the content from the titles Structure the extracted data into table as the source data    

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. 

when I am using AnchoredSnapper Reader Cad civil Writer : oracle spatial  Anchor : arcsCandidate : pointsSnapping Type : vertex Snapping it working fine Anchor : arcsCandidate : pointsSnapping Type : Segment SnappingTolerance zeroerror ORA-13347: the coordinates defining an arc are not distinct  same Snapping Distance in both  Why does this error occur when using Segment Snapping, The anchor is not supposed to move even with the Segment Snapping selected

So I was testing the 2025.1 Beta and was curious to try the new DocumentPDFStyler after seeing it mentioned in Seattle a few weeks ago at The Peak of Data and AI 2025. This caught my eye and I cannot find anything about this new “Safeguard”. What is it and why are the run icons disabled and not the same as other transformers (ex: Run from this, run to this...)?  

Hello, I have an AGOL Hosted Feature Layer that contains Fire Hydrants. There are 5,000 points.I want to update from a File Geodatabase with new Fire Hydrants. There are 5,004 points (meaning there are 4 new hydrants that do not exist in the Hosted Feature Layer).In the AGOL Feature Service Writer (highlighted in blue in the screenshot), to update this Hosted Feature Layer, would I use INSERT in Writer Mode? I want to upload only the 4 new Fire Hydrants to the Hosted Feature Layer from the Fire Geodatabase, thus preserving the existing records in the Hosted Feature Layer.  Would I use Truncate Yes or No?    

Can you help us complete this list of URLs used by FME? Some of our users work in environments with limited access to the internet and need to request access to specific URLs via a proxy . We are building a list of URLs used by FME and we are asking you for more input. Below are URLs we know FME may access in typical use. Are there other URLs you think we should add to the list? We will edit this list as answers come in.Of course, there is a multitude of web services you can connect to with FME using Web Connections and the HttpCaller transformer, and we don't want to add them all here. We are looking for URLs used by FME Workbench, standard FME readers and writers, and FME transformers. Please note: You can, of course, run FME without any internet access at all but you won't be able to use the FME Hub or access resources on the web.Workbench Startupwww.safe.com/ *fmestartup.safe.com/Help and docs:docs.safe.com/ FME Hubhub.safe.com:443**fmehubproductionopsworks-appstorage-c2mc0

I don’t know if this is a bug in build 25220, or if it’s the intended behavior. But it’s very different from past versions, and will likely cause issues in our workflows.When the ‘Merge Attributes’ option is unchecked, no Candidate attributes are carried forward in the Passed port as a shown in this screenshot. The Candidate attributes are only carried forward in the Failed port.If the ‘Merge Attributes’ is checked, the attributes are passed: However, the issue is that there is no configuration in the ‘Merge Attributes’ section that will only pass the original attributes from the Candidate. You are forced to either merge the Filter attributes, create a prefix on the Filter attributes (and likely have to remove in bulk post-SpatialFilter), or simply use the Filter attributes. No option will spatially filter the Candidates without altering the schema.I’ve found this behavior in many transformers that have the ‘Merge Attributes’ option, including SpatialFilter, SpatialRelator, PointOnArea

Hello, have bumped into the problem of generic reader not being able to read a GML and have read the literature on how to circumvent this by adding a separate reader as a resource to make the generic reader understand my GML’s. But I cannot get it to work the reader just runs and doesn't find data, no error or warning, Total Features Read 0.,So my GML is pretty straight forward as there is no problem getting FME to read it with a OGC GML reader without needing to set XSD schemas and so forth, just reads it in by default. I have tried various settings in a GML reader that have all worked and then copied that workflow when I add the reader as a resource without any luck.Have I overseen some step here or any ideas what I might be doing wrong? Send hilfen, Hlynur 

I have a MapInfo table which I want to modify by inserting and/or deleting records.I would like to modify the MapInfo table in place.I think that I can use the Precisely MapInfo Extended TAB Writer Feature Type Parameters?https://docs.safe.com/fme/2022.1/html/FME_Desktop_Documentation/FME_ReadersWriters/mapinfo_extended/mapinfo_extended-ft-param-w.htmMy software is FME Desktop FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64)But how do I build a workspace that performs this task?How do I build a Writer transformer that recognises an existing MapInfo table?