Data

I'm having issues running a workbench on FME Server which publishes to ArcGIS Online.  It appears to be an issue with the authentication in ArcGIS Online. I authenticate my Web Connection to ArcGIS Online, and publish the job to FME Server where it shows that the connection is authenticated/successful. If I run the job immediately, it is successful but it appears the connection is broken if I check again in a few hours. The green tick disappears and the job will fail if I try to run it.  Is there a step I'm missing to allow FME Server and ArcGIS Online to authenticate with each other? It seems to me as though the token is checked out when I publish the job immediately, and is then revoked by the next time the job is scheduled (daily). 

The behavior of File Copy writer reported in this question seems to be a defect of the current version of FME.filecopy writer creating empty folder in same location as fmw workspaceCould you please check this?

I am trying to import data from GTECH data base into a File Geodatabe. when I used the Oracle Spatial Relational Reader , I get only two tables our of hundreds of tables. so I switched to using the Oracle Spatial Object. when I use it I get more tables showing and I am able to import them. however, there are many tables do not show on the table list in the reader though. what would be the reason behind that?

I am trying in many ways to convert an SDE raster dataset into a PostGIS raster table, all I need to do is simply copy the table and its content without any manipulation in terms of data or schema. The native table is in SQLServer and it has only 1 record. I tried in many ways.Using the appropriate readers writers (SDE => PostGIS Raster). it copies only a non relevant schema with no dataUsed the native SQL Server reader (Spatial SQL Server => PostGIS Raster), it reads the feature but when it comes to write it says Failed to obtain raster from feature. Only features with raster geometry are expected. Both with Dynamic and automatic schema definition. Nothing just a schema with empty fields is created.I tried to use SQLCreator and feature reader . the features are read of from the native SQL Server but when it comes to write, again just empty unwanted fields.All I would like to do is to recreate the same exact table, schema and data from a SQL server table that contains the raster

Hello all,I am interested in changed the output format of the entire GeoJSON document. I am converting an ESRI shapefile into a GeoJSON file and my output from that is unreadable in a platform i am using. Is there a way, manually if needed, to create a layout that the file will fit to?

I have created a SQL Server in in Microsoft Azure with a database containing a table with of int, float, varchar and datetime data types.I have a workbench (2017.1) that is using a FeatureReader and the Microsoft Azure SQL Database Non-Spatial to read data from Azure SQL Server and write to a shapefile.his works great in desktop, however when I publish this to FME Cloud I get the below error.Module 'MSSQL_AZURE_SPATIAL' is unavailable for use with this FME editionI know FME Cloud does not run Microsoft ServerIs there a way to read Azure SQL Server database tables in FME Cloud?

I'm trying to create a connection to my Microsoft SQL Server database while setting the connection parameter trustServerCertificate=true. But I see this in my log file:Creating connection using connection string 'jdbc:sqlserver://********' and properties '{integratedSecurity=false, trustServerCertificate=false, user=***, password=************, applicationName=Safe Software FME, database=******, encrypt=true}Is there a way to set this to true?

When trying to connect to an ArcGIS Online Reader, it fails to connect. I'm running 2017.1.1 I can however connect manually through the web browser and using ArcMap. Is the something added I need to do like configure a proxy?

Hello,I am importing multiple DXF files into Smallworld from DXF files created from an old Trimble unit.The DXF files will always have a unique name but can be brought in as a single reader. Id like to know if there is a way to get a remarks field to fill by the unique DXF file for each of the points.If I make the field populate by the $(SourceDataset_ACAD) parameter it brings in whole directory path which is not needed.Anyone have any suggestions?Thanks in advance.Savas

When playing around with FME 2017 today on a new project, we noticed that attaching an sde writer to a workflow dramatically slows down the reader. Has anyone else noticed this issue occur? Worth noting is that we aren't using versioning or transactions (transaction type = 'none') and the only reason we are using the GEODATABASE_SDE writer is because we need to write esri's ST geometry.Writing to Inspector: FME Session Duration: 16.5 seconds. (CPU: 11.1s user, 1.6s system)Writing to SDE: FME Session Duration: 2 minutes 6.0 seconds. (CPU: 51.0s user, 2.5s system)Since Oracle writers work fast and all we need is the esri ST geometry type, we were thinking about trying to hack together a solution where we could trick FME into writing the point geometry out in the expected format ie: SDE.ST_GEOMETRY(1,1,-10106993.68204,5190612.4770125,-10106993.68204,5190612.4770125,0,0,NULL,NULL,0,0,300041,(BLOB))

when I set coordinate system in FME it can't translate into gml file and can't set urn as well?@david_r

Hi community.We have a client which for a long time has been using SDE/Legacy writer in a (in my world) complex FME workspace which they have written in-house. The workspace has several problems after upgrading to their environment to FME 2017, ArcGIS 10.5, Oracle 11g. The workspace will run on FME Server.The db has, 43 tables, 54 relationship classes, 8 featureclasses. In the database the 8 featureclasses has a field which is defined as Esri "Global ID" and 26 of the tables has an "Global Id" field. As they previously have written with Esri Legacy they have prepopulated the "Global ID" fields and used them as foreign keys in other tables (as GUID datatype).My understanding is for ArcGIS 10.5 (and later):- Legacy/SDE30 writer is not supported (?)- Alternatively using Esri Geodatabase (ArcSDE Geodb) writer one can not prepopulate a field with the "Global ID" datatype using the UUID or GUID transformersThis leads to my conclusion:- the workspace is

