Transformers

  j'ai débuter sur ce workbench mais qui ne marche pas exactement

I have a table with integer values as one of the attributes. I need to add an attribute to represent these values as a percentage of the total of these values like in the table below. have thisneed thisvaluepercentage of total617.64705882411.76470588617.6470588238.82352941225.882352941617.64705882720.58823529  I figured ExpressionEvaluator is correct approach but Im pretty new to fme and cant see how it's done. Any help much would be much appreciated, Rgds

I have an AutoCAD file with many layers and some object data tables (ODT). FME crashes when I try to read it as a Map 3D file. I can't find out what the reason for the crash is, and it reads fine when using a regular AutoCAD reader. When I export out the objects that are just on the layers I need (most of the PR_* layers) I can then read the file as a Map 3D type. I can't tell what is causing FME to crash on the original file. I can't even read the file contents as a Map 3D type.I don't want to have to export out the needed layers all the time, what if the issue is on the needed layers next time, and I am setting up a Server app for users to use and I can't expect them to create separate files all the time.My current FME version is 2020.0.0.1 (20200316 - Build 20202 - WIN64), but I was testing an old AutoCAD file for the Server app, and it ran successfully through an older FME version back in February, but can't now.Can someone tell me what is causing FME to cra

Hi,Is it possible to populate Values of a publish user parameter of type choice at runtime using scripted Python parameter or using any other approach?

Hi there, With Covid, all our employees going to work need to fill a survey about their health status now. Every day. It's the same for kids going in summer camp for activities. So we've been asked to develop a survey that could change in time, depending on the kids that subscribed to the activities. The subscribed kids are exported into an Excel file every week. For the same activity, one week it could be 40 kids, the next one it could be 80. I thought to read the file with FME and push the kids into the survey every week. That way the list of kids in the survey could change without our help. And the kid (or his parent) could select his name to fill the survey. The issue is that we don't know any survey plateform able to change automatically from a script. Do you know if any kind of plateform could change when FME push new values into it? Survey123, Microsoft Forms, SurveyMonkey or something else? Thanks.

I need to set new timestamps to a set of polylines that is to become gpx files and have two questions:1. How do I set what end is the begining of the line?2. Is there some way to start the timestamp at a specified time? Say I wanted it to begin at 01-01-2000?

Hi. I have seen a thread in which they explain that for converting from polygon to multipolygon you only have to choose the geommetry type in the writer parammeters (on FME2019). The thing is that I can't see that option. Is multipolygon not available on FME 2018.1? If not, how can I convert a polygon to a multipolygon? Thanks! 

Hi All,  I have a table contains 3 fields like (id, value1, value2). In that table I have some duplicate records with combination of  fields (id & value1) and the field value3 contains numeric values, these may differ or same. I have requirement like  to find the largest value record from the duplicate records of combination of  fields (id & value1).  Can any one please suggest the approach that how to find the largest value record.  Thanks, Seshu

Hi,Is it possible to get a georeferenced image/ static map from the image fetcher - or something similar?I've used the coordinates of a bounding box, and a Bing Maps API key to fetch an image but it isn't georeferenced.I've tried georeferencing it afterwards but the process completely distorts it so ideally I would like to avoid this step if possible.Thanks,

Hi,I have an attribute (string type) with values such as 37908.907836. If I use an AtributeRounder, I can reduce it to 37908.907. That's ok. But if I convert the string type to double type, the decimals comes again... I have tried to convert first and to apply the AttributeRounder later but it doesn't work. Any suggestion? Thanks!

I've been at it for a day, time to ask for some help.i got the JobHistorySnapshot from FME_SHAREDRESOURCE_DASHBOARD/temp and I am trying to create a custom dashboard and need to pivot some dataThe upper table is my input data and the lower is the desired output (i didn't add the other 4 columns for the repo_four)In words it would go like this, group by date and create columns using repository values concatenated with the existing 4 columns and also transfer the values. How could i achieve this?Thanksraw dataDateRepositoryQueuedTime.MaxTimeQueuedTime.AvgTimeFinishedTime.MaxTimeFinishedTime.AvgTime2020-05-21-17repo_one0088882020-05-21-18repo_one0030292020-05-21-18repo_two2518.511873.752020-05-21-18repo_four11729.252524.52020-05-21-19repo_one004945.52020-05-21-19repo_two2960296024256242562020-05-21-19repo_four0026047260472020-05-21-20repo_one10.16666666712049.833333332020-05-21-20repo_two0024052240522020-05-21-20repo_four002315423154

Hi, I have 2 sets of data. One is income grid (1 square mile area) other is the 50m point bin data showing point locations of potential client addresses. I need support on achieving the following:- create a polygon from bin data overlaid on income area grid and assign median income value to each of these polygons.- Polygons can be created based on the density of the clients close to each otherThanks in advance if anyone can help me with thatJohn

Hello everyone,please, I just wanna use ShortestPathFInder to find shortest path between 150 points. FME needs to get clean road (line) topology to get right path. But, Ive got road network, where are tunnels and bridges that crosses roads on surface.Please, is there any way, how to compute path which uses bridges, tunnels and roads on surface together? I have experience that FME can trace path only network at the same level, or am I wrong? Thank You so much!Lubo

