Transformers

I'm reading in data from multiple XML files, all of which have the same date attributes (xml_char in the XML Reader). However the dates are not all the same format - some are 2018-06-22 and some are 22/06/2018. I want to write the dates to date fields in a File Geodatabase.I can have 2 DateTimeConverters (one for one date format and one for the other) based on whether the date attribute contains - or / and use a Tester or TestFilter to send the features to the appropriate converter. But is there a better way?I'm wary of using "Auto detect" in the DateTimeConverter - people have previously said it's better to specify a specific Input Format.

Elements that I try to add to my list of exposed elements in NeighborFinder are not being saved after closing and reopening workbench FME Desktop 2018.1. Upon reopening the workbench, only those elements that were originally exposed are still exposed. The newly exposed elements are forgotten/no longer exposed.My workbench contains about a dozen NeighborFinder transformers, but no matter what I do, only a handful of them actually save the attributes that I expose after I save and reopen the workbench. I found an old forum post about the same issue in FME Desktop 2015 (https://knowledge.safe.com/questions/5162/attributesplitter-exposed-elements.html?childToView=91200). Is it possible that the same bug exists in 2018.1?  I’ve tried the following workarounds but none of them worked:Copy a working NeighborFinder and paste it to replace a broken NeighborFinder. Save and reopen the workbench.Create a brand new NeighborFinder, expose the elements, save and reopen the workbench.Copy the content

Normally I use input from a JSON-file directly as JSON upload body for HTTPCaller. Now I need to do the same from reading an Oracle table, So how do I build the upload body, so that it looks exactly the same (in an easy way)? Have tried with no luck, so please provide an example, if possible.Example of a simple JSON structure wanted.{ "vandstiktype": { "id": 1, "description": "Byggevandsstik og måler", "explanation": null }, "maalerAnsoegning": { "antalMaalere": 0, "maalertype": { "id": 1, "description": "Vandmåler ved egen boring", "explanation": null } }, "aeldreEllerUngdomsBolig": false}

Hi,If dwg file is attached to dwg file as external reference then we can know with attribute autocad_xref_name. Is there any possibility to know if image is attached???Pratap

I am reading Autocad blocks and writing to PNG format(raster). In the reader itself I am dropping the blocks, and using imagerasteriser transformer and writing to png. But the problem is if the input feature contains polygons or circles , it comes as filled in png output. Actually its not filled element in Autocad?I can I overcome this? or any workaround? (intersector is very costly)

Hello does anyone have some experience with using FME to validate CAD data provided by cadastral surveyors?

Whenever I run a workbench I encounter following errorERROR |BADNEWS: File C:\\apps\\FME\\metafile\\geodatabaseDefline_.fmi could not be opened (tabrdr_classic.cpp:2756 - tabrdr::ClassicTableReader::TableReaderSource::open) - (tabrdr_classic.cpp:1743 - tabrdr::ClassicTableReader::getRow) - (tabrdr_classic.cpp:1743 - tabrdr::ClassicTableReader::getRow)I am using FME Desktop 2018.1

I have lines imported from Autocad to a GIS system, and it seems that the digitazing order of their vertex are not valid for the GIS sytem (e.g. endpoint is on a vertex in the middle of the line).I was wondering how could i correct this order? My first thought was to use a chopper with 2 vertex and then merge all the segment together (LineCombiner) but maybe a transformer does this in one shot.Any idea?

i want to check if the polygon is full with a imagein this case, the polygon has image and here the grey area is missing.is there a way to solve this?

Hello, I am trying to create dimension from scratch using the workspace of @daveatsafe:https://knowledge.safe.com/articles/1131/creating-autocad-dimensions.html I would like to draw the label in a custom location with a custom rotation. So I am trying to modify the attribute values of autocad_text_midpoint.x & autocad_text_midpoint.y + autocad_text_rotation but it doesn't seem to have an effect… Does someone have experience with that? Than you!

Hello,  I have a List created with the AttributeSplitter. When I right click on the list and choose 'Expose Element' I can expose a however many number of list items as I want.  I've been connecting some of these items to attributes of my destination datasource, and my conversion works. The items contained in the list are written out to the proper attribute.  But if I save my workspace, close it, then open it up again, all my connected 'exposed elements' are gone, and I need to do it all over again? Can anyone let me know if there's a setting I can activate to hold onto all connected exposed elements?  Thanks everyone, Regards Alex

Looking for a way to provide a list of tables (in Excel), create a SQL statement and read all data into and Excel file. The challenge: each source table can have different fields.Example: two tables: Table1-Fields: ID, Text1, Number1Table2-Fields: ID, 88Text, ANumberFieldExcel file would have a 'TableToRead' column containing table names. In this example Table1 and Table2. (My actual excel file has about 40 tables)Use attributemanager to build the select statement based on 'TableToRead'- result 'SQLSelectStatment'(for instance SELECT * FROM Table1 )SQLExecutor then reads from 'SQLSelectStatement'-problem is the 'Attributes to Expose' will change with each table. I though I could use another SQLExecutor, do a sql DESCRIBE on the table, get the field list and pass to the SQLExecutor that does the select-but it looks like you can't pass 'Attributes to Expose' into A SQLExecutor.

Hi,I'm working with openflight models and have been looking for ways to extract the texture name or file name from each model.Using the SharedItemRetriever, I am able to visually see the textures in Inspector. Each feature displayed, has a IFMERaster listing with an Attribute Name (encoded: UTF-8) and contains the file directory path I need. How can I access this attribute? Raster Property extractor does not provide a Name attribute output. I tried Geometry Property Extractor and Appearance Extractor and similarly, they either don't reveal a Name attribute or similarly, show the Name attribute under the IFMERaster list. 

Hi, I am pretty new to FME and I am trying to find a way to transform contour lines that have been clipped into polygons where the boundary of the Clipper polygon would be used to close the polygons.The point is that I am trying to create polygons to illustrate the flooding zones which elevation are:2 years: between 0 and 21.9920 years: between 21.99 and 22.75100 years between 22.75 and 23.2Any hint is welcome ! Thank you,

Hello group! I've been trying to replace a string with StringReplacer, if the text line contains certain text. So basically it's a classic ifthen conditional in regex, though I'm new to conditional tests in regex.My text string is:#1=IFCCARTESIANPOINT((1,1));If the text string contains IFCCARTESIANPOINT then search for ));.I tried syntax (?(A)X), If A then X, thus my regex:(?(IFCCARTESIANPOINT)[)][)];) but it doesn't work at all.I'd very much appreciate help :)

I have two GeoTIFF rasters. A & B.Each Raster has a different amount of rows and columns. Geographically they are of the same location.Both Rasters are in the same projection.What I want to do is grab the cell values of Raster A and add to them the value that is at the same geo location in raster B.I had hoped RasterExpressionEvaluator or RasterCellValueCalculator would help but seeing the Rasters have different row and column counts it errors.Any advice would be great, thanks :)  

