Transformers

I have a use case that is not covered under the three snapping modes available in the anchoredSnapper.My candidates are a set of lines, the anchors can be either lines or polygons, but for this discussion will be polygons.The lines need to have their end points (and only their endpoints) snapped to the nearest polygon segment. The rest of the vertices of the line should remain untouched. Currently I am developing the following workflow:Create a unique id for the lines.Extract the end points of the candidate lines, send them to an anchoredSnapper with the polygons as the anchor, use snapping type Segment.Take the original lines and send them to a second AnchoredSnapper with the points as anchors and snapping type End Point, grouped by unique id. Is there a better solution I'm overlooking?

I have been given a huge spreadsheet containing countless series of identical columns that are duplicated many times, with a prefix in front of each that indicates some kind of property of the data. I now want to reformat these data so that the duplicate columns are replaced with unique columns and the attributes that were used to separate the columns become attributes in the data instead. Please see simplified attachment (and screenshot, below) which shows the "Current format" and "Desired format" sheets. CurrentDesired I've tried several things, none of which are giving me the results I want:Adding an AttributeCreator to create a separate, duplicated pipeline for each of the types (Apple, Banana, Orange, etc.) and then BulkAttributeRenamer on each to remove the prefix of the column based on the attribute I created. In theory, this should create a single "Tree Height", etc. column per pipeline that can then be merged back together and the remaining a

Hi, I'm using the string searcher to extract some codes out of a text field. I can extract the first match or build al list with all the matches but is it also possible to extract only the second match of the third match?This in an example of the text. When it says "2 opladingen" then I need the first two codes that are in the parentheses, but they can't be in the same field as I have yet to join them with another table. I already found the right expression to find the codes \\d{3}[_][A-Z]{3,}  Er ontbreken nog 2 opladingen voor aanleveringsgebieden: (ZG Beveren aan de Ijzer (rietveld VLM): AQUAFIN (556_AQUAFIN), ZG Beveren aan de Ijzer (rietveld VLM): INTERCOMMUNALE WATERLEIDINGSMAATSCHAPPIJ VAN VEURNE AMBACHT (556_IWVA))<br/>Een inactief gebied mag geen data meer bevatten (ZG Beveren aan de Ijzer (rietveld VLM): VLAAMSE MILIEUMAATSCHAPPIJ (556_VMM) -> Bewerking: p: 1, s: 0, i: 0)<br/>

Is there a transformer that creates an ESRI AddressLocator tool?

I've got a knotty problem that I can't seem to think out.I've got a CSV file that comes out of system A (the coloured section of the image). It's invoices that need paying against Purchase Orders. An invoice starts with a H (header) and has a number of D (detail) rows.On occasion a PO Item may have it's TAX split and the source system outputs the tax splits.The target system can only cope with a single line per PO Item number so I create a list and group on the appropriate columns and return a list on the ones I need to aggregate...Tax code - first codeAmount - sum of the valuesQuantity - sum of the values So far so good. BUT the DOC_ITEM (blue) must be sequential based on the number of rows in the actual invoice.It's late in the day so my brain may have stopped working but I can't think of a way to achieve the goal... How can I relate a line item back to the number of line items in the invoice and set DOC_ITEM accordingly. Any help gratefully received. Than

i used feature reader to read WMS (Web Map Service) , to read cartographic map .i would like to access thedifferent colors in cartographic map and use tester transformer ,to let the lines that include this specific color not showing .i would like to cancel the pink color from cartographic map .How could i achieve that ? Thanks in advanceFME 2018

SQL Server Link Templates have DataSource.Catalog.Schema.Table and I need to update the DataSource value.

