FME Form

I have a list with values in an attribute which contain diacritics. I would like the user to be able to choose multiple values and then upload it to Flow for self service data download. However, when I open an oracle spatial reader in Forms and use the where clause to add them it doesn't work.What would be the best way to solve this?The where clause of the reader is now as follows:"active" in '$(choose_status)' and "municipality" in '$(choose_municipality)'both attributes are strings and published parameters the list includes only values from the oracle table ‘allow multiple selection’ is on choice list delimiter is ',’ default value is a municipality with diacritics.The first (choose_status) works. The second (choose_municipality) contains diacritics and does only work for values without diacritics.I also tried a Tester (municipality in $(choose_municipality)) but it also only works for values of municipalities without diacritics.

Would be great if Regex Editor and AI assist was added into AttributeTrimmer rather than having to use the Regex functions in text editor, which are clunkier. In fact, it could go in any and all string transformers where you are trying to identify, use or replace a substring. 

Hello,I need to make a model but I honestly don't really know how to start it. I will try to explain.I need to create groups of “municipalities” whose data should be published together. I already have a list of which municipalities is intertwined with which municipality based on geometric overrides but the same municipalities may be intertwined with another municipality, which in turn may also be intertwined with another etc....Eg Municipality 1 should be charged together with municipality 3 and municipality 4. I have this list, but then I also have to search in the same list if municipality 3 should also be charged with other municipalities, in this case yes, together with municipality 6 and municipality 7. Then I have to do the same for borough 4 and borough 6 and borough 7 and so on until I have everything and can then make it 1 group. Is this clear? Can somebody help me with this model or give me a tip how to start it. I attach a sample of my starting table “Samen publiceren”I alre

I’ve come across an issue a couple times where the Oracle writer appears to go stale after a few months of working fine. Has anyone else come across this issue and do you have a better fix than mine?Problem: I run an FME workbench that writes data to Oracle, the workbench completes successfully and the log file tells me fme_features were written. When I go look in Oracle to confirm the deltas, the records were not changed.Current fix: If I replace the Oracle Writer and re-run the workbench then the records in Oracle do get changed. Any help would be appreciated

I wonder if anyone knows a knows what would be a good format to write out solid geometry. I have worked with filegeodatabase but that is multipatch. I need spatial indexing to be able to use a spatial intersect with a feature reader. So a big dataset with solids where we often only need a few of.The multipatch feature class (FGDB) kind of works but then I need a solidbuilder and that takes a lot of time.Thank you!

Hi Community!I'm working with two sets of polylines, but not all of them match perfectly.I'd like to identify, using FME, the polylines that do not align (Non-Overlapping).Is it correct to use the SpatialFilter transformer for this type of comparison?If so, how should it be properly configured?I've attached the data I'm working with:the red polylines (RtesType1.shp), which do not match, are located in the area highlighted by the black circle.The polylines I'm comparing them with are the ones in cyan (RC.shp).Thanks in advance for your help! 😊 

Hello everybody,I'm trying to replicate the functionality of the Aggregate tool in ArcGIS Pro within FME, specifically for raster data. I want to aggregate using the Sum method, meaning I want the output cell value to be the total of the input cell values. I also want to apply a cell factor of 10, which means the resolution will be reduced by combining 10x10 cells into one.In other words, I want to decrease the resolution and calculate the sum of every 10x10 block of cells.I’ve tried using a combination of the RasterResampler and RasterCellValueCalculator, but the results don’t seem to match what I expect.Thanks,Philip

FME WorkflowHi, I would like some help with PythonCaller.  I have a workflow where I read in feature classes from an Esri file geodatabase, combining the features into a single attribute to make it dynamic.  I filter out annotation, resolve domains and rename original domain fields, map empty and missing features to Null, then use AttributeFilter to split by FME Feature Type.My next desired steps are to identify, for each FME Feature Type, which attributes are nulls, and remove those attributes, then connect all splits to a Writer to write out to shapefiles grouped by FME Feature Type.I am trying to use PythonCaller to remove the null attributes.  It stores the attribute names in a list, and stores in a dictionary called alnum_tracker attribute names and whether they contain data (where they are saved as True), before comparing the list of attributes to the dictionary, deleting any that are not matches.  I’ve tested it and it is grabbing the correct attributes to delete and keep.  The

