Transformers

Hi,I am trying to calculate the width from a polygon at point feature locations (see figure). I was thinking about creating perperdicular linen at the point feature locations (perpendicular to polygon). Clipping the perpendicular lines (using the polygon as clipper) and calculating the length of the perpendicular lines. Is there an easier way to do this?Kind regardsMichael

Hi all,I have a polygon layer representing the sealed area of our road network with numerous attributes about the road. I also have a road centreline layer which has no attribute information. I want to get the road polygon attributes applied the appropriate centreline. The obvious transformer is the LineOnAreaOverlayer, however, this creates a lot of 'stub' centrelines that get associated with an intersecting road (please see image for an example). In the example, a small section of Road 2 is given the attributes of Road 1.So far the methodology that I have come up with is to:1. assign a unique identifier to each centreline2. process through the LineOnAreaOverlayer3. determine the lengths of each segment 4. combine segments based on unique identifier 5. use the attributes of segment with the greatest length for the attributes of the centrelineIts not ideal as there is potential for error, so I would be keen to see if anyone else could come up with a better methodology.Thanks as

Is it possible to use the MSWordGenerator transformer to out .docx via FME Cloud?

Hi all.I Need some help. I have two ESRI shapes, the yellow one and a pink one.Both have a column named ID with the values shown below. The red label is for the pink areas and the black label belongs to the yellow areas.The yellow areas can completly be overlapped by each other. (area 800 is under area 700)I want all to be "clipped" and joined between the pink and the yellow based on the ID column. I need the result as shown in the second image, the blue hatched resulting areas in a shape file.Any ideas?

I am running into something while trying to read a DWG file and handle the data based on layers. I set up the reader with 'Group Entities By Layer Name' and most layers are being sent to my writer as Feature Types, with one exception: There is one Feature Type that seems to contain data from several layers, as in this example:The Feature Type is A208, while the autocad_layer is A234. Both A208 and A234 are available as Feature Types from the reader, but the A234 reader contains no data. The data on layer A234 (and other layers) can be exported from A208. I found a workaround on this by exposing autocad_layer in A208 and take it from there, but in a different setting I may have missed it. Is there something special with these layers that make them come "grouped" up like this, and how can I determine if my DWG files have things like this? I'm a GIS person, not a CAD person, and Autocad is a bit alien to me...

I keep getting an error trying to write to a specific table, getting an ESRI gdb error message (http://support.esri.com/en/technical-article/000004275).It claims that the table name has a leading underscore.I placed a StringReplacer (Image 1)I keep getting the same error listed in the ESRI blog above????Geodatabase Error (-2147467259): General function failure.Could not open File Geodatabase table `Delta_Block_Polygon'A fatal error has occurred. Check the logfile above for detailsAny suggestions appreciated

I have a TestFilter query that works on most dwg layer names but not on a number of layer names.There are approx 70 Dwg files with approx 300 feature names, most work but one (Tree) does not??I tried two queries Else IF @Value(fme_feature_type) IN AF_Tree,G902TREELINE,G902DTREE3,G903TREE_DECIDUOUS,00__TOPO__TREE__LINES,00__TOPO__TREE_CONIFEROUS_SPREAD_SYMBOLANDElse IF @Value(fme_feature_type) = AF_TreeElse IF @Value(fme_feature_type) IN G902TREELINE,G902DTREE3,G903TREE_DECIDUOUSElse IF @Value(fme_feature_type) IN 00__TOPO__TREE__LINES,00__TOPO__TREE_CONIFEROUS_SPREAD_SYMBOLI keep getting G902DTREE3 rejected into the Unfiltered layer?? Any recommendations would be appreciated.

Good morning!I have a process that needs to get the definition for several CRS. To do that, it uses a HTTPRequest:http://www.opengis.net/def/crs/EPSG/0/4258http://www.opengis.net/def/crs/EPSG/0/3042From the response I get, I have to take only the first <gml:name> element:<gml:name>ETRS89</gml:name><gml:name>ETRS89 / UTM zone 30N (N-E)</gml:name>I wanted to use XQuery, but it requires the declaration of the namespace. The problem is that every CRS definiton has different namespaces:<gml:GeodeticCRS xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:epsg="urn:x-ogp:spec:schema-xsd:EPSG:1.0:dataset" xmlns:gml="http://www.opengis.net/gml/3.2" xmlns:rim="urn:oasis:names:tc:ebxml-regrep:xsd:rim:3.0" gml:id="ogp-crs-4258" xmlns:gco="http://www.isotc211.org/2005/gco" xmlns:gmd="http://www.isotc211.org/2005/gmd"><gml:ProjectedCRS xmlns:epsg="urn:x-ogp:spec:schema-xsd:EPSG:1.0:dataset" xmlns:gml="http://www.opengis.net/gml/3.2" xmlns:rim="urn:oasis:names:tc:e

Hello,I implemented a workflow that read a shp file, does some basic elaboration and writes the result in an Oracle table.I call the input file using a variable.Now, if I modify the input (more record but with the same structure), I receive this message in a window in FME Desktop:"Unexpected Input: During translation, some feature were read that did not match a reader feature type in the workspace. This can happen if the reader dataset if changed, or a reader feature type removed or renamed."If I execute the same workflow in FME Server, I don't receive any error message, but zero feature are written in oracle.Any idea about this strange behaviour? What can I do to better investigate?Thanks.

Quick Questions. I have a Writer that is writing to a Google Fusion Table. I know that it is creating a table with the "Table Name" that I give it and a new Table Id that is created behind the scenes.1) First Question: Is there some way in FME to get that Table Id? For any follow up operations (reading, etc) you have to use the Table Id and not the Table Name. I know that FME is using the Table Id. I can see it in the INSERT INTO statements that it is using... (I replaced the Table Id with Xs.)Google Fusion Tables: HTML SQL Request: 'POSTFIELDS=sql=INSERT INTO XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ('geom', ...Seems like the Table Id would be a nice thing coming out of a FeatureWriter... But maybe there is a way to get it today? 2) Second Question: Fusion table requests seem to fail pretty frequently. Is there any way to turn on retry logic so that on fatal errors (that haven't added data) the API request can be retried?Thanks!

