Transformers

May I know that how to export each vertex from a geometry?I tried to use Vertex Creator before, but the output is not one record for one point, but one record for all points.For example, there is a polygon with 4 vertex,The result I want to get like this:Pointxy1xxxxxxxxxxxx2xxxxxxxxxxxx3xxxxxxxxxxxx4xxxxxxxxxxxx but not like this:Polygonx1y1x2y2x3y3x4y41xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxIs there any function can help me solve this case?Thank you.

I am noticing that even if I set my workspace in Workbench to terminate on rejected features, it runs without error on FME Server. Is the rejected feature handling a workbench-only feature? I am expecting to see the same behavior on FME Server. I'm using 2017.1 in my testing. Thanks.

Hi.  I want to remove, or make transparent all areas where Band 0 and Band 1 are both 0. The rasterbandnodatasetter only looks at band 0 and sets those cells to nodata, which also removes information from the raster image. Is there a way to remove just the black areas (i.e. wher band 0 and 1 = 0)? I have tried to clip the image with a polygon but the black areas still remain. Is there a way to set the band values as attributes?  

Hi FME'ers, on the FeatureMerger, I get the rejection code 'EXTRA_REFERENCE_FEATURE. Does anyone know what this could mean?The problem occurs on a Supplier object, coming from AutoCAD Map3D, with OD objects. It merges with an Oracle table, using two attributes. When checking visually, the attributes should match, but it doesn't come that far because of the rejection.

I have a point file containing instructions along routes, lets call this the major decision points. Each collection of points belong to a route and has a route id. This data is all contained within one file, which can be made of points belong to numerous routes.I then have another file containing points for all junctions along the route, again this data has a route ID that is the same as the previous file for the given route. Lets call these the minor decision points and again this file is made up of points belonging to different route IDs.The problem is that I need to remove the minor decision points when they are duplicates for major decision points, however, these should only be removed if they belong to the same route ID. To complicate maters some of these routes will overlap.My initial idea was to create a loop transformer that processes features that belong to the same route ID, and then remove the duplicate minor decision points this way. However, I

Hey,I am working on table which include duplicates for address field. Earlier I had to define one record from the duplicate set and assign there value "keep" and for the rest of duplicated records I had to assign value "dup". In the end of the day, duplicated records need to be found in the repository with attribute Merged_Id which indicate ID of the "keep" record from the duplicated set. I would like to ask how to do it in the smartest way, considering conditions that if Merged_ID has missing value and address is duplicated in the certain group (left side of the pic), duplicated records 'dup' will have Merged_ID the same as "keep" record (right side of the pic).Thank you!

Hi, I've got more than 2000 DEM files and each DEM file has at least one adjacent DEM file, and they have a overlap area. I'd like to compare cell values of these overlap areas and locate those areas which don't match.I've already made this happen in ARCGIS model builder, but the process is very slow, I hope to improve the efficiency in FME by using parallel processing.Here's how I did in ARCGIS model builder:1.Create a raseter mosaic dataset in the GDB, then import all the DEM files into it and use it to minus every single DEM file by using iterator.2.Change output raster' 0 value into nodata from step 1 by using extract attribute tool which parameter is set as "VALUE >0 OR VALUE <0".3.Use IsNull tool to change nodata value into 1 and other value into 0.4.Convert rasters into polygons and export thoes values equal 0, then I got not match part.Can anybody tell how to do this in FME, which transf

Hello There we are reading Geodatabase and writing to PostGIS DB , the DGB reader is showing attribute width with 0 value and when we open it in ArcMap, the same attribute do have 50 value as a width, no idea why FME is not reading the value? arc Map view FME geoDB reader

Hi allI created a bounding box polygon and I want to use to clip and export raster imagery reading the imagery from my server Is it correct to use wms reader to read imagery and then ? clipper ? How can setup the resolution of my clipped output ?thxFrancesco

