Data

Hi,I need to export data from an Arcfm db to a different db with no Arcfm on a regular basis, hence looking at using FME. Any suggestion?

I have the following FGDB as reader. It works in FME Desktop 2019.1 but will fail and get Arcobject error when published in FME server 2019.1. It looks like that FMEserver 2019 cannot handle space inside the file path. \\\\enervest\\shared\\ArcGIS\\GIS\\Geoscience Technology\\Raw Vendor Data\\Rextag\\Temp\\Rextag_Crude_Oil\\Rextag_Crude_Oil.gdb Received arcobject error when running the job on FME server: Unable to connect to the File Geodatabase at '\\\\enervest.net\\shared\\ArcGIS\\GIS\\Geoscience'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147024893'. The error message from ArcObjects is: {} This is not good since I have not seen this problem in FME 2018.

My company recently switched from ArcGIS Online to having Enterprise Portal and I haven't been able to connect in FME. I put the portal URL in and my username and password which work if I'm in ArcGIS pro or working in an internet browser but in the reader or writer it's coming back as invalid credentials error code from the server of 400. Has anyone else experienced this? I have tried all of the authentication types available.

Hi, I am currently facing an issues in which I cannot access objects within a AutoCAD file. The AutoCAD file contains 3D objects from Civil 3D that can be seen in AutoCAD with the object enabler plug-in from Autodesk. However, I cannot seem to be able to find the geometry or the features while reading the .dwg file using FME. My hypothesis is that FME does not recognize the content since it basically is unknown for a standard set up of AutoCAD. However, once the object enabler plug-in is installed, the content can be read in AutoCAD. Anyone else had similar issues and could point me in the right direction? Thanks,Adam

use FME Desktop 2018 to convert a revit data into Esri I3S format(Indexed 3D Scene Layer). the exported data can be viewed in ArcGIS Pro 2.1 and sucessfully published as a scene service in ArcGIS Portal 10.6.but the scene service from this exported i3s data cann't be viewed incorretly in Portal scene viewer.thanks all!