I've gotten the basic fmear samples to work, and I've had good luck building an fmear output from 2d ArcGIS features from a file geodatabase.Now I've got a kml export from PLS-CADD that a colleague gave me. It's already 3d, and I'm not sure how to go about preparing it for export to FMEAR. If I drag it into ArcGIS Pro, it definitely renders in 3d. Anyone got any tips?My colleague also output the data as xml but I don't have an xsd so I can't make much sense of it.

Just for information sharing and if anyone has any ideas to improve, the following shutdown python script creates a password protected zip file that works with the FME Server download service.This use s 7za.exe located in the Resource Data area. import subprocessimport osDirectoryToZip = r'$(FME_SERVER_DEST_DIR)'outzipfilename = (os.path.splitext(r'$(FME_SERVER_DEST_DIR)')[0])+'_z.zip'ZipPass = str(FME_MacroValues['ZipPass'])subprocess.call([r"$(FME_SHAREDRESOURCE_DATA)/7za.exe",'a', outzipfilename, DirectoryToZip ,'-mx9','-p'+ZipPass], stdin=None, stdout=None, stderr=None, shell=False)os.remove(DirectoryToZip)os.rename(outzipfilename, DirectoryToZip)

I am pretty new with FME and I love it.There is so many testers and transformers that I am a bit lost sometimes.Anybody has an idea how to clip a raster 100 meters outside the boundaries of a polygon ?Thank you :)Mathieu.

