Transformers

I use the HTML Extractor in a number of workbenches: it is a very useful transformer. There was a minor glitch in FME 2017 when this was introduced, as it did not handle lists in the customary way: when a list attribute was selected as the required output, I had to use "list{}" as the list attribute name instead of "list". (This did not seem worth raising at the time)  This appears to have been fixed now in FME 2018 but requires modification to transformers created in FME 2017 to reverse the above workaround, otherwise the attribute title is taken as "}" once the list has been exploded or otherwise accessed.  Are there any further details on this issue, or can I assume it has been resolved between 2017 and 2018?

How can I change the email address associated with my Knowledge Centre account?

Has anyone found a transformer or process to convert survey metes and bounds to a geospatial file type (CAD/GIS/KML, etc.)?

Hello,I am trying to use the In operator in the Tester on a comma separated list of strings.In ArcMAP Select by Attributes, I would do this:SELECT * FROM <tablename> WHERE:<attribute name> in ('00002','00003', etc...)When I try this syntax with the Tester, I am getting this error:2018-05-07 16:23:01| 12.7| 0.0|ERROR |Tester(TestFactory): An error was encountered evaluating a TestFactory test: Illegal operator `IN' supplied for test evaluation -- operator must be one of < > <= >= != = ==2018-05-07 16:23:01| 12.7| 0.0|ERROR |An error was encountered evaluating a TestFactory test: Illegal operator `IN' supplied for test evaluation -- operator must be one of < > <= >= != = ==I know that I can limit the values returned by using SQL in the reader, but this method would be preferred.I have tried/tested changing the mode, removing the ( brackets, putti