Hi all, I have some troubles reading an ifc-File with FME 2018.1. I’m able to read all of the ifc-types except of IfcWindows and IfcWallStandardCase. When I read these feature types, I get memory issues and the workspace process fails with the message “Failed to free sufficient memory to reach the process usage limit”. The file is not that big (182MB) and I run it on a machine with 32GB RAM. I guess the problem is associated with the CSG Evaluation of the features. If I set this parameter to yes in the ifc-reader, then I get the memory issues right away when I start the workspace. If I set the parameter to no and run the workspace with certain transformers (like a GeometryValidator, VertexCounter,…) or the CSGEvaluator, I get the problems after a certain amount of features. As described in the reader documentation, the csg evaluation is performed, when it is required (“If the CSG evaluation is not performed in the IFC reader, FME will automatically perform the evaluation when it is re

Hi, I am trying to add Google sheets writer but I am getting a white screen when trying to authenticate. This previously worked but I was having a problem adding Google sheets to someone else report for me. I thought removing the connection and adding it back it might solve this problem but now I am unable to add this back so have lost connection for existing reports. I have tried to add this from running the report and via FME options web connections but the getting the same result. I am presented with a white screen and nothing else. I am guessing that you would normally get the google authentication to OK at the point I am getting the white screen.  Has anyone else had this problem and any idea on how this could be fixed. Thanks Kevin

I am looking to convert Ordnance Survey MasterMap Topography annotation from a GIS point shapefile format so that they display as annotation in MicroStation. I have converted using FME and written the GIS attributes as tags in the .dgn but unsure how to expose these. There may be a better way to do this! Thanks.

(Cross posting hoping to get more visibility... also posted here.)Anyone run into issues with SQL Server 2017 and FME Server? I have been testing FME Server 2018.1 with SQL 2017 and I run into to:Microsoft SQL Server Non-Spatial Writer: Failed to connect using SQL Server 2012 Native Client. Provider error ''. Connection string 'Provider=SQLNCLI11;Data Source=;Initial Catalog=null;User ID=;Password=********'  Microsoft SQL Server Non-Spatial Writer: Trying to connect using SQL Server 2008 Native Client...  Microsoft SQL Server Non-Spatial Writer: Failed to connect using SQL Server 2008 Native Client. Provider error 'Description: Class not registered'. Connection string 'Provider=SQLNCLI10;Data Source=;Initial Catalog=null;User ID=;Password=********'  Microsoft SQL Server Non-Spatial Writer: A suitable Microsoft SQL Server Native Client is not found. Install Microsoft SQL Server 2012 Native Client from http://www.microsoft.com/en-ca/download/details.aspx?id=29065 . Please expand 'Install

I have a dataset with 3D building saved in a geodatabase (*.gdb).I would like to write the dataset to a PostGIS-database. However, when I do this, some information seems to get lost:  This is the same building, the first directly from gdb-file, the second read from the PostGIS-database. The color information is lost and none of the attributes from the gdb are written to the database.I am using a PostGIS-writer in FME 2018.1Is there a way to transfer all information from the original dataset to the database? 

Hi, I'm a fme beginner .I'm trying to make a lod0 roofedge with a plane.but setting User Parameters is quite confusing.I want to set CityGML Lod Name : lod0RoofEdge or lod0Footprint.Then what should I select as feature role and Feature type?I already checked the link below but couldn't find proper item.https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/citygml/Tutorial/writing_citygml_from_fme.htm

Hello all, We are in the process of testing some ETL workflows and were wondering if it is possible to create a reader for an Excel file saved to SharePoint. The excel file is uploaded to a SharePoint site (on our internal network). I've tried creating a Microsoft Excel format reader and appended the site's url to the Dataset location, but with no avail. I am using network authentication to access the dataset with the necessary credentials from within FME desktop. Any ideas on where I am going wrong?  Thanks much in advance. 

Every two lines combined in my shp, I want to split, how I shoud do?

Hi I have an AucoCAD dwg file and tried to follow the "Converting CAD dataset to IMDF: Part 1".When I use the and I always get Test failed in Tester(Keep only Xref features).I am not a civil engineer, and get this dwg file from design company.Really need some tips or comment to help me fix this problem.Thank you so much.

I have several FGDBs with same feature class and fields and I want to merge them into one FGDB, so I set Single Merged Feature Type at reader and Dynamic at writer. By setting Feature Read Mode as Metadata I can keep field alias, but I can't keep allow null values as NO, is there way to make it work?Figs below show that field properties before and after running workspaces.Before:After:

Hi,I have a database with 160 featureclasses(tables) and a total of 170.000.000 tecords. It takes a very long time to read all te data (almost 2 days). Is it possible to use multiple readers and writers who will read/write at the same time. (for example: 4 readers and writers that handles 40 featureclasses each). Or do i have to make multiple workspaces? Kind regards kees

In the process of migrating a number of SDE databases to SQL Server 2017.... will my current FME Server 2018.1 play along? I've tried to find a simple technical specifications document online but wasn't successful. Thanks. (In other words: is FME2018.1 compatible with SQL 2017?)

I read an Excel (.xslx) file with several worksheets in it.I specify 2 Feature Types to read, i.e. I want to read 2 out of 8 available worksheets.I get the data I want and so far so good. What I do not like is, that I get hundreds of WARNINGS for all kinds of problems which seem to exists in the worksheets I don't read.e.g. WARN |A required column was not found in the table. Row xxx will be skipped I did not want to read them and I don't care about anything in those other worksheets.Is there a way to silence the warnings for worksheets I don't read ?I don't understand why they are processed anyhow ... ThanksMichael

I have a workspace that runs in Desktop, but has issues in Server.It appears that the file path for the MS Access database gets cut off at the first space character. The error message from Server is pasted below:Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source='\\\\server\\groups\\group;User ID=admin;Password=********'. Provider error `(-2147467259) Could not find file '\\\\server\\groups\\group'.' The connection string should be: \\\\server\\groups\\group name\\target database.mdbVersions:FME Server is 2019.1 - Build 19608 win32FME Desktop is 2019.1 - Build 19608 win32

I have a workspace that is trying to write to an Esri enterprise database (in PostGis). One particular layer errors out with An error occurred while attempting to open the table, feature class or relationship class 'xxxx'. The error number from ArcObjects is: '-2147216011'. The error message from ArcObjects is: {The SQL statement was not a select statement}I’m unclear what sql statement the process is trying to run as no ‘sql to run before write’ was specified when the writer was created.Other similar layers pass through and write with no apparent problem. Disabling that layer allows the process to run. The fields are named in similar fashion to the other layers.Esri told me to try writing out to a file gdb first (the File Geodb writer had no problem) and then read that into the enterprise version but the source format doesn’t seem to affect it. Obviously there is something the ArcSDE Geodb writer does not like about that layer, but I can't see it. What should

I have a workspace that runs in Workbench, but has issues in Server. I have tried reading both:Private data (via the Esri ArcGIS Online (AGOL) Feature Service Reader), as well as Publicly available Living Atlas data (via the Esri ArcGIS Server Feature Service Reader) The error messages differ slightly but are largely the same. The full text of the error message (for the publicly available Living Atlas data) is:ArcGIS Feature Service Reader: Could not connect to server. Check that you are connected to the internet and that no firewall is blocking outbound connections. The error was 'HTTPSConnectionPool(host='services5.arcgis.com', port=443): Max retries exceeded with url: /4LKAHwqnBooVDUlX/arcgis/rest/services/ParkBoundaries/FeatureServer?f=json (Caused by NewConnectionError('<urllib3.connection.VerifiedHTTPSConnection object at 0x050672B0>: Failed to establish a new connection: [WinError 10061] No connection could be made because the target machine actively refus

Hello i want to translate DGN to shape with Bentley Microstation geographicsi have many dgn files like 1.dgn 2.dgn 3.dgn etc...and many access files like 1.mdb 2.mdb 3.mdb etc... which are linked to dgn .But when i use Bentley Microstation geographics source i can put all dgn files but only one mdb file.Somebody can explain me how to do Thank you        

Is there a way to set the arrow size on an autocad_leader, I see that the leader style is controlled by the Dimension styles but when I pass a name value to autocad_dimension_style_name the dimension style is not applied to the leader. Is there any other attribute to control arrow size on leader?

HiI need to create in dynamic way ESRI Feature Class with domains fields. Feature Class names are dynamic so there is a problem to use XML schema template which defines only one, static feature class.I cant also import schema to Writer because FME do not import domains field definitions (am I right?) so when FME create new FC I don't get domain fields.Thanks for any suggestions

How can i see materials properties of building element in ArcGIS Pro attribute? I did export IFC from Revit and translate it to shapefile but i was not able to see materials properties. So what should i have to do in FME Workbench to add attribute with materials properties?