General

Doesn't appear as an option now on the website

@david_r​ Hello David, Need your help on the issue related to distributed engine setup with FME standard trial license where single engine is installed separate machine and remaining FME components on another host including Flow database on same. Kindly refer below link with example#2 that has been followed.https://community.safe.com/s/article/A-Guide-to-Choosing-your-FME-Server-Deployment-Architecture#FTEx2I have attached the log snap for your reference.Thank you.

Yesterday I used the FME clipper transformer to curve out unwanted portions in a polygon feature class from another polygon feature class. Both feature classes are in two separate Esri file geodatabases. It is a very simple geoprocessing operation, but it runs very very slow, measured in hours, some even became hung. Tested this in several feature class datasets, the same behavior - terribly slow. On the other hand, using the Erase geoprocessing tool in ArcGIS desktop, it finishes in 2 - 5 minutes for all the tested datasets. The results between FME and Esri Erase tool are exactly the same. So wondering why the FME clipper is so slow. I have been successfully promoting FME in my company in the last few months, but this came as a big slap on my face. I am at FME 2019.2.

I believe currently each FME Flow engine only uses one core per engine. Meaning each workspace that is being ran is only utilizing one CPU core. My question is does this also apply to Python ran through a Python Caller in the workspace when being ran in FME Flow? For example, I have a Python caller running an Esri tool and set the parallel processing of the tool to be 5 (meaning the Esri tool will use 5 cores). Does this mean the Python will use all 5 cores? Or does FME Flow still limit the Python from only being able to use one core?

Workbench was set up in FME 2020.2 where the Writer spits out a csv file, however in the new FME version 2023.1 it creates a sub folder then spits out the csv file. How would I configure so it doesn't create a sub folder?

Hi All, I'm putting together a workbench to run a multi criteria analysis (MCA) based on a hierarchy (hierarchy level 1, 2, 3, 4, 5, 6, etc). The conditional values in the Attribute creator will help me with that. The problem is that some of the values of the hierarchy need to the next level of the hierarchy . Here is the hierarchy that needs to be followed:  - Hierarchy Level 1- Hierarchy Level 2- Hierarchy Level 3 o Exception A : Any record in level 3 is ‘No main habitat’ will go to level 4 in the hierarchy, if level 4 is empty then goes to level 5, if level 5 is empty then goes to level 6, if level 6 is N/A then goes to level 7.- Hierarchy Level 4- Hierarchy Level 5 o Exception B:  Any record in level 5 is ‘Individual Tree’ then goes to next level 6 in the hierarchy, if level 6 is N/A

Hi, I create a filter in an Excel worksheet and then I want to read the filtered result with FME. Is that possible? Or do I have to copy the filter result to a second worksheet?

I'm attempting to use FME to inventory folder locations for all shapefiles and file geodatabases, and all feature classes within the file geodatabases to export to an excel file. I am able to identify all shapefiles and geodatabases, and can complete what I'm attempting to do but the performance is really slow. Some background on the workbench I've made - I'm using the feature reader transformer to read the file geodatabases to identify the feature classes (Esri Geodatabase (File Geodb Open API) Reader). The workflow seems to be getting super bogged down at this transformer. I've set the parameters to read only 1 feature, but it still seems to be reading all of the features within the feature class. Is this just the nature of the transformer or is there something I'm missing that's causing the transformer to still read all of the features? I've attached a picture of the feature reader parameters below - any suggestions are greatly

I have two layers point and a polygon, I wanted to have the aggregate of a column name "Progress" with its respective polygon name and polygon id. The progress field in the point layer has the values namely 1, 2, 3, 4, 5 . The count is the total number of points inside the polygon.  The result should be like this   I have currently done this process in FME The result is How to change the workbench to attain the desired result. Any leads will be helpful. Thank you. 

Is there a way of validating that the data contained in an attribute is valid based on a table of values?I know I can use a CSV list in a tester with 'in'. But my table of preset values is 4-500 entries long, and has the possibility of change, is there a way of comparing directly to this table, or using the table to populate the CSV value (maybe through a parameter?) automatically?

I'm trying to clip out 'curves' from a polyline. I have a 2 layers, a polyline layer and a point layer. The point layer has a "point type" attribute that states if the point is "Tangent-to-Curve", i.e. the beginning of the curve, or "Curve-to-Tangent", i.e. the end of the curve. There is a one-to-one relationship between "Tangent-to-Curve" and "Curve-to-Tangent" points.  The issue is that the "Tangent-to-curve" and "curve-to-tangent" points don't have a shared id to link them.  My polyline layer does have measure values, which might be of use.

