Transformers

Hello,I am slightly confused and probably missing something with Deaggregator (or part counter).When I run part counter, I find out that 3 of my 48 features are multi-part. However when I want to deagregate those parts, one of these 3 features has no part number and isn't deaggregated.This file contains the 3 multi-part features, but only 2 of these are split up. The problematic multi-polygon has a donut hole, but this is the same for one of the other polygons and there it doesn't cause problems.Any ideas ?   

I need to convert Input image to 256 colors (8bit) by using the exist palette of Old raster. I suppose those FME -transformers are not correct for this case. Which FME-transformers are suitable for this problem?

Hi there,Using FME 2019.1, trying to convert GIS annotations (ArcSDE) to DWG.This is an example of my data source in ArcGIS.This is the final result in AutoCAD. Why am I getting those big disproportionate ugly annotations?Is there anything I can do? TX

Hi,I'm using dynamic writer using [schema from table] reading a workspace resource csv as per the tutorial.However the attribute types aren't created, and I can't for the life of me figure out why!schema csv as follows (Ive several feature_types)Esri shp Writer Any help/suggestions appreciated.ThanksDave

Hello everyone.I have a .dwg file including substructure data of an area. I'm studying on creation a 3D city model with virtulacityPUBLISHER. To be able to create this, I'm transforming dwg file into a geojson file format via "bufferer" transformer (Buffer Type: Solid). But solid type creating a semi-sphere at the end of the line. And then, generating surfaces which consist of 6n^2 faces. If we think about an awful a lot details for all substructure details (e.g. gas or water tubes, cables etc.) it will be too much surfaces to publish (with a web browser interface) for a city model. So, how can i simplify the lines (especially end of the lines) which is using for creating goejson file types.Thanks.

I'm nowhere near as experienced with dealing with Rasters in FME than vector data, so I'm looking for corrections/optimisations to my method of extracting Surface Levels from a City-wide 1 metre Raster. I'm simply feeding the Input DEM Raster and Input Points into PointOnRasterExtractor to extract the Pixel values onto the Point Features. However, this executes far slower than the ArcGIS equivalent 3DAnalyst ArcTool. 77,000 points take over 1 hour to calculate!The Raster Reader is the ESRI FileGeoDB Raster Dataset Reader.So:Is this the right Transformer or are there better ones?Should I be pre-processing the Raster with something else before putting it into PointOnRasterExtractor?Are there methods of limiting the Raster Cells to use in PointOnRasterExtractor which may make it faster (even though in theory this optimisation should be within the Transformer itself) by using a spatial comparison beforehand?

Hi community! I'm unsure how to tackle this so looking for any suggestions...What I have is a data set of hundreds of points. These are arranged in 'groups' by sharing a common attribute. I'd like to join point to point (create lines) in every permutation of each group. See example images of groups below.My ultimate objective here is only to find the longest distance (and generate a line) between the points per group. Bear in mind that there are multiple groups so I need to run the operation by group or have another means of performing the analysis per group. This is a 2D exercise however the points have a Z value that I would like to retain. Thoughts?

