Transformers

As many times before I've populated a multiple choice user parameter from an Excel spreadsheet. This time though, and also in all of my older workbenches now, when the user parameter Promt is shown it displays all the choice options there as well. ? Is this a known bug, and/or is there a workaround? Here are my parameter settings :  Best Jonathan

An FYI rather than a question:As others have mentioned previously, comparing geometries with lots of decimals is fraught with danger. I managed to expose a new and odd behaviour though (before I remembered I needed attribute rounders). I have a point filegdb layer, it has attributes that describe the location. These are not automatically updated from the geometry however, so during editing these get out of sync.A quick coordinate extraction, then an expression that subtracts the attribute from the extracted coordinate and a range filter after that, to accept anything within a metre. When I expected the result of the range filter (and sorted by numeric ascending/descending) I got 6464 points that pass.That's great, until I scroll through the rows in Inspector. They start off close to -1 and part way through the list, values of -4, -5, -6, -7 start to appear. Wait a minute, how'd they get there?I then added attribute and coordinate rounders, ran it again and got the same, 6464 po

Hi All,I wish to move a file from one folder to another. I have tried using FileCopy Transformer initially but that isn't working properly. It works fine on a single run whenever installed fresh but isn't working fine on consecutive runs. It is only copying the data from one folder to another. I now resort to create a python script which can be called via a python caller or used as a shutdown script.. Can anyone recommend me a python script for moving a file from one location to another or instead a delete from the location?Thanks.

Hello-I have used the following example to some success, but I have some questions regrading the rounding of the block and when the incident location is an intersection. In this case I need to just pass on the street name to the location and not have it pass through the attribute manager that adjusts the address number. I am also using a geocoder published to ArcGIS server instead of a CAD file. Thanks!!

If yes how?

I need to work on label/text placements in an AutoCAD DWG file. I am exploring MapTextLabeller transformer for this. Have anyone explored this option ? Thanksbey_atkins2009

Hello FME Community, I am working on a project where I need to convert an AutoCAD .dwg file into Apple's Internal Mapping Data Format (IMDF). The tutorial FME provides assumes you have a master drawing file. Being that I was not able to find a master drawing file for the space I am looking to model, I created my own AutoCAD file. I am not a Civil Engineer and I do not have experience in AutoCAD.I wanted to know what steps I can take to actually modify the AutoCAD file such that FME will process it correctly and spit out the .geojson file I need to proceed with IMDF. I've heard certain terms like blocks, block attributes, layers, and properties but I don't know what exactly to do so that FME will read features out of the file.If anyone is willing to share information or even resources that might put me on a better track, I'd appreciate it greatly! Thanks!

Hi, I have a set of 250 raster tiles, I have reprojected them from ITM to WGS84, before reprojection each tile was 87,215KB. After reprojection the tiles are roughly 180,000KB. Why has this happened? My workbench is included here, I first mosaicked the tiles then reprojected and finally clipped back to the tile boundaries. Thanks for any help.  B

I am using surfaceModeller to generate TIN surfaces, I need them to be stacked as they represent various height and they have to be like that. Triangulation and draping work ok, the only thing I would like to remove are the contours on the side. See image of the pdf as example of output. I already tried a negative buffer but it does not work as it removes also some internal contours that I would like to keep.Could anyone help? 

Hi,I would like to transpose data into a new table. My input table is:CODE VALUE_1 VALUE_2 C1 11 22 C2 33 44 C3 55 66 My output table should be: C1-VALUES_1 C1-VALUES_2 C2-VALUES_1 C2-VALUES_2 C3-VALUES_1 C3-VALUES_2 11 22 33 44 55 66  This is what I have done so far. Please see attached my workspace. Thanks, Jeffrey  Cc: @takashi

I am building a data quality control layer and currently checking data formatting. As part of the format checking, I would like to ensure all data will not contain uncommon characters, which I guess, means anything OUTSIDE the normal ASCII character set (0 - 127). Efficiency would be imperative here considering this is a very small part of a very large processing "layer" and will likely involve checking every character in a potentially very large dataset. I'm guessing regex would be ideal but I cant figure out a way to implement regex without explicitly listing every single strange character, and I'm unfamiliar with regex as it is... Any recommendations?   Thanks!

Hello,i would like to calculate the surface of a dwg plan. My first approach was to make a bounding box and calculate the area but it's not precise enough.  I was wondering how i could do something like that :   The blue line is at 4 meters of the feature ....  I hope you see what I mean , and hope that you could help me.  Thanks a lot.  Best regards.  Steph.

Hi all,Can anyone explain which transformers to use, to find the index of a certain string in an attribute - BUT only the last occurrance, by looking forward and/or backward in the string. Unfortunately I have very little experience with RegEx.

I want to try and use the Affinewarper to do a few adjustments, where can I find out the required format for the control file to be able to do this transformation?

