Transformers

I have calculated approx. 3000 possible routes with the ShortestPathFinder over a network. Most of the routes are overlapping each other. At some networksections more then 50 routes are overlapped. I will split op the sections and fill the _overlap attribute with the amount of overlapping routes and I use the LineOnLineOverlayer for that. But the LineOnLineOverlayer performs very slow in this case. Does anyone knows how I can increase the speed? Regards, Steven Loosman

Hello There the workspace work with no error on the FME desktop but when published on the FME server I am getting this error (The clause 'JSON_DOCUMENT @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>text_line_data<closeparen>,JSONValidator) READ_FROM_FILE NO FILEPATH_OR_URL <Unused>' within 'FACTORY_DEF * JSONFormatterFactory FACTORY_NAME JSONValidator INPUT FEATURE_TYPE UUIDGenerator_OUTPUT JSON_DOCUMENT @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>text_line_data<closeparen>,JSONValidator) READ_FROM_FILE NO FILEPATH_OR_URL <Unused> FORMAT NONE SYNTAX_ERROR_LIST_ATTR _json_error OUTPUT OUTPUT FEATURE_TYPE JSONValidator_PASSED OUTPUT INVALID FEATURE_TYPE JSONValidator_FAILED' is incorrect. The parameter to JSON_DOCUMENT must be a constant value, a value-of (&) attribute, or an FME function call) Any idea please ?? this is the Json transformaer section of the WS

Hello everyone, I'm using FME Desktop 2017.1 to read from a CosmosDB colleciton. This works fine for single-partition collections, but with partitioned collections FME raises an error telling me that the "x-ms-documentdb-query-enablecrosspartition" needs to be set. Has anyone experienced this and found a workaround, or am I missing a setting somewhere? The alternative would be to use the CosmosDB REST API, but that would be quite a bit of effort so isn't really an option at the moment. Thanks, Jan

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> <author>Erik T. Ray</author> <year>2003</year> <price>39.95</price> </book></bookstore> I want to delete all book elements with the year 2005. So the resulting xml should look like this: <?xml version="1.0" encoding="UTF-8"?><bookstore> <book categ

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 uploader Thanks in advance!

Hi I 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 to use this transformer? Regards,

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.

Hi I 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 Issa mohissa@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 format attribute{n}.fme_data_type attribute{n}.name import 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 pass When it comes to expose the attributes I create FME does not seem to be able to

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.ffs' +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Feature Type: `' Attribute(string): `CS_NAME' has value `ER94' Attribute(string): `DESC_NM' has value `ER94' Attribute(string): `DT_NAME' has value `ER94' Attribute(string): `GROUP' has value `ASIA

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?