Skip to main content

FME Form

A space to discuss FME Form

10000 Posts
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Weekly Quiz: Round 2 Answers and Results

Hi FME'ers, Here are the answers and results to yesterday's quiz:Answers1) Which of these transformers has a Stiffness parameter? Displacer HullAccumulator SpikeRemover RubberSheeter EggBeater The answer is the Displacer transformer. This transformer is useful for moving features apart that are too close to each other (usually for cartographic purposes). The stiffness parameter controls how much a feature can be deformed in moving it. Give yourself 3 imaginary bonus points (ibp) if you knew the answer already, 2 ibp if you figured it out from what the transformers do, and 1 ibp if you typed stiffness into Quick Add and pressed tab (great tactic).You get no ibp if you went through each transformer to check! 2) The FME Mobile App that connects to FME Server is called... FME Server Express FME Data Express FME Mobile Express FME Workbench Express FME Vande Bharat Express It's the FME Data Express. It's intended to allow mobile access to Server, with some data collection capabilities too.

323
danilo_fme
Evangelist
scarter
Contributor
scarterContributor
asked in Authoring
PointOnAreaOverlayer not producing expected results

Hello Forum, I am experiencing an unexpected problem with what should be a simple point in polygon search process in FME Form. I have a Creator connecting to… FeatureReader - reading in a point dataset of 16255 records FeatureReader - reading in a polygon dataset, which covers a smaller area of what the points do The two FeatureReaders feed into a PointOnAreaOverlayer. But when I run the workspace 16255 point records are found. The number should be far smaller. Thanks.

292
scarter
Contributor
chandu
Participant
chanduParticipant
asked in Transformers
How to Perform a Utility Network Model Subnetwork Trace Using Python Caller or Python Creator in FME?

Hello FME Community, I am working with a Utility Network Model (UNM) in ArcGIS Pro and need to perform a subnetwork trace using FME. Since FME does not have a dedicated transformer for UNM traces, I am exploring options using the Python Caller or Python Creator to execute this operation. What I Need Help With: Python Script Guidance: How can I use the arcpy module (or another approach) within FME's Python Caller/Creator to perform a subnetwork trace. Are there any specific UNM functions or ArcPy methods that work best for this? Input/Output Handling in FME: i need to pass subnetwork name from FME to Python? How can I return the traced features back into the FME workflow? Environment: FME 2021.x ArcGIS Pro 3.x Python 3.x

201
trentatsafe
Safer
g_tz
Contributor
g_tzContributor
asked in Transformers
Read AEC Objects (Geometries and Attributes) in FME

I am working on feature and attribute extraction from an AutoCAD Architectural file, namely the extraction of room polygons and their attributes from AEC blocks that represent rooms. I have tried the Civil 3D reader and the reader actually sees the layer with the room AEC blocks and it shows me the available attributes correctly, alas the reader does not return any features. There are no errors, only a lot of warnings about attribute renaming because of scpecial characters. Has anyone ever succeeded in reading AEC block features and attributes? If so, how did you do it?

666
g_tz
Contributor
mr_fme
Enthusiast
mr_fmeEnthusiast
asked in Authoring
Problems with points in Bufferer

Hi, I have points created by vertex creator but my points don’t have coordinate system. I need create by points square buffers with 25 kilometers. I’m using coordinate system setter to define WGS84, after use bufferer but the error below is showed. Bufferer can’t understand my coordinate system but without the coordinate system isn´t possible to generate the buffer. Thank´s

8412
mr_fme
Enthusiast
darren
Contributor
darrenContributor
asked in Transformers
Creating a dynamic reader template

