Transformers

Hi,sorry for this, I have a strong feeling this is for the beginners level but I can't figure it out after 2 hours of trying so maybe someone can show me the right way (I'm also a FME beginner who did only a few workbenches till now).I need to update an xml file in a way to delete elements based on some condition. For example in this xml file:<?xml version="1.0" encoding="UTF-8"?><bookstore>   <book category="cooking">           <title lang="en">Everyday Italian</title>           <author>Giada De Laurentiis</author>           <year>2005</year>           <price>30.00</price>   </book>   <book category="children">           <title lang="en">Harry Potter</title>           <author>J K. Rowling</author>           <year>2005</year>           <price>29.99</price>   </book>   <book category="web">           <title lang="en">Learning XML</title>  

Hello,I have a list of countries in csv format e.g.: ALBANIA, AUSTRALIA, COLOMBIA, CHILE, NORWAY etc. and I have some records I'm reading from a database. I would like to find out if the description part of these records contains one of these countries from the csv. A description could be : CHINESE NOTICE 14/261; JAPANESE NOTICE 28; GERMAN NOTICE 23; COLOMBIAN NOTICE 172; SWEDISH NOTICE 593; GREEK CHART 311; AUSTRALIAN NOTICE 993. So the country name is not necessarily complete (Chinese, Swedish) or the description is longer than the country name (Japanese, Australian). Any tips what transformer to use? Thanks!

Good morning,I am trying to georeference a few CAD files by using FME. I have a script that can be used in AutoCAD to achieve this (), but I would rather have everything completed within FME. It is working for some but not all, I'm not sure what I am missing. Any assistance would be great!Thank you!David Prosack

Using FME 2018.1 (build 18528 x64)I'm noticing that two seemingly identical features are showing as updated when comparing them using Update Detector.   The geometry is what is being detected as a difference, even when using lenient geometry matching. Any ideas why? - unzips to ffs file type, ffs attachments apparently aren't allowed using the file uploaderThanks in advance!

HiI am trying to use the InlineQuerier for the first time. I am using it instead of FeatureMerger because I want to do a join using a Like statement with wildcards which is not possible with FeatureMerger.However I can't work out why my query is not running. I have done the same query within Oracle SQL Developer and it worked, but it is not working in InlineQuerier.The query I've tried is below but I get a "Format and Dataset Unspecified" error when I try to run it.SELECT b."POSTCODE",a."POSTCODE_AREA" FROM "OS_POSTCODE_UNITS" b INNER JOIN "TABLE1" a ON REPLACE (b."POSTCODE", ' ', '') LIKE CONCAT(REPLACE (a."POSTCODE_AREA", ' ', ''), '%');Screenshot is also included.I believe I have not set up the InlineQuerier properly in terms of the Input and Outputs, but I am struggling to understand what I am supposed to put here. Does anyone have a step-by-step example of how t

I have polylines and polygons as separate source data. A polyline that has an end in a polygon must be clipped with a polygon, leaving only part outside the polygon. At the same time, the lines thats intersects the polygons must remain unchanged.

HiI have just downloaded FME disktop tro convert TAB files to KLM, but when opening TAB files containing arabic text, all arabic text get normalized to _____ ____...it seems an encoding problem, how can I resolve it?Mohammad Issamohissa@Umniah.com

Is there a way to aggregate based on a condition? I have a set of polygons that I want to aggregate based on the distance. That has worked with the workaround @takashi has posted numerous times (with the buffer, en the count etc). But now I end up with aggregates that have a larger summed attribute value than I would like. Is there a way to add conditions to the aggregating proces? As in, form an aggregate based on distance, but if the summed attribute value exceeds a certain amount, further separate the aggregates.

I would like to compare the geometry of two file geodatabase feature classes to locate spatial differences that I know exist based on the number of records of each and visual comparison (see highlighted linework). Is this something I can do using FME? I've tried using the both the ChangeDetector and Matcher transformers, however, neither of the results produce an output that specifically locates the differences. I'm only interested in 2D geometry changes and have not identified any attributes to match. I've also tried this FME model using other fc's that have a difference of 1 record but also get outputs that include many records, making it difficult to actually locate the issue.

How do you remove a colinear point from a polygon when it is the first/last vertex?  When using the generalizer (Douglas) the wrong point is removed.  See attached workspace for an example of two similar polygons. The one where the colinear point is not the first/last vertex works as expected.  The one where the first/last point is colinear, keeps that point and removes an important vertex. 

