Best Answers

Good afternoonOnce again i find myself trying to do something relatively simple in FME and failing miserably. Frustrating doesn't come into it.I have an excel spreadsheet with multiple worksheets, each one populated with planning data.I would like to end up with one spreadsheet for each of the individual worksheets, so i can then use them for some other work with some spatial tables.When i add the excel writer, i'm given the option of all the worksheets, which i select, then attach them to the corresponding reader. But the resulting output spreadsheet contains all the worksheets in one worksheet.Have tried the fanout option to no avail.Have tried adding the source spreadsheet as a a workspace resource, with all the worksheets selected, again, to no availI'm sure this is a simple thing to do in FME, but it's currently beyond me. Any advice would be gratefully appreciatedregardsSimon Hume

Hello Everybody, I have seen some examples to open geodatabase metadata directly in FME using Feature Type Mode (metadata) but I cannot see this in FME 2016 version. I want to open the metadata of a SQL server based feature class/table's in FME and want to export it into our own metadata schema. Please guide me. Thanks

Hi, When I precise some attributes into a PostGIS SQLCreator (including the geometry) in the SQL request “SELECT id, geom FROM test”, FME doesn’t recognize the geometry. Its is only seen as attribute, but not the geometry of the feature. It only finds the geometry with “SELECT * FROM test”. Do you know what can cause this error ?

Hi guys,I'm trying some autocad text features formatting. So, I have a number of text features at their insertion coords. I want those to be formatted like they are aligned in some text editor and I want it in DWG output if possible. I have:100 200 390 420 210 333Of course, this is only a sketch. There can be up to 300-400 text feaures at their locations.I want them to be aligned like this:100200390420etc.Possibly in DWG format. If not possible, some other solution that can be copied to DWG is also an option.Thanks in advance.Best regards

Hello,I am trying to authorize a web connection to my Dropbox account on FME Server so that a file can be incrementally uploaded.In the Dropbox Developer portal, I created an app where I got my client id and client secret. As for my Redirect URI, I tried using http since my server is behind my network’s firewall, but it only let me use https. In my FME Server’s Web Connections, I updated my client information to match what my Dropbox app had. When I tried to authorize it, I got an error saying the site could not be reached.Is it because my URI is incorrect, and/or if there are other configurations that need to be done? My colleague mentioned that maybe we have to make the server public. I am not sure. Thanks!

HI, i am hoping someone is able to help me.I am building a html output and i am using the fanout expression to build individual html documents. My question is does the fanout expression need to have values from within the html content or can i use attributes from a attribute manager to set the fan out expression?hope that makes sense

I'm using the Cesium 3D Tiles Writer to export some CityGML data to Cesium. Although I can export and interact with entire buildings, I would like to model and interact with buildings as a hierarchy of individual parts (e.g. walls, roofs, etc.). The 3D tiles spec appears to support specifying such relations in the batch table (https://github.com/AnalyticalGraphicsInc/3d-tiles/tree/master/TileFormats/BatchTable#batch-table-hierarchy).I'm looking to achieve something similar to this: https://cesiumjs.org/Cesium/Apps/Sandcastle/index.html?src=3D%20Tiles%20Batch%20Table%20Hierarchy.html&label;=3D%20TilesI've looked and can't find any information on how to write this type of information to the tiles using FME. Does anyone know if this possible using FME? Are there any examples or documentation I could use?

I am just one week into FME (a friend recommended it to me)I want to loop through a 761,000 rows by 25 columns excel document, for the each rowcount columns with values>0 and store in a column called countfor the values > 0, add them and store in a new column called anim_locreturn the names of the column title that has values greater than zero and store in a column called anim_namesPlease how can i achieve these with FME.

Good morning.This week has been released the new INSPIRE validator:http://inspire-sandbox.jrc.ec.europa.eu/validatorThis tool allows you to validate a GML file.I have several GML that I got using the INSPIRE GML writer in FME. To validate them, I just checked them against the XSD provided by INSPIRE. That validation was always OK.But with the new validator I'm getting this error:cvc-elt.1.a: Cannot find the declaration of element 'gml:FeatureCollection'. I have attached a sample of my GML. There is a FeatureCollection tag...Does anyone know if I have to change something of the INSPIRE GML writer to build a proper FeatureCollection?Thanks!

