Transformers

I'm using the excelstyler writing to excel feature writer. Its applying the formatting (highlight full row) except to some date cells it only applies it to those cells in first row rather than those in every row that meets the condition.

My situation is this. I have a number of lines in a gdp on top of which I have some points (with a unique id called nodename). I want to rotate these points based on the angle of the lines. What I have done so far to achieve this is to make a buffer around the points, clip the lines using the buffer. Use the horizontalanglecalculator to calculate the azimuth of the lines. However some points have 3 lines coming through them meaning I have 3 angles for 1 point. I need to calculate the average of the x number of angles for each nodename.  Can anyone help me with this? See the picture below.  Regards Rasmus

I have tried to use LineExtender and Snapper but results are not correct, not sure what I am doing wrong. Workspace (FilterGeoJSON) and Geodata (LineArea) are attached.

I have created a User Parameter of type Choice. I am trying to transfer control to a workspace runner based on what is selected. So far, I am having no success. When I run the workspace, the value is showing as 0 instead of my actual choice.

Hi, just learning FME.I would like to know what transformers to use when I need the ff: Identify points that are near each other (points within 30m buffer)Identify the similar attributes of the points within that 30m buffer The goal is to know the potential duplicate points based on XY and other attributes. Thank you!

Sometimes one ends up with tables that contain empty columns. Is there a way to detect if an attribute is not being used, if it is "empty", and then remove it from the table? A automatic table cleaner of sorts. This would make the management of data "creep" a lot easier.

Hi,i want the start and endpoint of a line. So I use a Coordinateextractor and with coordinate index 0 I get the start and with -1 the endpoint. Normally it works fine but I have a line and suddenly the endpoint is somewhere in the line. I found out that the line was aggregated with FME and this somehow mixes the parts and the indexes of the line, so the endpoint is now in the line. In the help of the aggregator is listed: If the order of individual geometry parts within the resulting aggregate is important, you can first route the features through a Sorter. But I don’t have attributes to sort the line.If I use the dissolve function of Arcmap the line is dissolved correctly. So is there a way with FME to get a aggregated line where the coordinate index of start is 0 and coordinate index -1 is the end at the correct position?

Hello, I am passing in a list of values to a user parameter (eg: LGA LGATYPE ABBNAME). The user parameter is assigned to a parameter of ChangeDetector (Selected Attributes).  If I open the FME workbench and run it, the ChangeDetector recognises the parameter value passed as a list of attributes. It then uses those attributes to check for any differences between 2 datasets. That is as expected. However, if I run the tool from the command line and pass in the attribute list as a parameter, (eg: LGA LGATYPE ABBNAME), ChangeDetector does not recognise it as a list and does not find any attribute based changes.  If I reduce the command line parameter down to just one attribute (eg: LGA) then it works. The parameter is a list parameter:  Any thoughts on what might be going wrong?

Hi everyone. I am new to XML and am having some difficulties using the XMLUpdater and XQuery. My issue is around updating 3 attributes within an xml element from 3 attributes in an FME list to create multiple children. When I do this for a record which has say 2 items in the list it’s producing 9 children instead of 2, do I need to group my data somewhere in my XQuery? I’ve attached a sample workbench and data. I am reading an Excel document, then creating a list of all LCS_Codes and their measures per TAC_Code. I then want this list to form the children of a location element within my XML. So I’d hope to go from something like this: Input table:To this output XML text: <tractionCurrentSection id="M58"><location> <part idEl="B077/MSBFA" startPos="0" endPos="149.302"></part> <part idEl="B077/MSBLO" startPos="0" endPos="133.761"></part>

We have certain coordinate system transfomation requirements for LLH to grid coordinate conversions that are difficult to satisfy using the available reprojectors.I would like to understand how to build and provide a custom projector to be used in our FME transformation pipelines.

Hi FME Guys I'm struggling with a data situation that occurs frequently in my daily work. When I have a polygon feature it may occur that this polygon is composed from "thin" and "thick" sections. See below a screenshot of such a situation.I'm now looking for a way toidentify affected polygon featuresidentify "thin" sections from this featureremove the thin sections or at least cut them from the "thick" parts.Each solution should keep existing Z-values as I'm dealing with 3D data. Any ideas how to achieve the desired result?