Hi.FME supports lists in both a generic format (e.g. list{}) and as lists with attributes (e.g. list{}.value).Is it possible in Python to get the latter form from a feature as a dict using just the simple format ?E.g. from a feature attribute ( list{0}.value, list{1}.value, ... ) into _myvar = feature.getAttribute("list{}") -- returning {"0":"value0","1":"value1",...} etc.Just using "list{}" returns None as is.Cheers

I am trying to use the SurfaceDraper for a project but it wont do anything. The input arrow for Breaklines is red so I that seems to be the culprit. I cant see why breaklines should be mandatory? A polyline and a DEM raster should be enough to do the draping? Is there a workaround for this? 

Hi, i make a normal AutoCAD to AutoCAD conversion but i have Problems with circles…... circles move completely on a different place (e.g. ca.80000m to the left)when i stroke them with an ARCStroker they land on the Right Position BUT i dont want to have 2000 circles which are split into massive lines…..  so anybody any helps or Workarounds?Greetz and CheersFranco 

Hi guys, I have created all the vertices (point features with z information) on my line feature. Now i would like to create 3D polyline feture from existing line.1. I would like to maintain line feature and its attributes - so an option of creating line from points is not an option.2. Is there any option to define each vertice on my line feature a z information from existing points?Thanks in advance again. Bye, Miha

Hi,  is there a way to expose the file type suffix (e.g. ".shp") after the file has been created and zipped with the FeatureWriter? The "_dataset" attribute only yealds the .zip suffix whereas _feature_type attribute does only show the file name without the suffix. Thank you for your help.

Hi,I have boxes shp and building shp.(Jpg_1_1)I want to cut the buildings according to the box limits but I want the buildings that touch the box limit to stay in that box. A building can be in more than one box. (jpg_1_2)I use clipper but cut buildings according to the box borders .(jpg_1_3)  Finally, I want to export according to the box names .Example: (1149334,1149935)

I want to create boundaries on some point cloud data (see https://knowledge.safe.com/questions/109029/how-to-create-disjoint-boundaries-of-disjoint-clus.html ) Note that the point cloud data were previously stored in an oracle dabatse as multipoint For some reason, the ETL get stuck during the boundary polygons creation with the HullReplacer My datasets is very big (~ 26 millions of points). I would like to know if there are some transformers like pointcloudthinner for single multipoint in order to reduce the density of the input points or if there a reverse transformer for pointcloudcoercer so that I can reconvert first the single multipoints to a pointcloud and then use for instance the PointCloudThinner before sending the data to a Hull replacer Thanks

Hello, I have a table like this: System ErrorAffected RegionTotal Error 1City2Error 1Village5Error 2City 7Error 2Village3 What I would like to have is this:Affected Region Error 1Error 2City 27Village 53 What transformer do I need to use to change the table structure?Thanks.

Hi guys,I've seen that the transformer "OffsetCurveGenerator" creates me some gaps on one of the offset lines generated.Here are the parameters set:The input line from a ESRI Shapefile, which makes the issue (nothing really complex..):and here is the one on which has been created gaps (PINK) right side, and (BLUE) the Left side with no gaps:As you see, the other MultiCurve line, well created is the LEFT side from the transformer output. But the RIGHT side (pink) is created with gaps.I need to say that I tried to isolate that line, and the output stays the same.I use FME Desktop 2015.1.0.1 - WIN64 - Build 15480.Thanks for the help,

Hi,My question is so : What is the best way to recover all the points of a point cloud (las) within 5 centimeters of a facade (stl)?Among three ideas, only one seems to work (taking 1h30 of calculation for three million points and 96 facades)PS: A facade is composed of two triangles in STL formatThis idea is to start from the stl, to extract the 6 points of the two triangles, to keep only the 4 unique ones composing the plan thanks to PythonThen go through a "TinGenerator" before using an extruder on either side of the Tin surface in order to "Clipper" the point cloud with the 5 cm extruded planesBut this solution seems particularly time-consuming to me given the lack of input. I therefore seek to simplify this process so that it is more efficientBest regards, Corentinhttps://www.zupimages.net/up/20/22/6jkm.png

Hi, I appreciate this is an additional question on this topic, but I am struggling to get the Counter transformer to reset to 0 in my particular example.I have a dataset along the following lines: Site,Date,EventSite1,20200101,0Site1,20200102,0Site1,20200103,1Site1,20200104,0Site2,20200101,0Site2,20200102,4Site2,20200103,0Site2,20200104,0 I would like to set a Counter for each site to essentially calculate a value for "how many days since last event", i.e. the Count +1 for each 0 and resets when it encounters a non-0 value, resulting in:Site,Date,Event, Days Since Last EventSite1,20200101,0,0Site1,20200102,0,1Site1,20200103,1,0Site1,20200104,0,1Site2,20200101,0,0Site2,20200102,4,0Site2,20200103,0,1Site2,20200104,0,2 I'm struggling to have the Counter reset to zero, perhaps I should be looking at an alternative approach, as per the advice from @takashi this Knowledge base article? https://knowledge.safe.com/questions/5287/counter-by-group-but-reset-to-1-within-a-group.html

i have network properly noded and i got paths by short path finderbut some points has two paths and i would like to get the two paths if it is possible ,how could i do that?  i read some where that i can remove the path after it founds but i am not sure how could i do thatFME 2018Thanks in advance