Skip to main content

FME Form

A space to discuss FME Form

10000 Posts
nath
Contributor
nathContributor
asked in Transformers
Attribute pivoter

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?

281
nath
Contributor
dsign-world
Contributor
dsign-worldContributor
asked in Authoring
Dynamic Workspace: Wrong number of features written

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=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-SQLCreator 1===================

344
dsign-world
Contributor
aron
Supporter
aronSupporter
asked in Authoring
How do I change shortcuts in Form?

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.

261
j.botterill
Influencer
joe_cast
Contributor
joe_castContributor
asked in Transformers
Create vertex on existing line feature

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.

777
joe_cast
Contributor
bruno
Contributor
brunoContributor
asked in Data
IfcZone writing

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

232
bruno
Contributor
aawad.93
Contributor
aawad.93
asked in Data
ChangeDetector Still Flagging Geometry Changes Even with Lenient Matching and Vector Tolerance

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!

714
crystalatsafe
Safer
tnarladni
Enthusiast
tnarladniEnthusiast
asked in Data
Date written as text in excel

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 text I 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 still writing out as a

45620
crystalatsafe
Safer
F
felixderglueckl
asked in General
Meaningless error (Error running translation)

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 als

171014
crystalatsafe
Safer
tim.albert.vaa
Contributor
tim.albert.vaaContributor
asked in Data
Format Text File where Column Names are Repeated on Each Row

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-row I 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?

837
ebygomm
Influencer
andreaw
Contributor
andreawContributor
asked in Data
Missing OSM lines with OSMPBF reader

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

403
kailinatsafe
Safer
dsign-world
Contributor
dsign-worldContributor
asked in Authoring
Error using dynamic writer: POSTGRES Writer: Fanout for feature type '...' failed to find feature type template '...'

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 details I 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 `Defa

505
nielsgerrits
VIP
salah.elfarissi
Contributor
salah.elfarissiContributor
asked in Transformers
Primary Key name from User Parameter in FeatureWriter User Attributes

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)

332
salah.elfarissi
Contributor
aron
Supporter
aronSupporter
asked in Transformers
How do I get Visual Preview and Data Inspector to work properly in Form 2025.0?

[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 s

270
aron
Supporter
xproch40
Contributor
xproch40Contributor
asked in Transformers
Qgis in FME calling pythoncaller

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

1155
steveatsafe
Safer
rmpayaby
Contributor
rmpayabyContributor
asked in Data
Reading and IFC-file, reproject it and write back to new IFC-file

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?

511
daveatsafe
Safer
fchevaillier
Participant
fchevaillierParticipant
asked in Integration
Esri ArcGIS Online Connection HTTP Error: SSL connect error

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

271
donalmateer
Safer
jurkiewiczcraig
Contributor
jurkiewiczcraigContributor
asked in Transformers
Raster Calculator not calculating all files that were input

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!

162
jurkiewiczcraig
Contributor
tomraaymakers
Participant
tomraaymakersParticipant
asked in Transformers
Detecting the Geometry of a Feature Class in a FeatureWriter (ArcSDE Geodb)

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? Example Interestingly, 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!

402
ebygomm
Influencer
salvaleonrp
Enthusiast
salvaleonrpEnthusiast
asked in Transformers
Create a 3D polygon and flat from dimensions

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.

1086
3d_ff
Contributor
vdeyepc
Contributor
vdeyepcContributor
asked in Data
MapInfo transformation not reading right Coordinate System

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.

406
daveatsafe
Safer
tris_w
Contributor
tris_wContributor
asked in Transformers
LengthToPoint transformer - multiple rejected ports

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.

293
tris_w
Contributor
vosgeo-analyses
Contributor
vosgeo-analysesContributor
asked in Transformers
Custom transformer Community Publisher name not showing

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

302
donalmateer
Safer
jspratt
Participant
jsprattParticipant
asked in Authoring
MULTI_WRITER was not specified error: Why do I need it? How do I resolve?

I'd like to understand what this error means in the following context and how I might go about resolving it. I have a workspace that works perfectly fine if I run using cached features up to transformers just prior to a FeatureMerger then run from the FeatureMerger to a writer. However, when I try to run the entire workspace it results in an error that aborts the translation at the writer. I've also tried many other methods of joining these 2 streams and all are resulting in the same error output. MULTI_WRITER: No MULTI_WRITER_TYPE{*} or MULTI_WRITER_TYPE{3} was specified It seems like I need both streams to be ready at the FeatureMerger at the same time but I have not been able to gain control over execution order or block passthrough features through a variety of attempts. The goal is to read from both a CAD model and a DB, then compare the two datasets on a unique key, then write an SQL statement to a text file or SQLExecutor. I've only attempted this with the text file writer while

5066
jnknnn
Contributor
howeitzor
Contributor
howeitzorContributor
asked in Transformers
How to iterate though a list of strings read from an Excel doc and attribute filters

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.

324
howeitzor
Contributor
albinepro
Supporter
albineproSupporter
asked in Authoring
Multiple conditions for conditional user parameter

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.

463
albinepro
Supporter

Helpful Members This Week

Badge Winners

Show all badges

Popular Tags

Community Stats

31,153
Posts
118,100
Replies
38,771
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.