Best Answers

Hello,I am a FME beginner and I really love that whole folders can be added to a writer. However, I do have folders which contain many files of the same format each and I would like to add a folder to a reader and let FME guess the format of the files in that folder. It seems that this is not possible but only one of the two (add folder OR guess format from dataset)?thanks and best regards,Ludwig

Hi,I would like to write to elasticsearch, not from a table but from some JSON instead. I have prepared the JSON before hand because it has to be nested.The output format is like so:{    "mappings": {      "storymap": {        "properties": {          "storyname": {            "type": "text"          },          "storyid": {            "type": "integer"          },          "storyjson": {            "type": "text"          },          "categoryname": {            "type": "text"          },          "subcategoryname": {            "type": "text"          },         "regions": {           "type": "nested",           "properties": {             "region_id": {               "type": "integer"             }           }         }        }      }    }} I have managed to get this output format using the JSONTemplater - thanks to @petrahammoser your post was helpful. But now I want to pass the JSON to an index in elasticsearch which is already created.I have tried but I am at a loss, the JSON do

Hi all,I'm am looking for some Regex help to clean up my workflow. I have used StringConcatenator to bring together latitude / longitude fields and to separate these with ", " (comma white space)Unfortunately my data also contained empty fields and text resulting in:, 51.50757358840452, 4.358557125886925aan, Alphen, Winterswijk  The only data I want to keep are the valid latlongs in bold. Can you help me out with a regex string (to be used in StringReplacer) that cleans all except the valid latlongs?Best,Ed

Hello,I have a point shapefile and my goal is calculate the distance time In my workspace i used the transformer NeighborFinder to find the distance in meters between the features. Another information is the speed in KM / h to arrive point A until B.  How can i calculate how many minutes my point A will arrive in point B. Informations:  Distance: 443.81979158381 mSpeed = 2.778 KM - h  Thanks, Danilo

In my Aggregator transformer that I use to prepare and build a SQL query to next feed into SQLExecuter query, I want first to check if the primary key values are of type string in order to pad single quote for each value.. (example: value1, value2, value3, ..for numeric primary keys'value1','value2','value3', ..for string primary keys)So I chose to create a Scripted (Python) private parameter to check whether the primary key values of type string, then return a single quote as below: snglq= ","# Check if the primary key is string?if type(FME_MacroValues['SDE_PK']) == str:    #then add a single quote    snglq= "','"else:    # no single quote    snglq= ","return snglqAnd then assign value returned to the Separator Character box in Aggregator transformer, as shown below:But that's not working properly, always result in values with padded single quote, yet the primary key values are of type numeric!!What would be wrong here, please help

I use AttributeCreator to prepare a list of columns (A, B, C, D, etc..) for an Excel writer. My problem is that the list is 4000 items long. I have to manually expose every one of the column labels, which is not feasible. I have looked up and down and did not find a solution. Is there a way with PythonCaller to label a feature as exposed?

Hi,I have just a 6 points ( attached ) and i would like to generate a kml file using the service KML Network Link.Each point has a number of sequence ( _feature_n ) to show each 30 seconds.How is the best way to do this? Thanks, - Danilo

Do you think there is a way in FME to extract traffic layer from Google? I want to analyze traffic in a certain zone and I can't find the way to get this data in FME.I tried to see into the documentation but without success : Google TrafficI'm starting to think that maybe Google doesn't want us to do that kind of stuff though...

Hi,When writing CityGML, gml:ID is added to the surface feature (WallSurface, RoofSurface, GroundSurface) however, there is no ID written to the polygon of the surface. How can i create an attribute to set the gml:id of the polygon of the surface feature?Thanks,Steve

Hi,I'm looking for a best practice to extract parts of a path name.If I have a path: S:\\Miljø og teknik\\Svendborg Vand\\Anlæg vand\\Microstation\\Dokgraf dokumenter\\VandGraf\\vand_knude\\ULB00004\\Arbejdsrapport.pdfI need to extract the part starting with "VandGraf", i.e.: "VandGraf\\vand_knude\\ULB00004\\Arbejdsrapport.pdf" into one attribute, and the file name into another.What is the simplest way to accomplish this (without custom Python coding) ?Cheers.

Why is my DWG to DWG translation writing out PNG files? I am not reading in any PNGs anywhere in my workspace - how can I disable this? Write Thumbnail Image is set to No.

Hi, I want to output a list from JSON using the PythonCaller.I have tried the following syntax but it doesn't work. info = json.loads(data) for item in info:  feature.setAttribute("_list{}.value",item["time"])Does anyone have any suggestions?I am using FME Desktop 2017.0Thank you 

