Transformers

I am using NetworkTopologyCalculator to categorise streets by what network they are a part of, with the aim of only keeping the main network and discarding the islands.How do I determine the most common network_id value?And then how to I place that value into an AttributeFilter to only keep those features?

I have a number of large CSV's which dont have headers for the collumns. I then have another CSV with the headers / attribute names.  I want to be able to map the atribute names from the header csv to the incoming CSV's with the data in?  I suspect there is a simple way of doing it but i can't find one.  Any help will be appreciated.

Hi.I have a dataset of polygons, which I don't trust entirely. It has a lot of smaller polygons (wind mills?) on top of property polygons.Most small polygons have been cut out of the property polygons, but not all. So I run the data thru the DonutBuilder, just in case.But I've found an error in the output, where a small polygon inside a larger polygon with a cut-out matching the smaller polygon, replaces the former small polygon with a new with the values from the surrounding polygon.I.e., the smaller polygon is inside the outer boundary of the larger polygon, but has already been cut-out of it. In this case a replacement wasn't warranted, but something happened anyway, resulting in the described error.Does DonutBuilder only use "entirely within" the outer boundary for its matching, or ?Cheers.

Hey, So I have an ArcGIS Online Form, users enter an email address.FME periodically checks this AGOL table and grabs the list of email addresses within.What I am trying to do is insert these emails addresses into a local text file, but only if this email address does not already exist within this text file. This text file is simply a list of email addresses, think of it as a single column CSV file.If the email address is already in the text file, FME needs to go off and do other things (that part I have sorted).What is the most efficient way to test if the email address (its just a string) exists in an existing text file?I currently am using a feature joiner to do the test, joined means it already exists, unjoined means they dont already reside in the text file. This does not feel efficient, I am guessing there is a more suitable transformer out there?

Hello,I am using 7z to unzip files and would like to use it through System Caller. The command works perfectly fine in cmd, but not in system caller.Here is my command : "C:\\_temp\\7z.exe" x "C:\\_temp\\input\\data.zip" -o"C:\\_temp\\output"When this line is written in a .bat file and this file is executed through System caller, it works. What should I do to be able to execute my command directly in system caller? Many thanks in advance,  

I've been having some issues with Creating and reading AutoCAD 3D Solid geometries. Through my investigation I have found that the REALDWG writer/reader supports solids the best (ACAD will just read as multi-surface in most cases), however, when it comes to colours/appearances FME is falling short. While I can create a single solid feature with once color (using the default layer color), I am unable to color the surfaces individually which is pretty well supported by a lot of other formats in FME.  In addition DWG files which contain solids which have different color surfaces are just read in with all surfaces coloured as the layer color.  Has anyone had any luck either creating OR reading solids from AutoCAD witch have different colored surfaces?  Here's an example which creates a multi-colored solid box:   @daveatsafe or @andreaatsafe perhaps there are some PR's relating to these issues already? 

Ahoy mateys! Today is Talk Like A Pirate Day and so at the risk of getting keelhauled for this, I decided to have some fun with it and build the PirateOnChestOverlayer transformer (available in the Hub).Obviously inspired by the pirate song from Robert Louis Stevenson's Treasure Island :)Fifteen men on a dead man's chest Yo ho ho and a bottle of rumThere's of course Piratespeak log messages, thanks to heavy use of the MessageLogger custom transformer:And the nice thing is that if there's not enough pirates (we need fifteen, according to the song...) it will send out a press gang to round up some more (now if only it could invade other running workspaces and kidnap features from there...). However... if there's too many (we can only put fifteen men on a dead man's chest...) the extras will unfortunately have to walk the plank...Have fun!

Hi community!Looking for some advice on how to tackle a scenario...I'm trying to get an egg shaped (or ellipse) 3d buffer around some line work. My thoughts were to create some offsets for the sides, centre and top of the ellipse, generate a surface over these using them as break lines then do a similar process for the bottom half. I'm stuck on how to orientate the ellipses in 3D as well as simply creating them from the points and lines that I have. Any suggestions on how to tackle this would be great, be it the ellipses or a new approach to modelling this 'tunnel' shape entirely. Some top notch paint illustrations below. Sample .fmwt data attached.Top view3D view3D view again

Hello.I have input line data in EPSG:3857. And I break the line data into vertices and get points. (by Chopper)Next, I use the MeasureExtractor tool in the hope of getting M - values.However, the tool does not work and issues MISSING_GEOMETRY_MEASURE.Tell me pls, how can I get m - values for vertex?

I have a polyline (.shp) feature that is essentially just a road network in my city and I wish to update one of its attributes from an overlapping area (.shp). The overlapping area is a buffered corridor of a bikepath that I want to use to update the polyline attribute wherever they overlap.  I'm using the lineonareaoverlayer with the following parameters:I want to preserve all the other attributes of the polyline road network. I just want to update the status attribute from overlapping area status attribute. See below:Line feature attributes: Area feature attributes:I want the Status to switch from Not ridden to Ridden anywhere on the line that overlaps with the area. From what I can tell I should be using the listexposer to access the list generated from the lineonareaoverlap transformer but no matter what I try I can't get it to work.

I followed the esxample here to split my comma separated addresses .https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/attributesplitter.htm# However this is not working I exposed the elements of the AttributeSplitterBut they are not available in the AttributeSplitter output nor the AttributeManagerI also tried ListExploder but that gave me a multipe row of the address elements And I want the address parts in a single row in columns What Am I missing here?thanks

