Transformers

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 thi

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:

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) t

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 t

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

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 h

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!

Hi,My Workspace two Source : 1 feature of line and a Excel file with 3 features.The goal is bring the attributes of the XLS into a line.How can you see in my Template file, i used the FeatureMerger and after ListExploder. I have 3 lines but i need just one with all attributes.Attached my Workspace.Thanks, Danilo

Hello, I have a sequence of points along a line. I have to detect change in an attribute (called "framing") of a point from its previous point. The points are sequential. Sequences are stored as an attribute too "sequence". I imagine I can use an AttributeCreator to create a new attribute called "change" and make the value conditional. Problem is, I am not good at RegEx or conditional statements to know what would be useful. I need to compare the "framing" attribute with only the previous point within the sequence. Not the one ahead. I have been trying to follow the example in the thread below but no luck. https://knowledge.safe.com/questions/33705/compare-attributes-from-two-features.html Eg, if there is a way to compute something along these lines: IF point.framing = point

I'm trying to create an attribute ("incorporated") whose value is 0 or 1, depending on the value of another attribute ("Code"). I'm trying to do this in Attribute Manager. But I can't seem to get it to evaluate. I've tried many different permutations of the expression. The attempt shown in the attachment uses Python syntax highlighting which I would assume means it would be interpreted as Python code. Anyway, it doesn't work, as you can see in the breakpoint data.