Integration

Hi everyone!I’ll try to explain what we need...Nowadays, we have a download system based on Geoserver. When someone wants to download some data in KML format from the viewer, the data contain the same style you are displaying. So, you can open this KML in Google Earht and you can display it with the same symbology. Now, we want to change this download system and we want to do it using FME. But, when we download a KML, we have lost the symbology, beacuse we get data from database, not from Geoserver. Nevertheless, Geoserver contains SLD files from each layer. KMLStyler transformer can assign an static symbology, but this isn't what we want.The question is, is there any way to assign dynamicly, the SLD to KML, in order to display with the right symbology? That is, can we read he content of SLD and assign the colours to KML?

I am making my first workspace that uses a reader for a hosted feature layer from Portal. I notice that I am able to use the Esri ArcGIS Server Feature Service Reader/Writer as well as the Esri ArcGIS Portal Feature Service Reader/Writer to achieve this. My question is what is the difference? As the end result was the same for both.The Esri ArcGIS Server Feature Service Reader/Writer seemed far simpler to use as all I needed was the user and password plus the feature layer URL while for the Esri ArcGIS Portal Feature Service Reader/Writer I had to enter the host, user, password and feature service which was the folder location of the feature layer plus the feature service ID on the end in brackets in order to get it to work. I am using FME 2018.0 as well if that makes a difference. 

Good day,Is there anyone here tried converting Civil3d Pipes and Structure into ESRI Geodatabase Multipatch in ArcGIS Pro?My issue is the original attribute from Civil3d doesn’t copy in the converted Multipatch - when I convert using ‘CAD To Geodatabase’Can FME translate Civil3d Pipe/Structure Property to change the incorrect Multipatch attributes?Please see image below: 

Hi, I am trying to make API requests to connect to an application. It requires OAuth1 authentication. It seems like FME does not have built-in support for OAuth1. Is there a way to set the HTTP caller in this case? I would be extremely grateful if you could provide me with your assistance!

how to remove these unwanted connections from PostgreSQL Reader (highlighted) 

Hi all,  I want to run a workbench in quick translator mode instead of running whole workbench using .bat file 

i want to generate profile point along the road both edges and paint lines inside the road edges , as shown in the picture , please suggest how to accomplish this , through out the road network. 

I am attempting to transfer data from a file geodatabase into an enterprise geodatabase (PostgreSQL). By default, the writer copies it into either the "public" schema or the "sde" schema. However, I aim to copy the data into a schema of my choice (which is “test” in this example). Although I've attempted to add the schema name before my table name using a dot, as suggested in an older post on this forum, I am still encountering errors. Please see the attached image for reference. FME Workflow 

I recently upgraded my FME Workbench install on Ubuntu 22.04.  Everything had been running correctly before this.  I had set up the .profile in Linux to point at a much larger hard drive (7 TB) rather than the small 50Gb drive they have configured as the HOME/default.  When I am running processes on large data sets (hundreds of millions of records) the temp fills up with gigs of data so I needed that pointed to that larger drive.  After installing FME 2024 it is acting like it doesn’t see the FME_TEMP setting and longer.  I even went in the .profile this morning to check that it was still there. Have there been any changes made to the software related to this setting? If not, how do I get workbench to start playing nice again? Any information or guidance would be appreciated. 

Hello everyone,I have a colleague that uses FME Form 2023 in combination with the FME auto plugin (MApublisher)In previous versions he had nog problems using the FME auto plugin, however in FME Form 2023 he gets the following error:In  the previous versions one was able to succesfully extend the Avenza MAPublisher for Illustrator via the Integration console, however in read in a post that the Integration Console is deprecated :  https://support.safe.com/s/article/FME-Integration-Console-DeprecationI was wondering wheth

Dears, If i have Revit Model that has multiple Locations and we need to separate each Location to single Revit file .Is it possible using FME?? Thanks in advance

I've two types of cell features in my data with same name, only difference is that the origin of the features, as shown in the picture one type having the origin at the right bottom and other has it at the left bottom, how to identify those. expecting some suggestion 

Hi FME community,Just wanting to ask has anyone had success using a HTTP Caller or a connector to obtain data from Konect  server? Cheers.

Hy there !I’m using FME 2022.2 and ArcGISpro 3.1.1, Python Compatibility is set to Esri ArcGIS Python 3.6+I want to test arcpy in FME with the following script, it works but throws this error:Python Exception <TypeError>: clip_shapefile() missing 2 required positional arguments: 'clip_features' and 'output_shapefile' Clip works well and the shapefile is valid, but the pythoncaller ends up with this error.The Script:import fmeimport fmeobjectsimport arcpyimport os# Overwritearcpy.env.overwriteOutput = True# Functiondef clip_shapefile(input_shapefile, clip_features, output_shapefile):    arcpy.Clip_analysis(input_shapefile, clip_features, output_shapefile)    return output_shapefile# Sourceinput_shapefile = 'D:/TEMP/SHP/VWG_KAT_GEM.shp'print("Quelle gelesen !")#Clip Featuresclip_features = 'D:/

Hi FME Community, So I’ve created a basic FME Flow application using a script that simply lets you upload two excel files then generates a html report comparing the two. I’m wanting to improve this functionality where there's a dedicated library of files (.csv) from cloud drive (One Drive) as buttons or drop down selection menu. Requiring only to upload the comparison .csv file. Would I have to achieve this by writing a python or java script in a custom HTML in a HTML report generator?