I have a spreadsheet with a list of company names, and an RSS with a text field that may contain one or more of the company names (along with other text). How can I use FME to search the RSS text field and match it to my company names? So far I have tried the InlineQuerier with an SQL JOIN and LIKE statement, but I'm not getting as many matches as I expect and only one company name matching when there may be >1. I want my output to contain a field that lists all the company names found in the RSS text field. Any suggestions or alternative workflows would be greatly appreciated!

Hi,I'm trying to drape a selection of map tiles in GeoTIFF onto a Triangle or TINSurface with the AppearanceSetter. After trying using the TINGenerator > Clipper > AppearanceSetter I followed a few tutorials and help articles (e.g. https://gis.stackexchange.com/questions/130870/help-with-draping-an-image-over-a-tin-in-fme-for-viewing-in-meshlab-or-similar ).The closest result (see image) was by passing SurfaceModeller > Clipper > FaceReplacer > AppearanceSetter but the output terrain had a single map tile repeated across the whole surface.To address that tried ensuring that the tiles and terrain aligned perfectly by introducing BoundaryReplacer earlier in my process and then passing that to SurfaceModeller > Face Replacer > AppearanceSetter. My tiles are still being rejected by the AppearanceSetter.Any suggestions would be appreciated.

My DB contains line (say street network) and points (say Bus Stops), the points has to be placed on the vertex of the lines.Would like to find out all those points which is not placed on the vertex of the snapped line.

I 'am reading a Json file that contains a timestamp. I need to convert this to a date so that I can aggregate other data on Year, Month.I've tried using an attributemananger (@value/86400)+25569+(-5/24) and DatConverter to convert the timestamp but this didn't gave me any results.Therefore my question how to do this?

In a JSONTemplater I am using fme:get-attribute to insert the value of an attribute created in the workspace with an AttributeCreator.  The attribute is a represents a status code, so it should be interpreted as an integer, however the JSONTemplater always interprets it as a string, despite all my attempts at forcing it to integer.  Using @int(fme:get-attribute("_statuscode")) results in a TCL error (apparently the @int function is being evaluated before the fme:get-attribute function).  Also tried using an ExpressionEvaluator with @int(1.0) but this is still interpreted as a string.  Any ideas? Thanks!

While working with customers and sensitive data, we on the Safe Software Support Team often run into road blocks troubleshooting issues when FME Workspaces and source data cannot be shared (nor can an NDA be arranged in a timely manner – and for this argument, neither can a screen share be arranged).There is an excellent Knowledge Center article that takes a real world example, and provides a tutorial with many actions the user can take to anonymize sensitive data.Particularly the following techniques are used:- Removing Attributes (AttributeRemover, AttributeManager) - Renaming Attributes (AttributeRenamer, AttributeManager) - Replacing Attribute Values (AttributeManager, StringReplacer) - Geographic Manipulation (CenterPointReplacer, Offsetter) What actions do you take, or what do you think is missing from this list? Are there any custom transformers that could help? And is it possible that a custom transformer could be created to aid in automation of this practice?Looking forward to

Hi! I have one problem with coordinates of my objects. For example, I created a simple cube in Revit and exported to IFC file. After that I opened file in FME Data Inspector and I have 24 vertices or coordinates instead of 8 which I think I should have. So they are tripled. Therefore, when I calculate volume it is three times bigger. On the other hand, area calculator works fine. Is there any possibility to remove coordinates and leave only one for each vertex or maybe something else is a problem?

I have a fme_surface and I need to clip it. As long as it is not possible to clip a fme_surface, I have tried to extract triangles from that feature and then clip them. Is it possible to extract triangles from a fme_surface without using the SurfaceModeller?

I have a very simple workspace which is basically 3 steps: readers, UpdateDetector, writers. It is intended to compare changes between two ArcGIS feature classes, which represent data from different years.The UpdateDetector has 4 output ports: updated, inserted, unchanged, deleted. The outputs from the unchanged and added ports seem to be more or less what I'd expect. However, the outputs from the inserted and deleted ports are not being written out to the final feature class - although the post-run numbers show that features were routed through these ports. When I preview the output in the DataInpspector, all the features from all 4 output ports are there. I thought I may be able to workaround the non-writing by doing a 'Save As' on the data in the DataInpspector, but when I try this I get a 'fatal error' with the following message: "In order to update/delete a feature in the table/feature class 'Inspector_UPDATE_area', the FME feature must have the

Greetings,I am trying to export ellipse features to an ESRI file gdb.1)Do they need any processing by a transformer first??2)Should they be exported as a line or polygon??Any suggestions appreciated.

Why does this not work?SSIS Errors (Since @DateTimeFormat(@Value(init_start_time),'%b/%e/%Y') at @DateTimeFormat(@Value(init_start_time),'%T'))

Hi Everybody,I am using FME 2016.1.3.1In date time format I used* Source Date Format = "Unknown - Automatic Detection"* Destination Date Format = "FME Date/Time (%Y%m%d%H%M%S)"Then if the input is "2017-09-13T16:30:01" it will output "20170913173001".Attached is the FME workspace I used for testing. Did I do anything wrong? I don't want to have the hour shifted.Thank you!