Transformers

Hi,Is there any easy way to export the fme gallery to a table - I would like to index it using elasticsearch and make a dynamic dropdown for a user to select their intended projection.Thank youOliver

How can I convert a string to a number so I can perform arithmetic calculations?

Hello there!Into FME Server 2017.1 I have some process failing for some reasons and I get the error into the log.But when I look at the process status, it's Completed. Then, I don't get any notfications alerting me about this.Shouldn't I receive a Failure message instead?i could put an Emailer into my workbench, yeah, I know, but I would prefer the FME Server notification.Into FME Desktop I get the Failure message though.2019-01-03 17:03:36| 203.7| Â 0.0|ERROR |A fatal error has occurred. Check the logfile above for details

Hello there 'I am reading a XML file , and looking to expose the hidden attribute as you can see in the Pic I tried attribute expose and list exploder but it didn't work

Hello,I have please a question about the "CombineOnAttribute" parameter for LineCombiner (FME 2019 Beta)Is the logical relation between selected attributes to combine on is "AND" or "OR". In other words, 2 lines will be combined if they have same values for all selected attributes together or at least one common attribute ? Thank you very much.

Hi, I have some features that contain the especific date, but in others features from the same file no have date value...How I replicate the date for all by fme_basename? I´m reading many files at once and dates are different for each file.Thank´s

Hi FME users, I have 2 streams feature classes(points) I would like to calculate the distance between each point to it relevant point (based on key field)  Ex : point A from the first feature class can be connected to multipoint from the other feature class, we have a feature name attribute for the point A in both features.

Hi all,I want to remove duplicate rows, keep only one.For example: An Vân 2 rows, keep only row. Could you tell me how to make it? Thank you

I am dealing with a line dataset that has features that all have different orientations, but all of them are connected to another linear feature. I am looking to change the orientation of the blue lines (photo below) so the orientation end point will be at the red line. The orientor transformer looks to be the best option, but i am not sure how to filter out the lines that the orientation is opposite, Any suggestions?   

Good morning,I have two tables, being extracted from an azure database. I am using the inner join command, however when it runs, it repeats and processes the features from one table the same number of features in the other table. For Example: Table A has 10 features and Table B has 11. When I run the SQLCreator Table A gets repeated 11 times (# of features Table B has). Is there a way to prevent this. Below is a screenshot of the SQLCreator.Thanks,David

I have noticed in FME 2018.0 and 2019b that the Microsoft SQL Server Non-Spatial writer only raises a warning when a feature is not written due to (for example) NULL value constraints.Personally I think that an error should be raised in any situation where a feature is not written to the database.Despite the warning, the workspace continuous normally and the feature even shows up in the features written summary.

I'm having trouble building my DWG file again. I've done tests in several ways, using FeatureWriter, using template file, but nothing helped me.Follows my workspace:   I just need to read the file and write it to DWG identical to the input file. See the differences in the images below: the input filethe output fileinputoutputinput

I am attempting to generate an html report via fme. Attached is a screenshot that shows the existing report that I've been able to generate with some of my desired modifications. I've also uploaded my fme model here: I'm trying to do 3 things with the report: 1. Color the text based on the content (if water data, color blue, if sewer data color green, etc...)2. Right-Align the population column on right side.3. Possibly adjust column widths. I've attempted to do this with the Custom HTML option in the HTMLReportGenerator, but had no success as I am not familiar with how fme references the actual data that is then exposed onto the report. Please help... :)

Thanks for the help in advance and happy holidays everyone.I am running the SystemCaller to undertake a particular task, it takes a while and FME runs it multiple times.The issues is I need FME to continue only after system caller has completely finished all the tasks.Can someone please suggest a work around, I have tried a counter but not having much luck with it at the moment.Thank youOliver

I have these features that I would like to transform and group into JSON output:package_idpackage_nameresource_nameresource_url1Package AResource 1http://www.resource-A1.com1Package AResource 2http://www.resource-A2.com1Package AResource 3http://www.resource-A3.com2Package BResource 1http://www.resource-B1.com2Package BResource 2http://www.resource-B2.com3Package CResource 1http://www.resource-C1.com3Package CResource 2

