FME Form

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)?

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!

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.

Hello to all,3 months ago, kailin told me that the 2024 version did not allow writing zones. I would like to know if it is the case now. If not, what is the planned schedule because for the moment we are blocked for the enrichment of our models Best regards Bruno

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 transformers.

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

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

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

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 B Some 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! 😊

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

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!

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 AttributeManager but this would require manually changing the workspace anytime a new dataset is being processed, as the names

Good morning. I’ve been testing lately a FME Flow 2024 version. When writing “Date” field types using the ArcGIS Online Feature Writer, the following warning masked as an error is thrown: D:\code\fme\source\engine\plugins\python\fme-arcgisonline\src\arcgisonlinefeatures\arcgisonlinefeatures_rest_writer_helper.py:557: DeprecationWarning: datetime.datetime.utcfromtimestamp() is deprecated and scheduled for removal in a future version. Use timezone-aware objects to represent datetimes in UTC: datetime.datetime.fromtimestamp(timestamp, datetime.UTC). The FME 2025 Change Log shows this entry: It only mentions the Reader. Would it be possible to know if that deprecation was solved for the Writer, too? Thanks!

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! 😊

Dear all, I am trying to do something that seems very simple :I have a table that has 3 columns “id”, “category”, “value” and I would like to reshape it in wide format “id”, “category.A”, “category.B”, etc. (in R, it would be reshape(dt, direction=”wide”, idvar=”id”, timevar=”category”) I have tried the AttributePivoter with the settings : Group rows=id, group columns =category, attribute to analyze = value but it does not work, in the output I still get the 3 columns id, category, value with missing values everywhere in the category and value columns what am I doing wrong ? would another transformer do the job ? thanks in advance

Hi All, I’m having an issue writing out to GDB with a schema dataset. The workflow extracts multiple GeoJSONs from some GSI open Datasets (example path below), clips them to an AOI and extracts them to a GDB. There are around 50 datasets in total . The actual reading of the data seems fine: data features = Geojson format read through a feature reader schema reader = Schema Feature (Any Dataset) format reading the Geojson (n.b. when reading using the schema port of the feature reader, I can’t get it to read schema from multiple datasets, hence why have this separate) I am writing through a FeatureWriter - see settings in screenshot below. The annoying thing is that sometime it works, then I select a new set of features and then it doesn’t, and I can’t seem to find a pattern. However checking the input table before the Writer, everything (I think) looks ok. It feels like there must be something that is not right, but just can’t seem to pinpoint it. Any ideas would be greatly appreciated

Is there any way to get the “path” of a transformer so that it can be reported for a custom error logging solution. The standard FME log file has this information but I can’t find any way of getting at it inside a workspace. For example, in the image below we can see log lines being reported from a ParameterFetcher transformer which is inside the Log_Error custom transformer. If I could even just get the name/instance of the custom transformer that would be helpful but something really useful would be to have access to the <prior> transformer. I’ve seen some other posts on this topic which talk about hard-coding log messages but it would be nice to have a more automated approach and those posts are all from before Safe changed the way log files work to include the links to the transformers…. I guess what I’m really looking for is access to something like the FME equivalent of a stack trace from any point within a workspace.

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

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{}…

FME Workflow Hi, 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 Py

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 have If you're open to sharing your thoughts - or even jumping on a quick call - please comment below or send me a direct message. About Protobuf Protobuf 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 refrigerator you don't notice until someone c