FME Form

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

Hi there,  I have a 3D object in .las format which contains RGB values for each point in the point cloud. The goal is to get this object into an Esri .slpk format and keep the RGB values so the final object is colored correctly.  The .las file doesn't have a coordinate system but has relative xyz values; seems like the object is centered at 0,0. When using the CoordinateSystemSetter, it doesn't seem to change the XY values at all. This is just part of the problem.  The other problem is when I try to write out to .slpk using the Esri SLPK writer, I get this error: The layer requires triangular mesh geometries. Features whose geometries cannot be triangulated will not be written How do I convert the .las file into a triangular mesh so that it can be written to SLPK? Is this possible? Do I need a different input format? Other options could be .xyz or .pcd for the input file.  I haven't really worke

Is it possible to prevent FME Server from zipping the temp folders ? My server is zipping the whole temp folder instead of only the output of my FeatureWriter, making it impossible later on for HTTPCallers to access the file I need it to upload. This behaviour is problematic because I access files inside these .zip in later steps of the workspace and it raises errors because it is in a .zip file.

Hi! I´m trying to add an ID column to a GeoJSON file. I use a reader to read data from an Oracle database and then write it down using to GeoJSON writer. I need the ID not to be in the properties-section but as in the example below:https://community.safe.com/s/article/tutorial-getting-started-with-json Thankful for any suggestions on how to do this 😊

I am trying to send the MapnikRasterizer result to HTMLReportGenerator, but directly connecting them doesn't work. So I am using a TempPathnameCreator and FeatureWriter in between to write the png and then send it to the HTMLReportGenerator. However, HTMLReportGenerator can't read the path generated during the test running.FME version: 2021.2Error: HTMLReportGenerator: Unable to open image file 'D:/FME_TEMP/wbrun_1652070048335_8656/fmetmp_1c/1652075715010_34268_d\\r_2030.png.png'. Please ensure this file exists

Hi, I am trying to use ReplaceRegularExpression as described here:http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/!Transformer_Parameters/StringFunctions.htmTo do a simple transformation of Quotes to escaped Quotes in strings. I have the following: @ReplaceRegularExpression(@Value(Description),["],"\\\\""",FALSE)(as the instructions say I need to add quotes and escape the quote in the to expression.)This does not work, but at least does not have errors.If I try to slightly change the syntax of the to expression (eg less quotes) I get serious errors... Any ideas welcome...   

Currently I set the projection in the reader for the csv to match the gdb. I then added a Feature Writer transformer for the fanout creating feature classes in a staging gdb. My problem now is how do I get the feature classes the feature writer created back into the workspace so I can then use the attribute manager to map to my final gdb. I tried to use the Feature Reader transformer to add these back but have not been able to figure that out yet.

Hi,I'm trying to start a workspace runner just after a FeatureWriter has finished running, but I am getting a weird error with a '@Tcl2 function': ...WorkspaceRunner_ExecutorAndRouter (TestFactory): An error was encountered evaluating a TestFactory test: An error occurred while evaluating a test parameter: @Tcl2 function requires exactly one argument -- the expression to evaluate.  If you are using static function evaluation, only one $[ .. ] pair can be on a single logical mapping file line due to parser limitationsFeatureWriter_6_SUMMARY_-1_836_Player (RecorderFactory): An error was encountered evaluating a TestFactory test: An error occurred while evaluating a test parameter: @Tcl2 function requires exactly one argument -- the expression to evaluate.  If you are using static function evaluation, only one $[ .. ] pair can be on a single logical mapping file line due to parser limitations...This is happening with differ