Best Answers

I have a json-file (see attachment) that contains the coördinates of a circular route. It looks like this:{ "segments": [{  "geometry": {   "type": "LineString",   "coordinates": [    [50.814103, 4.521174],    [50.81309, 4.521811],    [50.80626, 4.536902],    [50.80482, 4.538866],    [50.80573, 4.541452],    [50.80621, 4.543173],    [50.80705, 4.545501],    [50.80755, 4.546541],    [50.80777, 4.546841],    [50.80919, 4.547739],    [50.8096, 4.548199],    [50.81052, 4.550243],    [50.810663, 4.551096]   ]  },  {  "geometry": {   "type": "LineString",   "coordinates": [    [50.810663, 4.551096],    [50.81065, 4.555264],    [50.81071, 4.555622]   ]  },... I want to convert it to an ESRI line feature class, but I'm stuck. The geojsonreader gives no error, but also no result as reader.  Json-fragmenter gives me the list of vertices in an attribute, but I can't fix it to convert these points to

Is it possible to change the name of a repository on FME server (2022 to be specific)? If so how?

Is there a possibility to suppress annoying WARN messages of the 'Autodesk AutoCAD RealDWG DWG/DXF' FeatureReader? Please see the following example:I use the AutoCAD reader to read features from an DWG file. I am only interested in the features of one specific layer (specified by a user parameter):Hence, the AutoCAD reader reads the file and skips all layers but the specified one.  In the log, the reader starts writing which layers are skipped. These messages are written at 'Information' level. After writing the 10th skip message, it writes a message "Further instances of this message will be suppressed" on WARN level. -----As text:2023-03-23 14:17:38|  1.8| 0.0|INFORM|AutoCAD Reader: Successfully opened the 'Release2018' AutoCAD file '<SOME_PATH>'2023-03-23 14:17:38|  1.9| 0.1|INFORM|AutoCAD Reader: Features for feature type '0' will be skipped based on the feature types requested2023-03-23 14:17:38|  1.9| 0.0|INFORM|AutoCAD Read

How do I Copy SHAPE column from an ESRI GDB feature class to a non spatial Postgres database?

Hi,I have a workflow where I need to forecast particular values. The formula to calculate this forecast value (in Attribute A) needs to reference the previous feature in Attribute A, but the AttributeManager doesn't allow you to reference ajacent features (in this case, previous) for the same attribute. Is there a way I can do this? I wonder if a looping process would help. Thanks

I have a request to convert some postgis geom data into TopoJSON. However they want the output to be single combined file similar to what is produced by https://mapshaper.org/ I can easily create individual TopoJSON files in FME. (Simple read postgis and connect to TopoJSON writer.) But I have not figured how I can produce a combined file with multiple objects in it like what is done with mapshaper.org site.  I uploaded sample TopoJson output files from FME and the sample combined file from mapshaper.  I figure this will likely need some type of python code, which is fine, but I'm hoping to not install any additional modules outside what FME provides.  Currently using FME 2020.2. That is what company uses. But I can use new FME version if it had options for doing this in some update.

Hello all, When will FME (server and desktop) be supported on the new Ubuntu LTS release 22.04? Thanks for your interest, Martin

Is it possible to add transfomer with PC sound notification? Eg. If unexpected path event was detected or a scound notification to the data inspector new window opening?

Since in ChatGPT its showing the following steps , install the Plugin.Snapshot for your reference.

In this article - Woody describes a custom HTTP caller using a parameter to call PBI API. Idea: Power BI Writer (safe.com), I don't really need a writer, I am looking for a way to use the HTTP caller and liked the post about using parameters.I have followed Microsoft's instruction for registering an APP. I can use MS docs to call the API to refresh a dataset. I have done the same with Postman. I am stuck trying to do the same with FME.Thank you - Tim Woods

I try to color features by attribute value. Tried both the FeatureColorSetter and the KML Styler.  I have the color in an attributes for each feature both as hex "#FFCC00" and as decimal "255,204,0" but both don't work when i feed them to "Fill Color" in the KMLStyler or FeatureColorSetter.  How do I have to format the color values?

I have a distributed FME Server deployment (core + n Engines). One of the Engine hosts has been dedicated to run jobs that require to write/read to/from Esri Geodatabase (SDE). In order to enable that I deployed ArcGIS Server on that machine (it is licensed and running).Unfortunately when running a job that tries to read from SDE (Oracle) I got the following error:60 Creating reader for format: Esri Geodatabase (ArcSDE Geodb)61 Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE'62 Could not load module '/opt/fme-engine-2022/plugins/..\geodatabase9.so' : '/opt/fme-engine-2022/plugins/..\geodatabase9.so: cannot open shared object file: No such file or directory'63 Module '..\geodatabase9' is unavailable for use with this FME editionIs this configuration (access to SDE GDB from Linux machine) supported? Should I try to use Windows based Engine machine with ArcGIS Server? FME Server version: FME Server 2022.2.4, Build 22792 - linux-x64ArcGIS Server: 11.0 Advanced

I tried generalizer and spike removal. The spike removal works to remove the twisted lines, but it leaves small cuts everywhere. Any advice how to clean the small cut lines and reduce the number of vertices? Thank you so much!

I have a Group in my company ArcGIS Online (AGOL) that holds multiple, shared, hosted feature layers, each based on a feature service and having multiple layers both spatial and non-spatial.  As such, each hosted feature layer is a Feature Layer Collection in Esri-speak.  Many of the non-spatial layers in a hosted feature layer are attachment tables, so others are relationship tables.  I need to read the schemas (as schema features) of every layer in every hosted feature layer into one big stream.  Alternatively, I could read all the features and shove them through a SchemaScanner.  In either case, I need FME entities, and I need to be able to loop through all the hosted feature layers.  Because FME FeatureReaders for AGOL Feature Services can process only one feature service at a time, I can't process all the hosted feature layers in the same workspace run.  I can think of a way to use multiple worksapces and WorkspaceRunner s to do the required looping, but that is kludgy and complex

I have 3D polylines that I’d like to split at specific elevations (3,000’, 5,000’, 7,000’, and 10,000). Any ideas are welcome!

After upgrading to FME desktop 2022.2.3.0 (20230131 - Build 22789 - WIN64) I cannot read any of the sde tables on postgres (10) backend. The FME desktop 2021.2.3.0 (20220131 - Build 21812 - WIN64) version still works. I've played with the Esri Argis compatibility workspace parameter without any succes. The version of Arcmap is 10.6.1Here is a relevant part of the logging:Worker 8020 > Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220952'. The error message from ArcObjects is: {The Product License has not been initialized.}Worker 8020 > Please ensure the connection parameters are correct (server=`localhost', instance=`sde:postgresql:localhost,5435', user=`sde', password=`***', database=`lais', version=`sde.DEFAULT')Worker 8020 > It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGI

I noticed that when I went to add the Geocoder transformer to a workbench there no longer was a transformer called Geocoder. I am using it to connect to an ArcGIS Server Rest geocoding service. I saw a Geocoder ArcGIS Online transformer and other system specific Geocoder but not the original "Geocoder" transformer.

Mdenoise is an denoising algorithm for topographic use that preserves sharp edges. It's part of GDAL, so I was wondering if it maybe was integrated in FME, but under another name? Or is there an transformer that works in a similar way?  Some background to mdenoise:https://personalpages.manchester.ac.uk/staff/neil.mitchell/mdenoise/ 

How to extract photo attachments from an fgdb esri file?

I'm parsing data from an SFTP call to get the file name. I'm returning _list values that have all the FTP properties of each file. I use an AttributeCreator get the length of this string as an attribute (ListStringLength=69) --- @StringLength(@Value(_list))-rwxrwxrwx  1 user   278361 date 00137 0001539147T ABCDEFG1234567.jpg I'm also using the AttributeCreator to get the starting position of the file name based on the prefix as another attribute (StartingPosition=33) --- @FindString(@Value(_list),"00137 0001539147T")278361 Mar 21 09:49 00137 0001539147T ABCDEFG1234567.jpg From here, I tried to simply subtract. But that didn't work.@Value(ListStringLength)-@Value(StartingPosition) = a string value 69-33 So then I added an SQLExecuter and did the math in SQL and output the FileNameLength.select @Value(ListStringLength)-@Value(StartingPosition) as FileNameLength From here, I added an AttributeCreator to get the FileName. @Substring(@Value(_list),@Value(StartingPo

Hello, I have a dataset in excel that I would like to simplify the data into a newly created status field. For example all records that are 1000 will be status A, all records that are 2000 will be status B, all records that are 3000 will be status C. I will then import the data into GIS to symbolize based on status. I am creating testers for each status type and then joining it all back together. I was wondering if there was a single transformer that I could put in all my criteria and have the status field updated. I think this should be fairly simple but not finding the right transformer. Thank you

We used to have the following 'Emailer' Transformer in our FME Desktop /Server 2021.2.2 and it worked fine: However after upgraded to 2022.2.3, we experienced the following Python Exception error for Emailer:Any idea how to fix that? Thanks.

Hello, I have a table which needs to be written to PostGIS. One of my dataset columns contains a list of buffer distances for example 300, 200, 100m. It would be ideal to write this as an array to PostGIS for example {300, 200, 100}.  If the table already exists with an array column in PostGIS, FME will update the array correctly. If the table doesn't exist I can't see how to set the column type as an array in FME. Is it possible? Thanks :)

Hello everyone,I am trying to convert dgn (Microstation) to dwg (Autocad), but for some reason the blocks are in my dwg unrotated. In Microstation those are called cells. Does anyone know how I can get the cells rotated in the dwg file? The igds_rotation attribute does show the rotation values in case of Microstation (see below for some example values)and I read somewhere online that the attribute name that holds the rotation value in case of autocad was 50. I could be wrong though. In the output (dwg) the cells are unrotated. It might thus be due to the fact that I stored the rotation value for autocad under the wrong name. 

In Salesforce, they have a feature called "Platform Events" where the fields are defined in Salesforce. Does FME have an existing connector or an app for this and can FME also publish changes to the "Platform Events"?Thank you