Data

When I try to add data to a timestamptz field in postgres using the postgres writer it gives the following error:Value of attribute 'start_date' could not be converted to type 'timestamptz'. Feature will be logged and skippedWARN Â |+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++WARN Â |Feature Type: `admin.real_right_version'WARN Â |Attribute(string) Â : `start_date' has value `2018-11-13 09:43:58.3875761+01'I'm using FME 2018.1 and postgressql 10.5

Is it possible to combine these glob patterns in one PathReader?*.jpg*scheme*.pdf

Is there a way in FME to provide directly the url <server>/<service>/<layerID> ? It takes quite some time at runtime for the reader to get to the service, loop for layers to find the one by providing the name. I'm trying to cut down the execution time and looking for the options of providing directly the url including the layer id, purely for reading purposes.All above while providing the token instead of user/pwd authentication.Any ideas ?  Thank you

Hello :) I'm new to FME and I have a question which I didn't found answered yet in your discussion board: I want to read my gpx files and write them into a esri shp file. The gpx files are containing gpxx extensions (heartrate "hr" and a temperature "atemp") but those I cant read. The normal gpx stuff is transferred to the shp file. I will give you a short code snippet from one of my gpx files. Can anyone try to help me ?! Thank you :D These are the first 32 lines:  <?xml version="1.0" encoding="UTF-8" standalone="no"?><gpx xmlns="http://www.topografix.com/GPX/1/1" creator="GPS-Track-Analyse.NET 6.0.0.4" version="1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd" xmlns:gpxx="http://www.gps-freeware.de/xmlschema/TrackPointExtension/v1"><metadata>&l

I got files with the type .mon ,I try to use them in the workbench but i cant find a specific format that works correctly with it. The type that should be the closest to it cant read it at all and gives the error as shown in the pictureI also tried it as an CSV because it is a kind of table, but the output is incorrect. Does anyone know how to work with this type of file?

Hi all, I have many .gml files.And, i would like to merge all gml files to one file. But i didn't have any idea on FME. Could you help me with this issue ? Best Regards.

Is there any good open source (or preferrably free) tool to validate any IFC-file? Thanks! Tried the first few pages of googling but with less luck.

Hi, I have an excel table with over 100 folder, lets say for example   folder  C:\\data\\1a\\z  C:\\data\\1b\\z   C:\\data\\2a\\z   C:\\data\\2b\\z       that I read in my main.fmw workspaceand I want to send it to another workspace that is named edit.fmw for example. In each folder I know there is many dwg, but I want to open the one in the subfolder that ends with ....03.dwg because that is always the terrain file in all folders.I want to1. Read excel2. Find the name of the dwg in each folder3. Send it to my other workspace and open it with a reader to do other stuff with. Any ideas?I basically need help with how to set up the workspacerunner and since I dont want to manually find and enter the name of the correct dwg is there a way to test/search for a file in that folder that ends with a specific string? I have looked at pathreader but that only reads dwg--> find metadatafiles and filepath but I want the other way around, folder-->list of all files.

I have been using a workflow that was previously posted here to try and extract text, representing a table, from a PDF and write out a worksheet (for each table) to excel. I have been able to extract and isolate the desired text but I cannot figure out how to properly organize the records to write to the excel cells.

I am really new to FME & spatial data. Is it possible to incrementally pull data from a data center hosted GE Small World database, via FME Cloud & push it to a destination on Azure. Pls share some inputs.

I would like to know if it is possible to import OS Mastermap Topography layers in GML, clip an area of interest and then export that in exactly the same format as the input?

For example, Because the ArcGis Portal publishing maybe failed because too many sub-layers. ( the writer will upload a GDB then publish it in the portal)so to save the time for the publishing waiting time,in a FMW, I want to create a process to create a FileGDB with multiple tables in it by difference process; just after the FileGDB created(100% finished), link this new FileGDB to a ArcGIS portal writer to publish it.But currently the FileGDB writer can't add any process behind it. it is a dead end.Anyway to do this?

Hi there, I've a problem with AIXM data. I try to translate AIXM data to gkpg (he problem is the same with another writer format : shp, postgis...). It only works when I translate AIXM to gml ............Some attributes are missing like the information regarding the volume information for the Airspaces (upper/lower limit....).What is the setting to get all the attributesCan someone help me please ?

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.