Transformers

Hi Everyone, I have quite an interesting question on how one can "Rate" your Input data in the FME workspace. The idea is to use some predefined questions, and then check the Workspace if the requirements are met. If the requirements are met, the Evaluated table gets a Rating/Value. Once this is done, an HTML page is exported with the rating.  I have made an example, but I find the process to be quite tedious, and can be a bit overwhelming on bigger workspaces. My Question is: Are there better ways to rate tables and create ratings on quality of the input data? Or should I rather work with loggers? So in my example, I have a table to Evaluate. I am using three different "Codes" to use for my Rating system Using Statistical Calculators, Aggregators and FeatureMergers, I add the Rating "CODE", to my Evaluated Table.  The Workspace:   The final result is a HTML: 

I have a sql executor using an ODBC connection with parameters in it. The params are fed by published params and an inbound reader [into the executor]Only a few small columns are returned and typically less than 200 rows.-When I run the query with params it errors about every other time. Not much detail in verbose just 'Error running translation.' Then it terminates.-When I attach a logger to the result of the SQL executor the translation never errors. -When I hard code the sql executor [just for testing with no params] it never errors. Unless I have nothing attached to the 'result'.- In short the translation works with a logger attached to the 'result' of the sql executor regardless of params or no params, it fails with nothing attached to the 'result' regardless of params, and it works occasionally with params and no logger attached. I can run the translation in production with a logger attached but why do I need to? And why doesn't it work without

Hi.I'm trying to find self-intersections using GeometryValidator but it just keeps passing all geometry. What am I doing wrong?Above is a zipped shape file which I've tried running through a GeometryValidator in multiple versions of FME. 2015, 2017, 2018, 2020. Checking for self intersections in 2D. Always passes no matter what settings I use. Here's a screenshot.It's originally a rectangle that I've twisted so that it self intersects in the middle. To me it should be obvious that there's a self intersection but as mentioned the GeometryValidator fails to detect it. Does anyone know what the problem is? 

I've been experimenting with the chart generator transformer and can't seem to get the background color to change, even after I change the color using the "Background Color" parameter under the Style section. This is for a bar chart. No matter what color I change it to, it will only keep the default white color RGB(1.0,1.0,1.0).  It won't change the color in the preview or after I write it out to a png. The documentation states: "This parameter sets the background color of the chart. The default background color is white, with an RGB value of 1.0,1.0,1.0."  FME 2020.0.0.1  

Hello everyone!  There were two adjacent DTMs with different resolutions(one is 0,5m and the other is 5m.). I resampled them to bring together and mosaick at 1m resolution. There seems to be no problem with 0,5m res. area in the mosaicked image, but after the resolution is reduced for 5m area, defects like a stair steps appear in 3D view(as seen in the image). So, how can i get a smoother suface for the downsampled area from 5m to 1m. Which transformers or parameters should i use in my workflow. Thanks a lot. @daleatsafe @daveatsafe @takashi @jovitaatsafe @redgeographics @deanatsafe @rylanatsafe @hollyatsafe @lenaatsafe @annabelleatsafe @steveatsafe

Hi there! hope someone can help.I'm trying to convert IFC into DAE, but having trouble getting the IFC Global ID into the DAE Name and ID properties.Any suggestions?cheers,ronald 

Hi, I need to find and extract numbers from a string of text, numbers and characters (see example below). The conditions needed are that the number string can only be between 8 and 14 digits long.I'm inexpericed with writing Regex but following some previous guidance from this wonderful FME community I did make a start (see below) however it's not doing exactly what I need it to do.Initally I thought I had solved this until I realised the data has number strings of between 8 and 14 digits/ I'm using the String Searcher transformer. My expression seems to be finding strings of 8 (or more) digits but only extracting the first 8 digits. This means that when the number string is greater than 8 it cuts the trailing numbers off (se below).The data I have been provided with is messy to say the least!In addition to the above question I'd like to ask if its possible to identify and extract, from results of the above, number strings of 8 digits that start with the digit '23&#

HiI am trying to filter a dataset to show a features that are in set of values . I am using the Tester transformer with the IN operator. If I were to do this in an ESRI product, I could select the field (attribute) I want to filter and it would list all the unique values for that field to enable me to chose the ones I require. However, I cant see a way to get that info in FME - I have to stick in another transformer and inspector and then copy and paste the values I want into the expression, which is far from an ideal workflow.Please could someone tell me if there is an easier way to do what I want to do? Many thanks

Hello Guyswe need to filter thousand of address into Odd and even number,we are using the test filter, I think we should use the reg expression for the condition,any idea how to write the expressionThanks

Hi, I have to fit the maximum number of polygon with specified dimensions into another polygon.I have to analyze two positions: vertical and horizontal and choose the most optimal placement (the largest number of polygons inside)for example:Do you have an idea how to do it in FME?  

I have a floating point number (i.e. 41165.2823011227) that I need to convert to year, month, day, hour, minute, second.  All I've been told is that the floating point number is the number of days since January 1st, 1900.  After a little bit of research, it looks like you can convert these in Excel (make sure you have 'Use 1904 date system' unchecked under Advanced Options).  When I enter the floating point number and format the cell to Date, I get 9/13/2012  6:46:31 AM which looks correct.  Is there a way in FME to accomplish this same conversion?  More info on the 1900 Date System here: http://support.microsoft.com/kb/180162