Hello!  I like to read line geometry from a PostGIS DB and save it to an ESRI File GDB. When I check the translation via Inspector everything looks ok but when I save it to the file GDB the geometry suddenly looks very generalized. The same translation to shapefile works just fine. Any idea what I'm doing wrong? Thank you for your help.

I have an Esri Geodatabase (ArcSDE Geodb) writer that takes 50 minutes to truncate a versioned feature class with 70,000 records.The transaction type on the writer is set to Versioned Edit Session and Features per Transaction set to 5,000.Any ideas of how to speed this up?

Hi all,I am trying to write a task that simply clips an ERS file based on a featureclass in a file geodatabase.I have successfully written it with hardcoded locations in FME workbench, however the initial reader is a file geodatabase so when you import the .FMW into a GP toolbox the input parameter is the FGDB.Anyone know how you can set up a parameter in FME to allow the featureclass to added instead so the GP tool can be used to select the feature class used for the clip?Thanks in advance,Gareth

Hi all,I have a LAS file containing duplicated points (same time, same X, same Y, same Z...). I want to remove duplicates and keep only one point.What is the best way to do this?Thanks

I'm writing a custom format reader to read our custom point cloud format. The sdk is not clear on how to add points to a point cloud. I only have 4 components x, y, z & intensity.

Hello!TLDR; My ESRISHAPE readers don't fetch schemas from all my source tables.I have a workspace with multiple ESRISHAPE readers, each of which are reading its own separate ZIP archive.The readers are using Merge Feature Type (*) to allow all Shape files in each archive to be read.I'm writing all these Shape files to a dynamic MSSQL_SPATIAL writer using "fme_feature_type" as Schema Definition Name. Most Shape files have copies (containing data from separate geographic regions) in each source archive. Their region suffix is ignored so they can be written to the same destination tables.It goes something like this:Reader1 The archive contains the tables: Table_A_1Table_B_1Table_C_1The reader fetches the schemas of all the tables in the first archive, logging: "Reader `ESRISHAPE_1' of type `ESRISHAPE' provided schema for types: Table_A_1,Table_B_1,Table_C_1"Reader2 The archive contains the tables: Table_A_2Table_B_2Table_C_2Table_D_2The reader seems to

Hello,  I'm attempting to geotag photos with FME Desktop by writing coordinates to the jpgs with an AttributeCreator.  The following headers have been attempted with no luck: jpeg_exif_gpslatitude jpeg_exif_gpslatitude jpeg_exif_gpsmapdatum etc... which is how the data appears in the data inspector with a properly geotagged photo. The tag names from http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/GPS.html were also attempted with no luck.  The proper data types were also considered.  Any idea of how to write gps EXIF data to jpg?  I know its possible with the exiftool and other third party apps but I'd like to keep it all within one workbench, without calling any other applications.  Thanks,  John 

Hi,  I have this workspace to add a geotag to a jpeg, based on a GARMIN glo GPS logger. I merge the GPS data with the jpeg by the date. When I take a look at the inspector merging seems to go well. But there is no exif information in the created jpeg (no original exif info and no latitude, longitude and altitude info). Anyone can help? I am new to FME.  Best, J. 

Dear users, I need to convert polygons from an ESRI filebased geodatabase to AutoCAD DWG. Unfortunately FME creates blocks for all polygons that have holes. My question is: can I prevent FME from doing this or is this absolutely necessary when using the AutoCAD file Format? Thank you very much in advance.

HiI'm currently transforming Oracle Spatial data to AutoCAD DWG format, i'm reading nearly 30-32 Electrical assets and writing them into AutoCAD DWG writer, while viewing the .DWG Output files in AutoCAD software, i would like specific features like ROUTE Layer to be pushed back.I can do it manually in AutoCAD by going into the layers properties and selecting the specific Layers and sending it to back. But, I'm looking for an option in FME where i can send specific layers to back before writing onto AutoCAD DWG writer.So when view from AutoCAD software, we no need to perform the manual activity of pushing the specific layers to back on each and every DWG tiles. Any help would be appreciated.Regards, Anil

I have a database of hundreds of assessment results for utilities. In FME, I have taken the utility coordinates from the database, joined into lines, sorted into 'pass' or 'fail' and organised by utility owner. This all works. I have done a microstation DGN writer for each e.g. electric 'pass', electric 'fail', gas 'pass' etc etc. I have also tried putting all outputs into one DGN writer. Neither gave me what I needed which is to have individual layers for each result and utility type, which can be switched on and off. I can't do a fanout (I dont think) because I need to fanout by an attribute and I dont have the results as attributes, but rather as sorted/styled data. Would I need to use an AttributeCreator, or is there a way in the DGN writer to get multiple layers in the DGN based on my sorted data? Thanks.

Hello, I have result from FME, one shape file with many attributes that need to be written in one DB in Oracle that I have access to. I don't know how to connect that DB in FME and how to export attributes from this shp to that data base. Is there any way to do it?

Hello,  I am trying to do a rasterization of one DWG. After I run MapnikRasterizer, I get good results for most of the parameters but TEXT is problematic. In AutoCAD my text looks like this:But when I get a result text looks like this:I have tried setting almost all options in MapnikRasterizer. I have turned on in writers attributes "autocad_text_rotation" and tried to enable it in Mapnik, but I get an error. Does anybody have an idea how to preserve text same as in CAD?   Thank You in advance!