FME Form

Hi, why does the attribute pivoter no longer work? I have already read several questions about this.  There is an alternative somewhere with the aggregator, but that doesn't work very well for me either.  Isn't there an easier way or a reason why the pivoter doesn't work?

FME tells me that there was 1 feature written to the database, but it is not true. In my opinion that’s a bug because the statement is objectively wrong.In this case the translation failed because of an error. No features were written to the database. No table was created. I guess FME counts the schema feature, although it is NOT written to the database.Here’s a part of the log and the workspace is attached.POSTGRES Writer: Fanout for feature type 'SQLCreator' failed to find feature type template 'schema_from_query'POSTGRES writer: An error has occurred. Check the logfile above for detailsSuccessfully closed POSTGRES database writer=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Feature output statistics for `POSTGRES' writer using keyword `POSTGRES_1':=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Features Written=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-SQLC

Is it possible to change the keyboard shortcuts in FME Form?There are some important shortcut that rely on function-keys. With the rise of compact keyboards I am not the only one who has done away with that row.

Hello all,I have some point (electricity poles) and line (overhead conductors) features which I need to connect up for our utility network model. I am trying to insert a vertex on the line at the nearest point to the pole. I have a neighbor finder and vertex creator, but neither are actually adding a vertex to the line (the neighbor finder has insert vertex on base feature set to yes). Is there something I am missing or another way to go about this?thanks. 

Hello everyone,I’m working in FME 2023.2 and using the ChangeDetector to compare features coming from PostGIS and ArcGIS Online (AGOL). Visually, the geometries look identical (no edits were actually made), but the ChangeDetector keeps reporting that a large number of features have updated geometry.I’ve already tried:Turning on Lenient Geometry Matching in the ChangeDetector Setting Vector Tolerance to a small value (like 0.0001 - Takes more time)While that helped reduce the count somewhat, I’m still seeing a substantial amount of features flagged as updated when they shouldn’t be.I suspect it might have to do with differences in ring orientation, vertex ordering, or the presence of Z/M values, but I’m not certain how best to address these discrepancies so the ChangeDetector recognizes that there hasn’t really been a change.Any suggestions or advice on how to make the geometry truly match (or be treated as unchanged) would be greatly appreciated. Thanks in advance!

The process is to read from a sql database, write to excel file, then import that excel into another software.The software expect one of the fields to be a date field. The data coming out of the database is datetime.I used the DateTimeConverter to go from 20190101000000 to 01/01/2019. I'm using an excel template so I'm setting that field to be of type date. The writer in the workspace is set to be of type date. But the data that is written is text. I can tell it is text because it is left justified instead of right. If I click into the cell and press enter, the data is then right-justified and I'm able to import the excel into the software. I've looked up this issue and the most common solution I found is to do a "Text to Columns" under the Data tab in excel. I did this in the template, but the data written is still a textI thought maybe it was the DateTimeConverter transformer, so I created a view in the database to make it a date instead of a datetime. It is

Hello together, I'm a bit confused. I have a workbench where I merge attributes from 3 data sources. The result should being saved in an FFS file. But the workbench throws an error at the end which is completely meaningless to me. This is the end of the log file:Translation was SUCCESSFUL with 25 warning(s) (919246 feature(s) output)FME Session Duration: 35 minutes 27.1 seconds. (CPU: 1867.5s user, 275.9s system)END - ProcessID: 25060, peak process memory usage: 17993084 kB, current process memory usage: 307928 kBTranslation was SUCCESSFULError running translation.On the one way the translation seems to be successful, in the other way there is an error running the translation. One strange thing is that there are two instead one FFS file being created by the writer of the workbench: Output.ffs (with 39 FTS files) and Output_1.ffs (with 9 FTS files), although I defined just the Output.ffs in the writer. In spite of the error I tried to load the Output.ffs into the Data Inspector. I also 

