Transformers

I am parsing an XML and writing the header-content into a table. When inserted to database the inserted row (always 1 row) will be assigned a primary key. The same XML contains a number elements that are written to a separate table in the same database. The two tables are connected by former database-assigned key.How do I add the database-assigned key to the features before writing to the second table? Can I handle it in FME? I tried using a SQLexecutor, but performing a call to get the key seems like a bad idea.Do I have to go to T-SQL and write to both tables in a single SQLexecutor?

I want to create a published parameter that will give users the option of choosing multiple options from a dropdown/tree list, depending on the category. I could use 'Choice with Alias (Multiple)' and then an AttributeValueMapper, but I'd rather not as the 'Choice (Multiple)' has the ability to 'Use Tree'  

Is there no more customer support for chat ? Keeps saying.Sorry, there are no experts currently online or they may all be busy. You can usually reach us Mon-Fri between 9am-12pm and 1-4pm PST. Please use one of the following menu items, or click on "Report a Problem" to be directed. Even though I'm with in that those times.

Hi, is there an official date for the 'launch' of 2020.1 (Server & Desktop) yet please? We're looking to upgrade, but I'm unsure whether, given the timeframes, it's worth aiming for when 2020.1 is released out of Beta?Thanks,Martyn

Is it correct that if in a StringSearcher Case Sensitive is set to no that the expression \\x{03BC} should match both the micro symbol and the greek letter mu? \\x{00B5} also matches both if case sensitive is set to No

Is it possible in FME Server Windows environnement to run fme.exe from command line (.cmd or .bat file) ?Is there the exact same fonctionnality as in FME Desktop install ?Does it use the FME Server licence ?Thanks

Hi, I am to perform a spatial join between a line and a polygon. In some cases the line will be crossing polygon boundaries (there are no spaces between polygons). For these cases, I want to split the line, and find out which segment of the line is longer, then assign that polygon's attribute to the original line. I've tried used the LineOnAreaOverlayer to split the lines, then using a Matcher to find 'duplicates' (lines that ended up getting split between polygons), and then the LengthCalculator. So I have something pretty close to the end product. I have a match_id value from the matcher so I know which lines belong to eachother (on top of a GlobalID that I'm using in the matcher). The issue I'm facing with this approach is that I do not know how to split these lines apart, or compare them against each other. Maybe I should use a sorter, then some type of filter to split every one feature into different features?

I'm using Sevencs kernel. I've shape files and I want to encode them to S57 format (or DENC format).

I finally think I have my head wrapped around dynamic writers but I am running to all sorts of errors  What I am looking to do is use a NeighborFinder transformer to join admin boundaries to my data while also using the dynamic fields for each feature in a geodatabase.I am having multiple issues when trying to write dynamic dataOne issue I am having is that I am getting a "|Geodatabase Error (-2147219884): The Field already exists." error. I tried to remove/rename ObjectID and Shape fields with no luck.Another version of this workbench and I am getting "Cannot define schema for 'unknown' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration" errorAnytime I change it back to Manual writer I have no problems writing the features to the geodatabase. I have been stuck on this for a few weeks now, let me know if you have any suggestions.  Thanks in adva

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