FME Form

Hello, newbie here. I'm using AttributeManager to rename and remove some Attributes - and to add a new Attribute using a Conditional Value based upon (among others) an Attribute named IATA, which contains airport call letters. For San Francisco International Airport, IATA contains "SFO" but for Nadi International Airport, the IATA Attribute contains "NAN". No matter how I try to force FME to treat those call letters as a string, it eventually becomes "if NAN != null... and I get "nan" as the result. Pretty sure that's a bug (2019.2). Note: Set Value with @Value(IATA) works fine with "NAN". It seems to be only the Conditional Value code that has the problem. Does anyone have an idea how to conditionally process an Attribute that may contain the value "NAN" (or other values that might also be mathematical constants)?

I think this is an easy one, however i am stumped.  I have a set of data with 3 columns.  Fieldname, Fieldval, RecordGroup.  I simply want to aggregate by recordgroup and then rename attribute names to the value that is stored in the Fieldname.  Where i am stumbling is how to rename the fields to the values in the input field.  Thanks in advance.   

Is it possible to get an additional attribute from a las file in FME. Indeed I have an input point cloud in las format with a vertical distance attribute on each point.I need this attribute to make statistics.How to get this attribute directly when reading the las file (or other) without passing "PointCloudCoercer"?

Hi, Is there a way to test if a polygon geometry contains curve? I dont find any transformer that explicitely achieve that. Thank you!

I have a workbench to process some raster imagery, each image is stand alone in the processing done, so a clear candidate for parallel processing. The workbench now looks likeI've set the group by to the image name (all unique), and run in both modes with the following outcomes:'Process when group changes (Advanced)' - Task Manager shows only only a single FME instance processing, act as blocking, processing all files before it begins writing results. 'Process at End (Blocking)' - Task Manager shows multiple FME instances launched, but only one is doing any work, acts as blocking, processing all files before it begins writing results. Both paths are giving correct results, I have removed any 'group by' within the custom transformer, I'm trying to understand what is going wrong in r

Currently, we have a very curious problem. A workspace is made in FME Workbench desktop which runs without any problem. In the workspace, geometry in a ESRI file geodatabase is repaired by a Python script (arcpy). However, when deployed on FME Server, this process results in an unexpected error, see attached file. The account which starts and runs the process on FME server has sufficient read and write persmissions on the location where the geodatabase is stored.  What could be the cause of this problem?  Kind regards,Pim van der Zwaag.

A very simple workspace using ArcObjects Esri FileGeodatabaseReader and output to an Inspector. Duration 16.5 seconds with FME2022 and similar workspace duration is 10.5 seconds with FME2021.2 Logfiles attached and a Excel spreadsheet with output from FME_PROFILE_RESULT_CSV bestPål Herman

Is there a work around to be able to import Datamine, gOcad and Leapfrog 3D objects within FME to be able to automate queries and manipulations on these objects?

Hi,Does anybody have any experience writing GDB metadata images into SDE?I can update just about anything but inserting an image to the item description needs to be in a specific ESRI binary format (EsriPropertyType="PictureX") and the AttributeFileReader transformer does not support this encoding type. Cheers, Itay

I'm using an ArcGIS Feature reader to read a layer with two tables. The two tables have 9257 and 9606 rows. After reading the two tables, I join them. At this point (with feature caching) I can see that I have 9606 rows. This is correct. The last step of the workspace is to use an ArcGIS Feature writer to populate a different layer.  The ArcGIS Feature Writer has the following Parameters for Layer: Writer Mode: Insert Truncate First: Yes Currently, my destination Feature layer has 10584 rows. How could this be? How can I exceed the number of rows in my source layer? I just ran the workspace up to the Writer and can see 9606 items going into the Feature Writer. then, I ran the entire workspace and the destination layer now has 9752 rows. I'm perplexed. This is a public facing dashboard and I need accuracy. I do run this workspace from a batch file and schedule it to run at 3:00 AM with Windows Task Scheduler. I'm not

XML Document is: http://vocab.nerc.ac.uk/isoCodelists/sdnCodelists/gmxCodeLists.xml

Hi guys, I have DTM files in ASCII GRID format and I need to generate contours from this files. Everything works fine untill last step. When I am generating contours with contours generator transformer everything works fine, but I have in the area few lakes where I don't want to generate contours.  I've tried to use breaklines but when I am using it generally nothing change - contours still looks the same. I have layer with lakes where I don't want to generate contours. Before connect it to Breaklines arrow in ContourGenerator transformer I am using geometry coercer and 3DForcer. Can you guys tell me what I am doing wrong? I have no idea how to manage with this. Screnshot below. Brown polygon is a lake. Thank in advance. 

