FME Form

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

Hello!I have a set of points representing the location of the tree trunks. I also have a 3D model of a tree that i want to be copied to each of the points locations. And here is the tricky part, I need them to be instanced geometries, so they do not require to much space (and rendering power) when I export to fbx, skp and dwg.I tried to read up on the GeometryInstantiator-node but I must admit, I don't quite follow what it is supposed to do. Is there an example for this availible anywhere or do anyone have a clue?Here is a screendump of my script, but it only manages to place the trees as individual models which creates a 30MB file from copies of a mere 15KB geometry-asset.:Sincerely,Robin Nilsson

I have defined a new published parameter (pp) in an existing FME workspace, which exist as a scheduled workspace on FME Server. When published with the new pp to FME Server, I can see the new PP in the interface of the scheduled workspace on FME Server. However when I use the REST API to get to the scheduled workspace it doesn't recognize the new pp, only the old ones. Just when I open the scheduled workspace on FME Server and click OK, then the REST API can see the new pp. Isn't that a bug of some sort?

Hi FMErs,Has anyone had any experience importing GoCAD ts files into FME using another reader type. It appears that GoCAD is not supported directly in FME, however the geometry of the object/s appear to be 3D triangulated surfaces ?Thanks in advance

Hi I'm using Revit native reader to read Revit 2021 arch project file but having problems with transformers rejecting geometries. E.g. using MeshMerger or MeshSimplifier transformer will result in rejecting all imported geometries. Any hint how to solve this problem? I want to simplify and join geometries before writing to gltf, to get gltf file that's easy to renderThanks ​

I am writing from a csv where all the fields are text. One of these fields contains a date 10/11/2021. I need to load this to a geodatabase that has the field formatted as a date. I need the date to look the same in the field I am mapping to. I have tried many different things and am probably just missing something but I can't get this to work. Attached is what my current workspace looks like. I believe I need to do this in the attribute manager using the dat time format but I am not figuring out how to dot his properly.

When I run this workspace locally, it puts out a .prj file and all is well. The issue only occurs on fme server. there is no prj in the zipped download.