FME Form

Does's it possible to use where clause for more than one feature type? f.e. [gas_distribution]cp_bond_wire where id > 0; [gas_distribution]cp_rectifier where id > 0Two where clause delimited with ";".

In TestFilter, is there a trick to allow specifying the list index range in the Test Clause?e.g., _list{[0-2]}.fruit = 'Apple'rather than specifying each element index to test for individually:_list{0}.fruit = 'Apple'AND _list{1}.fruit = 'Apple'AND _list{2}.fruit = 'Apple'without going into PythonCaller way?

I am trying to read in multiple files from a folder at once which contain a specific text string in the title and not any files that don't contain that string. I want it to be dynamic, such that if the files in the folder change, the reader will update as I want to put this at the start of a workflow which will put all the features from each individual source file into a single file and perform some transformations with that data. I have managed to figure out making a reader that looks at a folder and all its sub folders, but it reads in all the files in the folder, some of which I don't need/want. Is there a way I can apply a search filter to the reader so it only brings in files that have certain terms in the title?

Hi FME community, I'm creating a workspace to automate a proportional spatial sum.I have polygons with employment data.And I have bus stops that I'm using to create multiple buffers as my zones of interest. I'm testing this with zones I've already caculated with MapInfo GIS software so I know what values I'm suppose to have in the end, and i'm able to compare this with FME workspace results. I get the expected result when I aggregate all my stops points from all buses indifferently: But I also need those stats for each bus separately. To do so, instead of aggregating indifferently all points, I do it with a group by using my bus name attribute.But the results are way off.  If I add a tester before the buffer, in order to filter only one bus, I have the exact result. As soon as there is more than one zone of interest the results are false.My guess is that I don't know how to use the clipper correcly with multiple zones as clippers (even if the clipper type is

How to find the distance between two point efficiently. Have used Linebuilder with a larger dataset and it takes ages, workspace with test data is attached.

Hi FME Community,I have a large polygon and I would like to devide or split it to mosaics. do you know a transformation capable of doing it for me automatically.Thank you in advanceArash Hokm

I have a geotiff in tif format & ovr format. I want to convert this to another format such as a CSV or autocad format but I can't seem to get the correct output. Any help is appreciated

I have a workbench that fetches data from an API and updates a Web App in ArcGIS. I am using the Teams Connector to publish update information to a relevant Teams channel. When running this workbench locally I receive no error and the message publishes successfully to Teams. The Problem: After publishing the workbench to FME Server in Cloud, I am receiving a strange error which I cannot seem to find the solution to on any article. The error and workbench are shown below. Error: Workbench: Looking forward to hearing any opinions.

Hello all,I am using CoordinateExtractor to extract the start and end coordinates of line features. Most lines have only a start and end but some have an intermediate vertex. I want to extract the start and end for the list created but if I use the -1 I get no results (according to the help 0 should be start and -1 should be end)  If I open the text editor it is showing a problem with the expression  Can anyone let me know what is the correct syntax to get the end point, please?

Thanks to Debbi L for her help today and pointing me to:https://community.safe.com/s/question/0D54Q00008FXAFASA5/i-have-a-100-ft-line-that-curves-and-then-turns-back-into-a-straight-line-how-can-i-use-fme-to-only-gather-the-straight-line-after-the-curve-only-i-basically-want-to-cut-out-the-curve-and-only-grab-the-line-after-the-curve While this helped, I am at a loss as to how to build the rest of this in order to achieve the removal of unnecessary vertices. I was hoping Generalizer would be able to do the trick but it is mainly based upon the distance between vertices. Any help would be appreciated!😉 To expand upon this, I would want to remove the vertices in the adjacent lines segments highlighted in this image:

Hi, currently all my zipfile output from my FME Server App using the Data Download Service are being named with "FME_" following by some random numbers. I would like to ask if there is any guide to change the naming of the zipfile, be it through the FME Server UI or configuration files. Thank you. 

Hello, How would I remove specific vertices from a feature that are stored in a list, the vertex remover only allows one vertex be removed. I have a list with: Coordinate Index - vertices_to_remove{}.vertice_indexX - vertices_to_remove{}.xY - vertices_to_remove{}.yZ - vertices_to_remove{}.z Thanks 

Hello,I have about 5000 DWG files that have a lot of excess layers that have no element. I would like to use FME to delete or clean up the layers that have no element. I would be grateful if you could help me, which transformations can help me with this.thank you in advance 

Hi FME'ers,Apologies for the lack of What's Up Wednesday last week. Both Liz and I were out of the office. Anyway, let's dive into FME news for this week. Upcoming WebinarsIt's been a while since I listed upcoming webinars, so here are a few.   The most important to me is Build Your FME Community Network, where on October 19th Dale and I will cover some of the changes we're making to this community, and have a go at a couple of community activities. So make sure to join us because it should be both educational and entertaining. Also upcoming is the Masked Revit User on October 27th.  This is where a special guest Revit user will demonstrate real-world examples of what others have made possible by using FME to automate preparing and extracting from Revit. The other webinar I wanted to highlight takes place on 20th October and is about Automation Keys in FME Server. Automations are really powerful items and one of the reasons is the ability to pass information from on

I am really, really new to FME and so trying to wrap my head around everything. Essentially I have a CSV that has multiple data sets one after another, split by a multi line section of header information that it not formatted the same way as the data. I'm trying to read each section of data and write it to a single database table. So for each section I need to read a specific line within the header area (Serial number and Counter Name) and then use that as one of the attributes in the writer.  Data should look like : SerialNumber, CounterName, Date, Time, Value When complete in order to write it to the table.  From the various posts I've found I think it might involve using a variable setter and variable retriever but I'm not sure how to make that work.  Any suggestions are appreciated.  

