Transformers

Is there a way to get a list of exposed attributes/schema from a SQLExecutor into an attribute value or as a list? I know I can write out a record with a featurewriter and sue a schema reader to get at it, but that is a convoluted way to go. I guessing ti can be done with python, but my python skills are limited

Hi All, I want to count the number of houses that intersect (gas)lines, in order to do some quality checking.most gas pipes only intersect one house. Any pipe with multiple intersects is suspect. The gas pipes are of limited length (typ. 30 meters). However I need to do this for > 1 mln pipes aganinst > 3 mln houses. That crashes my pc due to lack of memory.I'm looking for a way to process this in chunks, by dividing the country in some grid, make the gridsquares slightly overlapping (say 50 meters) and then intersect only the houses and gaspipes in the squares. No need to check a pipe against houses in another city...How can I achieve this localized processing (using e.g. line on area overlayer) ? I tried clipper with a hand made "grid" that divides the country in 5 chunks, but I'm forced to process these slabs of land manually, by running the workbench 5 times and combine the output after running the jobs.

Hi FME community.I have a simple task to change Japanese field names in a shapefile to English field names. So I was using SchemaMapper to do this task. I created a simple csv file which has two columns, old_name and new_name. Then, I used this csv file in the ShemaMapper. I save the resulted layer as a shapefile. But the shapefile I crated had the exactly same field names as original one. All Japanese field names...I realized that when I inspect the output with the Inspector, I can see that SchemaMapper actually c

The featurereader is not giving the expected result when we use the spatial filter optionas you can see the polygon ( initiator) overlap with the shapefile, but as you can see the there is no output is there any setting we need to fixThanksresult

I'm trying to write a link in the Word-file, that I'm creating with MSWordStyler-transformers and the Microsoft Word writer.I'm using markdown, but it isn't written af a link - just as plain text.I'm writing this in the Text-field in the MSWordStyler with Content Type set to Paragraph:[Klik her:](http://www.ph.rm.dk/Omraader/sundhedsberedskab/arrangementer-begivenheder-og-events/)

Dear FME community.I've to generate a complex line with a points listing. Complew why ? Because the line is a composite of lines and curves. The information of the geometric type is in point's attributes like that :I only tried with the LineBuilder but I don't know how to do with the curves objects.Thank you for your help.

I want to redefine raster band values, based on another raster band value.More specific: If raster band 3 has a value "0", raster bands 0, 1 and 2 should have a value "nodata".How can this be done most efficiently?

How would I go about creating a curve where two lines intersect? I am basically just trying to smooth the intersection and create the red part.See picture below:

I have raw road geometry need to create network geometry need to refine and delete extra vertices and make smoother geometry to make can anyone help I have used generalizer but could not able to do so can anyone help me out?

Hye, I'm trying to create a 3D terrain model (export format : .obj/.fbx/.3ds or any other textured mesh format) from imagery raster (France, IGN) and elevation raster (France, IGN).Inputs formats are : 1. For imageryMultiple *.jp2 files with *.tab files associated (same file name) A sample of .tab file : !table!version 300!charset WindowsLatin1Definition TableFile "01-2015-0830-6540-LA93-5M00-E100.jp2"Type "RASTER"(830000.00,6540000.00) (0,0) Label "Pt 1",(840000.00,6540000.00) (2000,0) Label "Pt 2",(840000.00,6530000.00) (2000,2000) Label "Pt 3",(830000.00,6530000.00) (0,2000) Label "Pt 4"CoordSys Earth Projection 2003, 33, 7, 3, 46.5, 44, 49.00000000001, 700000, 6600000, -792421, 5278231, 3520778, 9741029Units "m"2. For elevationMultiple *.asc files with *.asc.aux.xml files associated (same file name) An extract of *.asc file :

I am trying to create depth zones (polygons) from a set of depth curves (polylines). I would like to create one polygon that covers the area between the 0m and 3m curves, one that covers the area between 3m and 6m, and so on. There are also shallows and deeps that need to be taken into consideration. What would be the best practise to do this? I have experimented with Testfilter » Areabuilder » Disolver » Clipper. But that quickly gets very convoluted... I am guessing that I could use one of the donut transformers to manage the shallows and deeps?

I'm using the following flow and getting two different results:The flow uses a cutting line and gives back the original (un)cut results. The polygon for this example is:POLYGON((145055.748 479705.959,145059.802 479704.301,145060.003 479704.791,145061.669 479704.11,145061.468 479703.619,145079.166 479696.383,145084.101 479708.452,145066.422 479715.682,145066.222 479715.191,145064.556 479715.872,145064.756 479716.363,145047.05 479723.604,145046.285 479721.734,145043.203 479722.994,145042.471 479721.338,145039.139 479722.701,145038.458 479721.035,145035.116 479722.401,145034.481 479720.846,145014.358 479729.074,145012.216 479723.836,145013.891 479723.15,145012.653 479720.124,145008.46 479721.838,145002.488 479719.333,144994.651 479700.17,144989.025 479702.474,144968.486 479652.247,144971.54 479650.998,145020.56 479630.952,145021.

