Transformers

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  

Hi Guys,i have excel file ,i want to make comparisonasif sum 1 < base A < sum 2 if yes ,so as give me the outputi want to check for every cell in base A is the value between sum1 and sum 2 in the each row or not .as example check the first cell of base A (65452 ) is between sum 1 and sum 2 at first row or not then continue to check 65452,first cell of base A with the second row of sum 1 and sum 2 or not . i want to check for each cell in base A ,if this value between sum1 and sum 2 for each row .after finish checking 65452 so start with 65438 and so on so it will check for each cell with 10 rows i want to do the same also for Base B ,if the value between sum 1 and sum 2 and if yes gives me output and continue check for this cell till the end till i finish with all field cells in base A and base B Thanks in advance FME version 2018 

could i ask how to get in inspector only the lines that intersected with polygon ,i tried alot with clipperpolygon as input for clipper and lines input for clippee output from inside ,i got the intersected lines with polygon plus all lines inside the polygon .i want only to have the intersected lines with polygon and delete the rest of lines inside the polygon  how could also give intersected lines specific colour . Thanks alot 

I would like to ask ,I have two excel fileAs input First excel has only two attributes ,Column A is part of Column A in the second excel (exactly 10 Same iD of the second excel ),Column B is new data Second excel has Column A includes 90 Id,Column B,Column C,Column DI want to merge the new data on Column B to second excel and create new attribute Column EBut I found when I do merge ,I lost the data beside 10 ID that i want to merge ,it shows missing data. Could I ask ,how can I do that and keep the Data in excel 2 plus Data in Column B from the first Excel .

I need to transpose some of the attributes (with prefix "INTER"), but keep the other ones not transposed.Original data looks like this:The result should look like this:Except not transposed attributes should have values. Obviously AtributeExploder doesn't do the job in this case. How can it be done?

@garydlesterHi !I'm trying to do an elevation profile of some network lines to be exported in AutoCAD. But I'm not being able to adapt the labels and grid so as to be able to view the profile of each section.Could you please help me.Thank you very much.

I am trying to modify an existing workbench which reads features from an Oracle database using an SQLCreator and writes them to a feature class in a geodatabase. Currently there is a single query in the SQLCreator. I'm trying to add something to the output which requires a temporary table so I now need there to be three queries running in this SQLCreator:Create temp_table;Query to extract features from Oracle DB (and temp_table);Drop temp_table; Is it possible to run a series of queries in SQLCreator? If not is there some other way? The series of queries work fine when run directly against the database but I cannot get it to work in FME. My fallback is to create views in Oracle rather than using a temporary table but I'd rather not do that if I can avoid it. Thanks,Michael

Trying to use the long-awaited 12D Reader but the resulting lists are overwhelming. Basically, there are pairs of attribute names and values scattered across lists of various depth and ideally regular attributes with values could be constructed. The attribution in 12D and the resulting lists are bound to different levels of a 12D model. Some attributes belong to the whole model, some to geometries and some to individual vertices. Hence the extensive lists.Vertex attribution: The best I managed is a sequence of List Exploders to get to the last position of a list and then build the attributes using ListKeyValuePairExtractor - This custom transformer seems to struggle with the long nested lists; works fine with pairs on one level. It ends up with duplicated geometries for each list pair but it could be flattened by Feature merger and Matcher.Using this approach I need to inspect the lists manually and identify on what level of a list particular pairs are.Any idea how can this be achieved

 Hello Guys ,i want to split ths two lines that intersected in point, i have coordinates for each x maximum and x min. and y max. and y min , i know,one of them is xmax and the another should be in this case minimum one also is ymax and another should be ymini used topology builder static to make group network id and it did correctly but this two lines i do not want to be in the same group so i used clipper points as input and lines as clippe but i found it did nothing .bcs i used after that zopology builder static and it consider both of them in the same group and i want to give each one new network id so is it possible , to make topology builder static with condition that create network id for all lines except the when it occurs value of x max equal value of x min ,value of y max equal y min .do we have conditional to write it for topology builder . or could i use clipper to split two lines when x min value and x max are equal y min is equal with x min .

I have a coarse raster where the pixel value indicates the number of points that should be generated within the confines of the pixel.  I have a fine raster (1 to 2 orders of magnitude higher resolution than coarse raster) where the pixel value indicates whether a point can be placed there. For simplicity purposes this can be a binary mask.  I would like to generate points according to these two rasters with the additional criteria of a minimum separation between points.  Thoughts on how to do this in an efficient manner? I'm hoping to avoid the brute force approach of generating a random point, checking the constraints and repeating until the desired number of points is reached.

I have a Maria DB and a JIRA platform, I would like to use the DB to create new issues there through the JIRA API, how can I integrate all of them? I have already made the regular CRUD operations to the JIRA platform through the API using the HTTP Caller, but, how can I properly use the SQL Creator to use that data?

 I have Oracle no spatial as a reader and when i am trying to read the coordinate ,i found the output is null and i have read many articles and i tried many hours but without any success . could someone help me ,how can i fix the problem for Geometry for Oracle non spatial  in inspector the output of oracle ,it looks like points and each point has his coordinate (x,y)  Thanks in advance