Hello FME users,I just wanted to share some information about an update to data types in FME2020, which I don't think has been publicized much. The best demonstration is through a video, but first here's a brief description of the update...Data Type PreservationIn previous versions of FME, attribute data type would not be preserved fully throughout a workspace. For example, a writer could not determine the data type of an attribute added or edited in the workspace.You could prove this by following these steps:Open FME Workbench 2019Add a writer and set the feature type attributes to automaticAdd an AreaCalculator transformer connected to the writerThe result is that _area is added to the writer, as type char(200). The writer was not able to tell that this attribute should be a numeric type. You would often see char(200) fields as a default for unknown types.In FME 2020 this has changed.If you repeated the above step in FME 2020, the result would be a real64 field (or the equiva

Hello,I have a few ESRI generated json response files from ArcGIS Server feature service that can contain 1 to 200 records per response and these do not have geometry.  What I want to accomplish is to add one new parameter "projectnumber" and assign it with a static variable and rewrite the output back to JSON or ESRI JSON file again.  Thanks in advance ! Original: {  "attributes": {  "sapfloctplnr": "MASG-GASD-SA01-SERL-0055647",  "lifecyclestatus": 1,  "GLOBALID": "{E839E029-529F-4D6B-9C4E-85BD875BC582}",  "ASSETGROUP": 1  } }, {  "attributes": {  "sapfloctplnr": "MASG-GASD-SA01-SERL-0055649",  "lifecyclestatus": 1,  "GLOBALID": "{A9BF1A40-C1E4-4BC7-A538-7011FA9C55EA}",  "ASSETGROUP": 1  } }, {  "attributes": {  "sapfloctplnr": "MASG-GASD-SA01-SERL-0055659",  "lifecyclestatus": 1,  "GLOBALI

I'm looking to build a workspace for an FME Server App to read a generated QR code that has a CSV list of attribute values in as an attribute and further transform it. Does anyone have any experience?

HiI've set up a Workspace that does the following; Dissolves a MapInfo Polygon layer, adds a Counter and Attribute Creator then produces a 2d Oriented Bounding Box (and saves a MapInfo table) Chops the Bounding Box including the Longest and Shortest values (and saves a MapInfo table as well), adds aother Counter then a Sorter & Sampler and then saves the result as a MapInfo table with the longest line from the Chopped table In total there are 197 polygons in the source table which becomes 13 Groups when dissolved. However, the final Table containing the Longest line for each Group is incorrect as some of the lines are the shortest ones. There are the correct number of lines though (13). I've attached the FME workspace and a zip file with the source MapInfo table. If anyone would be interested to run the Workspace and see where i've gone wrong. I've tried using other columns within the Sorter and Sampler transformers but still get the same result. It may be the Sorte

Hello,I wish to generate a count of points within Polygons [PointOnAreaOverlayer] but I am unable to generate a count for some polygons because of fme_rejection_code: INVALID_POLYGON_GEOMETRY_TYPEThese Polygons are either Self Intersecting or Multi Polygons. I believe I need to resolve this before I can start counting points inside but Aggregator and Geometry Validator do not seem to fix the issue.Thanks. 

I want to write a DWG containing a mesh (it is one feature in FME), but it always gets split up into strips with a specific number of vertices like there is a limit (see image). Is there anything I can do about it or is it just a restriction by the DWG format? I'm not very familiar with the DWG datatype, so maybe there is another autocad entity that is better suited?

I need the operations to work in the following order:TerminatorDatabaseDeleterData Load (rest of workspace) I tried using a WorkspaceRunner transformer, having split out the three functions. It works fine if I'm in FME, but if I try to run it using a batch file, it errors out. Ultimately, I want to be able to schedule this through Windows Task Scheduler to run nightly. It will compare the last updated date between two datasets, and terminate if the destination dataset is already up-to-date. Otherwise, it will proceed to delete a subset of the destination dataset (a "partial truncate" for lack of a better term), and then re-load the new data.

I found something back in 2009, but nothing since and no solution built for this. I have Intermedite knowledge of FME.  I have a records for every 50 meters along a roadway that contains 3 fields Ride value, Rutting, and Surface condition. These 3 values make up our Condition state of our segments. I want to reverse this and build my segments based on a Rolling average for say 1 km minimum (20 records) where the average IRI = >x, Rutting = >y and SCI = >z. it would then build a polyline or group by averages. This would be a massive upgrade to our current system which involves shovels, hammers, and coffee!!! Sample graph where the red line would be my split, the roadway here groups into 2 segments.

We have a Mapinfo file with customers and we're using this stupid third party geocoder (for now hopefully changing) and we're pretty sure it's having an issue because of the size of the table we're sending it. I was thinking maybe I could get around it by having FME split the table into 3 equal tables and then geocoding them and then combining them back together. Does anyone know of a way to do this? There's no real column info that I could export based on anything it would have to be after X rows or something similar to that. Thanks so much! 😀

I am new to FME Desktop and experimenting with downloading a feature from a Map Service hosted on an ESRI ArcGIS server. Is there a way to enable the "return_true_curves=True" when downloading the feature to a local FGDB. I have everything working using a Reader pointed to the map service; however, FME is converting the true curves to simple curves when reading or writing the data. I am able to download the feature using a query and the ArcGIS REST API in python to get a feature with two point curves to a FGDB. Would like to do this directly in FME.