Data

I have a question. I make a Projekt in FME Desktop and I want that a one of the Datareaders starts after a writer has finished his work. Is this possible? I need this, because the writer updated a table from the Reader

Hi,I am trying to query 40 Oracle Spatial tables within a bounding area using the FeatureReader where each table has multiple geometries but not all geometries have spatial indexes. Unfortunately only the geometries I am going to query have the indexes so I can't use the multiple geometries option. Adding the additional indexes is a lot of work for the complete electric and gas databases.It seems that with the FeatureReader transformer you cannot use Oracle Spatial Object and also specify the geometry column. Is this still correct or have I missed something? I'm using version 2015.0 as our FME Server is 2015.0 but I've also checked in version 2016.I see this post in 2013 but this is a lot of work as I have 40 tables with multiple geometries and I need information such as the oracle_orientation. I think I will have to resort to the WorkspaceRunner and somehow pass the AOI geometry into the second workspace as described here.Thanks,Annette

Hi,How can I best accomplish reading a generic (any) XML file without specifying any initial root tags etc. ?I.e. return the whole XML document as a single fragment.Do I need to create some special XRS or xfMap templates, or can it be accomplished with the simpler Feature Paths ?Cheers

Greetings!I would like to set an attribute of my feature as the value returned by a pl/pgsql function. Currently, I use the SQLExecutor for every feature. It's much slower than using the pl/pgsql function in the INSERT.The expected result would be that FME produce the following insert statement.INSERT INTO my_table VALUES (17, 'abc', MY_FUNCTION(17));I'm using fme build 16716 with postgreql version 9.5.Kind regards,Jean-Denis

Hello,I have a non spatial data set in Excel format.For each row i have to split the data into two tables.First I need to enter some of the attributes in the "Property" table and then into "Contact" table."Contact" table contains the primary key of Property in "PropertyId" column as Foreign key.To insert the data successfully I need to have the id of the row inserted in Property Table and the store it in the Contact table.Is there a way to achieve this functionality with FME Desktop?Thank in advance.

Hello all,Last year i posted a question here on reading a descripton of a kml-file. This is a new question with the same background: reading a kml-file that contains data from an app (BuitenBeter) that people can use to inform the city about all kinds of things in public space. Some of these kml-files, like the one attached, have a &-character in the kml-description that results in an error: XML Parser error: 'Error in input dataset:'file...MOR 020816-140816.kml' line:1 column:58047 message:expected entity name for reference'. The script continues with the next file, but this file is now only partially read. I get the same (kind of) error when using the XML and KML reader and using FME versions 2014 en 2016. The error refers to a &-character that can be found in some descriptions. Till now i replaced this &-character manually, but now i'm working on a automatic script for which it is important to get a 'real' solution to this problem.So, does an

Hello,I execute query on my postgresdb to get result as a json: description is here http://rextester.com/ZULI42144It looks nice but now I would like to convert it to xml. I decided to use fme to query postgres just like in example and now I have noe idea how to convert the result to xml and write it to file.Also talking about json which I also need (I need result in JSON and XML format) what I achieved is that I simply executed postgres query end then wrote results using simple text writer so I suppose that fme doesnt really know that the query result is a JSON :)Structure and content of the database is as described here:http://rextester.com/ZULI42144and there is sql that is used in below sqlExecutorThis is prototype of my workspace that I have right now and the question is how to format nice xml from this list exploder (if its possible).And here is output of the logs. Of course in the result xml I would like to have structure ike <person>...<car>...<wheel>...</whe

The translation is running and writing records to Oracle. But suddenly i get an Oracle error ORA-12592 or ORA-03135 and the translation stops.The database is online.What can cause this problem.

You can use FME Server to stream a KMZ-file to a Google Earth instance. However, can you also do the reverse? Ie get FME Desktop or FME Server to Record data from a KMZ-file-stream?

I have an object that has that has two Point styles. I can translate point styles into cells in Microstation but I would like to generate a line that will go between the two cells. To be honest I am not sure where to even start. Any help would be appriciated

In a previous question I asked how to translate a custom line style from one Microstation file to another and the answer was add the lines with the custom styles to the seed file save it delete the lines and don't compress. It worked brilliantly. Now I need to translate from Smallworld into Microstation and have a chain that I am translating from Smallworld use a custom line style in Microstation. I tried using the same seed file as before and the same methodology or at least as close as I could when creating the fmw file and it did not work. I guess the question is, can I create a line in Microstation using a custom line style from a Smallworld chain object? and if so how?Any help would be appretiatedThanksRobyn