My organisation keeps its data in epsg:314685783, which is an extension of the GK4-epsg:31468 with the epsg:5783 altitude reference system ( https://epsg.io/5783 )How can I read such data from an oracle db and convert it to epsg:31468 for further storage in a postgis database.Currently my server job fails with "ORACLE Reader: No exceptions match for SRID `314685783' was found -- determining coordinate system using Well Known Text"

Hello FME'rsI have a problem that either I've been staring at for too long or maybe I'm just way off base on. Either way, I can't seem to get the desired output:I have (2) datasets: an oracle non-spatial table and a xlsx fileI am trying to add rows from my xlsx file to the db tableThere is no "ID" field in my xlsx file, so I would like the new rows from the xlsx to populate the "ID" field(s) where the existing table left off (max+1)I have tried to add the existing table as a reader --> run through a StatisticsCalculator to get "_max" --> through AttributeCreator for the new features, set "ID" to @Value(_max)+1 --> my result is "+1" on all of the "ID" fields instead of a sequential numbering.What step(s) am I missing?Thank you for your help!

Hi everybody,Why FME calculates different area in compare with Qgis.I have one area calculates in FME as: 46,56, but in Qgis the area is: 56,56.Thank´s

Hi there,I've been toying a lot with rasters lately, but I've hit a bit of a snag. I need to create a raster from shape files that has a resolution based on another step that takes place in my workbench. I'll explain:So first thing I have is a set of polyline geometries. In quite few steps (BoundingBoxAccumilator ->GeometryCoarcer ->Chopper ->LengthCalculator-> StatisticsCalculator) I know what the longest and shortest edge is of the bounding box of my geometry, by using the Minimum and Maximum based on the lengths calculated. Anyway, this is just to give some context, it is not the problem area. I did inspect this output and I do get for example Minimum:1000, Maximum 1500.I also have a FeatureReader separately attached to the BoundingBoxAccumilator mentioned above, which calls a WMS layer and outputs a raster based on the inside of the bounding box. Naturally this will also have a Rows/Columns of 1000x1500 as it uses the same bounding bo

We have a need to read some spatial data that is zipped up, but several of the zips are then nested inside another zip, just to make things fun. Like this:c:\\temp\\top.zip\\1.zip\\1.gmlc:\\temp\\top.zip\\2.zip\\2.gmlFME can read say GML from inside a Zip, but not GML from a Zip inside a Zip. Anyone got any magic to unpack the top level Zip? I suspect the answer is Python, perhaps as either a PythonCaller or Startup script and then I could use a FeatureReader to get at the data at the next level.Seems a bit contrived but its a genuine requirement as its the way a product is shipped. 1 zip file was clearly not enough!Thanks

Hi guys,We have a problem. We have a CAD file and we need the original color to be displayed automatically in ArcGIS. We are able to map the CAD color index to RGB values. Do you have an idea? Can you help us?

I don't know if it's reasonable the FeatureJoiner will assign the <null> to missing attributes with an outer join mode (Left or Full).

Hi,I am using CoordinateExtractor to get the start and end points of around 200k lines in a shapefile. This is working fine for around 90% of the lines, but for around 20k of them the coordinates are the same. I have inspected many of these lines and the start and end points are clearly in different places and there's nothing about them that would indicate why i'm getting a different result to all other lines in the shapefile.Any ideas?

Hello! I am getting errors while trying to delete records from using the Informix ODBC writers. I am putting the columns to match in the delete column row and getting an error that those columns do not exist:IBM Informix Spatial Writer: Error - No column named ltt_id found in table xxxxxA fatal error has occurred. Check the logfile above for detailsOr just that there was error:A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...and the only other thing written is a warning about assuming the geometry is 2D.Has anyone else had any trouble with this?

I've been trying to apply an image as a texture to a vertical wall (from CAD 3D solid to Geodatabase multipatch format). As a brief summary my current workflow is:1. de-aggregate CAD 3D solid and select vertical wall of interest to apply texture to2. swap coordinates Y<>Z so that the vertical wall has a top-down view3. use the AppearanceSetter transformer to apply a GeoTiff using the 'texture coordinate generation parameters' settings: 'Use Existing Texture Coordinates = Yes and 'Texture Mapping Type = Top Down Georeferenced'4. swap coordinates Y<>Z again so that the wall moves back to its vertical position5. write to an ESRI geodatabase as a multipatchThe result is that the geotiff is applied at the correct location as a texture BUT then areas of nothing (ie. area where the background colour can't be modified, but the multipatch is still there) are tiled alternately with the image across the rest of t

Hi everyone,In my organization we have some users of FME desktop and up till now I have done manual installations on every computer. But now I would like our technicians to deploy it automatically. But they are have trouble with the msi-file that can be downloaded on Customer downloads page. Is there an other msi-file that doesn´t hold 3 other msi-files or an exe-file somewhere for download? 2018 and 64-bit version is the one I´m looking for.Thanks in advanceJenny

Hello,I'm using the PointOnPoint Overlayer to find if any points overlap. When I use the transformer and let the workbench run, I get an attribute value of _overlap: 72, for each individual point. None of the points overlap (see attached picture). I thought I would get an overlap value of 1 because the points do not overlap. Is there a reason why each point is getting an overlap of 72?*the total number of points in the file is 72*Thanks! David

Hello allIm trying to Drape 2D FME points, (Which are centre points of trees extracted from LAS data) and trying to drape these points on a Surface model. At the moments all the points are level under by surface. I cant seem to be able to drapeI have tried using the SurfaceDrapper but my points stay the same level. Any ideasThanks in advance

Hello AllIm hoping someone can help me with a particular problem i am having trying to edit a Tin Suface.I have created some FBX files of ground surfaces using point cloud data. Easy However i now want to feed FME a DGN or DWG that contains outlines shapes, that i can use to cut holes in my FBX TinSurface. I feel i have tried everything :( I have tried also to remove the points from the point cloud and remake the mesh, with added holes, but the surface modeller joins the holes back up. eeerrrr!Any help would be much appricated

Can fme creat a hemisphere like this below? Thanks a lot.

Does FME support reading/writing Navigation Data Standard?