Hello, I am new to handling JSON but am really struggling to understand it.  I have formatted json stored in a csv as an attribute.  I cannot seem to flatten or fragment it.  Latest attempt was to write to a json then read in and fragment.  The workspace screenshot attached ran successfully but hasn’t exposed the strings I have requested.

Some users in my organisation are getting the below error when using  using fme-form-2023.2.1-b23774-win-x64. They have already looked at editing the path in environment variables and that didn't work. Any suggestions on a solution? Python Exception <ImportError>: This package should not be accessible on Python 3. Either you are trying to run from the python-future src folder or your installation of python-future is corrupted.Failed to import `fmesite'Python Exception <ImportError>: This package should not be accessible on Python 3. Either you are trying to run from the python-future src folder or your installation of python-future is corrupted.Failed to import `fme'(PythonFactory): The Python Framework could not be started. PythonFactory could not initializeThe Python Framework could not be started. PythonFactory could not initialize

Just update eterra3.ancpi.roGeometryFetcher. Updated all transformers to 2024, created a workaround for Tiler not completing a Conditional Value for $Parameter Contains/Begins with, created a test suite, uploaded .fmx and .fmw to the Hub.This is the Test Suite Failure Log:2024-03-12 20:33:35| 0.0| 0.0|INFORM|Current FME version: FME 2023.2.2.0 (20240205 - Build 23781 - linux-x64)2024-03-12 20:33:35| 0.0| 0.0|INFORM|System Time: 20240312203336 UTC2024-03-12 20:33:35| 0.0| 0.0|WARN |Workspace was last saved in FME version: FME 2024.0.0.0 (20240304 - Build 24187 - WIN64)Can’t run 2024.0 workspace on 2023.2.2.Please fix this!By the way, in case safers missed it: Something is wrong with the Conditional Value in transformers that only have Arithmetic Editor (for transformers that have both Text and Arithmetic Editor it appears to works)

I am using Oracle DB. My sql commands are update commands. I believe it is directly sending to the oracle to execute rather than regular transformer which execute in batches. Please clarify. 

Hi All,Fairly new to FME, and brand spanking new to Rest APIs.i have an API integration that i worked out in Postman, but, i’m struggling to translate that to FME workbench for use in an FME Server Automation.In postman, i have to use a GET to generate an antiforgery token, then use a POST to log in, a second GET to update the antiforgery token and then a second POST to send the actual content i want to .. uh.. send.now, in Postman, my request looks like:GET {{DeskAlertsURL}}api/xsrf/getwith the following auto generated headers:Cookie:Host:User-Agent:Accept:Accept-Encoding:Connection:and the actual request headers look like (i {{shortened}} some of them for readability):GET https://URL/DeskAlerts11/api/xsrf/getRequest HeadersUser-Agent: PostmanRuntime/7.36.0Accept: */*Postman-Token: acbb9ca8-9dc2-44b1-888e-63468a39523fHost: desk

Please feel free to take your best guess about the title of this post in the poll. Then, if you are curious about the answer, check my new transformer OpenAIOSMReader and the LinkedIn article.  

Hi Community, I am using some SQLExecutors in my workbench and the this is taking so much time to execute. Is there any way I can execute it faster. Is it because the statement going from fme to outside db and execute it in batches of 1000 and commits the edits making the whole delay?. Is it possible to execute the whole sql actions using a plsql script and bind it to fme?. I may also need to have logs or exception tables for plsql script. Is it possible through fme?

Hi! I'm trying to transfer the information from the layers and tables of one geodatabase (with domains and relationships) to another geodatabase with a different data model. I need the GlobalIDs from the reader  geodatabase to remain in the writer geodatabase. In some tables/layers, I manage to keep them by setting "translation type: none" and "preserve GlobalID: yes," but in others, it's necessary for the translation type to be edit session, and then the GlobalIDs are not preserved. Is there any way to maintain the GlobalIDs regardless of the translation type or in any other way?I have read several posts regarding this issue but I can't find a solution.thanks!     

Hi community,I would need your help to make my FME code smarter and more dynamic. I am retrieving data via API. The problem is that I can only retrieve 100 items per page. I have 6 pages so I duplicate 6 httpcaller to be able to recover all of my data.Wouldn't there be a more dynamic way to retrieve this data without having to duplicate the httpcaller, maybe by looping but I don't know if it's possible on FME.In the first call, I have the information about the number of pages.Thanks for your help

I keep finding more and more areas where AI can enhance or simplify FME workflows. Just another example - we can ask the OpenAI API to give us expressions for RasterExpressionEvaluator and with the latest beta of FME 2024.1 (sorry, not publicly available yet), we can take the expressions from attributes. We can, for example, color a DEM by elevation. Do you want to see what AI can write for us? This is one of three expressions needed for coloring of multiple elevation intervals of the DEM. Good luck finding errors 🤣:if(A[0] <= 110, if(A[0] <= 22, 0, if(A[0] <= 44, 29, if(A[0] <= 66, 58, if(A[0] <= 88, 87, 116)))), if(A[0] <= 332, if(A[0] <= 154, 144, if(A[0] <= 220, 173, if(A[0] <= 276, 202, if(A[0] <= 332, 231, 255)))), if(A[0] <= 554, if(A[0] <= 388, 238, if(A[0] <= 442, 209, if(A[0] <= 498, 180, if(A[0] <= 554, 151, 122)))), if(A[0] <= 776, if(A[0] <= 610, 255, if(A[0] <= 664, 226, if(A[0] <= 720, 197, if(A[0] &