Transformers

I have an issue where I have text that contains braces that are inputted into an XMLTemplater through a SubTemplate (and also through ROOT). Since I don't want the XMLTemplater to parse the text, it is referenced as @Value(text) and not {fme:get-attribute("text")}. Still I get an issue as if FME expects a function. The log tells me: "context item": undeclared variableFor this issue I prefer not to escape the braces in my text, which of course would be a workaround. 

Hi Everyone, I need your help to solve a problem. I have many no. of points that are not in order if we look at them spatially and in many places, there is a significant gap considering its distribution. I have tried Sort and then Line builder transformer in FME but the output was generated based on the layer drawing order. Another issue is line builder does not consider the gap within point distribution and connects all points to generate a single polyline. Looking for a solution to convert points to separate lines based on their spatial sequence. The attached below screenshot could make you clear about the issue I am talking about.   

I am running workbench an FME Server automation that is fired from a SQL Server insert trigger for a ArcGIS feature class that has editor tracking enabled. On the workbench I check previous records for the feature and only want the workbench to complete under specific conditions - it is writing an HTML file. I was considering using the NULL writer but the documentation indicates this should only be used for testing. Looking for the best way to accomplish this. I considered modifying the trigger but this is so involved and much easier and cleaner to do in FME... Any tips would be appreciated.Thanks!

Hello,I am trying to obtain Max OBJECTID value from a database and pass it into Variable Setter.The SQL Creator > Variable Setter is obtaining the correct value (just one record at present) but the Variable Retriever cannot obtain the value I think?I hope this is a simple step or order I am missing.Thanks in advance

If I do not explode, I loose the 3d surface and the geometry is shown as point.

Hi all,I'm trying to download files (in this case zip files), which are in a parent folder on an ftp. The folder name changes once a week, when new updates are uploaded. I would like to automaticly download the updated files once a week, but it seems that the ftp caller has some limitations in that department - (asterix and subfolders). I have searched the forum for answers, but haven't really found a solution yet. I've seen suggestions using python caller and ftp caller combined, but I dont really do python :-) Any suggestions? Thanks

Hi all,I am trying to convert fbx file to FME AR. I am getting the error below."FME-AR_FBX' of type Directory, expected a dataset of type Regular file"I tried to deaggregate to see if it works workout but no luck. 

Hello, Let's say i have an excel table containing multiple attributes and features, and I would like to output in an excel table a summary of the unique values for each attributes. Using duplicate filters I managed to get the results but they are ordered in rows in order of arrival instead of being nested for each attribute. Example with three attributes:ID ----- Name ------CityA1 -----Mark -------MoscowA2 ------Paul -------GlasgowA1 -----Joanna ---CapetownA3------ Paul -------Glasgow  Then in excel I get three columns but the results are spread in the order of arrival of results for each column unique values: Column A -- Column B -- Column CA1A2A3--------------Joanna--------------Paul--------------Mark --------------------------------Glasgow---------------------------------Moscow-------------------------------- Capetown Instead of having the results over various lines, I would like to get the unique values on top of each column. Is there a way to do so ? Maybe working with lists ?

Hi All, I have a complex polygon with smaller polyons within a bigger polygon, multiparts and lots of overlap issues. I want to be able to desegregate, remove multiparts and be able to select each polygons individually. Any thoughts will be helpful.

I run features through an AttributeFilter Transformer in order to split the stream for specific manipulations downstream. If I test this in Workbench everything works as expected. If I call the workspace in BATCH from a DOS script all features end at the AttributeFilter (identical data).In FME Log of the BATCH run I see lines likeAttributeFilter_9 AX31001 Transformer Output Nuker (TeeFactory): Cloned 818 input feature(s) into 0 output feature(s)AttributeFilter_9 SD41000 Transformer Output Nuker (TeeFactory): Cloned 1154 input feature(s) into 0 output feature(s) What is going on here ? Why are the features not passed ... very,very confused 👿 😮 FME 2021.0 up to 2021.1.3 all the same 

I have an attribute called "Status." The coded value is an integer and the domain value is a character. When I do not resolve the domains in the reader, then the automatic writer sets as an integer field, but when I resolve the domains, then the "Status" attribute and the "Status_resolved" are both characters. Is there a way to get "Status" field as an integer and get the "Status_resolved" attribute? I don't want to have to use a manual writer because I have >100 fields. 

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?