Data

I created a workbench to translate from Smallworld to GeoDatabase. In my Smallworld reader, I've specified to export the difference between a checkpoint (base) and an alternative. The difference between the alternative and the base (checkpoint) was 1 insert and 1 update. I used the AttributeCreator transformer to inspect the fmd_db_operation for insert, then insert the object into the GeoDatabase writer. However, it treat both records as insert and inserted both records (the insert & the update) into the GeoDatabase writer.

Hi all,I'm having a simple question about using the Red-Green-Blue (RGB-) values from point clouds. I have a LAS-file, which is already coloured and does display the RGB-values when I open the LAS-file in the FME Data Inspector. However, it seems impossible to use those values in any kind of calculator. I have a GIS-background, and I am used to a strict vector/raster data separation. It seems like a LAS-file is read as a raster, although it can contain multiple points per [xy]-value (e.g. walls, tree stems). I want to use the RGB-values that are already in de point properties. I see how I can keep them (e.g. PointCloudPropertyExtractor), but there seems to be no way to use these properties in any kind of calculation tool. The reason why I want to do this, is because I want to filter some points out based upon the ratio (R+G)/B.Suggestions are welcome :)Thanks in advance,Martin

Hi there. I have just started to use FME and am still learning this super capable software.I have a question regarding vtk (paraview data file, legacy format).I want to read vtk legacy files and convert to different 3D file format like 3D Tiles or IFC. And it is important to keep attributes when I convert vtk files. So far, I am converting vtk files to stl format using a python script but it won't keep attributes (or values). Do you think I can somehow convert vtk legacy files using FME? or Safe Software can somehow develop the reader for vtk legacy format?? I searched community postings but I couldn't find any answers.Thank you!

Hi,Is there any possibility to know the version of AutoCAD dwg file in which it is saved-in...Prtap

We are using following FME product:  FME(R) 2016.0.1.1 (20160224 - Build 16177 - WIN32)  We noticed that fields of type 'Lookup' are not supported. We get following error:  Microsoft SharePoint List Reader: The Field 'Gemeinde' of type 'Lookup' is currently not supported and will be excluded from the feature schema.Are there efforts underway to support fields of type 'Lookup' in Microsoft SharePoint List Reader in a future FME Desktop Version? Or is there a know workaround solving this problem?

I am having different dataset, that i have to convert to CityGML using ADEs. When am trying to do this, TRANSLATION WAS SUCCESSFUL is displayed (eg: 780 features transformed)BUt, when am viewing it in FME Data Inspector, "THERE IS NO GEOMETRY IN THIS VIEW" is shownI am using FME trail version. LOG TABLE shows this: "The 'FFS' reader was destroyed successfullyFailed to display the table contents due to the following error:----------------------------------------------------------------The floating license environment variable LM_LICENSE_FILE is defined, but is ignored by FME. To enable FME to use LM_LICENSE_FILE, set the environment variable FME_USE_LM_ENVIRONMENT to the value YES."please help me..----------------------------------------------------------------

I am using FME Server 2016.1.1 and FME Desktop 2016.1.3.1 to make a workspace for FME Server that will write a DXF/DWG file with the FeatureWriter transformer. I have to use a template DWG file to be able to write the correct linetypes and block names.But I have noticed that the FeatureWriter transformer, when running on FME Server, will simply ignore the template DWG file I have specified, and write in the log that "No AutoCAD Template file specified". However, running the same workspace, with the same parameters, locally on FME Desktop, the FeatureWriter transformer will use the template DWG file as expected.I have tried putting the template DWG file on the server's local C: drive with an absolute path, putting the template DWG file on a network share with an UNC path, and uploading the tempate DWG file when publishing the workspace. No matter what, the FeatureWriter transformer will always always ignore the template DWG file when running on FME Server.The only way I ha

Hi can anyone please help me to find an answer to keep autofitwidth to all columns in xlsx file

I am using SQL executor to get some data from Oracle SpatialData, Im getting the data but is not possible export/output in a shapefile or .gdb (Polylines)...Please advice

Hello!  It appears as though an email address can only be associated with a single FME Cloud account... I wanted to add a new user to an existing FME Cloud account, but because the user already began the process of opening a personal account (using the same email address), he was unable to join the company account. He had to first complete the registration of his own account, and then close it, before he could be added as a user to the company account. Has anyone else encountered this? Is there a way around this restriction?Thank you,Courtney

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