FME Form

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

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 repea

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}",  "ASSETG

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 So

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.

Hi how to avoid to repeat 3 days of data read after a translation failed? Seems the temporary folder run out of space. Can I swap the temporary location and restart the process from certain point instead of starting again from the begin? Alex

I am running a workspace that detects changes in data between an API and Web App and applies only updates to the Web App using a change detector transformer. I am sending a notification to a Slack Webhook but instead of a single HTTP request being made, it makes 1 request for each data record updated. What I Want:"Successfully updated 70 records". What is Happening:"Successfully updated 1 records"."Successfully updated 2 records".And so on till 70... Is there a transformer that will allow me to sum the number of updated records and only send a single HTTP request to the Slack Webhook? Workbench Screenshot: Thanks!

Hi all, I am generating a workspace for a client. A requirement is that output data should be in EPSG:29902. The writers have been defined to use 29902 as the output coordinate system. However, when I open the datasets in QGIS or Arc, the data is reporting as coordinate system EPSG:29903. Is there a way to correct this behaviour? Attached is a simple workbench with a creator transformer and a writer set to use 29902. But the output generated is 29903. Many thanks

I have a list of hyperlinks in Excel that lead to PDF's held in a website. Can FME iterate through this list and download the documents to a folder? Thanks in advance. Sean

I've got a HTTPCaller in a loop that retrieves data page by page (I use offset and limit). I have a tester that tests whether 'has_last_page' is true. This all seems to works ok but the translation does not stop - it just keeps repeating the last URL even though all records have been returned.

I'm extracting some data from a DB that stores values for time periods against a date in a comma separated list (above). I've used a cloner to create the time period for the date. Any idea how I split the csv list (presumably using an AttributeSplitter) and append the value to the desired timestamp? Any help appreciated!Thanks    

This morning all of my FME workbenches failed to open and I get an exception breakpoint application error. It says (0x8000000003) occurred in the application at location 0x00007FFAB8D6293. The only option is to terminate the program. Any help would be appreciated. Thank You. 

Hi All, i have been banging my head against this for a while. Im trying to parse an api call response I get ( XML returned) . I have tried Flattening it. I have tried Fragmenting it, I have tried swearing at it. None of the things I have tried have worked. I don't really understand how this data is structured. Its nested I think, with something like tuples??? there is a Name, Number and Text for each attribute?? Any help or direction appreciated. Happy to learn. I'm trying to return the "number" value of NZTM 2000 Northing and NZTM 2000 Easting as attributes... Many Thanks for your suggestions.

I have an issue where I have text that contains braces that are inputted into an XMLTemplater through a SubTemplate (and also through ROOT). Since I don't want the XMLTemplater to parse the text, it is referenced as @Value(text) and not {fme:get-attribute("text")}. Still I get an issue as if FME expects a function. The log tells me: "context item": undeclared variableFor this issue I prefer not to escape the braces in my text, which of course would be a workaround. 

Hi Everyone, I need your help to solve a problem. I have many no. of points that are not in order if we look at them spatially and in many places, there is a significant gap considering its distribution. I have tried Sort and then Line builder transformer in FME but the output was generated based on the layer drawing order. Another issue is line builder does not consider the gap within point distribution and connects all points to generate a single polyline. Looking for a solution to convert points to separate lines based on their spatial sequence. The attached below screenshot could make you clear about the issue I am talking about.   

I am running workbench an FME Server automation that is fired from a SQL Server insert trigger for a ArcGIS feature class that has editor tracking enabled. On the workbench I check previous records for the feature and only want the workbench to complete under specific conditions - it is writing an HTML file. I was considering using the NULL writer but the documentation indicates this should only be used for testing. Looking for the best way to accomplish this. I considered modifying the trigger but this is so involved and much easier and cleaner to do in FME... Any tips would be appreciated.Thanks!

Hello,I am trying to obtain Max OBJECTID value from a database and pass it into Variable Setter.The SQL Creator > Variable Setter is obtaining the correct value (just one record at present) but the Variable Retriever cannot obtain the value I think?I hope this is a simple step or order I am missing.Thanks in advance