Hi, I am trying to create geometry from a coordinate list in GML but it does not work with the GeometryReplacer (GML). I don't know if I did anything wrong with exposing the XML attribute containing the geo or if the format is the problem. The following template contains the workspace and the XML source. The coordinates are stored in the XML tag "Building.geometry2D.BuildingGeometry2D.geometry.Polygon.exterior.LinearRing.posList Thanks in advance for any help!

When trying to call an API using HTTPCaller (POST) "upload from file" option, FME fails with error code 500.However using exactly the same piece of JSON structure as "specify upload body", then the HTTPCaller works fine.So how is it possible, to change the upload body for each time I read a new JSON record from the file.Any ideas to make this work, one way or another, are very welcome.

Hello!I am currently running a shortestpathfinder to calculate fastest routes along a road network. I am having difficulty creating a from-to line that does not have overlapping points. Currently the LineBuilder has great overlap generating a not very well optimised route through shortestpathfinder. This is similar to the Travelling Salesman, if the salesman were to visit every point on the network.Any idea on how to better generate the from-to line to have less duplication? The image shows the messy LineBuilder.

This should be a dead easy translation, but unfortunately I use FME only one or two times a year, and I’ve been too lazy to take enough time to read the documentation and become more proficient.I have several hundred AutoCAD drawing files that I need to extract data from three feature types:linework on layer R-UTIL-CATV-LINESblocks on layer S-UTIL-CATV-SYM: all I want are the insertion points and the block name at each insertion pointblocks on layer S-UTIL-ELEC-SYM: again, just insertion points and the block nameThe target writer type is Esri shapefile. I can get the geometry of the lines and the block insertion points, but I cannot get the block name no matter what permutations of translation parameter that I try. I have looked through the forum postings, but apparently this is one of those FME 001 translation types that is supposed to be self-evident. I will accept the fact that I’m a lazy ignoramus, but I would really appreciate a solution for getting those block names. Here is a li

I created with sql creator a dataset then i write the data in two sqlite or postgres table. Same data and data type.  If i compare the both, the first set id detected as deleted and the other is detected as added.  

I have a layer with several polylines that represents a hiking trail in southern Sweden. I need to segment this trail into equal lengths in one direction along the line, either starting from the north or the south. At one point the trail splits in two and one feature ends in the middle of another, otherwise all features are joined on the start and ending vertices of each other. The sum of lengths of the lines is 85 266.31 m.The layer uses projected geographic coordinate system: SWEREF TM 13 30, which I believe is LatLong @david_rI am trying to use the IterativeSnipper to cut the trail into 4000 m segments. First I tried to aggregate the polylines, since I want the lines to go in one direction, or to have one starting and one ending point. The translation failed because of invalid geometry that time. And I couldn't get the LineCombiner to work either @egomm.And when I use only the IterativeSnipper with the below parameters, I get a result of 27 polylines with most of the features (1

I have been developing an FME workflow in version 2017 and have since upgraded it to run in version 2018 but am noticing a vastly slower processing speed when running the DatabaseJoiner transformer in the 2018 version. I can literally count each feature as it gets joined. This used to happen in 5 seconds at the slowest in the 2017 version and in fact I can run the DatabaseJoiner in a workflow identical(data and workflow) to the slow 2018 version and it will run super fast. This may be indicative of a bug in this transformer. Can someone help me find out if this is the case? I used to be able to run this workflow in less than 3 hours but in the 2018 version it takes over 9 hours to finish processing.

How to speed up Clip 6 000 000 triangles against 20 areas. Have tried Clipper, Spatialrelator, spatialfilter. With no luck for speeding.Using Postgres is an option, but would prefer a lightning-fast solution that only includes FME without a DB-backend :)

Hello all,I am a newbie to FME and have failed at the first hurdle to convert an .XML file to .csv format.I really want this converted but do not have the time to learn how to use FME (wonderful, though it is) to complete the task.Would anyone like to do this as a simple challenge to their skills? The file is of no commercial value but it is about 115MB in size. I would simply like it converted to an .xlsx or .csv file with a flat structure.(I would use somethimg like www.wetransfer.com to send it to you).Any takers?Thanks one and all !! 

I am pushing data that I have cast as a double number to the JSONTemplater - it goes in as 0.09 once it comes out it gets longer becoming: "prod_index" : 0.09000000000000001This seems like a floating point rounding number issue. Can anyone suggest a way around this.Many Thanks,Oliver 

Hi together,I'm trying to create a transformer that processes point cloud data from a LAS file. To do so, I'm modifying the CenterOfMassCalculator_Python example.How can I access the point cloud data? The feature.hasGeometry() attribute is true, but feature.getGeometry() returns None. Code:def input(self, feature):   self.logger.logMessageString("--- input() ---")   self.logger.logMessageString("  Feature type (fme):   " + feature   self.logger.logMessageString("  hasGeometry (fme):    " + str(feature.hasGeometry()), fmeobjects.FME_INFORM)   if feature.getGeometry() is None:     self.logger.logMessageString("  Geometry is none")Output:--- input() ---  Feature type (fme):   LAS  hasGeometry (fme):    True  Geometry is none