I have a text file that looks like this:"CommonCode":"EI","IATA":"EI","ICAO":"EIN","CarrierName":"Aer Lingus""CommonCode":"AM","IATA":"AM","ICAO":"AMX","CarrierName":"Aeromexico"I want it to look like this:CommonCode IATA ICAO CarrierName EI EI EIN Aer Lingus AM AM AMX Aeromexico I want it to create the column names dynamically from the text file as the column names will change and increase or decrease in number.In R there appears to be a command called:  “unsparsify”   Which according to this post seems to do it.https://datascience.stackexchange.com/questions/55879/file-format-where-column-names-are-repeated-on-each-rowI can do it using a combination of AttributeSplitters, ListExploders, ListIndexers, AttributePivoters and AttributeExposers.   But I can’t seem to get away from having to Explicitly input the Attribute names in the AttributeExposer and I need it to be dynamic.Any ideas?

When i import OSM.pbf data in FME with the OSMPBF reader the following warning pops up:During translation, some features were read that did not match a reader feature type in the workspace.  This can happen if the reader dataset is changed, or a reader feature type removed or renamed.When i open the data in QGIS, the missing lines are there. Version 2024.2

POSTGRES Writer: Fanout for feature type 'SQLCreator' failed to find feature type template 'schema_from_query'POSTGRES writer: An error has occurred. Check the logfile above for detailsI tried to create a workspace using a dynamic writer (see attachment) but I get the error above. The writer uses following parameters:Table Name: `@Value(fme_feature_type)` The `fme_feature_type` attribute contains the value `SQLCreator` on my features because I use an SQLCreator to read the features.   Schema Sources: `Schema From Schema Feature` I’m using the schema feature from the SQLCreator.   Schema Definition Name: `schema_from_query` I think the schema definition name refers to the attribute called `fme_feature_type_name` on the schema feature. This attribute contains the value `schema_from_query` when using the schema feature from the SQLCreator. I have also tried to leave the Schema Definition Name field empty in the settings of the dynamic writer’s feature type. In this case it defaults to `De

Hello,In FeatureWriter, User Attributes,I want to use a User Parameter as the name of my primary key.User Parameter (in french: Primary key name)Feature Writer (not working) 

[Edit] I solved this by fiddling about. Se solutions at the bottom. Will leave post as is, incase it can be of help to someone else.Visual Preview and Data Inspector are behaving very erratically on my computer in Form 2025.0. Bordering on making the software unusable.Some of my issues:One specific to a workspace Today Form refuses to show the results from inspectors inside Custom Transformers, it will only show those in Main. This worked fine yesterday. Only difference is a computer restart.This issue prevails if I open the workspace in 2024.2. I created a new empty workspace and got the previews working from within Custom Tranformers.The issue below goes for all workspaces. Form is behaving like a raging toddler when I try to turn on Enable Feature Chaching. I try to get it to work with me by clicking the setting over and over and over again, but it just resets and does noting each time I press run. Then suddenly it complies without me understanding how that happened.There is simply

Hey, I’ve been trying to get FME (Feature Manipulation Engine) by Safe Software to use Python libraries from QGIS (like qgis.core) so I can mix their cool features in my temp.fmw workspace. The idea is to use QGIS’s Python (version 3.9) inside FME by setting it up with PowerShell commands. But it’s not working, and here’s why, explained like I’m talking to a 5-year-old and then a bit more grown-up:The Toy Box Story (Simple Version)Imagine Python is a kid who needs toy helpers to do jobs—like QGIS toys (for maps) and FME toys (for data tricks). These toys are called DLLs (little helper files). I want Python to borrow toys from both QGIS’s toy box and FME’s toy box at the same time.Step 1: I told Python, “Look in QGIS’s box (C:\Program Files\QGIS 3.32.0\apps\Python39) and FME’s box (C:\Program Files\FME\python)!” That’s like setting PYTHONHOME and PYTHONPATH.Step 2: Python found some QGIS toys (like qgis.core), but then it yelled, “Where’s my Qt5Core.dll toy? I can’t play!” It’s like a t

I am reading an IFC-file using a FeatureReader with the following configurations: I am using the <Generic> port to connect it to a Reprojector-transformer. After reprojecting it, I want to use a FeatureWriter and write it as a new IFC-file. I am however stuck on how I should set up the FeatureWriter. I have managed to get a new IFC-file, but the file size is quite small. I am interested in automating the process, and want the FeatureReader to accept any types of IFC-files. Any tips on how I can solve this?

Hello All,I am trying to create an ArcGIS Online connection but get this error after signing in. Has anyone seen this? I am able to sign into ArcGIS Online successfully in the web browser on this machine. CC: ​@salvaleonrp 

In my workbench I am taking points, buffering them, and using those buffered areas to clip small portions of a raster mosaic.  After clipping I then run a raster calculator on each of those points  to find the sum, mean, min, max range, etc and create an excel file with all the values calculated and collected. My workbench runs successfully, however in several of my datapoints I get empty rows with no stats being calculated.  When I check the area in ArcGIS Pro there aren’t any null values in those areas and it runs without any issue.  I have tried using RasterBandCoercer to change any null values to 0, rasterbandnodataremover, and nullattribute mapper to help deal with these issues but none of them give me results that I can actually use without skewing the data and giving me invalid results. Does anyone have any suggestions or ideas on how I can fix this issue? Currently running FME(R) 2024.0.1.0 Thanks! 

Dear FME Users,In our organization, we frequently work with Esri Geodatabases, and we often use FeatureWriters to write data to these databases. This process has always worked smoothly for us until we updated our FME Form to version 2024.2. Since the update, we've encountered an issue where the geometry of a feature class is no longer auto-detected when adding a connection to a .sde file (we always embed these connections) and then adding a feature class from the dataset. Previously, this functionality worked perfectly, and we appreciated not having to manually set the geometry.Could this issue be related to the version of FME Form, the transformer itself, or are we possibly missing a setting in the FeatureWriter setup?ExampleInterestingly, when we select a table without geometry, it is auto-detected as a 'geodb_table'. However, for some reason, geometries are not being detected.Any help would be appreciated!

Given the height, length and width of an underground vault, I'd like to create a 3D box of the vault. I'd also like to create a flattened box out of the same dimensions.I've started out with a creator, cloner and a 2dBox replacer then a 3D extruder for the box. I'm a bit lost with the flattening of the box in a 2d plane. Any suggestions on how to get the bottom corners of boxes 1,2,3, & 4 align with the corners of box 5?The bigger challenge is how to project this so I can draw this in a DWG file later in my translation. I have a lat/long as the center of each vault and I could probably start at zed value of 0 initially.me dimensions.

Hello FME Folks,This is related to MapInfo Tab files. Since we upgraded from FME 2018 to FME 2024.2.1. The MapInfo coordinate System (Non Earth Meters) are not detected which used to happen in FME 2018. Instead it is taking wkt_auto_1 and is misaligned. Please let me know what changed.

Upgrading 2023 workspace to 2024.2.  When upgrading or adding a new LenghtToPointCalculator transformer and referencing existing attributes for the X/Y coordinates, FME adds 2 rejected ports to the transformer.  If you then run the workspace you get the error:Cannot have multiple factories with the same name.  Multiple factories were assigned the name 'LengthToPointCalculator_<Rejected>'  Any suggestions on how to get only 1 rejected port?Thanks.

Hi everyone, I've just uploaded my very first custom transformer to the FME hub which I'm very excited about. However when downloading the transformer it doesn't show my name next to the community publisher. Any idea how to show my name there?A lot of time went in this transformer so a little bit of credits would be nice :) 

I have a workbench that creates a table based on a number of joins that are on occasion, filtered on an attribute. Instead of manually entering the attribute values, I’d to read a list of attributes from, say, an Excel doc e.g. NSG001, NSO001, TES001 so I don’t have lots of duplicated transformers. How do I iterate through a list of values and plug them into FeatureJoiners without duplicating lots of stuff. 

Is there any option how to set multiple condition for visibility of user parameter? I need some parameters to be available for two choices of another parameter. I could define another connection parameter but i have to use it in same readers and writers of workspace.- is there a chance for some workaround?I can’t merge these two choices, because there another flow for each one of these two.I know thers new feature in FME 2025, but we recently upgraded to last major 2024 version. Probably we’ll be waiting for another release of 2025.

I’m working on an analysis to determine the correct calculation for elevation gain and loss along a line representing a real-world route (such as a trekking, marathon, or MTB course). I’m using FME and have two source vector datasets: a GPX file that already contains Z values for each vertex and a PostGIS line to which I need to assign elevations from a DTM (Draper). Is there a standard workflow for this type of calculation?

Hello, I have a SharePoint List that I am already using. Can FME be used to update this list? What Transformer(s) would I use? At this stage, I am looking for general information to help me get started, so anything you can provide would be excellent.