General

Hi,I have a point data set and I want to connect all points that have the same ID to each other. So if four points have the same id, each point should create a line to the other three points. The LineBuilder does not solve my problem because it simply creates an entire line and not just individual ones. I've read a few articles that the VertexCreator could help me, but I haven't found the solution yet.I would be very happy about your help. Greetings, Bastian

Hello, We are experimenting the use of FME as a sales reporting tool. Can someone provide an example of using the GooglePlacesConnector  or some other way of using Google Maps or other geocoding type transformers? Ultimately, my goal is to plug in a store name and have FME process a list of list of stores with address and lat/long across the USA. One example of what I would like to develop would be a list of all Chick-fil-a and Walmart stores in North America with their store number, address, and lat/long location. I can see using this for mayly store names and facility types in the future if it works.Thank you!Matt

Building a brand new Windows 2019 Server, with FME Server 2022.2.5. If we have workbenchs that write to SQL Server 2017 standard edition which ODBC Drive do we need (if any). My old server uses SQL Server Client, but my DBA says:SQL Server Client was announced as deprecated and isn't recommended to be used. ODBC driver is the one to be used.

Getting repeatedly the geometry object as delta on multiple runs

FME Desktop - How to Read Non-Spatial Oracle Update Trigger to Update a Spatial SQL Feature Class

hello everyone I got a 3d shapefile of buildings and I want to convert it to a citygml fine with LoD1 what is the workflow that I should do and here is my shapefile? thank you

I am currently working with about 60 towns (folders) on AGOL which all contain 10+ feature layers. The data is read from all these layer (reader per layer), compared with data in my db, then the data is updated/inserted/deleted in our db.  After this, let's say some work is done on the db data . I then have another workspace which is writing the updates back up to AGOL for the same town. I currently have 2 workspaces per town which take care of all the reading/writing/processing for all the layers. This has resulted in 120 workbenches which, when an update has to be made to the way data is processed, I have to go back and update all of those workspaces. Also more towns are being added every week so the number of workbenches is increasing.  The screenshot below is taken from one layer where data is read from both AGOL and the db, compared and then written out. I have a section like this for every layer where the processing is largely the same, with small differences depending on if

Hi, I have a geodatabase with some feature classes. I would like to convert the attributes of each feature class into excel. How can I do that>

I have a pretty basic workbench with a HTTP Caller which processes the downloaded data to insert. When I open the Workbench it works perfectly. I preset all the input parameters so I do not need to pass them into the model. However when I try and run the workspace from command line, specifically in Jenkins, I use the following command:"C:\\Program Files\\FME\\fme.exe" "\\\\xxx\\xxxx\\MY_MODEL.fmw"  I get the following error: HTTPCaller_4_<Rejected>: Termination Message: 'HTTPCaller_4 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''Program Terminating Any idea what would cause the http caller to fail only when run from command line?  Any help would be greatly appreciated!

Is going to be a FME Desktop 2023 version for Ubuntu 22.04? Thanks

I am trying to install the FME Desktop on my Ubuntu 20.04.1 laptop, but it doesn't work. Could you please help me to solve this problem? Thanks!

Hi i would like to cut the data (polygone) outside the perimeter that could be line ot polygone, and keeping those inside.

Hi,  Doing an overlaps removal on polygons but I have multiple polygons that are identical shapes layered on top of each other. does anyone have any solutions for this as I cant seem to find a way to select and remove all but one of the stack, over the whole layer. unfortunately the polygons don't have any data to match them on so its all spatial. Thanks in advance.

In a FME workspace I have a SQLExecutor-transformer, which uses different database connections. I use one PostGIS-database per year called db2020, db2021, db2022, db2023.When the user needs data e.g. for 2021 a sting is generated, which contains the name of the database, in this case "db2021". This string is called "connection" and is referenced with @Value(connection) in the connection field of the SQLExecutor-transformer. This works locally in FME desktop. Alle connections are present both on FME desktop and on FME server. When I try to upload the workspace to FME server I get a error message saying "@Value(connection) is either missing or unsupported by this version of FME Server." Any suggestions or workarounds would be appreciated.

Hi pls help me with this. I just want to know which direction building is facing. I have thousands of building and i want that at once all buildings front direction should come out. The data i have are building foot print(.shp), 3d model (citygml) and road center line(.shp)

How can I fit a data in obj format to its real location in the world?

I have extracted files to an output folder like this. I want to extract the files inside the zipped folders and tag the folder name to the output file. How do I do this as a bulk process. The unzip transformers only seem to do one at a time but I am sure there is a better way.

Hi guys,I am working on a basemap project in arcgis pro now I have to create raster tiles and vector tiles for the basemap.So my questions are​1) Can we open and visualize arc gis pro project or map package in FME if yes then how?2)Can we create raster tiles in FME?3)Can we create vector tiles in FME?4)If we are using web Map tiler then can we import our own arcgis schema?This is a part of my study project ​Thanks in advance.​​

FME Desktop 2022 Build22153: The color and frame of transformers are not printed as the workbench is printed in A4 paper size with “fit to page” option,  I couldn’t figure out why the color and frame of transformers are not printed as the workbench is printed in A4 paper size with “fit to page” option as per the screenshots below What could be the issue here? The workbench is attached          

Hello,I am trying to configure SharePoint List Reader/Writer using the Web service Template. I tested FME 2021 and 2022. I have an Azure Single Tenant environment and followed the documentation (https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection#singletenant, https://community.safe.com/s/article/Create-an-FME-Server-Azure-Active-Directory-Web-Connection-in-FME-Desktop, https://community.safe.com/s/article/Troubleshooting-SharePoint-Web-Connections-and-Services).  I did the following:  In the Azure Active Directory portal: 1.      Creating the app registration and getting the Client ID2.      Add the Redirect URIs (https://login.microsoftonline.com/[TENANT_ID]/oauth2/nativeclient and https://localhost) for a newly created platform3.      Setting API permissions accordingly In FME Desktop: 1.      Creating a new Web Service from the existing template2.      Setting the Client ID3.      Setting the Redirect URI with the same value as mentioned before. I tried b

Hello there we have number of truck send there location over time and status as below we are looking to create an event for each in/out status , the result will bewe will create an event as soon as we detect status = in and we will close the event as soon as status=out  Thanks 

Hello FME Community, I want to create an access database from my tables.When creating the database, some columns must be defined as primary keys. I want to know how can I define column in FME as primary key before writing.  

I'm interested in generating SQL automatically, for use in SQLExecutor

In FME Workbench I have a Bufferer transform which is stopping on a specific feature. FME is reporting:Bufferer_SC1_2DBuffering (PolygonDissolveFactory): Buffering feature number: 49788And stops.How do I find out what feature number 49788 is referring to? What I want is not the FME Feature number but the value of a unique user identifier called search_criteria_pk_id.regardsSimon

Is it possible to upload a zipped File Geodatabase into a specific folder in an AGOL user account using FME? if yes, what would be the best transformer(s) to use?