Hello, I have a workbench with the following elements :1 Excel writer based on a template file, and with option “Overwrite Existing File” set to Yes (mandatory to use a template). 8 Feature types writing to 8 different sheets of the same Excel file.As I’ve seen in other posts, this configuration should work.However, when I run the workbench, only one sheet is filled in the final excel file. If I run the writer Feature Types one by one, they do write their own sheet and remove the others. Can someone tell me what is wrong in this configuration ? I use FME Desktop 2021.2.   

Hi FME Community,Our team is looking to connect with users who have working experience with the Protobuf reader. If you’ve used it in your workflows or projects, we’d love to hear about your experience!We’re especially interested in:How you’re using the reader in real-world projects Workflow examples or use cases Performance insights Any challenges or suggestions you may haveIf you're open to sharing your thoughts - or even jumping on a quick call - please comment below or send me a direct message.About ProtobufProtobuf is a compact, open-source format developed by Google for serializing structured data. It is widely used in APIs, messaging systems, and IoT applications where efficiency and portability are important.The new reader supports .pb (binary) and .json data files defined by .proto schemas. It works with Proto2, Proto3, and Editions 2023. Geometry is not supported.Available in build: FME Flow 2025.1 (Build 25587+)

The documentation is absolutely correct: "When Workbench opens, it displays a Start tab. The information is generated from a live web page, so this tab will always display the most up-to-date FME news, downloads, and resources". But here it is: I have come to dislike the "Start tab" with passion (gusto?). When I open Workbench, I always want to start a new workspace and get on with my project or task. And every time, I also have to either close the extra tab, or choose to create new workspace before I can do so. It didn't bother me the first few houndred times. Only when I fist noticed this little "additional click" with the mouse, did it start to bug me. As I couldn't locate the solution myself, I turn to my FME-colleagues out there for help; please preserve my sanity. Illustration of the main three ways I don't want to start my work added below. It is just one of those little things that start getting at you. Like the special hum from the r

Hi, I have a pointcloud where I want to count the unique number of values in a component. In this case I want to find the number of unique GPS time values in a point cloud (The point cloud is made from individual epochs of a lidar scanner, but there are time gaps so I cant use the max/min values) Basically is there something like the hub transformer AttributeValueCounter (which doesn't work on components). I do not know how to use python so I can't work out how to edit their method to work on components rather than attributes I can kind of do it by using the PointCloudSplitter and counting the files, but this is really slow Thanks

Hello everyone! I'm a novice in FME Form/Flow. Maybe somebody can help me.I have a workspace that has multiple PostgresSQL readers, and these readers have a reference to the User Parameter in the WHERE clause.This workspace is published to FME Flow and triggered by an Amazon SQS trigger. The SQS message content is a JSON with parameters that are required for the readers in the workspace.My question is, how do I pass/parse incoming content to separate parameters in the workspace?

I have generated a raster that has integer data values between 1 and 6 and needs a nodata value.  As the RasterInterpretationCoercer has a “Data Interpretation Type” of “Int8” I thought my task would be as simple as:Use the “RasterBandNodataSetter” to set the Nodata Value of -128. Use the “RasterInterprationCoercier” with the Data Interpreation Type of “Int8”. Use the GEOTIFF writer to output a tif file.When I try this type of workflow and then use FME to read the generated tif file, I find that the raster band is written with the type Uint8 and that my data value has been changed to 128.  I am using FME 2025.0.3.Is it possible to get the GEOTIFF writer to write raster data with the datatype of int8 and a negative Nodata value?  If not, which raster types in FME will allow this?

Hello, does anyone know how to configure the Clipper function to split planes with 3D lines, which these planes intersect? The one input is a set of 3D planes and a another input is set of 3D lines.

Hello,I would like to know if the IfcZone are managed with the version 2024?Best regardsBruno

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 ? Thank you very muche.

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 Mike

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 the lowercase in DBeaver and connecting fine. I’ve also tried the scheme DBO, “dbo”, “DBO”. There is another schema in the database

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. It also works fine when the SQL is included in the writer to run after writing. In some instances, I can using the run after writing approach, but in others I do need to do standalone calls to the db to manipulat

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.