Hi FMErs,I have a 3D point dataset containing many other numeric attributes.The dataset has been successfully written out to 3D point shape file with a feature writer.In parallel with the shape feature writer, attempted to write out and test FME AR.Both the shape file and fmear file appear in the inspection window OK, and are created and appear on the local disk.When using the FME AR app on iOS, the app connects to the fmear file, but nothing appears in the viewing window. To test the iOS, app, and the datasource, I used the example file and workspace, which correctly renders a surface and overlain image in FME AR app OK. So question is, do the 3D points need some sort of default appearance / styling in order to render in the app? What if the points have no appearance set ? What is the default - White or transparent maybe?Or is there some other requirement in order to render 3D points in the app correctly?Ideally, for an impressive visualisation, maybe to extrude the points by a numer

I need to change the order in which features are sent out of an AttributeFilter, because they eventually get set to SQLExecutors which will fail if not processed in the right order (due to database constraints). I have seen questions & answers regarding the port order of custom transformers, but is there a way to control the order in which the features will leave an AttributeFilter? The image shows the situation - the features seem to come out of the InterFeatureLink port first, but they actually have to wait until the features from the RoundPipe port have exited and been executed on the database.

Hi Everyone, I having some issues using a GeoJSON file in a spatial filter or clipper. When I inspect the layer, as well as the other layer I'm comparing it to, they clearly overlap and I have made sure that the coordinate systems are set correctly. Is there a reason why GeoJSON would not work for these spatial transformers? I have used the transformers before multiple times but have never worked with the GeoJSON format.  I have attached a file which includes a simple workspace showing the issue as well as the 2 source file (which have been made as anonymous as possible).  There are 2 files included:Area 1: A shape file which was created from an Esri GeodatabaseArea 2: A Shape file created from a GeoJSON file (the original file can be shared if necessary)  I would really appreciate any help with this.Thanks in advance!

Hi guys, I have an integer attribute containing all node_ids. I need to split those ids apart. The number of integers for all ids is similar (e.g. 7 integers). I came to this attribute by extracting the ids of the child nodes from a json file. I used this expresion (json["data"][*]["id"]), I used the * here because I have so many ids and I need them all. The result is one attribute with all node ids without any seperation between them (which i could have used to split them). So, the result e.g. is as following (72523657255486725577872521357256895). I know that I can use the attribute splitter to seperate them as the following picture but I need to be able to split them using some kind of expersion which split each 7 integers at once because I might have handreds of ids and it is not practical to keep counting them and then use 7s equivalent to their number. Therefore, my question is: Is there a way to add a comma or semicolon between the node ids when I extract them

I currently have JSON objects that are returning in FME very well. During the migration there are approx. 1,500 updates that need to be ran changing coded values to a description for storage in a data warehouse. This can be accomplished running an update that is prepopulated then passed to the "Update" port on the updater.replace(xs:string($x(fme:get-attribute("FIELD_NAME"))),xs:string(fme:get-attribute("code")),fme:get-attribute("name"))The issue is running 1,500 updates on 2,000 records takes 12+ minutes. The question is, is there a way to get the JSON Updater to updated multiple replacements at the same time. I have attempted to use the JSON Node updates and get errors.Attached is a simplified version where I am attempting to change json["features"]["attributes"]/ASSETGROUP from 1,2,3,4 to One, Two, Three, Four where there is a match. Thanks in advanced!! 

I'm trying to count the vertices on line segments. The data is a .GDB and has complex line segments that contain fillets and arcs. The VertexCounter is calculating an incorrect number of vertices for line segments that contain arcs. Is there a work-around for these more complex line segments?