Data

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?

Hello,Is possible to inform or write jpeg_exif_xresolution and jpeg_exif_yresolution header in a jpg image created with FME Server?Thanks in advance 

I have 2 buildings, each with its own IFC file and I am able to convert them individually from IFC to LOD2 CityGml.Those 2 buildings are part of the same neighborhood, and I would like to have them combined in a single CityGML file.I have basically combined the 2 individual workbenches in a new workbench so the transformation run in parallel, to have 2 building features in a single GityGml file. A cityGML is generated which is 6000KB but there is no geometry.Anyone know how to fix that?

I have read this: https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.htmlAnd tried to fix it with all these steps, with no luck. UPDATE: With respect to workspaces these was updated from FME Server 2015.1.3.1 - Build 15573 - win64 to FME Server 2016.1.2.1 - Build 16674 - win642017-01-24 20:12:10|   0.1|  0.0|INFORM|FME Configuration: Using Named Connection values from 'XXX' for MSSQL_ADO_12017-01-24 20:12:10|   0.1|  0.0|INFORM|Creating reader for format: Microsoft SQL Server Non-Spatial2017-01-24 20:12:10|   0.1|  0.0|INFORM|Trying to find a DYNAMIC plugin for reader named `MSSQL_ADO'2017-01-24 20:12:10|   0.1|  0.0|INFORM|FME API version of module 'MSSQL_ADO' matches current internal version (3.8 20160224)2017-01-24 20:12:10|   0.1|  0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Read 2 DEF line(s).  Found 9 attribute(s)2017-01-24 20:12:10|   0.1|  0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Opening `XXX' for read operation2017-01-

I have a point cloud of a surface which has been derived from pix4d photgrammetry software. There is a large amount of noise and outlying points generated, which when triangulating a surface creates a bumpy surface. These point clouds are for relatively flat ground surfaces. Unfortunately pix4d does not have an easy solution to remove of such outlying pointsTo help smooth the point cloud and the resultant end data, is there a way to filter the point cloud to remove these outliers if i know the maximum slope of the surface? Or if this is not possible that the elevation difference between points is too large? Thanks.

I want to create (user) parameters for selecting a table (feature type) from an Esri geodatabase (gdb). So I would like to see a dialog which asks for an gdb and afterwards show a list with all the feature types (tables) from the selected gdb.How to do so? I am able to create a parameter for selecting a gdb but how to add a list of the feature types which are part of the gdb and select one? Any idea?Best regards,Frank

refid|type|latitude|longitude|source|add_dt|pressure_sys|situs_addr|situs_frac|situs_pre|situs_stree|situs_suff|situs_post|situs_suit|situs_buil|situs_juri|situs_zip|chg_dt 344122-1|SVCPT|32.7655812974478|-117.032253396029|GIS|1/25/2017|LM, LG, SV Gravity - 656|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset 302698-1|SVCPT|32.7659789784174|-117.023796522145|GIS|1/25/2017|LM, LG, SV Gravity - 656|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset 355862-1|SVCPT|32.7566364143178|-117.014639927890|GIS|1/25/2017|LM, LG, SV Gravity - 656|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset 302723-1|SVCPT|32.7641617522751|-117.023556288137|GIS|1/25/2017|LM, LG, SV Gravity - 656|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset|unset

Hi,my wb reads an ESRI-SDE Feature-Dataset-->Feature-Class --> table. I want to write this table as a gdb. (ESRI-SDE-Reader and GDB-Writer) But the gdb has the same structure like the source:GDB-Name--> Feature Class -->table. Is their any Chance to write the gdb with following structure:GDB-name--> table?Thanks for helpBarbara

Hi, I am currently trying FME2017 Beta and especially the 3D-Tiles. My Problem is that I am trying to generate a simple box in the middle of brussel and trying to view it in Cesium. I see Cesium loading the tileset file and the tile, but nothing is shown in the viewer.Is there any example of a working model + Cesium viewer to view the data?Thanks.Vincent.

Hi All, I have ESRI shape files with polygon geometry type, i need to extract the text from them and need to import the text to Smallwrold. In Smallwrold, the geometry type is annotation, i'm using the transformer "Label Point Re placer", features are imported to Smallworld, but when trying navigate to a feature, getting message "The selected object do not have the geometry in the map" in smallworld. Please suggest how to import text from Shape files to Smallwrold. Thanks in advance. @takashi @itay

Hello  I have a GM-access-table that I want to import to oracle. Instead of the original auto-number ID, I want to use an UUID in oracle, which I generate with the UUIDGenerator, and save it in a raw-type field.  How do I do this, as in FME raw-type columns are not shown?  Thanks in advance! Vera

Hi,I'm trying to do some reporting in Excel using FME and an Excel file as a template.The template is quite simple with some formatted fields, a logo, few combined fields.The Excel writer writes the data after the formatted rows (B12).Everything works fine, until I add a formula in the field D11 (as simple as =Sum(D12;D100)). Then, Excel throws an exception when loading the generated files and the formatted fields are no longer formatted.The exceptions I get is in french but could translated to : "Sorry... We found a problem in the file "xxxxx.xlsx" but we can try to recover data if the file is safe". After a data recovery, the data is there, the sum is calculated, but the fields are not formatted anymore (probably because of the recovery...), the logo is gone. The recovery log is stating that the is a major failure at Line 1, Col 0. Nothing more.Any ideas on what can cause this behavior ?Thanks for your help.RegardsPhilippe

The questions speaks for itself. If I simply connect a shp writer the output has no geometry

Ok, so this is the situation:I have a workspace that is completely functioning in FME Desktop. In this workspace, a lot of writers are implemented, creating folders and output. Some examples:- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/Validation/Validation.html (for a html writer)- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/Delta/ (for a esri shape writer)- $(FME_SHAREDRESOURCE_DATA)/output/$(DateString)/output.gdb (for a file geodatabase writer)De folder "output" already exists, but the folder "$(DateString)" not yet. The DateString is made in a small Private Parameter script.In FME Desktop, this results in all my folders being created and files being made exactly how I want it. However, when I do this using FME Server, only my geodatabase writer seems to write anything (and often not all the features that should be in it!) in my output folder. The other data is only available as a downloadlink after the run (which is not how I need it to be). Any idea h

I have combined a las file with a aerial photo using the PointCloudOnRasterComponentSetter and would like to save the result as a 3d pdf. The results looks great in the data inspector but now i´d like to share it.What would be the best method?