Dear FME community,  I have a road dataset with lines that looks like this:VNKNNKVSTBSTLEN102010402005001000102010406008001000 The columns VNK/NNK are just identifiers for the road segment, the columns VST/BST are the measures (in metres) and the in column LEN is the value for the absolute length of one road.  The above table means, that one road segment 1020-1040 is divided into the segment from 200m - 500m (with a value for XYZ), and then from 600m -800m (with a different value for XYZ). The complete road goes from 0-1000 metres.  Problem: I need to fill the "invervalls" with Zero-Values. If the road has the length 1000 metres, then there are no values from 0-200, from 500-600 and from 800-1000. I can calculate the missing values from start (0-200) and the end (800-1000), but how do I get the interim value (500-600)? The could be many intervalls :-)  Goal: The target table should look like this (th

FME 207.1.1.1 (17652) on Windows Server 2012 R2 DataCenter.I'm using PointOnAreaOverlayer to add point attributes to polygons which contain the points. It works for 721 out of 754 points, but the other 33 don't get assigned to a polygon. Some of these points are not in a polygon, but others, including the examples shown below are definitely inside a polygon. I have tried de-aggregating the polygon layer first and have also used the GeometryValidator - all tests except the 2 OGC ones - all features pass.Any suggestions apart from trying FME 2018.0?The second example below is actually one polygon. The Deaggregator appears to merge this into a single polygon with the wiggly internal boundary removed. Either way, I would still expect the polygon to pick up the point attributes.

I am writing my first FME transformer using Java Plugin SDK. I am following the CenterOfMassCalculator sample. I have a problem understanding the .fmx file structure though. When I run my transformation in FME Desktop it fails. Specifically, it complains about the arguments of '@JavaCenter' which I copied and pasted from the CenterOfMassCalculator.fmx sample, as I didn't know the purpose of the following code: FACTORY_DEF * TeeFactory   FACTORY_NAME $(XFORMER_NAME)   $(INPUT_LINES)   OUTPUT FEATURE_TYPE $(OUTPUT_OUTPUT_FTYPE)      @JavaCenter($(X_ATTR),$(Y_ATTR),$(Z_ATTR))      $(OUTPUT_OUTPUT_FUNCS)Can anyone suggest some reference on this? The FMEPluginSDK_Java.pdf does not cover this well.

Hi Fmeirs,My fmw working good in 2016 fme desktop. now i installed fme 2017. when i run my fme script it says python error cx_oracle not found. I used python inside my fmw. i am connecting to oracle using python program inside and updating oracle table.how can i move forward?please help

I am having trouble extracting all the information from a JSON. I have a JSON (see attached) with multiple addresses on the same level. When I use the JSON Flattener or the JSON fragmenter I only get the first address.The JSON in the attachment contains for example a JSONFeature addresses with the subfeature type which can be "vestigingsadres" or "correspondentieadres".This is just an example, same JSON I work with contain multiple addresses. And on forehand I do not know how many. How can I extract this information?

I am trying to replace point features (shapefile format) with 3D objects (sketchup, collada, etc.)I thought geometry replacer will carry out the task. But, I am not able to do thisPls help. Thanks in advance

Hello, I have a .SHP with lines and I need to extract X, Y coordinates as points for start and end nodes of lines and give them an ID. I could have a polyline containing several lines connected, in that case end node of first line is the same point as start point of next line. I tried with CoordinateExtractor, CoordinateConcentenator, AttributeKeeper but had no luck. Is there any solution for my problem?

Hello, I am currently working with gbXML file in FME. I am trying to display the points, out of the coordinates that I have. In the column Coordinate_xml_id last character refers to axis. 1-x, 2-y, 3-z. What I would like to do is to create separate columns for x, y, z Coordinates - so having all the x coordinates with Coordinate_xml_id with 1 at the end in one column, all the coordinates with coordinate_xml_id with 2 at the end in another column, etc. Any help would be much appreciated!

Hi there. I am a FME beginner and have a simple question regarding constructing a SQL statement.My goal is to use FeatureMerger to merge CSV table data with polygons. But this process is going to be a dynamic process, I want to create a flexible workspace. For example, I want to use different CSV input files but the rest of the process stay same.Here is my question. I want to use one of output value from a transformer in my SQL statement. How I can do that? I described my workflow below.1. There are a CSV file that has a join key field (in the image below it is called "area") and polygon data (join key name in this polygon is called key_code in the image below). This CSV data include lots of duplicated join key values.2. In order to use FeatureMarger between the CSV data and the polygon layer, I wanted to get a unique join key values from the CSV table. I used DuplicateFilter and Aggregator to get a comma separated join key values to use in a SQ

Is it possible to take a binary string in memory and use it in a transformer to tell it to treat it as a zip file? I know I can use a FeatureWriter (format set to data file) to write the binary string to disk then use a FeatureReader to read it back into memory. I was trying to skip the step of writing it to disk. Any help would be great!

Hi,I'm reading a bunch of data from a log database, transforming it and storing it somewhere else. I leave the unique ID attribute of the log message alone. So I want to make it so my workbench only reads the logging rows I haven't processed yet. The ID numbers are ascending so my idea was to check the destination database using SQL to get the highest ID stored in there, and only read/filter from the source based on that. Now: How do I do this? I can get the current highest ID processing using the SQLCreator, but how do i read/filter based on that?Thanks!

I use the Aggregator to merge polygons based on one attribute. When the output is Shapefile, multipolygons are created and all works fine.When the output is OGC Geopackage or Spatialite, FME creates a GeometryCollection instead of multipolygons (and I can't use GeometryCollection with others GIS softwares).I want to force multipolygons instead of GeometryCollection. When I use GeometryCoercer, nothing is coerced.Thanks a lot for your help :-)

I have a very simple server workspace copying a table from one database to another using the dynamic workflow:This workspace is uploaded on the server and gets triggered from a job submitting workspace in FME desktop:which should signal success or failure through messages.Strange enough, when I submit a non existing table to be copied, the submitter signals success, while the server log shows:Error executing SQL command ('select * from "gsm"."odt99" where false limit 0'): 'ERROR: relation "gsm.odt99" does not exist What is wrong here?Or, more precisely, how can I get such an error reported back to the job submitter?

HiI have a polygon with name A and some points around with names A, B , C, DI would like to calculate the distance between the centerpoint of polygon and the point with the same name of polygon (distance polygon A point A)ThxFrancesco

I am running a simple workspace in 2017 and 2016.1. Read Shapefile, bounding box accumulator and feature reader, with spatial filter on WMS.The process works fine in 2017, but in 2016 with the exact parameters, transformers and variables will not clip the full extent,simply when the envelope is applied the URL request is something along the lines of BBOX=xmin,ymin, xmax, ymax,2017 works fine the the variables are correct in the request URL, however in 2016, the bounding box coordinates in URL are that of the WMS. Again everything is identical between the two workbenches except for the result.

I have the following datetime format built from python datetime like bellow.datetime.datetime.today()2018-04-29 12:20:36.975031Im reading a csv dataset and trying to load it to an elasticsearch writer setting the writer field with the pythondate to a datatype 'date' but it always fail with following error 2018-04-30 16:35:25|   2.0|  0.0|ERROR |ELASTICSEARCH writer: {"took":0,"errors":true,"items":[{"index":{"_index":"imob","_type":"imov","_id":"pzIxF2MB3029rqSru8Tt","status":400,"error":{"type":"mapper_parsing_exception","reason":"failed to parse [date]","caused_by":{"type":"illegal_field_value_exception","reason":"Cannot parse \"0000/00/00 00:00:00.000\": Value 0 for monthOfYear must be in the range [1,12]"}}}}]} Seems odd cause the date beeing sent is beeing checked with a logger just before the ES writer and the  value is 2018-04-30 16:40:42|   1.7|  0.0|INFORM|Attribute(string

Hi allis it possibe to insert a buffer distance inside the FuzzyStringCompareFrom2DatasetsI mean My goal is to compare the name of dataset a with name of dataset b within a distance of 500m

Is there a way to set the logging level on a workspace on FME server? You can set logging level on your desktop by pressing Tools -> FME Options and unchecking/checking options in "Log Settings". We specifically want to not log information.

Hi all,I got some points like in the pic. How can I create a cluster with most point and get the long/lat of the center?Thank you all

Hi all,I hope an easy one.Please see attached images; how should I write to get the values within the measures item in the AttributeExposer tool?Many thanks

I have a set of polygons resembling the Towers of Hanoi (I have many towers with varying rings but only included one tower here):I would like to start with the polygons which doesn't have any holes and which are holes in other polygons (in this case I only have the small one in the center) and dissolve it with the polygon in which it is a hole. I would like to repeat this until the dissolved area is larger than some threshold (here 30).Can I do this in FME 2016?I have attached a shape file with the data set above.