Data

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 transformers

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,T

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!

The 32-bit installer for beta build 18254 is not working, see this question. Could somebody from Safe look into this?

Hi Team,Can you please let me know if FME can write data into SDE geodatabase or not.I need to automate spatial data creation process.My sde geodatabase is in Oracle. SDE/ESRI version is 9.3.1, Geometry storage is SDE binary (BLOB) and feature dataset has geometric network.Please share your expert views and any details which you can provide.Many ThanksManoj

Hi, I am currently using the AzureBlobUploader to try and uploading it to Microsoft Azure blob storage. At first, my workbench was working fine (it uploaded the files to blob storage) but after a few successful attempts, it no longer works? I now get an error [Errno 2] No such file or directory: u'C:\\\\Users\\\\aileen\\\\AppData\\\\Roaming\\\\Safe Software\\\\FME\\\\FME Store\\\\Transformers/New\\\\Missing_BT_links.csv' Any ideas on how to rectify this would be greatly appreciated. Thank you, Aileen

I'm testing my current workspaces in FME 2018 Beta and i'm getting a new warning from an Excel Writer. WARN |Excel Writer: Attribute xlsx_row_formatting is empty, no row formatting applied  It doesn't seem like this warning is anything to be concerned about but i'd like to make any changes possible to prevent it from showing up as many times as it does while running. I can't seem to locate the much documentation on the xlsx_row_formatting attribute, so i'm wondering, is there any way to populate it to prevent the warning? Thanks! 

I have a kml with the attributes 'kml_additional_files{0}.href' and 'kml_additional_files{0}.path' filled with filenames and -paths. I want to place the locations (points) as objects in a local database with the filename(s) in an attribute to these locations. But I can't find how to do this.I'm using FME desktop 2017.1