I'm trying to create a re-usable template that uses a dynamic reader to allow it to read a table from a database, the 'connection', 'feature types to read' and 'where clause' attributes would be defined before the reader but this approach seems to be causing me problems. The process so far looks like this... The FeatureReader looks like this... If I define the connection, table and where parameters within the feature reader everything works fine, the reader recognises the schema and creates an appropriate output port. Using the above approach and defining the same parameters as attributes doesn't create a output port (which I understand as how can it create a port for a feature type it hasn't read yet), next stop was the generic port but I can't seem to get anything useable out of this. I've read numerous articles on here about using a feature merger to merge the schema and the generic ports but this doesn't seem to give me anything useable either. I've also tried an attribute exploder

1332
j.m-visma
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Esri Indexed 3D Scene Layer (I3S) - Point Cloud Help

Hi All, I’m working on a workbench to help my team to convert E57 point cloud data into SLPK and publish these into a 3D Scene in Portal for GIS. Initially I was converting the E57 into LAS files and then use ArcPro to convert the LAS files into SLPK and upload them into Portal. Before doing any publishing on Portal I wanted to do a simple test on my machine to makesure the E57 point cloud export fine to my machine, I have read the slpk can be created in FME by using ‘Esri Indexed 3D Scene Layer (I3S)’ but, for some reason, I can’t get it to work. Below a screenshot of basic workflow that read the E57 and tries to export to slpk….but it doesn’t export anything? there’s no slpk at all, see below: Any ideas if I’m missing something? Cheers

466
nielsgerrits
VIP
philipwhitten
Contributor
philipwhittenContributor
asked in Transformers
ERROR : INCLUDE -- failed to evaluate TCL expression

I am getting the following error in a FME Form Workspace: Starting translation...ERROR : INCLUDE -- failed to evaluate TCL expression ` if { {-1} == {0} && {ORIGINAL} == {ORIGINAL} } { puts "MACRO REAL_MODE LAST"; puts "MACRO REAL_RATE <Unused>"; } else { puts "MACRO REAL_MODE ORIGINAL"; puts "MACRO REAL_RATE [expr <Unused> * ( -1 ? -1 : -1 ) ]"; } ' -- missing operand at _@_in expression "_@_<Unused> * ( -1 ? -1 :..." (parsing expression "<Unused> * ( -1 ? -1 :...") invoked from withinexpr <Unused> * ( -1 ? -1 : -1 ) invoked from withinif { {-1} == {0} && {ORIGINAL} == {ORIGINAL} } { puts "MACRO REAL_MODE LAST"; puts "MACRO REAL_RATE <Unused>"; } else { ...Program TerminatingTranslation FAILED. In a general context , what does this error mean? What are examples of issues that can trigger it and what FME form workspace design approaches eliminate it? In the specific workspace, if I progress through the workspace from beginning to end using the “Run To This” option on each transformer t

234
philipwhitten
Contributor
sussexpete
Contributor
sussexpeteContributor
asked in Authoring
FME Workbench and other FME Form software broken by VMWare Tools

Since updating our FME Form host computer with the latest version of VMWare Tools, FME Desktop, FME Data Inspector, and all other FME Form GUI software does not run. We briefly get a spinner and then nothing. The problem was noted on FME version 2021 but is a problem with all version of FME Form up to the latest version FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64). It is still possible to run Workspaces in batch mode. The issue seems to be with OpenGL as indicted in the log, below. I would be interested if others have the same issue and, if so, how the issue can be resolved. Here is a snip from the log file: VMWare Tools v12.5.0.24276846 Faulting Module = vm3dgl64.dllWorking Version = 3.5.3.2 Faulting Version = 3.6.0.0 Event Log: Faulting application name: fmeworkbench.exe, version: 2021.7.41.21614, time stamp: 0x60f7b7a5 Faulting module name: vm3dgl64.dll, version: 3.6.0.0, time stamp: 0x66a16726 Exception code: 0xc0000005 Fault offset: 0x0000000000e3696d Faulting process id: 0x

511521
nia.colebrooke
Safer
p_c_20
Contributor
p_c_20Contributor
asked in Transformers
Feature reader - dynamically expose attributes using schema read in by another FeatureReader (or Schema Scanner)

I have a collection of geopackage files, several of which have different feature attribute schemas (attribute names, numbers of attributes). I have read the schemas using a FeatureReader, and created a list for each FME_Feature_Type_Name. (I’ve built a concatenated text string here just for visibility): Where I am getting stuck is in using this in a subsequent FeatureReader to define the attributes to expose for each file. I’m using fme_feature_type_name in the read location to grab one file at a time. But am struggling to use the Schema list or concatenated attribute to drive the attribute exposure. I can get all attributes exposed via AttributeExposer, but then I have to use a TestFilter and an AttributeManager to remove the attributes that don’t apply to particular files (because ‘expose all’ picks up all attributes from all files). Is there any way this will work?

1081
j.m-visma
Contributor
tb09114
Supporter
tb09114Supporter
asked in Transformers
How to get Bing tiles into MapnikRasterizer?

I need to get data from my Bing subscription into the MapnikRasterizer. At least that how I think it should be done. It works of course in the preview because I made the Bing maps available through the options. But as I see it for the MapnikRasterizer I will have to provide the background as an image and I am struggeling to get the Bing data into my workflow. background settings in MapnikRasterizer How can I get the Bing data into the MapnikRasterizer?

471
tb09114
Supporter
jon
Contributor
jonContributor
asked in Transformers
How to update Feature Types using a FeatureReader

For normal Reader feature types, to update for schema or attribute changes you simply go to Readers > Update Feature Types. I can't find the same functionality using a FeatureReader. Is there a way to do that? The only workaround I've found is to drop the FeatureReader and re-add it.

4037
kalbert
Supporter
hrinn
Contributor
hrinnContributor
asked in Integration
Autodesk docs connector shows deleted and renamed folders with old names

I have a problem with the the autodesk docs connector. For example, if a folder is renamed or deleted in in ACC it will still show up with the old name in the connector. Is this a known issue? Anyone else having the same experience? Makes it impossible to control the file sync. Im using FME 2023.1 Win64 See the reply from Autodesk support If I understand correctly, you use FME app to sync the data from ACC to your system. Although FEM uses Autodesk cloud service to build the integration, we do not know how they implemented the logic and how they used the API. So the best would be you (as a customer of FME) contact their support team to more information. better FEM contacts us if they cannot resolve problem of specific point of Autodesk: API, cloud service, etc. With my experience, I guess FEM uses App context authentication (at our side, called 2-legged token workflow). By that, it will dump all folders, including deleted or even hidden folders. That might explain you could see those u

212
hrinn
Contributor
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?

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

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

727
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

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

674
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

44320
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

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

827
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

353
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

Helpful Members This Week

Badge Winners

Show all badges

Popular Tags

Community Stats

31,022
Posts
117,570
Replies
38,798
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.