Transformers

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" le

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 thought

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

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

Basically, can anyone tell me the format of this value. For example if I want the reference scale to be 1:800?

Hi,I'm using FME 2016. My workflow is:- open dwg- transform (coordinates)- write dwgWith FME 2016 I'm able to retain layouts but here is my problem: layout viewports don't seem to be transformed. After the coordinate transformation is done the viewports still point to where the data was before the transformation. I enabled "read paper space layout Information" and "read model space entities through viewport".Does anyone know if transformer works an viewports as well and if so, how?Thank you, Rob

I wish to add text record of attributes to jpgs. I am creating a workspace runner to do this. However, I cannot get the text to be applied to the raster. I can see that the text is created in Inspector, but Vector on Raster overlayer does not write the text to the new raster. (See workspace)I tried mapnikrasterizer with even less success; I couldn't get any product from the jpg writer.This seems like it should be a simple fix.Your help is much appreciated,William

I need to convert sketchup .skp to some format that I can open with solidworks like .step does anyone know if this is possible?

I need to use the Inline Querier to perform a row_number, at the moment I am getting the following error (I am using this syntax in SSMS and it is working):InlineQuerier(InlineQueryFactory): Error preparing database query: near "(": syntax error Unable to execute statement InlineQuerier(InlineQueryFactory): Database was unable to prepare query 'SELECT "Conf Score" ,"TOID" ,ROW_NUMBER() OVER (PARTITION BY "TOID" ORDER BY "Conf Score" desc) FROM "Sheet1" '.InlineQueryFactory instance was not properly defined. Consult logfile for details. InlineQuerier(InlineQueryFactory): A fatal error has occurred. Check the logfile above for details A fatal error has occurred. Check the logfile above for details

Dear users of FME,The main question is short and of the kind 'yes/no':  When writing to a .dwg file (creating a new one), using an existing template .dwg, is it possible for the external references from the template to be incorporated in the new .dwg? Especially when making use of relative pathways in the external references?   Also, would it be possible to create attributes like 'autocad_xref_path' and 'autocad_xref_name' to manually specify an external reference when writing to a new .dwg?  I have been trying out both cases but none seem to work.  Looking forward to your opinions!

Hi all,I have a Workspace configurated to extract HTML information. My goal is extract the information ( Previsão do Tempo: 29 max and 13 min ) using the transformer HTMLExtractor:Attached my Workspace template:Thanks, - Danilo

Quick question. Can anyone tell me, or point me to a resource for these geodb_* values, specifically relating to an ESRI file geodatabase that I'm trying to write annotation into including horizontal and vertical alignment?

Hi,How can i store color symbology from CAD Layers in an attribute and apply it to layers in File GDB after translation?Thanks in advance.

Without further ado I wanted to honour last month's Flavour of the Month winner: @redgeographics (aka Hans). Congratulations Hans, for your score of 1081 points, and to everyone for their great contributions. This was a very high scoring month.The top ten for August:takashi: 2229erik_jan: 2144david_r: 1477redgeographics: 1081courtney_m: 10351spatialdave: 637danilo_inovacao: 620sander: 525mark_1spatial: 440gisinnovationsb: 434Well done to you all, but particularly Hans on (I think) the 13th anniversary of starting his own business. I also wanted to mention that I'm putting together a small, fun contest to find the community's favourite FME transformer. I've taken the top transformer for each of the 16 categories and am putting together a knockout competition based on online polls. So watch out for that next week.Finally, last weekend I did som

Hi,I want to explode the multiple features of particular shapes in CAD file into single point feature in File Geodatabase.for e.g. rectangle or small circles into Point.Thanks in advance.

hello,I am looking at converting from British National Grid to London Survey Grid,I have looked in the pre-defined Coordinate systems within FME and struggle to find this grid,the conversion figures are provided in this PDF on page 17 Table 1,as i am new to this kind of data, how would i go about using those figured to create a custom coordiatie system in FME?any help would be much apreseatedcheers,Jameshttp://www.engineeringsurveyor.com/software/1-026%20-%20Topographical%20Surveys%20and%20Mapping.pdf

I am trying to add a new attribute to a feature class in CMDM Geodatabase. This attribute is going to be FEATID, I tried to use AttributeManager, and the user attributes in writer properties but none of them worked. I tried to use PythonCaller with the code below but I could not get any result: ----------------------------------import arcpyRoadCentreline = "C:\\Users\\akinc\\Desktop\\dellMe\\CMDM2.3.3.gdb\\ReferenceData\\RoadCentreline"Add Field arcpy.AddField_management(RoadCentreline, "featID", "LONG", "", "", "", "", "NULLABLE", "NON_REQUIRED", "") ----------------------------------- This is the workbench: