FME Form

i have an excel sheet and want to make some sums and write them in another new attributei want to sum row O from start to line above an attribute in row M wich is VU or VD...so e.gsum 1 = light bluesum 2 = light blue + dark blue and so on till the next line which is one above a line with VD or VU…...i hope i have explained it not to difficult…...i think the hard part for me is that i need always a sum from the beginning again Thank you and greetzfranco

I have a point location and I would to find the 20 mile extent from that point across a road network. Effectively, I want to create a 20 mile buffer around my point but it must use the road network to determine the distance in all directions. I have tried creating distance isolines using the NetworkCostCalculator and ContourGenerator but this didn’t seem to work very well with a large distance specified (contour interval of 20 miles equivalent). Does anyone know how I might be able to do this?

I have a problem. First my FME: It is partly in Dutch, but it doesn't matter here. It is about spatial data with some features. There are two feature readers: the first one to select features which fall within a pre-defined contour, the second to select features. The attribute manager to add some attributes. The featurewriter to write the data in gdb format. In the FeatureReader you can see attributes for “pand_v” and for “scheiding_v”. The attributes of “scheiding_v” are standard, hence the same for other features, except for “pand_v”. The difference is that in “pand_v” BGTPlusType is replaced by “identificatieBAGPND”. The features are of several geometric types: lines, polygons and points.In the output of FeatureWriter all the attributes as given in the AttributeManager are shown. I'd like to see that for “pand_v” no BGTPlusType is given (there is no value here) and that for all other features no “identificatieBAGPND” is shown. And that some other attributes like fme_…, attribute{}…,

Hereby a short description of my workflow with the questions at the end. I have created a TIN from points. (TINGenerator)Then clipped it with polygons (water area). (Clipper)The water polygons have been lowered to -1 meter with the 3DForcer.With a Junction I collect both the water (3D Polygon) and the TIN (surfaces). Here are my questions:how do I properly merge those geometrytypes together? how do I fill up the (vertical) gaps between the lower water and the surface.I tried many transformers and different steps, but as you can guess, with no results. Using: FME2024.1

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

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 <NULL> 0.5 1 0.5 4.5 0.5 2.1 <NULL> 1 2 1 2.3 1 2.2 1.5 3.5 1.5 1 1.5 1 1.5 2.1 2 3.0 2 1 2 4.5 <NULL>  Depth and measurement values can be tabstop, space ore comma-seperated, doesnt really matter. In a later step I want to route all Measurements into different features using the AttributeExploder and Aggregator while still keeping the depth information. I realise this could be easily done using the AttributeMa

 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 then use a FeatureWriter, setting fme_feature_type to the value of the Destination attribute so it writes to the correct table name.   The problem:The destination tables are created with the correct names in the GDB, but they do not contain any attributes from the source tables only OBJECTIDs. What am I missing here? My tables are in Excel and will be dynamic, so I can't simply explode all attributes manually.I have a solution using a PythonCaller, but I'm interested in a more native solution using FME transfo

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?Thanks in advance!herewith I have attached the screen

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 installed our FME server as distributed components (3-tier). If it is installed as Express, it is working fine. Any help, please? PS We are using the latest build (20596)

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

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