Transformers

Hi,I have a SQLite database with point and line geometries. I want to create a line between the points and the line objects. This line should be the shortest path and the sounding line (90 degres) on the existing line.How can I manage this with a SQL Statement? I want to use the spatial functions from SQLite Thank you and best regards

Hi all,I'm making pivot table from json file but I got problem in this model.Could you tell me why? Thank you

Hello, Experts. I struggle to perform a simple task. Wasn't able to find a solution by googling, I'm sorry.I want to separate a red color from a raster (RGB 255 0 0) using RasterExpressionEvaluator. The end result should just be raster containing RGB 255 0 0 color: I can't seem to find the right expression. Here is the screenshot of my workbench along with the RasterExpressionEvaluator parameters:   Thank you very much.

I have a Postgis table with records which have a geometry column. Within the geometry, there are multipart polygons (example. If I query this one record in QGIS, it shows one polygon at location x,y and the other polygon 200 meters north). What transformer can I use to identify records that have multipart geometries that are over 150 meters apart from one another?Other records in the table have a geometry with one polygon and these can be ignored. I'm looking for records that have multipart geometry and if so, that are greater than 150m apart. Much appreciated. Thank you.

I'm fairly new to FME so my apologies if this is a pretty straightforward question. I'm trying to create a GTFS Feed using FME by reformatting data I already have in a excel table. I'm getting an error from a reader and I'm not quite sure where to look, tried reformatting my table data again but no avail. I'm on Workbench 2017.1Here's the error:Python Exception <ValueError>: unconverted data remains: 4Error encountered while calling function `convertDate'f_95(PythonFactory): PythonFactory failed to process feature Any help would be much appreciated Thanks!Kevin

Hi  I am trying to build a connectivity model for electrical cables.  I need to break lines with the following rules:  If the end of line A touches line B then break line b at that point  If line A has a node/joint on it, break it at that point  If line A crosses line B, but there is NOT a vertices at the point it crosses, DO NOT break that line  if line A crosses line B, but the end of line B is a short distance away from line A, shorten the line to A, and break.  IF line B does not quite touch line A, adjust its length and break  I have played with the topology builder etc and so I am confident that I can identify the nodes where lines need to be broken.  I can't figure out how to break the lines in the correct places.    Can someone point me towards the correct transformer(s) to do this?  Thanks

I'm attempting to convert a series of MDB's to OBJ's. However, I'm getting this error:OBJ Writer: Unknown geometry type 'IFMENull' is not supported, the feature will not be writtenI tried using a 'geometry filter' to get rid of all null values, but that didn't work either.

Hi all,Today I stumbled upon an issue with the ChartGenerator. I'm using it to create histograms of data from 17 data sets. I'm using a workspace runner to batch process and create the histograms with the ChartGenerator transformer, but writing the output to file using fme_basename is not possible. Can anyone guide me to a solution where the 17 generated histograms are written to unique png-files? 

I have a esri geodatabase that I'm trying to translate to a "Mapinfo" table. It is successful if I limit the max features to a million records, but the geodatabase is 2 million records and I keep getting the following error (see image). I'm running FME on a Windows Server 2008 machine. It has 2 XEON (E5-2670 v2) processors and has 10GB of RAM installed.I've set the temp folders to the Secondary "D" drive. Not sure why this is happening, as this wasn't an issue when I was running FME 2013. Since upgrading to FME 2018 this has become an issue.  

Whenever I try to import data using an Odata reader, I get the following error: A potentially dangerous Request.Path value was detected from the client (:).Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.  This is the link ( https://opendata.cbs.nl/ODataFeed/odata/81573NED )I'm able to specify the right tables in the parameters, so there is nothing wrong with the URL. It also works when i try this link in other software as Excel.Does it have something to do with the fact that is an 'https' url instead of 'http'? Because this URL works http://services.odata.org/Odata/Odata.svcAnybody have any experience with this? Or has any ide

Hi I have a point and line fc. I am using NeighborFinder to find nearest line from point. However when I compare the result with Near tool in ArcGIS, the nearest line obtained differs. I can see both lines are adjacent. Any idea?

Bonjourje cherche a créer un spline a partir d'une série de pointsuivant l'exemple ci dessous (je cherche a créer la ligne verte)qui doit passer par les pointsj'ai bien essayé avec un Generalizer mais les algorithmes génèrent des lignes qui ne passent par les points(ou je n'ai pas les bons paramètres ?)je voudrais essayer avec des fonction Python et un PythonCalleravec en entrée un tableau des 6 points et en sortie en semi de points représentant ce SplineMais je ne connais pas suffisamment l’interpréteur Python Callerje suis preneur d'idées et d'exemples Merci a tous!

I would like to create a grid file from the corresponding DTM / DSM tiles with the height difference stored in the cells. DSM 1 km tiles are supplied in 2 metre resolution (500 by 500) while the DTM 1 km tiles are provided in only 5 metre resolution (200 by 200). To get the grids to have the same number of rows and columns (so the height difference can be generate in the RasterCellValueCalculator), I first tried to use the Raster Resampler with the number of rows and columns set to 1000. However the interpolation methods produce unreliable results. Is there a transformer that will split the 2m / 5m cells into groups of 1 metre cells while keeping the same value? Also what is the best way of pairing the files so that a workbench can iterate through DTM / DSM tiles with matching file name in the source folders? For example processing DTM\\SO4043.jpg and DSM\\SO4043.jpg together and then all the other matching pairs?Each output would be fme_basename.tif

Hi,I´m trying to create an XML-file from an excel sheet.I have an xsd-file to create my header information in the ROOT-Template and it contains a number of prefix (namespace) definitions (not sure about the correct names here). When running the workspace it works fine using prefixes in the ROOT Template part but when using the same prefixes in the SUB template I get an error telling me it is not defined. Can I make the SUB Template recognize the definitions in the ROOT Template or can I somehow define them in the SUB Template but not writing it out in the _result attribute in the sub-part of the xml-file?

Hi, i have timestamped gps records in a database of several devices.Those records are filtered in order to established a relationship with an area.How can i retrieve time spent on a specific area ? Thanks

Hi All,I am attempting to use the RCaller to interpolate barometric pressures in water loggers from a set of data taken from a barometric logger in the project site. The R script I am using works in RStudio when I run it and returns correct results, and it runs without throwing an error in FME however the values calculated (interpolated barometric pressure) are <null> when they are taken out of the RCaller into FME.Any advise would be greatly appreciated!Thanks-Jack

I have a set of points and lines that I need to collectively scale down using the Scaler. I am combining all features using the Aggregator, scaling down, and then Deaggregating. The features are retaining the original attributes, but all features are getting the attribute values from just one of the features. I am needing the features to retain their original attribute values after the Deaggregator.

I have to write some data to a XML-File, that's afterwards transformed to a HTML-Page using xsl.  One attribute in my data is an image, that's encoded in base64. In xsl it gets decoded and displayed in HTML as png.  This works fine, but now I want to make sure, that this image is of the correct size (height/width). Is there way, I can do this with FME?Thanks, Vera

Hi, I have a shapefile that contains polygons and we would like to find the minimum width of each of the polygons. Any help would be greatly appreciated. Thank you.

This morning I worked with FME Desktop V2017.1.0.0 (b 17539). Suddenly I get a message: Creating reader for format: Oracle Non-SpatialFile D:\\apps\\FME\\metafile\\.fmf could not be openedI read in the known issues We've fixed this issue for FME 2018.1. This issue was a problem with showing Oracle table list in the DatabaseJoiner.Ik have the same message with SQLCREATOR.- wich metafile FME tries to open? Can we replace this missing file?- Is this the same error in DB Joiner as I also have in the sqlcreator?- is there a workaround available (I have tried to create an new DB joiner and even copied the whole WS to a new WS and replaced all DBjoiners but that does not work).(- install fme 2018 will happen in a month or 2, but I can not wait so long or I have to escalate this issue to our manager with priority.)thank you for your reply

Suppose one line having 3 segments. First and third segment having ABC road name but middle one having no name or XYZ road. How to find it

I am trying to convert a three character month to a two digit month (e.g. - Mar to 03) using FME 2016.1 (build 16492). Should be easy enough using the DateFormatter but the converted value returned is always 01. I think my parameters are set up correctly. Screenshot attached. Any ideas?Thanks,Aaron

Suppose one road is having ABC Road name and off road having same road name. How to find it out if i am having thousands of record in shape file

I have some features with attributes as follows fromto41444146412441815406700241214124700299663418141449966399661540675406414654067 And I'm aiming to reprder/assign an ordered value so that the from value equals the to value of the preceding feature. fromto41214124412441814181414441444146414654067540675406540670027002996639966399661 All suggestions appreciated.

I have a dwg file that I'm converting to a KML File. As you see in the attached work space the line features that are routed to the Utility_Lines KMLStyler have a label. Everything works great until I route them through a KMLRegionSetter then they stop showing. If I set GeometryFilter_2 to route the lines and arcs past the KMLRegionSetter they will show again. What could be the problem? There must be a setting somewhere to make this work.