Transformers

Hi,My Workspace two Source : 1 feature of line and a Excel file with 3 features.The goal is bring the attributes of the XLS into a line.How can you see in my Template file, i used the FeatureMerger and after ListExploder. I have 3 lines but i need just one with all attributes.Attached my Workspace.Thanks, Danilo

Hello, I have a sequence of points along a line. I have to detect change in an attribute (called "framing") of a point from its previous point. The points are sequential. Sequences are stored as an attribute too "sequence". I imagine I can use an AttributeCreator to create a new attribute called "change" and make the value conditional. Problem is, I am not good at RegEx or conditional statements to know what would be useful. I need to compare the "framing" attribute with only the previous point within the sequence. Not the one ahead. I have been trying to follow the example in the thread below but no luck. https://knowledge.safe.com/questions/33705/compare-attributes-from-two-features.html Eg, if there is a way to compute something along these lines: IF point.framing = point(sequence-1).framingThen, Change = No. Any help will be appreciated.PS: Working with FME 2016.0

I'm trying to create an attribute ("incorporated") whose value is 0 or 1, depending on the value of another attribute ("Code"). I'm trying to do this in Attribute Manager. But I can't seem to get it to evaluate. I've tried many different permutations of the expression. The attempt shown in the attachment uses Python syntax highlighting which I would assume means it would be interpreted as Python code. Anyway, it doesn't work, as you can see in the breakpoint data.

Hi All, I am using a linked Transformer, creating an attribute, let's say Z. Attributes X and Y already exist on the object. On FME Desktop, the three attribute values X, Y, Z are passed by the Linked Custom TransformerOn FME Server, where the same version of the Linked Transformer is installed (double checked), the X and Y attributes are lost. Attribute Z, created by the Linked Transformer is the only remaining attributeIf I Embed the Linked Transformer and republish to FME Server, the X, Y Z values are all retained.Does anyone have an idea why this happens?best regards, Jelle

Hi guys,I am trying to use point overlay to get a point count over polygons, but everytime the Point Area Overlay transformer seems explode the multi-parts polygons. Is there anyway i can avoid this?Thanks!

We recently updated NTLM from v1 to NTLM v2. After this changes we getting '401 Client Error: Unauthorized' when we are trying to read SharePoint list with "Microsoft SharePoint List" reader. Our FME version is 2016.1.3.1 (Build 16716) Does FME support NTLM v1 and v2? Any suggestion here?  Thanks in advance Yarko

