General

Presagis Creator allows formatting of a hierarchy where polygons can be organized under groups, objects, and naming of polygons. When I read in an OpenFlight file with these attributes and output it to the FME OpenFlight writer the polygon names are all empty. Is it possible to define a hierarchy where groups, objects, and polygons can be customized instead of empty nodes? I included a generic screenshot showing how I would like to organize the FME writer output. Thanks!

I am looking to dump from results of the SQL Executor into a DB table (fields not known). Looking for ways to do it. I see there is Schema and Result port for SQLExecutor. Not sure how to use both in order to insert the data into a table.

I am trying to write a 4 digit year into an existing MySQL database. The field type is year with a length of 4. Therefore, one would think that a 4 digit integer would write into it, but it does not. I get a warning saying "MySQL Writer: Skipped feature due to invalid date/time string". This seems extremely basic, but how do I turn a4 digit integer (e.x. 2012) into a date field that MySQL will recognize as a year?

I have road events from different groups and time lines.. so the geometry doesn't always match but they want me to push them together. is it possible to just use the PathName, Start Measure and End Measure to join many events together?  Example: All Path's have3 events Weight, Height, Width. I want to be able to merge them together like Snipper or LineOnLine so I can join the Start and End Measures where they break.. If needed in Python or Transformer preferably so I can complete this on the fly from two databases to compare.  

I have a process where I determine the last ID number used for two id fields using statistics calculator. I then use an aggregator to merge the two ID's. I then bring about 100 records from another table and am wanting to add these ID's to it. But what is happening is that the two ID's are just being added as another record instead. I have tried using variable setter & retriever but those didn't work at all.

I have a problem when creating a workflow in which additional attributes are linked via an identical ID from Excel (name) and Ifc (ETL_TYPEN.NAME). The problem is that not all attributes from the Excel list are recognized and linked and the geometry is taken over in the updated IFC (Writer).

in FME 2020 the behaviour of Generic Reader changed in a way, that "Guess format from extension" for GPKG now defaults to GEOPACKAGE_RASTER instead of GEOPACKAGE (vector). This broke a workflow in our application. Why was this changed ?

Hi everyone I'm trying to make a web app that will be situated on our company VPS which is off course on remote server. We are running FME Server 2019 on local machine inside our company local network and is accessed through IP address. For the web app, I'm using some REST API code (I'm not an expert I must say) found in your "data-distribution-with-web-maps" demo where you set fmeserver url and token. Off course, setting those two is not a problem. I have also enabled CORS on FME Server. When opening webpage, web app triggers workbench but nothing happens and web developer error appears : Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https: ...As I have defined in JS file in web app, fmeserver url should start with http and by no means https protocol. I don't know if I'm doing something wrong. Has anyone tried anything similar and made it work?When using this app on local network, it works (CORS disabled). T

Hi Folks - I am looking to use the API to get a list of all the Web Connections on the FME server. Has anyone done this before? Thanks

I am trying to create an individual HTML file for each 'grouped by' polygon. I have the Fanout Expression set as per below with the attribute that is used in the 'group by' but I just get a single HTML file.  The attribute seems to be available to select but does not appear to be used during output. Is there something different I should be doing to get individual HTML files?

Well, it's time for all the latest FME news for the week. The FME World TourThere are many World Tour events still to come, as well as completed. The 1Spatial UK Tour visited London and tomorrow (perhaps today by the time you read this) is in Cardiff. They have upcoming events in Leeds and Glasgow too. Everyone was happy to be back in person again and to be presenting in front of others.  Also coming up, there are World Tour events in Brazil with Solutial (São Paulo and Rio de Janeiro), Austria with Axmann (Vienna), and Japan with Pacific Spatial (Tokyo). You know where the full list is. Don't you?! Of course, as some events are completed, their presentations appear online. Here we have some user presentations from con terra España. I don't speak Spanish but I do see mention of CityGML, Cesium, and FME Server Automations. I don't speak Dutch either, but even I can tell what "snel, sneller, snelst" means on Red Geographics world tour page. I think you can still

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

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

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?

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

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

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.

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?

On 2018 build 18520. Attempting to read in an Esri GDB and get this error This GDB version appears to be working fine in ArcGIS. Is it an FME version issue ?  (I'm new to Esri technologies other than shapefiles. Be gentle...