Transformers

Hi allI've been given a handful of grid shift file (.gsb) that I need to add to FME Cloud so that I can use them within a published service (via the CsmapReprojector transformer).This is what I've done so far.On Desktop I've copied the .gsb files to C:\\Program Files (x86)\\FME\\Reproject\\GridData\\Australia and modified C:\\Users\\<user>\\Documents\\FME\\CoordinateSystems\\MyCoordSysDefs.fme, adding the custom transformation definitions which point at the relevant .gsb. For example:The transformation was tested and worked fine using desktop.I then uploaded this modified MyCoordSysDefs.fme file to FME Cloud when I published the workspace I'll be using. I uploaded the file to myfmecloud.com/fmeserver/resources#/Engine/CoordinateSystems.I realize the transformation definitions in MyCoordSysDefs.fme points to a desktop file location, not the server location so I presume I have to upload the .gsb file to FME Cloud and change the GRID_FILE parameter values in the tr

I am using the SBS-Plugin for Smallworld to connect to Smallworld datastores. The plugin version is 2021,FME version 2021, the Smallworld version we are using is 5.2.3. We have connected a new datastore to Smallworld. Unfortunately this new datastore does not appear in the table list dialog of the SBS-reader. Any ideas?

Hi, I need to download files using WFS link and zipped it and publish to FME Flow so that I can share the link of the zipped WFS files to other. Can anyone assist on how to achieve this? Thanks

Is it possible to delete rows in Excel based on a cell value? I am comparing a data-set in Excel to another Excel file using Feature Merger. I want to delete the rows in the data-set which match a specific field (DETECTOR) in the new file(s).I feel like this should be very basic since Power Automate can do it (And MS has a surprisingly poor integration with their own software). The closest thing I found was the Database Deleter, but it doesn't have an Excel option for format. I can add Microsoft Excel as a new custom format, but that doesn't behave the way I would expect (opens a new workspace?).

I've been using a couple of Affine transformer to transform data from/to a custom, local coordinate system. I just discovered the possibility of defining a custom FME coordinate system with the TMAF projection, so I'm trying to simplify my workspace using this. I put a new TMAF (based on UTM32) into MyCoordSysDefs.fme and then use it in a regular Reprojector transformer. It's my understanding that such affine transforms should be invertible, and that I should just need to change the from/to coordinate systems in the Reprojector to get the correct transform, but I can only get it to work one way? How is this supposed to work?

Hi, I have multiple gdb with feature classes. I would like to get one feature class per each gdb as a sample. The catch is that I do not want to read all data as it's massive. I would like to filter/sample it while reading something similar to SQL Creator

Hi, I have a workbench where I download data from Arcgis online.For this I use the transformer "ArcGIS_AP_FileGDBExport". This works fine with FME Form. But I will use this workbench inside fme flow and during the upload comes the following warning: If I ignore the warnings the workbench is not working! How can I set up web connections correctly in fme flow?

good week everyone There is a yield in point format. I want to produce a line from these points. There is a method I used before, but I did not get very good results. As an attribute, each point has a shooting time. Can I create a line using this shooting time?

Dear FME Community, I am facing a challenge while using the SharePointOnline Connector in FME to load a CSV file directly as an attribute. My objective is to avoid storing this CSV file on any network drive, local drive, or an M365 named account OneDrive folder. Instead, I'd like to process it immediately within the FME workflow. Goal:My end goal is to convert this attribute—which contains the entire table from the CSV file in text form—into a temporary table or a temporary CSV within FME for further transformation. Version:I am currently using FME version [2022.2.0.0 (20221103 - Build 22765 - WIN64) ]. Problem:I can successfully load the CSV file as an attribute (see picture), but I am struggling to convert this attribute to a format (temporary table or temporary CSV) that I can then transform further.  Questions:How can I convert an attribute (_contents) containing a full CSV text file into a temporary table or CSV within FME? Are there any transformers or specific settings that

I have used the FeatureWriter to save a csv with a dynamic filename of "Name_@Left(@DateTimeNow(),8)" before passing on the features to be used by the Emailer transformer. However I only get a result from the Summary port and nothing in the output port.  If I change the file name so that it doesn't include functions and uses an attribute instead (creating a new attribute to handle the date function before the featurewriter) then I see features in the output port.

Hi, I am trying to run the attached fme workspace in fme server as datastreaming service. The workspace works fine in FME Workbench and while running in FME server web interface as datastreaming service. However, I am trying to access this service from my web app. Below is how I am forming the request : var httpRequest = new XMLHttpRequest();httpRequest.open("POST", url, true);httpRequest.setRequestHeader("Authorization","fmetoken token=*********")httpRequest.setRequestHeader("Access-Control-Allow-Origin", "http://localhost:8080");httpRequest.setRequestHeader("Accept","application/json;charset=UTF-8");httpRequest.setRequestHeader("content-Type","application/x-www-form-urlencoded"); httpRequest.onreadystatechange = function() { if (httpRequest.readyState == 4 && httpRequest.status == 200) { console.log(httpRequest.responseText); } } // send a request so we get a reply httpRequest.send(&quot

