Transformers

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

What does it mean if the pipes are broken as in the second and third example?? Anything?

Hi,I've been playing around with this for a few hours with no joy. I have lots of linework (imagine like river drainage) that is automatically generated, which I am trying to simplify and remove many of the vertices. The lines are split wherever there is a junction so during the simplification there should never be an issue with lines overlapping the end points of other lines.I am using the Generalizer transformer (Thin No Point (Generalize)), and to the large part this is working exactly how I want it to, but there are the occasional lines which over-simplify to straighten out and overlap other lines. Obviously with rivers this cannot happen! See the two offending lines highlighted above and below.When smoothing using the Generalize tool, I have previously used NURBfit, preserving shared boundaries, which seems to work fairly well, I get no overlaps. In this instance I'm trying to generalize and remove vertices, not smooth and add them. I'm struggling to get this functioni

I would like to find the coordinate for the tip of a leader line in autoCAD I tried extracting coordinate at vertex 0 but the point is not at the exact same location as it is in AutoCAD is there an autocad attribute that represents this information? I have used aggregation method and coordinate extraction on the line feature to get really close but the point is not at the exact location after processing.It looks like the location I am getting is actually the center of the arrowhead and not the location of the tip on the arrow.

Hello,Situation:I connect to an API on a daily basis and write that data back to a SQL server.The API returns a JSON with also a modificationDate. With the ChangeDetector I check if there's a change on that date, if so Update the attributes.But I thought there were a lot of updates so I added a list to check what. Here we can we can see that OriginalValue is trimmed where as revisedValue is not. The OriginalValue source:And the RevisedValue source: Both look the same to me, so how can it be the data is cut off?I'm not doing anything with it, just reading it straight from the DB?Sincerely, Jonathan

This seems such a simple thing but I can not find a transformer to achieve it. I want to measure the distance between two points along X and Y. I could of course do this with a LineBuilder, LengthCalculator, a AzimutCalculator and some math. But surely there is a simpler way?

I have an AutoCAD text & leader (mleader AutoCAD object) that are on one layer and a structure they describe that is on another layer. The structure is an autocad block, which FME reads as a point located at the block insertion point. The the leader line always connects to it's strucutre's block insertion point. The text is contained in a box that connects to the leader line always in the same pattern. I want to create a workbench that will determine which text/leader objects go with which structure. So it seems like a SpatialFilter transformer set to check if the leader layer touches the block layer should be able to capture this relationship. When I try this nothing passes the filter though, why could this be?

I have a raster file and i would to fill sink and after to make a diffrence with the initial raster. There is a transformer for that ?

Hi, can I have some advise on which is the best transformer to use? I have an overlay of topographic features in PostGIS. I have another overlay which consists of boundaries of 10 electoral districts. The electoral districts each have an attribute of feature name. How doI assign the feature name from each electoral district to every topograhic feature as a new attribute of that dataset?I then want to write out the topographic overlay to individual gml files for each electoral district.I've tried AeaOnArea and SpatialRelator but am struggling.ThanksJon

How create?

Hello, We've been doing 3d modelling with agisoft metashape, mainly small buildings. Right now we have a project of modeling 300 hectares of city and the outcome has to be cesium tiles and it has to be one unity. The problem is that agisoft cannot produce that large of an object in one go so we have to split into parts. How can i merge those parts back to one with FME?  Kind Regards

I have a problem with maximum and minimum value of raster. I have a script (on screenshot, and attached) that calculates NDVI. Firstly I use RasterExpressionEvaluator to count NDVI, and then RasterBandMaxMinExtractor to extract max and min (I need those for further calculation). The maximum and minimum I get are different then maximum and minimum in QGIS for the same raster file.  I checked raster before I run RasterExpressionEvaluator, and minimums, and maximums of bands are the same in FME, and QGIS, so I think the issue might be with the RasterExpressionEvaluator, but I am not sure. Has anyone has idea how to get this issue right? I need proper max and min value for normalization of NDVI, and I can see that results I get with this max and min value are wrong. 

Hi all,I am attempting to create a series of tiled OBJ files with a terrain mesh and an ortho image draped over the top of the mesh. In order to ensure that the geometry between two adjacent tiles matches up I have a set of tile edges as a Geodatabase line feature. These are heighted, based on the input terrain and the tile edge dataset are used within the overall tile creation. These act as a set of breaklines and geometry between tiles is shared. The resultant terrain mesh is as I expected (see tile-edge-mesh.jpg) - N.B. this has only 1 tile selected as I can't see how to select more than 1 tile at a time.Anyway, the geometry that results from this looks good and tiles edges match up in terms of geometry. The problem that I have is with the textures draped over the top. If you look at the original-orthos.jpg image, you can see that there is no discernible edge between the 2 tiles. However, once you run the workspace an artefact seems to have appeared at the edge (see obj-f