Transformers

Hi,Is there a way to do both operations at the same time? I want it to update the existing ID's and insert the new one in a access database so i can store the data. There is not always an update required , sometimes the existing ID's are not given again.Thx!Nathalie 

Hi Community,I have a simple task I thoughtm but I can't get it to work. I have a long string (URL) with lots of forward slashes. I would like to find the last one or actualy I would like to get the string after the last forward slash. To find the last forward slash I used the @FindString function: @FindString(@Value(exampleURL),"/",-1). It returns -1 instead of the actual place of the slash. When I search from the beginning it works fine: @FindString(@Value(exampleURL),"/") it returns 5 which is the postion of the first slash in an URL. What am I doeing wrong?Thank you

No real question, but I want to share some insights for my Belgian colleagues. In FME, there are two 31370 coordinate systems: EPSG:31370 and Belge_72.Lambert_72_FME. They are exactly the same, except for the Esri WKT Description. The first one contains false easting and northing up to 5 decimals, the second one only three (like the OGC WKT). Until ArcGIS 10.6, you have to use the EPSG:31370, with the additional decimals.Starting from ArcGIS 10.7, ESRI changed the description of the coordinate system and applied the OGC values with 3 decimals.  Opening a filegeodatabase with EPSG:31370 in ArcGIS 10.7 leads to a 'custom coordinate system', not recognised by the software. Using the Belge_72.Lambert_72_FME coordinate system in FME avoids this issue. I hope this post will help some people saving some time.

How this can be achieved in FME?https://support.esri.com/en/technical-article/000011817Source data – 2D point geometry with attributes 'FROM' and 'TO' (elevation values stored). The goal is to create 3D lines from those values.

Is it more efficient way to separate outputs based on multiple attribute value? In this case, I have 3 attributes and 3 testers, alongside 3 attribute renamers. The goal is to have all three attributes merged horizontally (by adding features) in one attribute, filtering out empty values. See the attached workspace.  

Stupid question, but I'm wondering how much post-processing I need to do on the output of a ShortestPathFinder before writing it into say, an FGDB.So, a Path is not a Line feature in FME, it seems to be really an aggregate of its component segments, and each segment has a direction indicator on it so that the Path "knows" how to virtually act as a line with the correct virtual Vertex order, regardless that the component segments that are its aggregate, could alternately be running in opposite directions from each other, and one of a Path's segment's start vertex be an adjacent segment's start vertex as well (ie. The adjacent segments run in opposite direction to each other)However, if I put the output straight to say, SpatiaLite or FGDB, then the writer needs to downconvert the Path to Line. Fine, this is desirable behaviour in my case.My question is though: In what order do the vertices get written? In the direction of the Path, or does it depend on the orien

Hi!I have lines connected to a feature. I would like to give a number to my lines on clockwise orientation in relation to this feature.Do you have an idea?Thanks! 

Hello FME´ers,please, there is one big challenge to generate walking route for postman in census. What I have:- points (households) - one point can represent one or more households, accorging to attribute value- lines (streets)I need to generate routes for postman that contain visiting of 50 households per day, every household must be visited only once. Every route should be unique.Please, is there any idea, how to figure this challenge?Thank You so much!Lubo

Hello,How is that possible that the log is showing inconsistent timestamp values?  

Running the VoronoiDiagrammer is producing some very weird results. Mainly huge strangely shaped polygons around the edges covering the whole globe as seen in the first image. The image below that is from qgis (same input data) and shows the output I was expecting. Anybody know what is going on?

I can't seem to line up my elements/attributes on this lookup table I'm creating. Thanks in advance!Below is the screenshot of the XML attribute I'd like to create a feature from.Below is the parent-children tree of the elements I want to retrieve from my XML file.This is the screenshot of my workspace and configuration. Enable Flatenning is checked and all options are default.This is the result I'm getting from the workbenchBelow is the expected result  DomainNetworkNamenetworkSourceIdNetworkSourceNameAssetGroupCodeAssetGroupNameAssetTypeCodeAssetTypeNameElectricDistribution6ElectricDistributionDevice1Arrester1Distribution ClassElectricDistribution6ElectricDistributionDevice2Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice3Capacitor1Fixed CapacitorElectricDistribution6ElectricDistributionDevice4Circuit Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice5Elbow1Load BreakElectricDistribution6ElectricDistributionDevice6Fuse1Automatic Secti

 Hello,I am trying to find a soultion of workflow in FME, as to the attached image.My first attempt was to use the "NeighborFinder" and check if a footprint touches another. Then group/ list those (light blue circle). Then perhaps do another "NeighborFinder" check within a i.e. distance of 15, and make that a merged list (dark blue circle).I appreciate any idéas. Thank you!

I'm looking for a workflow suggestion or a transformer suggestion. I'm a light user of FME and I have Drill Traces, 3D Polyline files, that are missing their DrillHole ID. I have a DrillHole point file with the correct HoleID in it. The DrillHoles are typically within 0.02m of the beginning of the drill trace. I'm looking for a way to populate an Attribute added to the Drill Trace file to add the Hole ID to it. Both files are Shapefiles. I have attached a screen shot showing the Drill Hole and the Drill trace. I have about 7000 of these I need to match so doing it manually is not an option. Is there a proximity transformer or something that will pull the Hole ID into an attribute into the Drill Trace file from from the Hole point file that is closest to the beginning of the trace? Thank you! 