When creating a label with the Labeller or LabelPointReplacer, a labelpoint is made at the asked position. However, the label itself is always placed on the right above position from the labelpoint.I need the label to be placed on the left above position from the labelpoint (thus having the point at the end of the labeltext instead of the beginning), in order to garentee a good label fit in the end result. How would this be possible?

The new DatetimeConverter works well for the gtfs stop times which are stored as only a time string field. But it rejects (naturally) any times greater or equal to 24:00:00. The gtfs convention is to roll over midnight for bus routes that do not finish before midnight. How might that be handled?I am trying to calculate the total time of a route using Arrival_Time - Departure_Time. I cannot just replace the 24 with 00 because I have to add up two intervals. I can see a clumsy three part conversion. There are 1.4M records so elegance and speed would be welcome.

Hi,Does anyone know how to get rid of/remove the KML warning when you add a overlay to the KML?KML: Raster feature has no fme_basename attribute; destination filename will be based on the feature idThanks!

I've got thousands of thin polygon and their centreline. And I can calculate average width of each by using polygon area divide centreline length. I want to generate some random width number based on the average width and the numbers are between max and min width of the polygon.My first thought is to create points along the centreline with small interval like 1 meter, and create station lines based on the points. Then use polygon to clip these station lines, the shortest and longest length of station lines will be the max and min range. So I can generate random width numbers in excel.I've already got the interval points by using @takashi 's LineDivider, and some articles about calculate line angle and create bearing line. I just want to know if there's an easier way to do so, and only in FME. To get my thought work, I have to switch between FME and ArcGIS, and also some third party add-on in ArcGIS. It is too complicated for others to use it.

Hi, Im trying to split a large dataset of lines (~1.2m records) by an almost equally large dataset of polygon boudaries (~900k records). I have tried Line Over Area Overlay, but no luck there. I tried creating points at the intersections of the lines and polygons boundaries, and executing point on line overlay, but I came up empty there as well. Has any one run into this problem before, and what conclusion/solution did you come to?

Hi,Is there any way of reading AutoCAD dynamic block names/visibility states? Currently all I can seem to get is the anonymous '*U___' value in the 'autocad_block_name' field.I feel like there should be a way of reading the real block name somewhere, as it picks up the correct block names in the reader parameters under 'Explode Selected Blocks'. Any help would be appreciated!Thanks.

Comment effectuer une boucle sur les éléments d'une liste pour pouvoir créer autant d'attributs que de valeurs de la liste ?How to loop the elements of a list to be able to create as many attributes as values of the list?

Anyone able to help me with this?com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host DEV-TFS, named instance TRAVEL failed. Error: "java.net.UnknownHostException: DEV-DB". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.Working on FME Desktop but when I published the workspace to FME cloud this error comes up. I believe I already enabled inbound UDP traffic to pass through on port 1434 shown below. Any idea what else am I missing?Thanks in advance.

Hi,I use the StatisticsCalculator and group features by attributes. The result features do not have a geometry anymore.I cant see see why this happens - anyone having a tipp?Rob

Hi there,I'm completely baffled about how the "Apply to: Cell" function works in the ExcelStyler transformer.The explanation of how this works (at least to my untrained eye) seems pretty confusing:"Specifies which cells will be styled. This option allows selection of attributes, which correspond to columns in Excel, to style for each incoming feature, which each correspond to a row in Excel. The result is that the intersection of the columns and the rows are the cells that will be styled. Note that this can only be set when applying formatting to cells." I don't want to involve any attributes into the equation, but instead just want to always style "C7" in a specific way, for example. Is there any way I can do this? I have several cells to style individually, but how to set up these attributes to represent the rows and columns (I guess?) is blurry to me. There will be no dynamic values or anything, "C7" will

Hi FME community.I am trying to color my 3D object based on its fme_color attribute but I don't know how to do it.Currently fme_color is set as cyan. So, if I can how this as 2D in the Inspector, it shows as cyan. However, if I switch to 3D, it becomes gray. I think this is a default color. I looked at the Front Appearance Reference and this setting is set as <inherited_or_default_appearance>.If I can set the Front Appearance Reference as same as fme_color, then this 3D object will be cyan color. I used AppearanceSetter to manually set the Front Appearance Reference but I don't know how to change it with transformers.If someone who knows how to do it, please share your knowledge.Thank you in advance.H

Hi,I am new to the appearance setter and while I having no trouble applying a colour using the appearancesetter, I am having trouble applying a texture. Can someone please me show me how?Attached is a FFS file with 9 roof geometries and 9 images, both having a _count attribute that references them to one another.Thanks is advance,Todd 

My goal is to identify the dominant color in a JPG. For instance, your JPG is mostly 'green'; that is, most of the JPG pixels fall somewhere in the 'green' hue. I've looked into using a Python script, but unfortunately my Python skills are limited so that option has been troublesome. I've also tried the 'RasterCellNeighborSummer', custom transformer but I don't get any output. I've attached a basic workspace that just feeds in a test JPG to the 'RasterCellNeighborSummer' transformer.