Transformers

Hi there,I've searched a few threads on here about calculating percentages, but nothing seems to quite summarize what I'm looking for.I have several polygons, each containing an attribute of "TotalKm" and "MinorKm"The "MinorKm" represents roads inside that are of a lower class or quality.I simply want to calculate the percentage based on the "TotalKm", like this example:MinorKmTotalKmPercentageKm156025%15020075%I tried playing around with the ExpressionEvaluator to do this, but I could't quite create the correct expression for this.Thanks in advance,

Most of our ArcGIS projects are in a custom projection based on NAD83 2011. I cannot find a transformation for converting the data to EPSG4326 (WGS84) for export to kml files. I added the custom projection to the MyCoordSysDefs.fme file and it is reading the parameters. Anyone else working in the 2011 datum trying to export to KMLs? We are seeing a shift using the older NAD83 to WGS84 transformation, how do you work around that problem? Did you have to create a custom transformation?It doesn't help that ESRI refers to the datum as GCS_NAD_1983_2011 and FME has it as NSRS2011. It appears not able to translate those two.

Hello everyone,I'm stuck on something in FME and looking to you all for assistance.Little background for the following example is I work for a Large Utility Company and working with data in an electrical system which is Points and Lines:Here is the the basic description of my problem and what I am looking to achieve and I have the workbench built (or did until I ripped it apart trying to solve this).I have a LINE object (Primary Conductor) being filtered by an Attribute (Circuit) and have multiple different features (all points, representing the different electrical devices) which have a Circuit field but in some TiePoint cases the Circuit field could be different.Therefore I am running a SpatialFilter on those points that touch the conductors and after it runs through the rest of the workbench produces an object named by circuit and the type of device it is.My workbench accomplishes everything I need it to EXCEPT the points that join between two different circuits (Lines with diff

Hi,I’m trying to transpose the following table from SQL Server:KriterieTestparameterVerdi 1Verdi 2Verdi 31UNIKEnToTre2STADNasjonal5PROD123Into this table (first row as column name):TestparameterUNIKSTADPRODVerdi 1En1Verdi 2To2Verdi 3TreNasjonal3Kriterie125Using this article, I’m able to transpose the table into (column name like A-G): https://knowledge.safe.com/articles/31701/transpose-a-table-using-fme.htmlBut for further use the column name must be the first row, not A-G.How can I set first row as column name? I’ve tried using the AttributeCreator with values from a second list, and exposing the dynamic attributes afterword’s, but I can’t get it to work.. Attribute name from list example: New Attribute = @Value(_testpara_attri{0}._testpara_value)Attribute value = attrs{0}._attr_valueWhere _testpara_attri{} is the list with column names, and attrs{} is the list from the transpose routine. Workspace:

Hi, I want to do a point on polygon analysis and list all the records under each polygon without merging duplicate properties.I’m using Spatial Filter to find the properties within a given area. It’s giving the correct output if I send one record at a time. But when I send all the area records to Spatial Filter it merge duplicate properties (candidates) to a one record.I’ve change parameters on the Spatial filter but failed to get the expected output. Can someone please help me? Area record and relevant properties Area ID Property 1 A 1 B 1 C Area ID Property 2 C 2 D 2 E Expected Output Area ID Property 1 A 1 B 1 C 2 C 2 D 2 E Expecting 6 properties, not 5 properties after merging the duplicated property C.Thank you.

Hi,I have what I think is a fairly simple question. I just want to calculate the average of all the cells in one band on a raster. I am using FME2017.0.Is there a simple way to do this without having to convert the rasters to vectors (points) and then using StatisticsCalculatorThanks

Is there a way in FME to detect if there has been a change in the attributes name or if there has been a new added attribute to a source file how it can be synchonised in writer

Hey folks, I'm in a bit of a trouble. The readout of an xml file gives me an attribute that contains coordinates. The attribute's content is like this: '47.609703,9.858943 47.620427,9.867245 47.613033,9.92076 47.600331,9.930115 47.612142,9.960663 47.61008,9.972698 47.631773,9.980192 47.609703,9.858943 47.609703,9.858943'Please be aware that i shortend the count of numbers.All I am trying is to build a polygon with these coordinates to write an Esri shapefile.The PolygonBuilder/AreaBuilder won't help because it needs polylines to work with. Thanks you so much,Ed

Hello, I've tried looking into this and I'm pretty sure I know the readers and writers to use but the middle bit seems to be stumping me. Put simply, I have a folder with 800 files in it. I have a list of about 200 files which reside within the aforementioned folder.I'd like to copy and paste only the files contained within the list into a new folder.Any help would be greatly appreciated!

Hi,For a given 2 lines (line_id1, line_id2), I should do LineOnLineOverlayor and then lengthcalculator.After that I want to have the accumulation of length of the new segment of Line_id1.Ex: length_accumulator of the first new segment = the samelength_accumlator of the second new segment = length_accumulator + lengthAnd so on.I’m using Counter (to have line_id1), then LineOnLineOverlayer (generate List line_id1_List) and finally AttributeCreator (length_accumulator).What should I do to calculate the length_accumlator (I can not use length between coordinates because I have curve and polylines)?Thanks