Hi,I have multiple workspace files and publishing them to our FME Server is demanding too much time. Is it possible to published them through the command line or python? If so, how?Thanks

Hi,In my workspace I'm inserting through a FeatureWriter into MS SQL Table and I'm trying to cast a string to a datetime, but it doesn't seem to work.This is the format that I'm reading: dd/mm/YYYY and I'm trying to parse the attribute column in FME as this:@DateTimeParse(@Value(DATE_OF_BIRTH),%d/%m/%Y)But I'm getting this error from the console:2017-07-26 15:25:28| 162.1| 0.0|WARN |Table1_StudentUpdate_FeatureWriter_f2afd4cb_4a56_4aec_8f42_9e384693c40417: Failed to evaluate expression '@DateTimeParse(03/13/2010,%d/%m/%Y)'. Result is set to null.

My workflow is pretty easy, I drag and drop a CityGML file in the workbench and then add a CityGML writer and connect it. FME proudly tells me it wrote features, but when I open the file there's no geometry. Do I have to add a bunch of transformers?Variations tried on reader:- all features- single mergedVariations tried so far on writer (feature type definition):- all of themMore info:- the source CityGML file is fine and displays without errors in the inspector- no errors are reported during the translation

Apart from being able to connect to Oracle or SQL Server, is there any major difference between the express and distributed installation for FME Server

I am trying to combine roughly 50 different GTFS feeds (a feed is composed of 13 CSV/txt files) into ArcSDE using the spatial ETL tool. I need to update the stop_id field in each of the csv text files to continue the stop_id sequence that of the agency table in the SDE. Basically i need to remove and match the Stop id from the incoming feed to the stop id sequence in the SDE. I am very new to spatial ETL i have only been using it one day so please bear with me if i am not making much sense as this is very new to me

