FME Form

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?

I have a road network (lines) that i need to convert into points for labeling reasons.I have managed to do this using DistanceMarker but I want to be able to save the orientation angle of the line as an attribute in each point. So that when i use the points for labels, I can tilt them correspondingly. Since the lines are rarely straight, I want the orientation in the specific point.Any advice for how to apporach this?

Hi all and Safe.I just revisited some INSPIRE docs, that specifies the projections used for data here.In Denmark we often use UTM 32N, but there are two basically identical EPSG-definitions: 25832 and 3044. We normally use the former, while INSPIRE only uses the latter.The only difference is that 25832 is given as Easting,Northing, while 3044 is given as Northing,Easting.I tried a simple reprojection workspace, entering a 25832 point, reprojecting it to 3044, and extracting its WKT. And it was still Easting,Northing !Doesn’t FME handle such coordinate value swaps when reprojecting, or is my setup flawed ?Cheers.

Working with FME Form 2023.2.2.Comparing features using a ChangeDetector transformer I see a weird behaviour. It does not always happen though but can’t see a pattern.I see features correctly output though Updated and Inserted ports but all of them have value ‘INSERT’ in fme_db_operation attribute. Has anyone experienced something like this? 

I have a list and with ListSearcher i found that element with id {_list_index} needs to be removed completely from the list. How can i achieve this.

I am trying to intersect 3D Polylines and Solid Cubes to determine which cubes are touching the polylines.So far I tried Clipper, intersector, SpatialRelator and SurfaceOnSurfaceOverlay. All the features are ending in the rejected port as invalid geometry.What is the right way to accomplish this task?

Hi all,I’m exploring a workaround to split a polygon based on a 70/30 area ratio:70% area → Type A 30% area → Type BSome visual explanation is included below.The geometry of the split doesn’t need to follow a specific direction — any orientation is fine as long as the 70/30 ratio is maintained.Has anyone come across a method or workaround to achieve this?Thanks! 😊

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