Transformers

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

Hi,there are two sets of line feature. The lines of the first set are interrupted, figure 1. The second set is a whole boundary line extracted from a polygon, figure 2. The coordinates of point 1 and point 3 are equal, so do point 2 and point 4. Now I want to add the bottom line from the second set to the first set, leaving this yellow line, and breaking at the intersection. What should I do? Thank you so much.

We face a problem correcting the geometry between multiple polygons in a layer.There are some gaps between polygons and we need to automatically fill them. We identified 2 ways to fill the gaps between 2 polygons, explained in the following chart. We tried the first solution using dossolver and Donut Hole extractor, but there are some line left after the process (maybe due to the different positions of the shape vertex on the grid). So we don’t know if our process is the best to succed ? if yes , how to fix this problem ?

Is there an escape character for the SQL text box in the SQLExecutor?If I try the following SQL against and Oracle database - select OFFICER from officer where lower(email) = '@Value(userName)'where userName value is in the format of it will fail because FME turns @Value(userName) into a string (evidenced by highlights in this picture).If I format my userName field to 'myemail@address.com' and remove the single quotes in the query as per this picture, the query will succeed Obviously I can run this through extra transformers to format my values beforehand but this is adding unnecessary processing and workbench bulk.Here https://knowledge.safe.com/questions/36933/how-to-prevent-single-quotes-turning-my-parameter.html @daleatsafe has stated that FME doesn't touch single quotes, but it appears from my first picture that it does? Or I have misunderstood something in that post.Also select OFFICER from officer where lower(email) = '''@Value(userName)' run

Hello,I would like to create the Dist CLoud/Mesh tool of CloudCompare.I have 2 input files. One is individual points (PointCloudCoercer : Individual Points) from the class Building of a Lidar point Cloud and second is polygons representing roofs in SHAPEFILE. I wanted to measure the (vertical) distance from each point to the nearest polygon.I firstly used the SurfaceDraper to drape the points into the roof, then measure the distance between the draped point and the original points, but it didn't work as you can see below. Do you have a solution to my issue ?Thank you in advance,VictorPoint cloud : You can find the Shapefile polygon via this link: https://wetransfer.com/downloads/291f3edefb457b27a0f286ca68e3420120200624124047/919a8805a20a2c4b08eee3a830f2776e20200624124104/84c603