Hi,My customers upload .zip or .tar.gz files to our server, I have a CSV reader, when I set the url (https://mydomain.com/customer1.zip) of a zip file with only 1 file, FME server works fine.Now, a customer send us .tar.gz files with several files in it, for this spacific workspace I need to grab only one file form the package, there is a way to specify which will be the file in the url to process? I tried with https://mydomain.com/customer2.tar.gz\\students.txt with no luck, I manually convert to a zip file https://mydomain.com/customer2.zip\\students.txt but nothing works.ThanksVictorV

Dear all,I have a workbench for some data (feature) filtering inside and outside of some polygons. I'm stuck at final step where I need to remove duplicate features which are inside of one polygon. The problem is with this specific polygon where Duplicate filter is sending one feature that for sure doesn't have duplicate through DUPLICATE port while it should be unique. I've tried different polygon and different features and it worked fine but for this specific feature it's not working right. I've tried the MATCHER also and got the same result, it sent feature to the matched port while it should be not_matched. I've checked for all the possible differencies in attributes between this problematic feature and any else feature and didn't find anything different. The features are autocad_text_strings. I didn't expose any attributes.I hope someone can suggest some other solution or what to check for this specific feature? I can send data if necessary. Thanks

Hi Team,I have a simple example attached and it contain just a Reader and i would like to generate another shapefile.The problem is: the Writer ( using the transformer FeatureWriter ) needs contain one Attribute:@Value(De_Produto) I tested to get the value from the source attribute De_Produto configurating the Writer, but without success:How can i get the value attribute and transform the value this attribute as Attribute Name my Writer?Thanks in Advance,Danilo

Im trying to figure out everywhere a road intersects with another road and i want it to give me a table with all the roads plus all the names of roads they intersect.I have major roads, and I want to know all the major and smaller roads that intersect each major road (this will be a non-spatial table)I want my end user to select one road, and it will return all roads that crossed this major road's path.

Hi,I'm trying to join two tables using the FeatureMerger and I have enabled the Process Duplicate Supplier since my Suplier table has got more than one entry for each of the Requestor entries I'm trying to match. However, I'd like it to keep all duplications from the Supplier table so that the total Merged includes duplicate rows from the Supplier. Is there a way to achieve this?Thanks!

Hi, I am working in FME 2014. I am trying to create a workspace that will have a reader grab all xls files from one folder (with multiple schemas), re-project the xy coordinates to two new attributes (x, y), and export the data to multiple xls files based on file name and new projection. Before the workspace is run, the user must manipulate the xls files to have columns with original coordinate system and original x and y coordinates. The headings "Original_Coordinate_System" and "SourceX" and "SourceY" are the only common column names between all the excel files. When I run the workspace I get an error saying "Error fetching dynamic schema definitions from reader `XLSXR_1"Attached are two xls worksheets as an example, and two screenshots to show a portion of the script.Would anyone have any suggestions that I could try? Thanks in advance.

Hello, I have a query please. The attached table is a snapshot (fictional names etc used) of an Excel dataset of 10000 records, where employees of a company are each given a Card to access the office building, and this dataset logs their details each time they have entered the building, by swiping their card at the entrance door, in the past week.In the ideal world, every employee should have a unique "Employee Number" and also a unique "Card Number." So in this example, John Smith should have an "Employee Number" of 100, and a "Card Number" of 1. However, we can see that he also has a "Card Number" of 2 on two occasions he has entered the building, for whatever reason.Also, we can see that for Sarah Brown, her "Card Number" should indeed be 5, but for some reason, she has two "Employee Numbers" (400 and 500) when in fact she should just have one "Employee Number" of 400.What is the best way, using FME, tha

We are using FME server 2017.0. I am following this article https://s3.amazonaws.com/gitbook/Server-Admin-2017/ServerAdmin4Scalability/4.03.ChangingDatabaseProviderForFMEServerDatabase.html, chapeter 4 exercise 2 to change the FME database provider – from the default to, – not to a PostgreSQL, but to an Oracle12c database. I ran the Oracle scripts to create a FMESERVER user and installed the FME objects. After I changed the fmeCommonConfig.txt (see below) and restarted the FME server, I can not login the web UI using my previous logins. I can login admin/admin, but the contents are pretty much blank. I have no option to import the previously exported fsconfig file. I have to restore the original fmeCommonConfig.txt to go back the working FME server. Feel like I missed something here.fmeCommonConfig.txt: #------------------------------------------------------------------------------- # Database Connection #------------------------------------------------------------------------------- D

I have a file of 100+ polygons and need to find lines that exist outside of the polygon based on a join condition that links the line to the polygon.ie find me the lines in file x that exist outside of a polygon where line.shape not in/not entirely within polygon.shape and line.auth = polygon.authI'm a new FME user - I've experimented with both the spatial relator and the spatial filter. I don't know if I'm just using them incorrectly! any help appreciated!ThanksBaz

I'm using an RCaller within a workbench that's processing some reasonably large datasets. The R script I'm using works fine in R itself, and the workbench runs perfectly with a smaller test dataset. However with a full-size dataset I get the following error, approximately 30 seconds after the last feature enters the RCaller and the rscript.exe processes begin:RCaller(InlineQueryFactory): InlineQueryFactory encountered an error when starting R interpreter. Message was: Process operation timed outRunning with the same size dataset in RGui or RStudio, the processing I'm doing takes approximately 10 minutes. However the processing is by group and so I use the ddply package in parallel mode to split the processing across 10 cores, making the process take approximately 1 minute.I've transferred this over to the RCaller in FME, and it starts the 10 processes, but still times out after about 30 seconds. How can I use the RCaller to do work that takes more than 30 seconds to produce an output? 

FME 2017.0.1.1 (17291) 64-bit on Windows Server 2008 connecting to SQL Server 2012 on Windows Server 2012.MS SQL Server supports this type of update statement:update db.owner.mytableset field1 = ABC, field2 = XYZwhere primkey = 123I want to do the same thing with SQLExecutor thus:update db.owner.mytableset field1 = @Value(fieldA), field2 = @Value(fieldB)where primkey = @Value(uniqueid)However when I put this into the SQL Statement parameter, the cog on the transformer goes red i.e. something is wrong, but nothing is highlighted red in the transformer properties. Is this an FME bug, or do I need to write it differently?