Hi,I am trying to connect to my AWS elasticache servicehttps://search-dev-elasticsearch-z4b7vwlsqswv4uial343rdjccq.us-east-1.es.amazonaws.com/I can go here on a web page and it returns:{"name": "dF9fcow","cluster_name": "929479087525:dev-elasticsearch","cluster_uuid": "Owj46HL6TpSWiGnOeYeCaw","version": {"number": "5.1.1","build_hash": "5395e21","build_date": "2016-12-15T22:47:19.049Z","build_snapshot": false,"lucene_version": "6.3.0"},"tagline": "You Know, for Search"}But for some reason FME cannot connect, it appears to be trying over port 9200.This is the error I get:ELASTICSEARCH writer: CURL error was: Failed to connect to search-dev-elasticsearch-z4b7vwlsqswv4uial343rdjccq.us-east-1.es.amazonaws.com port 9200: Connection refusedELASTICSEARCH writer: Unable to locate or open server 'https://search-dev-elasticsearch-z4b7vwlsqswv4uial343rdjccq.us-east-1.es.amazonaws.com'.  Please ensure the server exists and is accessible.  Note that the ELASTICSEARCH writer does not have the abilit

Hi, FuzzyStringComparer is a great transformer but it only works within one dataset. Has anyone created a method of doing the same with two datasets?  I have done a feature merge on two streetname lists. As output I now have two lists which contain streetnames that are missing/wrong in either list.  So I would like to continue by doing a fuzzy comparison and return to ListA the most probable candidate from ListB for each attribute.  It is likely there are just typos, and I will then find them. Where the probability is very low the streetname is most likely missing completely or superfluous in either list which is also useful information.  Thanks for any ideas how to proceed...

Hi, I need to extract the extents of LiDAR point cloud data.The HullAccumulator not the HullReplacer does not seem to export the extents. Instead it outputs a bounding box, which is not what I need.Please see image below:Please see the example simple workbench with sample data attached.Please can you help what I am doing wrong?Your help much appreciated!Many thanks,Magda

My company receive AddressBasePremium from OS via disc, the data is stored in zipped GML files and has previously been pretty good to work with, however we may have changed some settings that appear to be affecting our ability to open GML files in desktop or the data inspector, the following error is thrown when attempting to view the data (freshly extracted from disc) in the inspector;URL resource cache - 'attempt to write a readonly database'A fatal error has occurred. Check the logfile above for detailsFailed to read features from dataset 'E:\\Temp\\AddressBasePremium_FULL_2017-07-03_099_gml\\AddressBasePremium_FULL_2017-07-03_099.gml' using the 'GML' readerI can't find anything that may be causing this, can anybody offer some assistance? I understand FME will be creating a temporary database for the tabular GML information so assume this may be permission issues, but my user account is a local admin.

Hi, I have 2 LAS (pointcloud) files that have differences in classification of the points into different classes. What would be the quickest/easiest way to compare that files and output the differences into another LAS file please

Hello Team,I'm doing a Proof of Concept to show the use the transformer TCPIPReceiver.Its not necessary to read all information from Host. My question:- has a configuration like Max Features to Read ( similar we have in Navigator ) ? Thanks,Danilo

I am trying to generate a JSON file that includes elements like this one:But I have problems with the "positions" property. I can´t reproduce it. I can get and array ([] instead of {}) and each element like "9": [220000, 3230000] with non desired {} at the begining and the end.I attach the full project () with the target.json that I need.Thanks in advance.

Hi everyone,I have to download all the features from an OData REST endpoint, but each request has a limit of 100,000 features (I expect there's 8 million or so in the full database).I've got the process working well with a JSON reader for the first request. But how do I loop so that I don't need 80 JSON readers?Each time the service responds with a JSON object with its values and a "nextlink" if there are still more features that could be returned. If you then send the same request with a "$skip=100000" query parameter it sends the next 100,000 features.I've experimented with an HTTPCaller in a custom transformer loop but I'm not familiar enough with FME to test for the existence of the "nextlink" attribute and then increment a skip counter by the number of features returned.Thanks for your help everyone,Aiden.

hi there,I have a question regarding loops in FME and my inputs are:A point file(have an ID field) and polygon file (have an ID field).Now I want to create voronoi polygons from point file but in a loop in which I will select first polygon and all points in side it, create voronoi polygons, clip voronoi polygons with selected polygon and save the result. Then loop goes to second feature and same procedure runs till the end of polygon file.In this way my voronoi polygons will be seamless with input polygon layers which is for me very important.This is first time I am doing something in FME with some loops. I have searched and sofar, I have not found any thing which can help me. so l am looking for some suggestion.S/WFME Desktop 2017.0 64bitWindows 7 64bit

Ok, I've a gpx file that I see in the data inspector, I have a mapbox map in the background that I can see too. I want to save this out to a jpeg but it doesn't create any file so I tried saving dataset as a pdf. That works, except it only exports the gpx data, it doesn't include the background map. Is there a way to do this?

While generating HTML report using ESRI Leafet i am unable to display line features in HTML Report on ESRI Leaflet. Translation gets failed in this case and works after not passing the line features using Geometry Filter. I am getting below error.  'fmeobjects.FMEArc' object has no attribute 'numPoints'(Not validating any numPoints attribute)Thanks in advance.