Hi together I get a lot of polygons and some of them have redundant vertex point coordinate!!! How can I remove the redundant points in this polygons? Thanks Zoran

I have a point cloud and am wanting to create a 3D solid from the extents. I have been able to produce a solid like this below with help but just wondering if there is a way so that the solid is created like the first image attached with the solid that I require very roughly outlined in red?Any help greatly appreciated

Hello,I'm trying to create a kml-file using the xml-templater. In the kml file I want to visualize points and Lines, something like:<Placemark>  <styleUrl>#Icon</styleUrl>   <Point>  <coordinates>{fme:get-attribute("rw_wgs84")},{fme:get-attribute("hw_wgs84")}</coordinates>  </Point>  </Placemark> <Placemark>  <LineString><coordinates>{fme:get-attribute("_coordinates")}</coordinates></LineString> </Placemark>But I get an syntax error (missing comma between the Placemarks)?What Am I doing wrong? How can I create a template for different placemarks?Thanks for your help,Isabell

Exporting a Database in 12c , the SRID is set to null , is there a way that FME can update all SRID to correct coordinate system within FME , would it be Feature class by Feature class or can it be doen for the whole Schema ?

Hi Guys,I hope I explain my self clearly.My Problem is: I have a point dataset and a line dataset. What I want to be able to do is find the point that is the closest to the start and end node of each line object and display it in a csv file etc.The lines could have multiple vertices in them but I only need to know which point is closest to the start and which point is closest to the end.Both datasets are shape files.Is there any way this can be accomplished?so the output would look likeline_idline detailsstart_node_pointend_node_point1234sdgsgfg9876541234565678sgsfhdfhd546214748565

Hello, any datetime expert out there? I have a dataset in yyyymmddhhmmss format in utc time. Now I am trying to convert it to local time with the consideration of daylight saving. I know the newest version of FME has features that support advanced datetime conversion, but still really confused on this especially with daylight time saving. Before, I have a user parameter to ask the user to manually choose the UTC offset. Now I am trying to upgrade my workspace so that I can get rid of this and have the FME detect my UTC offset automatically. Any ideas? Really appreciate it!!!

Hello,please, I need to solve one spicy problem. I have autocad_insert entity (block reference) composed by insert point and text point (label). Distance between these two point is variable, so I need to extract relative position of text point to block insert point. Is any possibility there to extract difference in X,Y?Thank You so much!Lubo

I have a CAD file with polygons representing areas of landscaping which I am going to export as a shape file after some manipulating. These polygons have multileaders with an area reference (as text) pointed towards them, and I am trying to give the polygons this text value. I would've liked to have used the Neighbor Finder transformer but the distance between the leader arrowhead and polygon isn't necessarily the same throughout.Any suggestions would be much appreciated.Katie

I have to fetch data from PV output website and for this I am using TimeStamp_StringSearcher. This is provided to me by my teacher and I dont know how to understand this:  cats = [[ A-Za-z0-9_@.\\/'#:,&+-]*]  When I run my fme scheme it says this error:  @Length -- Invalid argument -- ''6:15AM','6:30AM','6:45AM'.....  Kindly explain briefly  Thank you

Hi!I am trying to find the shortest paths between many points and one destination, any idea on how I can easiest do this? I would like to reach a similar effect as v.net.distance in QGIS. I have looked at shortestpathfinder and networkcostcalculator, but I cannot see how I should use them, or which other tools to combine them with, in order to reach my goal.

I am trying to create 3d block of the point cloud extents and not really getting anywhere. I was wondering if anyone would be able to help me in achieving thisThanks, Sam

I have a startup python script which runs perfectly fine with the previous FME 2017.0 version, but after I upgraded my old work space using the newest FME 2017.1.1 version, the work space failed to run. It gave me this warning message "The User-specified library C:\\Program Files\\FME\\fme.exe could not be loaded". I'm wondering if this has something to do with the installation of fme and python library. Also I have two error messages saying "Python Exception : No module named arcpy", "Error executing string `import os". Does this mean I have to reinstall arcpy library? Can anyone give me some suggestions?Appreciated it!

Dear expert of Dynamic Segmentation:I was using LineOnLineOverlayer for Dynamic Segmentation purpose, but it was giving me wrong attribute information. I've got 2 segments or event layers here, all with geometry:The ideal result I was looking for is:But the result generated by LineOnLineOverlayer is:Looking at the result in FME Inspector, the geometries of the 3 segments are at the right place, just the attributes are all messed up, specifically 1st and 2nd row. I didn't find too much information about using FME for linear referencing stuff, so I have to turn to this forum. I hope gio and takashi or anybody with previous experience could provide some insights on this. Much appreciated. Thanks!@gio @takashi aand  

Hey guys,I checked this post below:https://knowledge.safe.com/questions/56005/create-a-personalised-id-with-letter-and-number.htmlit helped me, but I need to use 3 letters (I will specify) and 6 numbers. I used counter to generate the numbers and used string replacer to add the letters I want. However, I need to add zeros between letters and numbers. I need to something like:ABC000001ABC000002.........ABC000011...ABC012341