FME Form

Hi everyone!I have some "from-to" path features (FROMTO.shp) that I need to use to calculate the shortest path across a network (NW.shp).However, it doesn't seem to work for all 4 features (just one), does anyone know why?I've attached the files for reference.Thanks in advance!

Hello,I am trying to string together attributes. The difficulty is that the attribute names can vary by dataset.Generally what i am trying to do is that may look something like this:DEPTH [m] Measurement 1 Measurement 2 Measurement 3 Measurement 4 0.5 <NULL> 1 4.5 2.1 1 <NULL> 2 2.3 2.2 1.5 3.5 1 1 2.1 2 3.0 1 4.5 <NULL>  What I am trying to accomplish is something like this DEPTH [m] Measurement1 DEPTH [m] Measurement2 DEPTH [m] Measurement3 DEPTH [m] Measurement4

 Hi ,I'm building a workspace in FME where I need to copy multiple tables from an SDE geodatabase to a File Geodatabase (GDB). I use an Excel file to map the source and destination table names.Excel structure:Tablename Destination SDE_TABLE_1 GDB_TABLE_1 SDE_TABLE_2 GDB_TABLE_2  Workflow: I read the Excel file using a FeatureReader to get the list of tables. For each row, I use another FeatureReader to read the source table from the SDE using the Tablename attribute.

I’m working on a project where I need to replicate the table structure from an Oracle to SQL Server but without transferring any data. Essentially, I want to: Read tables from Oracle, recreate the same tables in SQL Server and write only the schema (field names, data types), not the records   Is there a best practice to force FME to write only the schema? Are there limitations I should be aware of (e.g. no support for constraints, indexes)?  

In FME 2025.0, it was mentioned that the IFC API Reader was updated to support reading IfcOpeningElement. However, in the latest version, 2025.0.3, the IfcOpeningElement feature still cannot be read. No matter what reader parameter options I adjust, it does not work.I have tried checking or unchecking the "Advanced - Subtract Opening Geometry" option in the reader settings, but that didn’t solve the issue. I have also tested several IFC versions, including IFC 2x3, IFC4, and IFC4x3_ADD2, but the IfcOpeningElement is missing in all of them.Is there something I might have missed? 

I have a road centerline dataset and RIF network data (one file per year) that includes from_dfo, to_dfo, and ria_rte_id. There are no common fields between the datasets.I’ve already done a manual match for 2022, where I assigned the starting and ending dfo values (from_dfo, to_dfo) from the RIF layer to each centerline segment — not the in-between segments, just the overall start and end for the full centerline geometry.Now, I’d like to automate this for other years (e.g., 2021–2017, 2024). My requirements are:Only extract the overall start and end DFO values for each centerline segment.One centerline may span multiple RIF segments, so I want the minimum from_dfo and maximum to_dfo from intersecting RIF features.There are no shared IDs, so I assume the match must be based on spatial overlap.Is there an efficient way to do this in FME, using spatial join and aggregation (min/max)? Any recommended transformers or workspace suggestion?T

Hi everyone, I have a parent workspace that looks like a series of FMEJobSubmitter transformers:Each FMEServerJobSubmitter set up at below:Submit Jobs: In SequenceWait for the Jobs to Complete: Yes When I call this parent workspace from the Web Interface, something weird is happening. First job gets submitted straight away and it becomes Completed after a second. Then the second one will only appear in Running jobs after about 45 seconds. It is not in the Queued and one of the engines is not doing anything.The same case is happening for the rest of the workspaces - they will only appear in Running after about 45 seconds once the previous one gets Completed.It is worth mentioning that we install

Is there a way with an ArcSDE Reader with an archived clause to expose the attributes GDB_FROM_DATE and GDB_TO_DATE ?Thanks

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…

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 (mu

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

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 sav

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 p

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.

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