I work in local government and I am constructing a BI report using telematics data from refuse collection vehicles combined with weighbridge data from our waste disposal partners to analyse waste composition from residential waste in specific geographic locations.Our telematics system on our refuse collection fleet can be used to generate reports on the location of every lifted residential bin including datetime, vehicle registration and the WGS84 latitude and longitude.Vehicles are unloaded at the waste disposal plant several times a day, providing a ticket number along with the weight, type and quality of the individual load which we receive as via email on a regular basis. This includes the vehicle registration and the datetime.Complicating matters; vehicles are often swapped between teams depending on queues and breakdowns, can assist other times and vice versa, and spare vehicles are sometimes used. This means it is not adequate to simply match the daily su

I hope this isn't a repost - I tried posting once, but something went wrong.I am trying to read data from a CouchDB database, and would like to be able to use a view with startkey and endkey to limit the documents that are read. I have done some digging around and can't find a way to do this with the built-in CouchDB reader. I can do it with the HTTPCaller, but then have to use a JSONFragmenter to get the documents into individual features, and manually set attributes to be exposed (this is the most cumbersome part).Am I missing something, or is using the Couch HTTP API and the HTTPCaller the way this needs to be done? 

dear all, I need to create a space where i can upload drone images or videos, then geotag (if automated better) and later search them. do you have some example of something like this? regards.

I have some large processes running on FME Server and they seem to be leaving a lot of files hanging around in the "FME_TEMP" location (Users\\s_fmesrv\\appdata\\local\\temp). Ended up with about 40GB in there in a week, filled up the hard drive, crashed the machine.  Anyone have a good solution for automatically purging this folder? The solutions on FMEpedia seem to be manual processes geared to Workbench on a desktop...

Hi.I have 2 fetching administrative areas one inside the other. For that, I am having servers to get the data.When I am running anyone query in SQLCreator, it is working fine separately, but while using union the output is only from the first query. Any comment on this about where am I going wrong. --admin area 0a(select na.*,aa.geom, aa.name as A09, feat_type, a9_admin_id, a8_admin_id, a7_admin_id,a6_admin_id, a5_admin_id, a4_admin_id, a3_admin_id, a2_admin_id, a1_admin_id from x.mnr_admin_area aajoin x.mnr_admin_area2nameset an on aa.a9_admin_id = an.admin_area_idjoin x.mnr_nameset2name nm on an.nameset_id = nm.nameset_idjoin x.mnr_name na on nm.name_id = na.name_idwhere aa.country='IND' Â and Â na.iso_lang_code='ENG' and aa.feat_type = '112')union--admin area 0b(select na.*,aa.geom, aa.name as A08, feat_type, a9_admin_id, a8_admin_id, a7_admin_id,a6_admin_id, a5_admin_id, a4_admin_id, a3_admin_id, a2_admin_i

Hi all,I have 3 folder 2016, 2017, 2018. Each folder have 46 images .TIF format.In each folder, for one day have 3 images tif and split to _p1,_p2,_p3 and the date is same.My goal sort images in each folder and execute raster calculate the first image of each folder to other first folder and then create folder based on squence 1,2,3....I describe in here. Could you tell me how to the way make model ? Thank you

Hi,From the documentation on https://playground.fmeserver.com/ I have made a web interface where my goal is to initiate a workspace on the server and then use the json output in a javascript foldertree. I have one published parameter that specifies the ID of the webfolder I want to re-create as json. Everything works as can use the json output directly by saving it as a file set is a source in my foldertree but I can't get it to work when using the streaming service and using the the URL as source. I specifically tried using the streaming service as in the https://playground.fmeserver.com/javascript/data-visualization/mapbox/ example but the data isn't read from the foldertree javascript.   I lack the basic programming insight but I suspect I will need to use jsonp to

I'm running an FME Cloud with the Forgot Password option switched on. When a user uses that they get an email with a link to reset the password but when clicking that link they get a page saying "Could not connect to FME Core.Please ensure that it is running."And yes, it is in fact running just fine. Anybody else get this too? Did I maybe misconfigure it? The SMTP settings are good because the emails are being sent. The Public URL is set to https://[servername]-red-geographics.fmecloud.com/fmeserver

HI. I have a shapefile of Dissolved points and another shapefile of a polygon. Now I want to clip the polygon overlapping on the point file. Please note that the whole polygon area does not cover all the dissolved points.

Is it possible to create minimum bounding triangles for groups of points using FME desktop?