I have a dataset of around 85k road segments and 130k non-road segments where I want to cut off small parts of the roads around the non-road segments: There's a buffer around each of the non-road segments that I use as clipper on the roads.I've applied all the tips given in this thread ( https://knowledge.safe.com/questions/62461/why-the-clipper-transformer-is-too-slow.html ). I forced the clipper to wait until all clippers were available, I dissolved both datasets before clipping and it works fine on smaller datasets. Still, it takes around 2 seconds per feature in the dissolved dataset (total 12k). I've even discarded all attributes.Algorithmically, clipping polygons should take nowhere near as long when everything fits in memory. [M. de Berg et al. Computational Geometry. Ch2 ]Is there anything I've missed? Why is clipping so slow?

Hello! I am currently starting working on gbXML to CityGML conversion, using FME. I know that gbXML is not supported right now, so I am trying to use xml reader. Maybe someone has already tried this conversion, or has some ideas/hints on what could be useful for me. Any help would be appreciated.

Can a revit model and a primavera schedule be integrated into GIS?

I am reading features from an Excel sheet and writing those features into a table in a File Geodatabase.I have noticed that string attributes without values in the Excel sheet are written as empty strings in the File Geodatabase instead of being Null.Is there a way to write those as Null instead?

Hi all,In autocad, I have a file containing information I would like to merge.Using the picture below will help to figure out the situation :I have a block and texts. I want to add the text string "(1.00) Z=190.98" to a new attribute of my block.Offsets between text insertion's point and block insertion's point are always the same offset x= 0.14 offset y = -1.25.Then the next step is to compute the value. Ideally, the attribute must have the calculated value 191.26-1.40= 189.86. Any ideas ?Thanks Arka

I am trying to read the results for a SQLExecutor. The transformer does not have the possibility to expose schema features. And I would need it (rather than reading the table from the DB with a FeatureReader)following the advice from the answers for this question:I am using Python to read the feature name and types and create a schema feature with the formatattribute{n}.fme_data_typeattribute{n}.nameimport fmeimport fmeobjects# Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer parameterdef processFeature(feature):    feature_attr_names = feature.getAllAttributeNames()    i = 0    for feature_attr_name in feature_attr_names:        feature.setAttribute('attribute{0}.fme_data_type'.format(i), feature.getAttributeType(feature_attr_name))        feature.setAttribute('attribute{0}.name'.format(i), feature_attr_name)        i+=1    passWhen it comes to expose the attributes I create FME d

I have scaled a point cloud, and then rounded the values. So for example the points(2555, 1467, 8695) and (2599, 1401, 8622) became (25.55, 14.67, 86.95) and (25.99, 14.01, 86.22)after rounding they both become the same point (25.0, 14.0, 86.0)This means I now have duplicate information, and it's making my .LAS file needlessly large. Is there a way I can coalecse these points into a smaller point cloud output?

Hi,I have this proj4 config that I had converted to FME custom coordinate system. However, when I run a reprojection transformer on it, it gives me an error.Below are the details. Can anyone shed some light on this error?Thank you!Proj4 config:  +proj=tmerc +lat_0=0 +lon_0=120.95 +k=0.9999 +x_0=446904.02 +y_0=2879827.84 +ellps=GRS80 +units=m +no_defs FME custom local coordinate:COORDINATE_SYSTEM_DEF ER94 \\   PROJ TM \\   UNIT METER \\   DT_NAME ER94 \\   DESC_NM "ER94" \\   GROUP ASIA \\   SOURCE "ER94" \\   ORG_LAT 0 \\   PARM1 120.95 \\   SCL_RED 0.9999 \\   X_OFF 446904.02 \\   Y_OFF 2879827.84 FME ERROR when trying to reproject:Datum definition ER94 does not exist.Storing feature(s) to FME feature store file `.\\mapping_log.f

Is there a way to set the permissions on particular dashboards in fme server. I created a custom dashboard and can see it in dashboards area and have given permission for user to see but I only want user to see that particular dashboard, not all of the dashboards available.

Can anyone help me to convert my autocad file to geotiff?Please.Thank you

Are there video tutorials on the FME AR transformer?

I have multiple layers of client regional data from which I would like to extract data for a specified study area which will be defined using a polygon in mapinfo tab format. I have tried to use an AreaOnAreaOverlayer to capture the data within the boundary however I am struggling to make this work. Any suggestions?

Hi,I have a FME workspace which is intended to converting data from any format/schema into a defined standard personal gdb format which we have defined internally. I would like to create a published parameter exposing attributes of the source dataset (eventually picked upfront by the user in a separate published parameter) and allowing the user to choose the appropriate attribute which needs to be used by the workspace (example: "Pick street name field"). Schemas and attribute names are not known in advance and I would prefer avoiding using the SchemaMapper plus asking users to update a separate schema file upfront every time new source material needs to be processed. Does FME provide a solution for fetching attribute names at runtime (a published parameter could probably call another FME worskpace or script retrieving those names and returning them into a drop-down in the prompt window)?Thank you for your suggestions!Olivier

I need to read an Adobe FrameMaker file to extract data and export to other formats. Please let me know if there are any readers, as I did not find the current FME list

I have a problem with parsing JSON which is the result of an HTTP call to get what I need. (See json files attached.)If I download the .json file and simply put it in a JSON reader with a query,filter for type:"Update Feature Attributes" and explode some of the lists, it gives me what I need:My problem is that I have loads of transactions to go through the same way, so I'd need to use an HTTPCaller. I've managed to get that far that with a JSONExtractor I can get "type", "ID" for example, but struggling to break down lists "attributesAfterChange" and "changedAttributesNames" - ListExploder doesn't recognise them as lists for some reason. Any ideas what should I do to get the list values/break down the arrays? Maybe it's very simple but I just cannot find a solution right now. NB: the attributes in these lists vary and not exclusive to what's in the attached json files, so somewhat making it a bit more complex...Any h