Hi, everyone I'm new to FME, I had some difficulty in getting the geometry shape of walls converted from CityGML to IFC. The details are as follows:I can get the Guid of each wall, but there is no geometry information, could you give me some help? Thank you very much. Best regards Ying

I have attached a screenshot of the start of the proces without the loop. I want the loop to continue until there are no failed output in the tester. Any ideas on what I can do? Thanks!

I need to find distance between many lines, any suggestion? I tried NeighborFinder, but not helping.

Is there a way to get the field name aliases from an ArcGIS Feature Service instead of just the field names?

Hello everyone I have street numbers. I have the first and last number of each street. I would like to know witch are missing from my database. My idea is I set the min number ect 1 and the max 60 and creat a list or array to this street has theses numbers. A di could compare it with my database and find with is missing.Thanks advice

Hi All, I have a record with these attributes: ID, Condition1, Condition2, Conditon3. Condition values are integers. I want to write to an new attribute the name of the Condition attribute with the highest Condition value. IE if records is ID =Bob, Condition1 =20, Condition2=0, Condition3=80 then write out 'Condition3' to my attribute.  I have created a list, sorted the list then used listindex set to 0 which returns highest value but not the attribute name from where it came from. Any help appreciated @takashi Thanks Steve

I'm able to create a point shapefile successfully.

import os def get_excel_file_paths(folder_path):  excel_file_paths = []     for root, dirs, files in os.walk(folder_path):    for file in files:      if file.endswith(".xlsx"):        excel_file_paths.append(os.path.join(root, file))           return excel_file_paths folder_path = "/path/to/my/folder" ----I have a list of folders in a csv file which i read into the workspace so i plan to use that attribute hereexcel_paths = get_excel_file_paths(folder_path) for path in excel_paths:  print(path) Having troubles converting this to run in fme Thanks!

I have an Excel spreadsheet that contains 2 columns, 1st column is called Terms, 2nd column is called Definitions.  What I want to do is convert each flashcard pair (4 rows) into multiple choice questions via GPT3.5Turbo. The problem I'm running into is that while OpenAIChatGPTConnector  takes in the data just fine, it is only outputting 1 pair (The last row). How can I work around this? 

I encountered something a bit weird. In a bit larger workspace I wanted to apply parallel processing for part of the workspace, so I embedded that part of the workspace (which already contained some custom transformers) in a new custom transformer. Then however I obtained some issues with the parameters, it seemed that they were not passed on correctly. Attached is a workspace where I replicated the issue. It's just a dummy workspace that connects to an Oracle DB, and (aims to) return the static result; 'Greeting' = 'Hello'. Main;CT_0;CT_1;If I run the workspace with a database connection named 'My_DB_Schema (1-O) @ dev', I obtain an error;Error connecting to Oracle database: message was `ORA-12154: TNS:could not resolve the connect identifier specified'. (serverType=`<serverType>', serverName=`My_DB_Schema', userName=`', password=`***', dbname=`') Although this issue occurs with a Database connection parameter, in my main works

Hello, I am using the sqlexecutor and I am populating the attributes to expose from sql query. It correctly displays them but there is a (ok) button missing to add them successfully. When I close the window (x), they won't be added.

Hey FME Users, There is a lot of information in and around OSM on the forum, but can we add OSM as the background map in Data Inspector?

I have been tasked to set up an automation that will FTP a file from a State-supported site to our network.I have been advised to use the FTPCaller transformation to achieve this. I have the specifics to the State-supported site and, using WINSCP, can manually download the file. In order to do this, In WinSCP, I supply the host name, the port, and a username supplied by the State. Additionally, I have to click on the Advanced button, then under SSH click on the Authentication text, click on the ellipsis (...) under Private Key File I enter the name of a Putty file (that was given to me by the FME Administrator) The file is sent by FTP using this manual method. At this point I am trying to automate the process so that the FME, using FTPCaller as advised, will achieve the same transfer. However, I am not clear how-to setup the FTPCaller to incorporate all of the parameters (host name, port, username, Putty file) that I have been given for the manual transfer. Can I get some advice on

I have a workspace app that accepts a kmz dropped on it. The result is a postgres/postgis spatial overlay with the kmz. When there is no resulting feature I need to send a message to the app instead of the resulting data. I have added NoFeature testers into my workspace to capture any streams that do not have output. Just not sure how to generate a report and get that to the app when the workspace completes. I am thinking now it would be nice to have a count from each of the input data streams whether there is a spatial relate or not.Thanks for any direction.