A few years ago I created a FME-hub custom transformer InlineGeoJSON. It creates a GeoJSON file with FeatureCollections. The transformer works fine in fme 2020, but does not work in versions starting from FME 2021. This has something to do with the dynamic schema setup. The current error is:  GEOJSON writer: Unknown feature type 'GeoJSON' passed to the JSON writerInlineGeoJSON_FeatureMerger (ReferenceFactory): GEOJSON writer: Unknown feature type 'GeoJSON' passed to the JSON writer I tried many different solutions, for example:replacing the schemasetter with the new schemascannerchanging the schema definition namechanging the feature type nameI added my workspace with the current test workspace. Does anyone have an idea how to solve this?

In what way can I control the behaviour of SqlExecutor concerning transactions. I'd like to perform several inserts and updates as a single transaction (by putting the "commit"-command at the end). But this commit always results in the warning "there is no transaction in progress".Database = PostgreSQL

Curves has many vertex.

Hi!Im looking for a way to import StoryMaps API to FME PythonCreator/PythonCaller. I have tried to import and read the following script:"from arcgis.gis import GISfrom arcgis.gis import Itemfrom arcgis.apps.storymap.story import StoryMapfrom arcgis.apps.storymap import Themesfrom arcgis.apps.storymap.story_content import Image, TextStyles, Video, Audio, Embed, Map, Text, Button, Gallery, Swipe, Sidecar, Timeline" When I read this script in PythonCreator/PythonCaller I got a message "Translation FAILED". The first two worked perfectly, but not the other three. Any ideas how i can work around? Appreciate your help! 

Hi, I'm trying to get all the attributes of all spatial tables in an Oracle schema.For this I start with a SQLCreator. It runs a query that gets table names from user_objects. The SQL creator exposes TABLE_NAME. I connect the Result port to a FeaureReader. I set this up as follows:Feature Types to Read: TABLE_NAME.,Generic> Port Attributes to Expose: *When I run the workspace, I see the correct number of records coming out in the < Generic> port. However, not per attribute. In the log I see that a select is performed with all attributes. (Select schema_name.coloumn_a, schema_name.coloumn_b, schema_name.coloumn_c etc.).When I connect an attribute exploder to the generic port I see all attributes with content but then they are shown separately and no longer per record.Is it possible to dynamically retrieve all tables and then show all attributes of all these tables per record? 

Hi, what might be the impact of a closed TCP port 7078 on FME Server installation? Could it be that the only impact would be not being able to use the Topics Testing, as well as not being able to use the WebSocket protocol? Or am I missing something?  Regards, Helmoet.

Hello there is there a way we could generate random number grouped by feature type the actual transformer does not have this optionThanks

GDAL has a pretty handy proximity calculator where each pixel in the output raster represents the distance to the nearest pixel in the input raster. For instance, distance to the nearest road. Is there any transformer doing that in FME ? Thanks!

I have some shape files that might be corrupted i think... However reading/viewing them in ArcGIS Pro is working without any issue whereas in FME it reads them all but it mixes attributes of the features! e.g. Point 1 (shape file feature) becomes attributes from lets say point 10 (another shape file feature) an so on! All attributes are mixed! is this issue known? I am using FME 2022.0 p.s. I am just reading shape files without doing any transformation.

I would like to exit a workbench with my own user defined exit code. Is that possible and how can I achive this?

Hi, I have a specific use case to solve. Transform a CSV file to a Turtle file (.ttl).Here is an example:CSV file has: 12345, Fred, 2020-01-01, "Foo, Bar"    I would like to then transform this row to: <http://example.com/12345> rdf:type owl:NamedIndividual ;                 a:name "Fred" ;                 a:date "2020-01-01";                  a:ref "http://example.com/Foo",                             "http://example.com/Bar" .And then repeat for all the lines in the  CSV.Any help appreciated 

Is there a way to truncate a list?  For example if I have a list of 30 items but only want the first 10 to be kept. I know I could manually create the list with an attribute creator using _list{0}, _list{1}, _list{2}, etc but just wanted to see if there is a transform or more automated way to do something like this. Regards Dean