I have a routine to be done once a quarter-year or maximun a month. There is some major file downloading and processing that was managed by parallel workspace runner in Form (Desktop). I need to deploy the same routine on FME Flow, but I need to take advantage of parallel processing. As I understood I can't process multiple simultaneous jobs with one engine.So I have tried combining it with FME Form WorkspaceRunner that actually works, but somehow can't pass the DB connection from Flow job to Form workspace. Is there a way to pass the connection from Flow job to WSRunner other than embedding the connection and so creating a workspace for every DB connection?

Hi,I have been asked if FME can retrieve signal data from a site with no API. I have credentials to get into the site, and once in I can pass a list of site ids to a url to retrieve a csv file of the data.I'm having issues passing my credentials in the header of the HTTPCaller as UserName and Password to get past the login page. Any idea if this is possible? This is the site in question:https://www.detecdatapro2.com/login

Hello ,i have some points at the same line each two point has the same attribute .i would like to connect each point that has same id together So I think I can use line builder with group by id .how but how to connect each two point without the line intersect with other points ? as my phone , point 1 and point 4 has the same id but if I connect 1 and 4 together so it will create line intersect or overlap on other line between 2 and 3 2 ,3 has same id 1,4 has same id what should I do to create line between 1,4 and other between 2,3 ? The line should cross but not intersect because I would like to use network topology calculator later . fme 2021  

Hello - I have been able to use the HTTP caller to get data from an API. However there seems to be a 50,000 record limit. I have created a StartDate and EndDate fields using an attribute manager formatted as yyyy-mm-dd. I was wondering how I can use these fields as parameters to get data from (and including on) those two dates? P.S I have a field that is called OrderDate from the data the API gets and was going to use the dates to filter on that. However this field is formatted as date and time. Any advice would be greatly appreciated. Thanks,  

Hello,We are currently using FME and are quite satisfied with its performance. We are in the process of upgrading our SAP R/3 to an On-Premise S/4 HANA system. My question is whether I require an SAP HANA Runtime license or an Enterprise license to access the tables in my database. Has anyone encountered this issue before? SAP's communication on this matter seems somewhat ambiguous.

Hello - I would like to use the attribute creator in FME to generate a StartDate and EndDate. The EndDate should calculate the last date of the previous month and the StartDate should generate the first date of the previous month. There is no data to refence so I would like to identify todays data and then use the logic to get the Start and EndDate.  The idea would be to use these dates as parameters when calling an API. Does anyone have any suggestions on how I can implement this. many thanks 

Hello - I have several fields in hh:mm:ss format and I want to sum the total number of seconds from all parts all the field. For example:01: 10: 30 would total 4230 seconds  Does anyone know the best way to achieve this? I am brining the data in from an API and have used the JSONFragmenter to tabularise the data.  I assume the current data type for the fields is string as that's the default for FME?

Reading las/laz from network drive suddenly throws error: LAS reader: Failed to open file for reading. Please ensure that the file exists and you have sufficient privileges to read it. Other filetypes works fine eg. JSON. Also, if I move the las/laz files and read the from my local machine it works fine.Any ideas why this happens? (My user have full priveliges on the folders and it's content also I have tried setting full access for anyone on the folders.) Thanks

I FME workspace that creates Autocad to my local drive. How do I create the files in my SharePoint document folder?

I want to pass a feature class name into a workspace and have the workspace tell me if the feature class exists in my SQL enterprise geodatabase. The purpose is if the Feature Class exists I want to backup the existing feature class, then truncate its data and append new data into it. If the Feature Class doesn't exist I want to create it. I've tried the Schema (any format) method with no luck (when you pick ESRI geodatabase SDE if requires you to select the table you want to check against manually and I want to pass in a parameter). I really thought there would just be an "Exists" transformer, but sadly I can't find one. Any suggestions would be greatly appreciated.

I am relatively new to FME and have been attempting to process data which I would typically do with MapBasic. I have gotten so far but have gotten stuck at the point where I would typically run a loop in MapBasic When it gets to the point marked ‘ok to here’ The data is sorted and grouped by asset  1.     What I’m attempting to do is loop for every asset group i.e. asset 12 in the example below and then for RTC, FCD and NoPumps sum the number in the group2.     Update the row where the count = 1 i.e. RTC = 0 FCD=0 NoPUMPs=2 3.     Then discard the remaining lines i.e. 2-7 in the example   i.e.  After repeating for every Asset Group I should then end up with a single line, 10,929, for each Asset, containing the number of Pumps, FCD’s etc         In MapBasic I would simply do this with a few lines of code but can’ replicate with FME. Select

Orientation of a line

Hi, In the workspace below, search the website and return many rows.It´s possible to see in the Translation log, but in the result, only the last row is shown. How can I receive all rows in the result? Thank´s

I have a large DEM (DEM1) and a clipped one(DEM2), I want to replace a specific area of the large DEM with the )clipped one (see image below)