Good morning,I have a FME Server job that runs a python caller. Part of this python caller is to run some sql in a postgres database. When I look in my fme job log I can see the step being called but I don't see any logging from the sql. Is it possible to add the logging from the postgres log into the fme log?

Someone have idea? why my WebService give error 422 (Unprocessable Entity) when i use reader GML? If i use "Text File", my WebService works!?!?!?

Hi all,I am updating a cell of an Excel sheet using a SQLExecutor. The update of the cell works fine but I have a formula links to this cell that doesn't update.I check in Excel and the Woorkbook Calculation parameter is set to automatic.As I have more than 1000 formulas, I don't want to clik on them and press enter (the only solution I found for now) to update them.I put in attached the workspace.

Hi I'm not very familiar with ESRI software. I have created an update/insert process on a Layer I created in AGOL and I noticed even though I specifed 500 char for a field in FME writer, it is truncated to 254 when written to AGOL. Does AGOL adhere to the shp limitations of 254 char max or have I missed something ? ThanksCiara

I'm a Minecraft user that would like to model my city including some buildings.Unfortunately I don't know the type of file that include this kind of 3d coordinates and so I'm asking here. If I'm looking for a dataset that has information about the GPS location of my territory but including also 3d information about the buildings of my city which format I should look for ?Thanks!Gavin

Can I use something similar to update and ERSI File Geodatabase. I am trying to use the fme_db_operation but no data is being updated

I need to create heat maps on an hourly basis using FME. Is there a third party service I can call from FME or a technique that works well?

I'm using the Esri Geodatabase (ArcSDE Geodb) writer to try to inset features into an existing feature class but when I do I get a fatal error saying that the table already exists ('-2147216061'). The error text in the log begins, "An error occurred while attempting to create the feature class...". Why is it trying to re-create the feature class when it knows that I imported it when I added the writer?_________________________________________________Writer Mode: UPDATE (Tested INSERT and got same results)Transaction Type: TransactionsFeature Class Settings - Drop Table: No / Truncate Table: YesFME: 2016.1.2.1ArcGIS: 10.3.1SDE Database: 10.4.0 (non-versioned)__________________________________________________

Hi there,  i have a CityGML writer which works perfect and writes Lod0FootPrint's for buildings. However the generic attributes attached to the buildings are not written completely. The writer is just writing one generic attribute and is ignoring the other ones. What do i have to do? I enbaled the "Include Generic Attributes as Feature Types" option!  Thx in advance  Thomas

Hello There we build a service to doeload data direct from the Data base , some time the user cear a new view or table that represent layer we in the request we will send the table name as parameter but worksapce need to scan the availability of that table each time the request commes and complet the process for the down load , this way we dont have to predefine the table in the work sapce in advance Any idea how we acheive that

I am trying to figure out a way to update the schema of a writer after changes are made to the schema of a reader. In this case, there are no transformers, just a reader pointing directly to a writer. The name on the writer is different from the reader but that is the only difference. Occasionally a field length will change on the reader or a new field is added to the reader. I can bring those changes into the workspace by updating the reader, and I am looking for a way for the change attributes of the writer if the reader changes.

I have managed so far to extract a bunch of features from the output of a HttpCaller. All features are meant to be linestrings. In an attribute, conveniently called Linestring there is a list of coordinates, for example: 52.1626086 4.5000322 52.1632634 4.5000649 52.1633422 4.4997202 52.1634249 4.4993502 52.1634390 4.4993159.To the best of my knowledge, I can use a GeometryReplacer that is pointed towards the attribute Linestring and has as encoding GML. Which should result in linestring geometries. However the conversion fails, without any noticable messages in the log. Does anybody have any suggestions?Thanks in advance

Hello,please, I just wanna ask, if FME Desktop is able to generate SQL update script for ORACLE database, e.g. in sql format?Example:UPDATE sampleSET band='CCC'WHERE fid=123456Thank You for tips!Lubo

I have an FGDB feature class which includes a "DBOperation" attribute with values of INSERT, UPDATE, or DELETE. I want to assign these to fme_db_operation but when I do this in an AttributeCreator, it gets changed to...<at>Value<openparen>DBOperation<closeparen>I've changed the AtrributeCreator to Conditional Value which seems to be happier.Has anyone else had this experience?