I have 2 tables say table1 with a geometry column geoloc, and table2 with a geometry column geom,. table1.geoloc in general contains table2.geom. I want to pick those rows where the condition is such, and combine the two tables and create a 3 rd table with both the details including the geometry colmns. I want to rename the columns before inserting into 3rd table

Hi,  I see FME has an OSM XML data Reader. I wonder if its possible to have this reader/converter on the fly using transformers. I use the HTTPCaller to extract data via the Overpass API and I would like to convert the output XML into features, but that's not easy as I first tought because of the way OSM data is structured.  Is there a way to convert the xml data returned by the HTTPCaller into FME features without saving the XML on disk and then using the OSM Data Reader?  Thank you!  Maxime Demers

What are the settings (writer and additional attributes) to write to a dwg-surface? So for example to convert a pointcloud to a surface (dwg)Now when I would like to write it to dwg it becomes a mesh (object ;-) ). Thanks!

Hi,  I have a geodatabase with multiple feature  classes.  The FCs do not all have identical fields.  I want to write a test that removes attributes fields that are empty.  I can't find a way to do this, i.e. select all attribute fields.  The BulkAttributeRemover seems like the best bet, but not sure how to code the expression.  Also, tried the custom transformer NullAttributeRemover, but the script expects the user to select which attributes to utilise (not a Python user).  Any suggestions appreciated!  Thanks.

Hi We have dsm tiles with gcp 3.5 cm, I want to resample them to 25 cm. This is my workbench: The result has gaps of 25 cm, like this: How can I prevent that? Thx

HOW CAN I CALL A PYTHON SCRIPT IN FME, IT IS SIMPLE ONE CREATE A RANGE OF NUMBER AND WRITES TO A TEXT FILE IN RANGE LOOP

Hi, I use Extruder to extrude several lines to surface (Parameters: Direction: Vertical). But after extruding, the vertices of each surface point to different orders, some of which are clockwise (the bottom figure) and some of which are counterclockwise (the above figure). If I want to unify the directions of vertices as counterclockwise, how to set?Can anyone help me?

Hi all,  I have to classify polygons without attribute values, according to neighbouring attribute values. However, this has to be based on the neighbour with the largest shared boundary . A comparisation of shared lengths is necessary when the polygon shares boundaries with two others for example.   I have used a geometrycoercer to first make a line of both sets. Then a lineonline overlayer, since I don't think the common segment finder will help me. However, I cannot get to calculate the percentages of different shared boundary so im looking for suggestions.  I hope I made myself clear. Thank you in advance!

I have run attributecreator, creating a field from unique values in a field. I think it worked (no error messages). Where are these attributes? I don't see them. Thank you, Randy McGregorNote: Can't prrovide specifics of the data. Hopefully explaining it will work? 

Hi,In an Excel file, the data of 1 object is spread over several lines. This looks like this:ColumnA ColumnB ColumnC item 1 data item 2 data item 3 How can I ensure that all data is on one line? like this:ColumnA ColumnB ColumnC item 1 item 2 item 3 Greatings, Hans

Hi,I'm trying to transform IFC data into CityGML data. I use AttributeReprojector to reproject coordinates, and use 3DAffiner to perform a 3D affine transformation on the coordinates. After that, when I use CoordinateSystemExtractor to look at the coordinate system, found that the coordinate system is "IFC_COORDSYS_0", not the one I set, EPSG:31467. Why?A Warning "Coordinate system named IFC_COORDSYS_0 does not exist." appears in the log during running CoordinateSystemExtractor.

Hi, We have as input a shapefile containing roof polygons.We would like to modify certain lines of these polygons such as the gutter and ridge lines.We would like to modify the value of lines which are almost horizontal to make them horizontal ! At the end we should have Z1=Z2, Z3=Z4 and Z5=Z6. Our script is joined. We tried to extract the vertices of the polygons, modify them and then rebuild the roof. It works for simple buildings with 1 roof section but not for more complex buildings with 4 roof sections, for example.Is there anyone who have a solution ? maybe without extraction of the vertex ? Thank you in advance.Victor

Our installation of FME Server has just stopped working. All services are running but I have noticed in the Engine Logs that it is struggling to register engine. 2017-08-16 14:46:58| 0.3| 0.3|INFORM|FME(R) 2017.0.1.1 (20170512 - Build 17291 - WIN64) 2017-08-16 14:46:58| 0.3| 0.0|INFORM|FME_INSTANCE_NAME FMEQAS901_Engine1 2017-08-16 14:46:58| 0.3| 0.0|INFORM|Registering with FME Server on host 'localhost'... 2017-08-16 14:46:58| 0.3| 0.0|ERROR |FME Engine failed to register with FME Server 'localhost' on port 7070: Could not establish connection to hostAny advice would be welcomed.

Hi All, I am having grid (red) polygons as shown below and I want to update Grid id to other polygons (black) when it covers maximum portion in that grid. Can any one suggest how it can be achieved in FME.  Thanks,Ram.