Hello all, I have a question for which I feel like the answer should be simple. But for some reason I cannot find anything in Knowledge Center or think of a way to do it. I have a network of lines with points all along them. The points are not necessarily at the start or end of a line but along them. I need to sequence the points starting from the start of a line segment to the end (it doesn't matter which direction). The first point along the start of a line should be flagged as point 1, the next as point 2 and so on. If a line branches off, the first point on that line will be point 1 again and so on. In the above example, we can also start from point 4 and go downwards in a sequence. Any help will be much appreciated. ThanksEdit: I am using 2016.0 fme desktop

Good afternoon, I'm working on a project where I am doing an area analysis for a set of polygons. The area is calculated in hectares in MapInfo and converted to a shapefile in FME; however, when the area is recalculated in ArcMap, the results are different at a consistent rate of 1.0039 (i.e. MapInfo: 34.6516368 ha; ArcMap 34.7855988 ha). The projection & coordinate system remain unchanged during the conversion so the area should remain the same. The same discrepancy occurs when an Esri shapefile is converted to MapInfo and calculated. Would you be able to provide insight as to the discrepancy?Thanks!

I have two point featureclasses and want to snap the points from Point_01 to Point_02. Both Featureclasses have 261 points, but after the translation, there is always only 245 snapped points and 16 which are untouched. I have tried many tolerances and snap-to-Vertex as well as snap-to-endpoints, but something is stopping the 16 points from snapping to the next point.If anyone can shed some light I would be most grateful

I am looking for a way to have a "default value"  if there is no data in a subtemplate.  Consider the house, village example from the help documentation.  If we have multiple villages with an id, and multiple houses with a village_id,  we can set the Root template to <village><name>{fme:get-attribute("name")}</name><population>{fme:get-attribute("population")}</population><houses>{fme:process-features("HOUSE", "village_id", fme:get-attribute("id"))}</houses></village>and the correct houses will be associated with the correct village. and you could end up with an output like <village> <name>Anytown, USA</name> <population>2568</population> <houses> <house> <address>123 Main Street</address> <owner>John Doe</owner> </house> <house> <address>324 Main Street</address> <owner>Jane Doe</owner> </house> </houses></vill

Hi,I want to know in detail about How to style DGN file based on attributes?What are Cell file and Cell Names?What is use of seed file and cell file?Thanks in advance.

Hi, all:  I have a huge MS SQL Server Non-spatial database,each record has a "datetime" time stamp. Now I'm using "SQLCreator" to read the data. In the SQL Statement, I wrote:  SELECT * FROM mytable WHERE  ID='1007' AND YEAR(datetime)=2015 AND MONTH(datetime)=1  But I cannot get the data and FME say: MS SQL Server Reader: Query failed, possibly due to a malformed statement. Provider error `(-2147217871) Query timeout expired'   Does anyone know the reason?  Thanks in advance, Ariel 

Hi @NatalieAtSafe, most Idea pages are not found - 2017-09-12 15:10+09. What's going on?

Hi,I'm hoping to reproject a MapInfo Tab file from BNG to ETRS89 and also extract the lat and long the process. My starting point was the bnglatlongreprojector (thanks you Safe) but I'm getting the following error when I run it: "could not reproject the geometry of the preceeding feature: Reprojector: Could not create reprojection engine".Any ideas anyone? I'm using FME 2017 Desktop.Thanks in advance,Jake

Hello Everyone, I have a field which contains table and column name together for Foreignkey using (,) and (#) seperators. I have created also List on this field already, now i am not understanding how I can make another list for getting those values. Now my result XML is looking like :bnr:table > element is getting all the table and column names now, but i want to see my XML as follows:A partial coding of my XML template is as follows: <bnr:MD_DataSchema>  {  let $n := xs:integer(fme:get-attribute("_element_count")) - 1 for $i in (0 to $n)  let $aname := "_list_name{"||$i||"}.Spalte" let $atype := "_list_name{"||$i||"}.Datentyp" let $descrip := "_list_name{"||$i||"}.Beschreibung" let $fkey := "_list_name{"||$i||"}.Tabellenbeziehung" let $mval := "_list_name{"||$i||"}.Fehlende_Werte"  return {  if (not(fme:get-attribute($aname) eq "")) then  <bnr:colu

Hi,I have a pointcloud, each point has a value that spans between 0-50. I have separated these into 6 groups with the PointcloudFilter and collected these 6 categories of points into an attribute called Groups. Then I have created a NumericRaster grouped by Groups with a cellsize of 2mX2m.What I want to do now is to make them into polygons, I have tried alternative routes with success however I would like to try the RasterToPolygonCoercer, therefore I need to alter the band of the raster to my group categories. My question is how I need to formulate the RasterExpressionEvaluator so that the Coercer makes polygons based on my previous filter groups?

FME Information Edition: FME ESRI Edition (node locked-crc) Version: FME(R) 2017.1.0.0 (20170731 - Build 17539 - WIN32)Operating System: Microsoft Windows 7 64-bit Service Pack 1 (Build 7601)When I inspect geometries and zoom in, the data inspector does not render them correctly (see screen shot - the line should become focused and not fuzzy). In order to display them correctly I have to change to Table view and then back to 2D Geometry view. Can I do anything to resolve this?I have tried it with a single polyline and with 10000 Points - the result is the same.

Is there a way for the schema mapper to map based on a range of attribute values?  Essentially   MinHeight, MaxHeight, NewValue 0,10,Level1 10,20, Level2 20,30,Level3  such that a feature with a height of 14.7 would map to Level2.  The mapping file is an external csv maintained by someone who has no knowledge of FME, and get's updated on avergae every 2 months.  

I have a client with an interesting request. Basically they have about a dozen shapefiles that consist of points, and all points have 1-4 attachments. What they'd like is to combine the shapefiles into one complete shapefile, and carry over the attachments as well. Unfortunately ESRI doesn't allow you to merge shapefiles, and have the attachments go with it. To further complicate it a bit, all the attachments are labeled the same: photo01, photo02, photo03, or photo04. The naming convention is generic, so simply extracting the photos and reattaching them after merging the shapefiles is out of the question, unless I somehow rename the attachments as I take them off and link them to their proper attributes as they get reattached to the merged file.I very well could save each attachment and rename it with some kind of naming convention as i download it, but it's repetitive and mind-numbing, and it seems like a perfect candidate for automation. Anyone have any thoughts? I'm

I have 3 attributes that could potentially have duplicates. A, B, C. After finding the duplicates, I have to make a decision on which ones to keep based on attribute D. The scenario is as followed: if A,B,C are the same, take the record where D is not null. If D is null for both records, take any one. If D both have values, take both unless the value in D is the same then take just one. Help!

Hi,I have a set of 2D points and a disolved polyline in 3D formate that they overlap (with 100% precision) If the elevation (Z coordinates) of the polyline is removed. I am looking for a solution to elevate the points such that the intersection of each point matches the 3D polyline.Best regards

I need to take a polygon feature and create a csv with all the vertices. I have the whole process and it works no problem, except that the amount of vertices has to be limited to 50. I have some very detailed polygons, particularly at coastlines, that become self-intersecting after passing through a vertex limiter. So far, my process involves a donut hole extractor (process that ingests the csv cannot handle multi-part polygons or holes) and the outershell passes into a vertex limiter (vertex limit:50, aggressiveness level:.001) and then after passing through a geometry validator, the rest of the process creates the csv.What I need is a small final file, but as much accuracy as possible. I am aware that limiting the vertices from thousands to 50 will create angular polygons, but what I want most is to maintain shared boundaries while still limiting the vertices. I do not want them to overlap, have gaps or self-intersect. I have tried the generalizer, but I have a specific number of ver

I have a couple of thousand points that have a number as attribute. Some of those points are- close to each other - also have the same number Note: there are also points that have the same number but are far apart. I want to merge all points that match both conditions into 1 point So far I have set a neighbourfinder transformer, which groups the points by number and then finds the closest points (max 4). But how do I merge the resulting related points into 1?Any suggestions are welcome. Kind regards,Pim Verver