I would like to create some viewports that are circular and also one shape like this  Is there an autocad attribute I can set to make viewports in irregular shapes?

Hi,I am trying to use FME to get some excel data formatted into columns so I can use them for analysis. The problem is there are headers which I need to populate as a column. I can clean out the totals and blank rows with tester filter but I am not sure how to get the C HALL at the top of the group to populate in a column. I tried using variable setter but it gives me C Hall all the way through for all the lines. Any help is appreciated. So I need the attached data to look like this - C HALL4/1/2019    DATEEVENTROOMATTENDANCETotalEventsEvent Location4/1/2019Event ABuilding C121C HALL4/5/2019Event BBuilding C251C HALL4/11/2019Event CBuilding C3001C HALL   337  D HALL     DATEEVENTROOMATTENDANCETotalEvents 4/15/2019EVENT 1P1201D Hall4/22/2019EVENT 2P1401D Hall4/6/2019EVENT 3P2401D Hall   100  R HALL     DATEEVENTROOMATTENDANCETotalEvents 4/15/2019EVENT FC1101R Hall4/22/2019EVENT GC2101R Hall4/6/2019EVENT HC1151R Hall   25    

Hi,I'm using this to cut a line at two specific points per row of data - line a too and from. The length changes and i get bits on both sides of this line. Is there a simple way to keep the section between the cut points and ignore the rest. The section changes in size for each iteration. Sometimes the largest, sometimes smallest.thanks

If I zip the output of the attribute file writer (example: c:\\test.zip\\photo.jpg) and then use a fanout expression on my text file writer to send the data to the same test.zip file.... Only the text file will be present in the output. However, if I write them to (2) separate zip files the process works. However, I need my output in the same zip file. Does anyone have thoughts why it does not work when they point to the same output file?

Hi,i would like to define a list in the "PythonCaller" Transformer using incomming feature attributes. In addition, the list should be group by an attribute and sould output the same as the "ListBuilder" below. ListBuilder with incomming attribuit group by "Vorschrift" (=attribute) Definition in PythonCaller. how should the python code looks like for define a list using incomming attributes? desired output (=output of the ListBuilder above)    

Hi all.I've been working with outputting data in dynamic schemas, and wanted to debug something using the Redirect to FME Data Inspector feature. This fails, showing "no schema" as the data's only attribute.Is this WAD ? Shouldn't this feature work just as the proper output does ? Or does dynamic schemas only work in proper writers ? This make debugging somewhat more problematic.Instead I cloned my writer, sending its output into a test folder, and that seemed to work as expected.Cheers

Hi, I have a dataset of lines (from one lat/long to another lat/long).  I also have various polygons from an online dataset. I want to find out where the line crosses a polygon and then it the flag 'True'. My guess is to use spatialrelator, but not sure what parameters to set.  My line is the requestor, and I believe my polygons should be the supplier. However, not sure what to select as the 'spatial predicates to test'. Or if I even use this method at all.

with the new 2019 Version there is a new Feature:  i had these and worked with it then the IT reinstalled FME.I still have 2019 but now these Inspectors within the Transformers are gone.Is there an Option to activate or deactivate these?

Hi,I am working on a workspace that makes 3D Citymodels. My input is 3d polygons in a geodatabase. The output can be either 3ds or CityGML (prefer both).I Encounter a couple of issues while making the workspace.Extrude to a value from an attribute, is not possible. My workaround for this includes the use of the Clipper transformer. But..For some unknown reason the clipper terminates (or gets stuck) at some random point.The clipper rejects some 3d objects, but some are fine (seems random?)When comparing the Extruded 3d objects to objects from the SolidBuilder, there is a diffrence in the format. I have been unable to transform from Extrusion to Solids objects or visa versa. How do i do that?The Clipper workaround can handle my smaller dataset whitout any issue. I tried my best to format the clipper and clippee input, but, this had no effect what so ever for the real big data. It always gets stuck or terminates without a message why it did. This is also the reason why i cannot inspect th

Having trouble extending a line to the edge of the polygon it is in.The above example are boxes (different colours) and centre lines (red lines) both as a separate datasets and an attribute that contains the ID connects them if needed. I would like to extend all the lines straight forward (both ways, thus adding the green line) until it touches the edge of the polygon it is in, similar performance as the Extend function in AutoCAD. Is there a similar transformer that does this with two datasets like this? I tried the line extender and clipping and also the snapper but without satisfying results. 

Hello, here is my problem I can´t get solve: I try the "LineOnLineOverlayer" but I don´t want to touch the red, blue and green line. I have many lines at the same location with different attributes and nodes (black point in the image). After the transformer, the red, blue and green line have new segments I don´t want. Thanks for help!

I have a workbench which takes a file of JSon using the JSON reader and this automatically formats the data array in the JSON into a fme list which I can then explode and process. In doing this I've not had to provide any map of the JSON. i now need that JSON text to be accessed from a column in a database table. I have therefore a SQL Server reader to read that table and have experimented with JSON flattener and fragmenter to push the attribute into. Neither seem to give the required result and I'm thinking that to use either I need to describe the entire file in some way which is not practical.i've tried a couple of the examples that others have provided and I cannot see any yet that give me what the JSON reader provides.Help! Rob