Best Answers

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

I used several models. once without transformers and once with EsriReprojector, reprojector, and ...In all cases, the results are not in correct projection.even I force to create prj file and it has the correct projection but output dwg has UTM projection with wrong coordinates

Is FME version 2021 able to work with ESRI Geodatabases in ArcGIS 9.0 and 9.3 formats?

Hello I am trying to write some polygon data from a csv file which contains the geometry data to an esri sde database, all the conversion is fine until i come to write the data when i get the error below. It says that the Number of parts in shape is incorrect for its geometry type. What does this actually mean. The data is building a polygon, which it does. I have added in a geometry filter to get the areas and polygons followed by a geometry coercer set to fme_polygon... Any ideas how to fix this or what could be wrong?? Error while updating feature in the table/feature class 'OS_NGD_BLD_FTS_BUILDINGPART'. The error number from ArcObjects is: '-2147215922'. The error message from ArcObjects is: {Number of parts in shape is incorrect for its geometry type}Storing feature(s) to FME feature store file `\\\\dnfme01\\FMEWorkbench\\Workspaces\\Ordnance Survey\\National Geospatial Database\\OS NGD Buildings Daily Update_log.ffs'++++++++++++++++++++++++++++++++++++++++

I have a disconnected Python Caller which is suppose to do some data cleaning in target dataset before Reading data from source and writing them into Target Can you please let me know how I can make a sequence here before reading the data from source to ran and do the job of Python Caller First?   I tried to connect/put the Python caller before Reader but as you know where is no way to add it before reader , out of the box Thanks

Looking for a way to add a feature to a data flow based on a test condition where the feature count of the data stream is 1 or more? If there are no features being read from the reader source, no feature will be added. Best way is probably to test feature count equal to null.

Is this possible to automate in FME?  Is it also possible to run a script at an interval in fme, e.g. once per week?

I was excited about this new feature announced at FME UC 2022 and as soon as I saw the beta for 2023 dropped (and I also really want to test this on Server Apps), I downloaded to test. However it seems broken. The drop-down isn't revealing anything. Shouldn't it reveal one of the other parameters as input? Or am I missing something? Thanks.