I have an idea about a collection of feature readers and writers (feature reader for DWG can break blocks 1 level. then checking if the entities resulting from that break is geometry ( ill keep the block containing that geometry from before the break) or if its a block (break again). then iterating over that until all i have is blocks that if breaked/exploded only consists of meshgeometry.  I would like to hear some feedback on this idea.

I am trying to merge a set of tiles into a geopackage file. The sources have different geometries and schemas. The string transformers are beacuse the sources have (4) unique characters in the beginning that need to be removed in order to do the merging. I have successfully used a similar workspace to merge tiles into shapefiles in the past. This time all is well until I try to write the new file. There are quite a few errors reported but the geist of them seems to be: "OGCGEOPACKAGE writer: No definition found for input feature type 'NNNNNN'. Ensure that fme_template_feature_type is not set incorrectly and that the feature type name is valid". Any ideas on how to resolve this? 

What I want to achieve is:colour is split into list attribute colour{}nationality is split into list attribute nationality{}status is split into list attribute status{}size is split into list attribute size{}shape is split into list attribute shape{}etc. in one go. Thanks for you help

Is there a way to test if my incoming lines/polylines have measures attached before I use the MeasureExtractor? If the incoming feature does not have measures - MeasureExtractor fails. I tried GeometryValidator, but this lets the features pass if all vertices do not have a measure.

Hi!  I would need to prepare a FME-based flow doing more or less what the "Erase" tool of ArcGIS is doing. As there is no equivalent transformer (correct me if I am wrong), I use a Clipper transformer as shown in the attached workspace. How could the process I came up with be run in an acceptable amount of time (close to the 25 minutes of ArcGIS Erase tool) while preserving the attributes of the layer being erased (which ArcGIS does by default)? Indeed for many projects we need to recuperate a lot of information from those specific roads in order to create them with all the required attributes. Preserving these attributes in the process will have a significant impact on performance (I stopped the process when it was already running more than an 1 hour). Even preserving only the Id and then using later on a FeatureMerger in order to join the original attributes to the remaining roads (after clipping) results in a lengthy processing time (1 hour 19 minutes with FME 2014 sp3 64-

Selected blue area is polygon. Red lines is line.I want to cut the blue area according to the lines and create 3 areas.  

The workspace tries to read a CSV from internet and write a feature class in a geodatabase. I am trying to use this workbench with a remote desktop machine, which has all the licenses needed installed. Just a note, the workspace works perfectly well in local when not using the remote machine.  It also works when using Open API geodatabase writer or shapefile writer. I though it may be a licensing issue, but then the workspace works when you run it from the beginning to the join and then from the join to the end, instead of running the entire workspace. So I though maybe it was the temporary storage failing, so I changed the temporary files storage folder but the same error appears. BTW, the error is very generic "Error running translation" so I do not know what else to do. I would appreciate any help to solve this issue. Right now I've split the worspace in two, one to read and download the CSV file in the remote machine, and another to read the CSV from the remote machi

Is it possible to set up the spatialRelator, or other transformer, to identify a relationship where the features touch along an edge rather than at a point. I know I can set the spatialRelator to Calculate the Cardinality of Intersections, and then filter the _relationships{} list to remove any elements where _relationships{}.card_line = 0, but that is non-trivial (ie python), and then recalculate the _related_suppliers attribute, but I'm hoping there is a less involved option.

I often use GDAL Warp to minimum sample rasters. I struggle to perform such a resampling in FME and it ends up involving a lot of operations and/or external tools.  Does anyone have a tip?

I have a very large conditional I would like to export to text, so far I've tried copy/paste, and can't seem to find any other ways. However it doesn't wok.

Hi; I installed the FME Plug-in SDK for C ++. When compiling the sample solution, 2 files are missing. "fmeplugincapabilities.h" and "ipipe.h". Where are these files located?

Hi, is there a way to find the last OBJECTID in an ESRI FileGeoDatabase and return it? I can do this using SQLCreator > VariableSetter > VariableRetriever > Counter transformers for an Oracle Spatial Database but a FileGeoDatabase is not listed in the Reader Gallery within SQLCreator transformer. My knowledge of FME is pretty basic and would appreciate a 'how to' (if it's possible). Thank you

How to create a Polyline shapefile from CSV/excel data

I would like to know what would be the simplest step to transform the following source:  to the following