Hi,I am trying to read features from a DB/2 database using an ODBC connection. This is the statement that throws an error; Database Generated Error Information:Database Error Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token [ is ongeldig. Geldige tokens: ( NEW FINAL TABLE UNNEST LATERAL XMLTABLE JSON_TABLE <IDENTIFIER>.Database SQL Statement Text: SELECT * FROM [BZSAART00] WHERE 1=0 The problem seems to be with the [ ] around the table name. When I use an SQL executor without the [] it works just fine However since the attributes might differ (I want to loop thru 27 tables to read it's content) using an sqlexecutor is not an option since the attributes to expose will differ per table. Anyone knows a way to get the featurereader to use the right syntax? Is this a bug? Regards,Alex    

We use fme when converting obj files to b3dm format. There were so many buildings and Each building has texture. We created texture atlas(100 building in one texture) due to poor performance of cesiums bad. But fme import the texture atlas to b3dm file for each building. Is it possible to use the external atlas in b3dm.

I have some bad data from an outside source and some of the days are 00 and not 01 (YYYY:MM:DD). The SQL db I am trying to write is dropping these records. Stringreplacer? A little direction would be much appreciated.One of the errors from the log:Microsoft SQL Server Non-Spatial Writer: Failed to parse '19810400' as a datetime value. For FME datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm. For ISO datetime syntax, please see http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/!Transformer_Parameters/standard_fme_date_time_format.htm#ISO-8601-Duration-Format2020-06-26 10:36:20| 5.2| 0.0|WARN |Microsoft SQL Server Non-Spatial Writer: Failed to parse `Date' from attribute value `19810400' for column `prc_date_last_sale'Thanks!!

I've recently installed the 2019.1 betaEdition: FME Desktop ESRI Edition (floating) Version: FME(R) 2019.1.0.0 (20190618 - Build 19594 - WIN64) The sorter transformer does not seem to be sorting correctly.I am trying to sort a large list of alphanumeric location codes like CAON0696, CABC0002, USFL0788, etc.I am sorting alphabetically, ascending. I have tried grouping by other attributes like country and province codes but it is not putting them in the correct order.Sorting obviously worked fine in 2018. Is this a known issue?

Hello guys,i would like to iterate on my reader, i have one reader who read the county feature of the state of New York and a other one who read 8 millon of small polygon who are a mix with slope + swamp and forest.  Well i would like to iterate each county of new york than clip each county by this small polygon and result will be a county with holes and finaly i write all the county with holes in geodatabase. (evry data come from an esri geodatabase)  I read that i can create a master workbench and child workbench and use workbenchrunner. well i ve seen in this forum a guy who write that "If nothing else works, you could iterate over the input features using a master workspace that runs the clipping workspace using e.g. the WorkspaceRunner. You can there parametrize which block to process using a published parameter. But my tip is to start with the top two recommendations first. " the thing i can not really visualize what he mean, so if somebody can send me schema or picture

I have searched some methods to convert polygon into lines on FME. But none of these could do it.Firstly, I extract a closed polyline of a polygon with GeometryPartExtractor, and then try to decompose it with Chopper. But instead of four lines, the result is many of broken segments. Secondly, I turn a polygon to a closed polyline with GeometryCoercer, and then try to decompose it to four lines. But the result is also many of broken segments with Chopper, or only one closed polyline with Intersector.  Why is that? Can anyone help me? Thank you so much.

I have a simple workbench consisting of a FeatureReader, a VertexCreator and a FeatureWriter writing to a postGIS table. I am reading an Excel spreadsheet.The problem is that the FeatureReader is reading an extra row beyond the data and passing null coordinates into the VertexCreator. I have 103 records, but for some reason it is reading 104. The columns in the last row are all marked as missing. I have checked to see if there is any spurious data, like white space in the last row that might be getting registered as data, but I can't find anything.

Any recommendations on how to reference FME in academic papers? For comparison, QGIS has this guideline: https://www.qgis.org/en/site/getinvolved/faq/index.html

How to convert polygons to lines and vice versa?  I couldn’t figure out how the conversions are implemented in the FME. For example, how polygons are converted to polylines and vice versa?  Thank you  Best  Jamal

I am using NetworkCostCalculator to calculate driven distance along a network, storing the cost as a Z-value (though I could switch to Measure)Is there a way of splitting the line at a specific value (3500 metres) of the Measure?And then keeping those streets below the same value (3500 metres)?I am currently using a Contour Generator, but that gives bad results when a road loops around and comes back with the tail end getting caught inside the contour even though the driven distance is too long

Hi, I am trying to create a service area of 2km down a road network from a known starting point. Ie select any road/or part of road within 2km of my starting point (via the road (not an isochrone)). The equivalent of ArcGIS service area. I have read and downloaded the FME "Calculate Emergency Travel Times" example but am a bit lost. Im guessing i need to use the Network Cost Calculator... Any suggestions or ways forward would be appreciated. Thanks Goatboy.

Hello,I have a set of features, which have specific(but varying) attributes that I want to expose. All these attributes are uppercase, but all features do not have these attributes, and the names of the attributes vary quite a lot. The only thing they all have in common is being upperspace. I can filter them out with the PythonCaller, but I am unsure about how to input them to the AttributeExposer. The only input I can give the AttributeExposer is to open a file and read from there. Seems like a big workaround to read all the attributes, filter them, then write to a file and then open it.

Hi! I got several lines made of polygons with the CenterLineReplacer (medial axis), but i only want to keep the longest line with only two ends of each line. Is there a way for that? In the picture below you can first see the line with several ends, in the second picture you see the line as it should look. Thank you in advance!

How to remove “Self intersections” using FME  I wonder if there is a method to repair the self-intersections in the FME such as the ArcGIS tools “(Check geometry and repair geometry).  I have used GeometryValidator but it fails to repair the polygons, What might be the issue here ?    Regards, Ahmad Saleh