General

Hi,I have a question regarding the AreaGapAndOverlapCleaner and I dont know how to solve my problem...I have multiple polygon layer which I want to overlay. The lines of the polygons are not totally coincident as different data sources are used. Many sliver polygons are created when the layers are overlayed. I would like to remove these small sliver polygons with the AreaGapAndOverlap Cleaner (it does it job well - I used a tolerance of 1 m). My only problem is, that the AreaGapAndOverlapCleaner itself creates some little gaps between the polygons. Is there a way to prevent the transformer from doing it? Using Fill All Gaps does not make sense in this case, as there are some big gaps (exclaves) that I want to keep. Do you have any idea to prevent the AreaGapAndOverlapCleaner from creating gaps? Or is there any other transformer which suits better?Thank you!

Hi !I have an xls file with 2 columns. One contains a code and the other contains numerics values. I would like to create an attribute that group my data when there are a break on the values and group by code. For example : code valuea 1 => group 1a 2 => group 1a 3 => group 1a 10 => group 2a 11 => group 2b 1 => group 3b 2 => group 3 I saw "AttributeRangeMapper" but I have to indicate the bounds. In my case I would like that the bounds are create automatically because my datas change every time.My values can be integer or decimal. Thanks ! 

Workbenchs/ Connection String work fine on existing server. Moved them over to a new server and get: ArcGIS Desktop 10.8.1 and Background georproccessing 64 installed, TNSNAMES is fine, can ping to oracle server.  822022-5-13 12:41:01 | Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {No SDEHOME environment variable set}832022-5-13 12:41:01 | Please ensure the connection parameters are correct (server=`sde', instance=`sde:oracle$sde:oracle11g:ocspub', user=`encdirect', password=`***', database=`', version=`SDE.DEFAULT') Edit: added SDEHOME Variable C:\\Program Files (x86)\\ArcGIS\\Desktop10.8\\bin Still no good  FME Server 2021.2.5Build 21816 - win64

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

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

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?