FME Form

Dear FME Community,I would like to use the WorskspaceRunner for optimize the performances of my treatments, but I’ve difficulties to configure them. More precisely, I don’t how can I configure the reader/writer of child workbench, whereas I try to do same things like this tutorial.In this example, I try to have in input, a filter on limited objects, but in output I’ve all objects.This is my main workbench :And this is my child workbench : How can I can I do ?

Hi All,I have successfully developed an automation process that customises and exports a table to Excel format. The final transformer in the workflow is a FeatureWriter, which generates the Excel file.I am now looking to convert this Excel output into a PDF format. However, my attempts using the available FME PDF transformers have not been successful.Could anyone advise on how to achieve this using FME? I have read that SystemCaller or a PythonCaller script might be viable options.Thanks :)

Hi,I have hundreds of word documents that i am trying to extract the text from in order to run analysis on the content. I have tried just using the MS word reader to open a .docx file but with no success, so have seeked alternative workarounds to achieve this.One of the solutions I am looking at is to run ‘Mammoth .docx to HTML converter’ via SystemCaller to extract to word document into html.My issue is that, although the command runs fine when run directly in CMD, when run through the SystemCaller in FME it does not create the output file.from the log file I can see it finds the input .docx and extract the information it just doesn't write the output .html for me to read into FME with the AttributeFileReader. I have installed Python, Mammoth, and Node.js on my PC, below is the command used in SystemCaller;"mammoth "@Value(Input File Path)" "@Value(Output File Path)"Any help with this would be appreciated.Many Thanks Mi

Hi everyone,please is there any way how to read the full path of the file from GoogleDrive (e.g. Shared with me/Division A/Documents/PDF/data_view.pdf)? I can see that GoogleDriveConnector can load just _relative_path (e.g. Documents/PDF/data_view.pdf). Thank you so much!Lubo

Hi, I’ve read through other row to column posts but can’t seem to get it to work.Pretty simply I want the name values to become column headings and their value below them.I feel like this should be an easy one but just can't get it to work.  

Hi, I have and issue trying to connect to snowflake DB using keypair authentication, it is not recognising my schema.I'm using FME(R) 2024.1.2.1 (20240906 - Build 24624 - WIN64). I can connect fine in DBeaver using the keypairs. I'm using the advance JDBC settings to add the parameters in a new snowflake database connection.The error I get is ' COM.safe.fme.jdbc.TranslationFailureException: java.lang.IllegalStateException: Connection established with no current schema. Make sure that schema 'dbo' specified in connection settings exists and is accessible by the user ‘.I know you need to have the case correct in the parameter I have checked with the DBA and have been told that the schema is definitely lowercase. I can’t show all the jdbc connection string, but this is the schema bit ‘ schema=dbo ’ so it is passing the lowercase parameter.  Again, I am using

I'm joining two features in a featurejoiner in Form (2024.2.1). In AttributeManager one is a uint8, the other is varchar(200).Both contain value '2’.In Form these featues are joined with the joiner set to Automatic mode. When the workspace is published to Flow (also 2024.2.1) suddenly they are not joined anymore. I would expect the Automatic mode to work the same way in Form as in Flow. Especially since we run the same version in both environments I can't find any registered bugs on this issue. Has anyone else encountered this?

Hey AllI have a process with the general workflow of create an SQLite database (FeatureWriter) and then run schema/index/relationship queries against it using an SQLExecutor.Initially, this was built in 2020.2 and works well (see example attached). However from ~2023.2 onwards, this logic no longer works. I get the following error when running in version newer than 2023 (including the latest 2025 releases)SQLite Reader: Failed to read a feature from the database. SQLite3 Engine error: 'attempt to write a readonly database'Looking at the database, it’s not read only, I can read/write to it with other programs. I’ve also tried it when FME is running as administrator and writing out to different folder locations.I can replace the SQLExecutor with a PythonCaller and it works fine.

anyone know why Im getting these errors. Its an export to excel from gogov. I think the export is a bad file format?Excel Reader: Failed to open the dataset 'R:\Rubicon FME\GoGOV\Input\**\*.xlsx'.  Error message was 'File does not exist'Excel Reader: Failed to open the dataset 'R:\Rubicon FME\GoGOV\Input\*.xlsm'.  Error message was 'File does not exist'Excel Reader: Failed to open the dataset 'R:\Rubicon FME\GoGOV\Input\report (17).xls'.  Error message was 'It is not a xls file. Use the xlCreateXMLBook() for a xlsx file.'Failed to obtain any schemas from reader 'XLSXR' from 3 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationWorkspace generation failed.  Parameter file was C:\Users\pearly\AppData\Local\Temp\FME_1750261216546_26960. 