Hi guys,I got a challenge for you: I have 500k+ grid points with a distance of 0.5m and need to find the neighbors from each point within a given radius (let's say 2m).The NeighborFinder takes horribly long. The SpatialRelator has about the same calculation time.What I am now thinking of is to get the neighbors mathematically rather than spatially. For each point I can create the attributes minX, minY, maxX and maxY. Then, I just need to test if one of the other points' coordinates are greater or smaller, right?!In the end every point should have a list of all his neighbors (and their attributes).Any ideas? Or any hints how I can speed up the spatial tester?Cheers, Maria

Hello,I have summary output coming from the StatisticsCalculator that I would like to rearrange such that row values become column headings with values for these coming from the statscalc count output (see input and end result images below). I've tried AttributePivoter, AttributeTransposer without success.Thanks.Tony

Hi, I currently have 2 MapInfo table -First table contains points with fields Id1 and Number1 -Second table contains roads with fields Id2 and Number2.  I would like to calculate Number2=Sum(Number1) when Id1=Id2 AND the points are the closest to the line. The roads are divided into multiple segments but those segments have the same Id2.Multiple points can be assigned to one segments, and all those points share the same id1=Id2. So I think I should use NeighborFinder but is it possible to only search through segments with the same Id2 ? Thank you

 i have network of many lines in the map and i want to define start point from one line of different lines then i want to flow in each direction till the end as picture abovestart point will start then go in the first direction but it will find first intersection point with 3 directon so go one by one as example then it finds second intersection point with 3 direction then fo in first line till reach end line 1 and give me the coordinate of the last point (last vertices 1 ) then come bk to second intersection point and continue in the second line but it finds the third intersection point so go till end line 2 and extract vertices then come bk to third intersection point and go to end line 3 and extract vertices then come bk to second intersection point and go to last direct ion till end line 4 and give me coordintaes of last point and after finish it return back to the first intersection point and till reach end line 5 and so on . at the end i want to check the end coordinates of each

Hi,I would like calculate the distance between points by the road.I have 1 file with origin points ( 1 000 000 points) and 1 file with destination points (10 000).I would like the distance between every origin - destination points, so 1 000 000 x 10 000 distances.I try to do, with only 12 origins points and 5 destinations points : But the problem is for the FromTo, it take only one destination on a camp common with the origin points.How i can to do to have 12 x 5 = 60 combinaisons ? Thanks a lot, Matthieu  

Hi,Sorry if this is a super easy question that i have just misinterpreted on how to use the transformers. But i haven't got the accuracy i thought i would, so would love some guidance/help. Basically i have Road network polygons that include an Asset ID field that i need to transfer across to the neighbouring Kerb and Channel Polylines that i have. The polylines contain no attributes that i need to maintain.The Kerb and Channel polylines (red lines in image below )are within 1m of the road network polygons (cream(ish) polygons in image below) but they in no way ever intersect or are contained within each other at any point.Conceptually what i want to do is simple, but i just haven't managed to achieve it with either Nearest Neighbour or Spatial Relator. Should i be using a different transformer altogether? Thank you in advance  

Hello all,A tricky question here. I have two datasets, a road network and a collection of speed signs (points).I need to assign a speed attribute to roads, using the speed signs as input. For each speed sign, I know the speed and the direction the sign is facing.I'm looking at NetworkCostCalculator. Is there a way of having the calculation go in one direction from the source? And stop when it reaches another source? So I guess one source and multiple sinks?I don't expect this to be solved in one answer...  

FME 2019.2 desktop user. I have some dates that have fractional seconds and I want to truncate the fractional seconds to whole seconds. In the fme help for the arithmetic editor it says the @int function converts by truncation if it is in the range of a 64 bit integer, which is exactly what I want. Most dates I'm sending in are truncated. But ones of the type 20200220015759.999000 are getting rounded up. Which, in the case of above, is an invalid date because it rounds up to 60 seconds.Is this a bug or am I missing something? 

Calculating percentage of a value based on amount of value of colour Could i ask ,one attribute has 4 different names with different back ground color.in same attribute one of this with colour called exist (yellow colour) and the second called exist with no colour and third called half only exist with no colour and fourth not used with blue color    so could i calculate the percentage of values depends on background color , is it possiblebcs i have one name with background colour and another without background colour so i can not depend on the namefor each field name ,sure it has different distances so i should sum every distance for each field and make a percentagei know,that i can use expression evaluator to calculate the percentage but i am not sure how can i do that ,depend on the background color.FME 2018Thanks for help 

I am trying to update a single value within an attribute containing XML using the value from another attribute. Below i am trying to update the value within LOV_TYPE to be "Corp Yard" (which is coming from an existing attribute. This is a snippet from the XML of which there are dozens of CUSTOMFIELD entities that are defined by the PROPERTYCODE.I am totally new to XQuery and am using the XMLXQueryUpdater with the below settings:XQuery Input: XQuery ExpressionXQuery Expression:for $node in attribute {fme:get-attribute("XML")}//CUSTOMFIELD where $node/PROPERTYCODE = "OWN-ORG" return (replace value of node $node/LOVSETTINGS/LOV_TYPE with {fme:get-attribute("New_Own_Org")},)XML Input; Attribute specifying XMLXML Attribute: XML Any help would be much appreciated. <ns23:CUSTOMFIELD index="30" entity="OBJ" type="RENT"><ns23:PROPERTYCODE>OWN-ORG</ns23:PROPERTYCODE><ns23:PROPERTYLABEL>Owning Organizati

I run a workbench automatically through task scheduler. I've recently renamed this workbench (let's call the old one workbenchA, and the new on workbenchB). I have also updated the task. However, whenever this workbench runs through the taskscheduler, the logfile that gets created or updated is the one referring to the old name (so workbenchA.log). It does run workbenchB and says it as well in the workbenchA.log, but just sticks to the old filename when it comes to logging.I've already emptied my user temp folder. I've also now renamed workbenchA. But it still does it. It's like something is stuck in cache memory somewhere, but I don't know where to look. Also, when I manually start the workbenchB it does create a logfile with the correct name. I Have FME Desktop version 2019.

I have been using the Dropbox Connector to succesfully list files within a folder but have now started to intermittently return the error below.Request to Dropbox returned response "com.dropbox.core.BadRequestException: Error in call to API function "files/get_metadata": request body: could not decode input as JSON"Without changing any parameters sometimes i can connect and list files but more times it fails and returns the error. This occurs both through FME Desktop and Cloud.I am using FME Desktop 2019.2.0.0 (20191105 - Build 19801 - WIN64and FME Cloud FME Server 2019.2 Build 19801 - linux-x64

Hi All,I was wondering if anyone from the community can help me. I would like to introduce organization to my workspace. I have been using Excel as a large source to workspace structure. Currently, I would like to continue to use Excel to document attribute field mapping, as naming can vary by client.I am using Import Wizard to import attribute values. I have been successful with it thus far with AttibuteManager. My question is if it is possible for import wizard to import conditional statements to AttributeManager Transformer? If so, what is the format or structure to write a conditional statement using external document like Excel?

I am looking to split some data, which is stored in csv but contains commas.Unfortunately it cannot be read in using a CSV reader due to its complexity and non table / row format.An example line of data might look like this: "This data has , a comma in it", "So does, this one", This one does not,"but this one ,does", This one doesnt, or does this one,"Another comma, comma, comma",No comma, still none, still none I considered doing 4 splits:split 1: "," Split 2: ," Split 3: ", Split 4: , And then join the results back together. Although this would work, I need to retain the order of the data and assign an ascending ID.  EG:1 - This data has , a comma in it2 - So does, this one3 - This one does not4 - but this one ,does5 - This one doesnt So my consideration will not work since it will put things out of order. Secondly, I considered doing a pre-processing step which would read in all the data as CSV, then Write it as CSV with a

Hello!I would like to make a test on my datas. These are points , that have a _pontID and there is a _MIN, MAX and _MEAN values. I want to filter those points where _pontID = _MIN and _pontID = _MAX_uj and _pontID = _mean_pontssz. The problem is that the query only gives back the right solution with _MIN. Here is the definition:The values are like:Can you help me, what can be wrong?

Hello, here is my problem : I create a buffer from input points data. When the distance between 2 points is small, the buffers overlap. I would like to split the 2 overlapped buffers into 2 parts with the same area. Each polygon retrieve the attribute values of the associated point.I don't find any satsfaying solution. Is there a known issue?

I have an old raster that I have to update in the same internal structure. The old one have one band, the new have 4, that gives a factor 5 on data volume. What I want, What I have:

Hi everyone,  i have a simple workbench that uses the ShortestPathFinder to create paths and i have around 1,000,000 from-to lines to query.Before I run the From-To lines through the workbench I made sure that all line vertices are snapped to the nearest network node, and then within this workbench I snapped them again by checking the 'From-To and Network Snapping' option in the ShortestPathFinder transformer. Somehow, the workbench worked I when i send through a sample of From-To lines (around 100 lines), but failed completely when i send through the whole 1,000,000 From-To lines.   The error is - the source/destination node in the shortest path calculation is not a valide node in the network.Did it failed because I am sending through too mahy queries at once? Is there a way to get around this?ThanksRings