Transformers

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 fileinputoutputinputoutput Thank´s

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 2http://www.resource-C2.com3Package CResource 3http://www.resource-C3.com4Package DResource 1http://www.resource-D1.com The resulting dataset should consist of 4 features, one feature for each package. For each feature or package I need an attribute containing the package data in JSON format. For example the value of the JSON attribute for first feature should be:{  "id" : "1",   "name" : "Package A",  "resources" : [                  {"name" : "Resource 1", "url" : "http://www.resource-A1.com"},                  {"name" : "Resource 2", "url" : "http://www.resource-A2.com

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 summary total of bin lifts

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_id, a1_admin_id from x.mnr_admin_area aajoin x.mnr_admin_area2nameset an on a

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 make this work? Or is there a better way to do this overall?   Thanks!  /Jacob

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?

Hello,i have an issue with the creation of autocad blocks and object data.Everything has been created as i wanted: - correct autocad layer and correct OD tabelname.But every block itself receives also object data, i don't want this to happen.the workbench i use is very basic, just an attributevaluemapper to get a blockname for every attributevalue, so i fill in (autocad_entity = autocad_insert // autocad_block_name=<blockname from template>, autocad_color and autocad_layer)How can i prevent the "2nd OD" to be created? (on older workbenches i've done exactly the same but there this issue doesn't occur)Thanks,

Hi all/season greetings, I am trying to figure if this is best to use SQL or FME.I have two excel files which look like this below. I want to join the tables together and then produce a extra column based on the changes column. The join bit looks fine.The next step is the Extra column should be created based on if the changes column either contains a value or not. If it does then it spits a output and if it does not it also does. Only issue i am unable to how to get logic so when you join them based on the record number, you then base the 'extra column' on the changes column being populated with a value.Description of extra columnExtra Column Title = Status - will be the name of the column.It then should be able work out based on record number if the changes column has a value in it. If it is empty then the output to that column should be 'not completed' and if it does have a comment then it should come up as 'completed'. So far my flow is:Excel --> FeatureMe

Hi,I'm trying to combine two data streams based on keywords. (chain)   How can I do this? Thanks, Ed  

i dont know how do it, i see some discussion here but i dont know what i do wrong.the input the worckbench

Hi. I have a multipoint shape file of Dissolved points on the basis of locality. I want these points to be enveloped with the polygon on the basis of the locality.

Hi All,   I am currently trying to extract links from an HTML page, but it has them embedded inside a javascript toggle. The current workflow I have used in the past uses the HTTPCaller, then uses the HTML extractor to pull out any links using: CCS Selector = a[href] and Tag Part/HTML Attribute = href. It then uses the ListExploder to put all the links into a table. The problem I am running into is that on this page the links I need to pull out are inside a link that is <a href="javascript:toggleObj.()>. When I look at the HTML after the caller it does not show any of the links that are inside of that toggle. Anyone have any ideas how to pull these out? I have attached a couple images to illustrate the problem.   Thanks in advance! -Adrian  Example of the link I need to pull out and concatenate: HTMLExtractor:

I would like to use the Tiler transformer to create 100x100m tiles. How do I specify this? They only size option I see is listed as "ground units".

i need transfomer to gdb with raster to ecw. and i need pass from RGB to Grey.

I have an AttributeCreator that is meant to create a new attribute called "regDate" with the value:@DateTimeParse(@Value(supByRegPlanDate), %Es) The output for regDate is the string: @DateTimeParse(1543293100000, %Es)However, I am expecting an output similar to: 20181127043140Any suggestions why the output is showing the expression that had obtained the value from the feature, but, not created a DateTime?