Hi, I use a DGNStyler to set the color of line features.Color is set by RGB Color (Color Type = RGB). In the resulting DGN, the color of the line is replaced by the best matching color from the color table. Result (Color 59):Desired Result (204,0,0):Is there a way to get the desired result? Jasper 

Hi,I have hundreds of word documents that i am trying to extract the text from in order to run analysis on the content. I have tried just using the MS word reader to open a .docx file but with not success so have seeked alternative workarounds to achieve this.One of the common solutions I have come across is running a command for 7-Zip  in the system caller to extract to word document into XML then load XML.My issue is that, although the command runs fine when run directly in CMD, when run through the system caller it requires a response regarding duplicate files. “Would you like to replace the existing file:  Path:     .\[Content_Types].xml  Size:     3893 bytes (4 KiB)  Modified: 1980-01-01 00:00:00with the file from archive:  Path:     [Content_Types].xml  Size:     3893 bytes (4 KiB)  Modified: 1980-01-01 00:00:00? (Y)es / (N)o / (A)lways / (S)kip all / A(u)to rename all / (Q)uit?“As mentioned the

I’m using an Oracle non spatial reader in FME Desktop 2019.1.3.1 to read an Oracle view. Using Oracle client (i.e. SQL+), the total count of this view is 6,982,320, but the FME Oracle reader reads in over a million less, and the total count differs each time I run it. I’ve played around with some of the reader parameters - bulk read size, persistent connection, etc. - but each run is still different. Two examples below which read in two different total numbers and while they’re close, they’re way off the total count according to SQL. Any thoughts on this?  

Hi Community,I'm working with FME 2023 and I need to snap these purple points to the closest locations along the yellow polyline. What's the best way to do this?How do I use the Snapper transformer properly in this case?Could you please share an example workspace?I've attached the relevant data—thanks in advance for your help! 

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 

Can I please have some help, I have list of attributes as example:attribute{}.name = ID and attribute{}.native_data_type =longhow can I use jsontempleter to have as output to json ID(long)? Thank you,M

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 

Hi FME Community We have a dynamic FME workbench which iterates through 89 datasets in an Oracle Database and inserts all records into datasets in a SQL Database. Some of the datasets are large (over 4 million records) and the whole process for truncate & load can take over 24 hours to run. We are looking for ways to improve the speed of this process.  We are currently using a feature reader to get the Oracle features, then using a few transformers to clean up the data (i.e. in case there are multiple geometries), then using a feature writer to insert the records into the SQL database.  How can we speed up and/or optimize this process? Is there a way to use a SQL Executor to improve the process?  

Hi Community,I’ve developed a workflow that enables me to connect to an external SFTP server and download all contents from a specified folder. I followed the guidance provided in the following post:The workflow functions well for a single folder. However, the SFTP directory structure includes multiple nested subfolders. I now need to enhance the automation to recursively traverse these subfolders. Please see the structure example below.  Additionally, the SFTP contains files in various formats. To handle this, I plan to use multiple StringSearcher transformers—one for each file type (e.g., .tiff, .asci, .las). My c

Dear FME Community,I should to optimize my job, and for that I need to make group processing with an optimization of objects numbers like that :And after, as you can see, make a parallelize of objets for not having only a linear treatment. Do you know how can I do this ? Thank you very much.

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

What is the best way to extract the path_modified_date, path_created_date, and path_accessed_date for files in a folder (these are shapefiles and zip file)? I ran the Directory and File Pathnames Reader, and it shows these attributes as missing. Is there a transformer I need to use after this Reader to extract this information?  

I have this line (the green one): And I want to calculate the shortest path from the start of the line to its end across the network (the violet one).How can I do it?What is it the right way to do it? How can I set the parameters of the “ShortestPathFinder”?attached files!Tnks 

We have been using FME 2021.2 ( build 21789) and recently upgraded our SQL database to 2019. We started seeing timeout errors when the FME writer tries to connect to the SQL Server and keeps saying 2023-10-16 15:04:58|  2.2| 0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using Microsoft OLE DB Driver for SQL Server...We use windows scheduled task manager to run our jobs and this is causing some of the jobs block other FME jobs. Any ideas on what may be the issue.  Thanks,AD