Creating and organizing workspaces. How to use Workbench.
Recently active
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 it should.Has anyone been able to successfully use deployment parameters for web connection values in a custom transformer?Also, not sure if it makes a difference but I’m using a custom web service for my web connection.
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 guess what I’m really looking for is access to something like the FME equivalent of a stack trace from any point within a workspace.
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?