Hi I have seen a number of questions relating to this flowline of using ArcPro python with FME but I cant find a solution for my set up. I have ArcMap 10.8 and ArcPro 2.6 installed in same environment I am using FME 2021 64 Bit. I currently have a lot of workspaces set up to use acrpy for fme feature processing through the python caller. This whole flowline is working for fme and arcmap using 2.7 python. I want to replicate my workspaces to run the same processes using ArcPro with python 3.6 . When I run my workspaces that include python callers I get the following error message immediately on startup 2021-10-05 00:39:12| 0.0| 0.0|INFORM|Using Python interpreter from `C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\python36.dll' with PYTHONHOME `C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3'2021-10-05 00:39:12| 0.0| 0.0|INFORM|Python version 3.6 loaded successfullyFailed to import the site moduleError processing line 1 of C:\\Program Files\\

I want to try openCV, but I get completely stuck with no real error message at all. I tried a lot of different approaches, but even the simplest doesn't work whatsoever. Workflow for the simplest:Use the openCV comandline to mark positive samples and generate an annotation file. To make it as simple as possible, I tried 1 positive sample, resulting in this annotations file: F:\\temp\\opencv\\positives\\0.png 1 45 35 38 63 Next I made a folder containing negatives with 20 negatives (tried .png and.tif) Next up is the samplepreparer: negatives: use existing (tred overwrite too) positives:number of samples: 1width/hight 200 and 200 (tried numorous different values) I allocate a negatives and vec file location and that's it. No spaces in anny of the folder structures. I get rejected features.  Storing feature(s) to FME feature store file `F:\\fmetemp\\wb-cache--PkosFd\\Main_RasterObjectDetectorSamplePrepar -1 19 fo 1 _lt_REJECTED_gt_ 0 9db0cf751f86d66944dfbb4c75f54d358bd7f17d.ffsup

Hello, My current workbench is outputting an incorrect amount of Polygons using the FeatureMerger Transformer and I think the issue is partly to do with the number of vertices that make up some of the polygons and the fact some double back?Or is it perhaps at the PointOnAreaOverlayer Transformers as they seem to be creating too many records as well? Hopefully my images capture in essence what I want to achieve and the issues I am encountering. Perhaps FeatureMerger is not the correct Transformer I need? Thank you in advance

Hi I am looking for someone who knows/has expierience how to transform GIS Tree cadastre/register Data into BIM Objects with simple geometric representation of Tree crown, habit, root ball and trunk and of course the register Information as Attribute Data attached?  If anyone has ever done such a project, or knows someone who knows someone. I would be grateful to get in touch to get some basic information about their Project. Greetings tobias

Hi, fellow FME-lovers! I have an interesting problem that you can help me solve in an efficient way. I have many pipe segements as solids in an ifc-file, see example in Test2.ifc. The pipes are in 3D and can be connected in all directions. (I'm not sure about the fittings but for now don't mind them.). Now, I need to calculate length per segment and I started working no a complicated scripts (2D and algebra...) but there must be more of an FME-way. I'm thinking along the lines of creating a center line from pipe start to end... If you have any ideas I will gladly listen.  Bonus: what if segments are bent? Will this be handled in you solution? Peter

So I have written out the points into each featureclass that overlay a polygon... but now I want to get a list of unique values of one particular attribute (with a total count value of each), for each polygon. So that means the unique list (and count) will be different for each polygon. I've tried this workflow using StatisticsCalculator to get total count of point attribute (that I want unique values for) and grouped by the same attribute. Then passed to AttributeCreator to create a new attribute with this value. Then passed to Aggregator and then fanned out to a writer. However, the values are the same. I need to calculate the total count of the unique values for each polygon. Please help.

Hi, Is there a transformer that will take a table of OS Grid references of varying length/granularity and create a feature class of grid square polygons for them?

Hi there, so I have two column of data.​The column "Test_FloorNumber_Begin0" should have sequence of 0000, 0001, 0002, 0003 - the largest number of the input, or 0999. ​The second column "Test_FloorNumber_Begin1" should have sequence of 1000, 1001 - the largest number of the input, or 1999.​The sequence should start from 0000/1000 to the largest number from the input data. So I want to use FME to find out the missing number and output it. In this case 0000 to 0003 and 1002-1003 are missing.​Please help me as I want clueless on how to work this out.​Thank you very much.

I have two FeatureMerger transformers fed by a single AttributeManager that outputs two string Attributes - one containing a GUID and the other a mixed-case name. The two FeatureMergers are identical, matching the GUID so that the corresponding name gets inserted into their respective Features. Oddly, one FeatureMerger converts the names to uppercase. So I did the obvious thing: blew it away and copied the properly-working FeatureMerger - only to see the copy convert to uppercase as well. The names enter (the Supplier port) in mixed-case and come out (the Merged port) as uppercase. The Requestor ports of both FeatureMergers are connected to the Merged ports of previous FeatureMergers, which themselves successfully merged two mixed-case Attributes into Features with (only) uppercase Attributes. So what is making FeatureMerger convert to uppercase? Edit: Replacing the "uppercase" FeatureMerger with a FeatureJoiner makes no difference. Nor does removing the AttributeManger's

Hi, does anyone know how to write input data to one "block?" I have input data - 8 frequency values (pic1), which are written to the dataset as individual "blocks" (pic2), but I need to write frequencies to one "block" ( pic3 ) Thanks a lot

I dynamically write tables (Soruce: PostGIS) with, as well as without geometry attributes into ESRI Shapes . The Writer for Esri Shapefile format generates entire shapefiles (shp, shx, prj, cpg, and dbf) even for tables without geometry attributes. However, these may not be  read correctly by ArcCatalog. For geometry-less tables, it would be better to have a dbf-file only! Is there any option for the Writer to avoid writing such entire shapefiles for geometry-less tables?

I have some polygons as streets (streetname) and many pipes which lay mostly inside the street polygons. Using the line on area overlayer I can get pipe attributes on the street polygons. But I would like to cut the polygons where one pipe ends and the next one starts.Another approach would be to cut polygons where pipe attributes change...is it possible?

Hello,is it possible to run from fme system call (or python caller) and don't wait for the result?

Hello,I am trying to populate a value into "_overlaps" using the PointOnAreaOverlayer Transformer but all the data keeps being Rejected.This works fine when both Readers are consuming Oracle Spatial but I think the issue may be because my Point data is non-spatial?Tried the 'Reprojector' Transformer but had no effect. The View with the Point data contains a SHAPE field therefore should contain geometry but the FME non-spatial reader does not contain the field and I cannot pick up the data using a spatial reader.I may be pursuing the wrong process here?!Thanks in advance. 

I am encountering an error where my clipped raster data is not being written to the designated output folder . I am using FME Workbench 2021.1. I was following the Raster Clipping workflow here. However, I must be making a mistake when adding the writer and working with the settings. Perhaps I was a bit confused as to how to set the writer and parameters. There error I received was something like FME file not accessible. Unfortunately, my FME crashed and closed before I could copy the error I received. I'm hoping someone can guide me through adding a writer. I am trying to clip ~3000 geotifs to a shapefile file of Ottawa, On. and fan out by Ward name. Thank you   

Hello All,I have an AutoCAD drawing that has small circles (polygons) sitting over the intersection of two or more lines. The lines finish at the edge of the circle but I need to extend each of the lines to the centre of the circle so I can then create polygon features from the lines. The resulting line from circle edge to centre needs to be merged with the original line i.e. not just create a new line segment.Any ideas would be very much appreciated.   

The thing I want to do is for example to when AGOSLAG(pic 1) = Kodvarde update AGOSLAG to the text Kodlang(pic 2). Then I want to do the same thing for MALKLASS, HKL. I have serveral tables in excel and they all start with the number 1.  I've tried with databasejoiner but could only update 1 attribute at the time there. I have about 20-30 attributes that need to be updated.  What is the best way to solve this problem?  best regardsJesper

Hi, I have two polygon layers (Layer 1 and Layer 2). Layer 2 contains a subset of Layer 1 polygons i.e. one polygon of Layer 1 can contain 1 to n polygons of Layer 2 (Image). Each polygon in Layer 2 needs to be uniquely identified by using two attributes: ID of Layer 1 and pol which represents the number of Layer 2 polygons within one Layer 1 polygon (image). How to create a pol attribute?