Data

Whenever I write features into a GeoPackage Table, this table is registered in the GPKG_GEOMETRY_COLUMNS table. FME registers all the tables I create with geometry_type_name: GEOMETRY. I expected that FME would register my table with point features as geometry type POINT, tables with polygon features as POLYGON, etc., as prescribed in the GeoPackage-specification. Tables registered as GEOMETRY are recognized by QGIS as a feature class with unknown feature type. Which makes sense.How do I enforce FME to register the correct geometry type for my tables, preferably in a workbench with a dynamic reader (PostGIS) and writer (GeoPackage)? Wim

I tried to convert multiple feature classes to .kml, and using a test filter assign color coding then out to a writer . but the end result is just one kml. how do i get a klm for each feature class.

https://www.safe.com/transformers/kml-view-setter/I've been looking at the KMLViewSetter transformer, but when I set lat/long values in there it continues to open to the default location in Google Earth. I've tried using the values in the doc example, but it still opens to the default location.  I might be missing something - but has anyone got this to work and could help me out?FME(R) 2018.1.0.0 (20180321 - Build 18442 - WIN32

When trying to update a hosted feature service (truncate,insert) that was creating from ArcGIS I get an error that the service name already exists. I have a feature service that I create with FME using the same data and I can update that service without any problem.Is there any reason why I can update the service created with FME but not the service created from ArcGIS Desktop? The properties on the services are the identical and owned by the same account.

Using this to grab data from an XML feed and writing to ArcGIS SDE database and the process doesn't stop after successful translation. Any help would be appreciated, thanks!!Same issue

I'm loading data (450k polygons) from FGDB into SDE. Versioning is enabled.The Transaction Type is a Versioned Edit Session and my Writer Mode is Insert. I have Drop Table as No and Truncate Table as Yes. The writing is very slow and after running for 3 hrs and 43 min the transaction failed with the following error:An error occurred while attempting to start an edit operation. The error number from ArcObjects is: '-2147155559'. The error message from ArcObjects is: {Failure to access the DBMS server [08S01:[Microsoft][SQL Server Native Client 11.0]TCP Provider: The specified network name is no longer available. ] [sde.DEFAULT]}Here is the log file: Any idea why it is throwing that error?Thanks.

Hi, I would like to take a .IFC file and add some parameters to a 3D object. I have an extract of the coding used when exported from a software platform but I wanted to know if I could take an existing IFC into FME, Expose all of the objects within the file and add parameters to an object taken from a spreadsheet?#1615=IFCRELDEFINESBYPROPERTIES('9637335e-cf0f-59a1-8f9b-a375089be97f',#2,'Property Association','IfcPropertySet associated to element',(#33),#1609); #1616=IFCPROPERTYSET('1e82cc66-a22a-63d7-9d26-f8590c0c95ad',#2,'DWF - User attributes','',(#1617,#1618,#1619,#1620,#1621,#1622,#1623,#1624,#1625,#1626)); #1617=IFCPROPERTYSINGLEVALUE('User Attribute 01',$,IFCTEXT('Project X'),$); #1618=IFCPROPERTYSINGLEVALUE('User Attribute 02',$,IFCTEXT('L8'),$); #1619=IFCPROPERTYSINGLEVALUE('User Attribute 03',$,IFCTEXT('Staircase'),$); #1620=IFCPROPERTYSINGLEVALUE('User Attribute 04',$,IFCTE

Hi,I have a workspace that makes an initial SQL database call to write to a table that generates an id key that subsequent database writers require. The problem is that the initial call doesn't seem to close/finish writing before the subsequent calls look for the id key. I have placed a feature holder before the subsequent calls but if the records fall below a certain number the process fails (and the initial table is not populated). Over a certain number or records the process is fine. Any ideas?Thanks!Sam

Hello, I am trying to convert a Revit model in RVZ format to a Cesium 3D tile. However when the transformation is run I get a warning that says "Geometries which cannot be converted to a triangulated mesh will not be written" for some of the geometry. Is there anyway to fix this or to tell way some of the geometry does work and some of it doesn't?

Hi everyone. I write data using AutoCAD DWG/DXF writer. Everything works fine but after opening the file, users allways have to click "fit to view" (microstation) to see the data - and the ones that are not very familiar with microstation don't find the data at all. Is there the possibility to write the data's extent to the file? Maybe by using one of the various autocad_... format attributes? Thank you very much fot your help! Simon

Hy I want to know if it is possible to georeferencered the PDF before to use the PDF reader to obtain in the output a DWG or Esri GeoDb with the correct coordinates system thxFrancesco

I am trying to add geometry columns to a postgres instance on FME Cloud and I am getting this error.ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist LINE 35: SELECT AddGeometryColumn('cad_qa','WATERLINES','geom',2277,'...Here is the select statement, it is from an FMEpedia github project,SELECT AddGeometryColumn('cad_qa','WATERLINES','geom',2277,'LINESTRING',2);

Hello,I need to work with OSM PBF, but in FeatureReader tranformer in version FME Desktop 2018.0, there is missing configuration file parameter (e.g. INI file) for OSM PBF. But in version 2017.1, as you can see below, the parameter is there...Why is this paramater missing? If it is purpose, how can I solve substitution of configuration file?Thank You so much!Lubo

Hi,I have a FME Server and I would like to use jobs function. But the my workbanch is not working in the fme server. Normally it is able to work from fme dekstop. Server says that there is no defined Coordinate but I have. ITRF96 was added as custom. My question is how han I fix the problem.***********************************************************FME API version of module 'NULL' matches current internal version (3.8 20170315)MULTI_READER(SWORLDSWAF_5): Done reading 0 features from 2 readersCreating reader for format: Smallworld 4/5Trying to find a BUILTIN plugin for reader named `SWORLDSWAF'Trying to find a DYNAMIC plugin for reader named `SWORLDSWAF'FME Configuration: Source coordinate system for reader SWORLDSWAF_6[SWORLDSWAF] set to `ITRF96'Coordinate system named ITRF96 does not exist.Failed to get parameters for coordinate system `ITRF96' -- No definition was found for coordinate system `ITRF96'This FME edition does not recognize the `SWORLDSWAF'

I am reading in shape file and using attributepivoter to calculate stats. I then write the results to a separate excel sheet for each source file. After the attributepivoter I can no longer assign the source filename (fme_basename) to the sheet name in the writer

I have a MIF file with no matching MID file (attributes) which is intended to store purely geometry. I am able to drag it into my FME work space but when I run, it complains that the "...*.mid is missing"  I can get around this my importing the MIF into a TAB in MapInfo but is there a way FME can read in a MIF on its own?

Hi everyone,We use the FME Exporter for Revit but we have a lot of Revit files to convert. Do you know of any way to automate / script the export from .rvt to .rvz so it can be ran as a batch processing ?Thanks for your helpMat.

Hi! I'm trying to import some CityGML to Infraworks via the quick translator. I'm getting errors that seem schema related, and I saw when I colleague used the full trial so that he could see the workspace details, that the schema seems not to be defined. Is that possible? In the log file I have:2018-03-21 10:16:07| 1.4| 0.0|INFORM|mapping file Keyword: `CITYGML_1_ONLY_FEATURE_TYPES_IN_DATASET' occurs 1 time(s) 2018-03-21 10:16:07| 1.4| 0.0|WARN |UniversalReader -- readSchema resulted in 0 schema features being returned 2018-03-21 10:16:07| 1.4| 0.0|ERROR |The XML Module halted on error, see the logfile for details 2018-03-21 10:16:07| 1.4| 0.0|INFORM|Closing the SCHEMA Reader 2018-03-21 10:16:07| 1.4| 0.0|ERROR |The XML Module halted on error, see the logfile for details 2018-03-21 10:16:07| 1.4| 0.0|INFORM|Translation FAILED with 4 error(s) and 54 warning(s) (0 feature(s) output) 2018-03-21 10:16:07| 1.4| 0.0|INFORM|FME Session Duration: 2.0 second

We used this article (https://docs.safe.com/fme/html/FME_Server_Documentation/Content/ReferenceManual/Directory-Account-Permissions.htm) to give permission to write files to the Data file in resources, which was successful to write to that parent folder. We then created subfolders in the Data folder through the web interface for different processes we have. The subfolders say that the owner is 'root' and therefore the fmeserver service account does not have permissions to write to that folder. Is there a way to make it so any subfolder will get the same permissions as the parent folder?

I need to use an FMW script to extract xyz files from a single netcdf file. When using the data inspector, I see that the netcdf has several variables and multiple bands of data for each variable. Ultimately I am desiring the u and v datasets. I feel like I am close with my FMW file, but somehow it is not extracting the u and v datasets correctly.My steps thus far are as follows:1. Open FTP directory: ftp://ftpprd.ncep.noaa.gov/pub/data/nccf/com/rtofs/prod/rtofs.YYYYMMDD/ (you need to adjust the date characters YYYYMMDD)2. scroll to bottom and open the rtofs_glo_uv_YYYYMMDD_hcasts.nc.gz file3. use gzip to uncompress the file: gzip -d rtofs_glo_uv_YYYYMMDD_hcasts.nc.gz4. Open FME Workbench 2015 (I only have 2015 desktop)5. Open FME script (attached here) 6. Provide input parameters:SourceDataset = rtofs_glo_uv_YYYYMMDD_hcasts.nc (netcdf file that was downloaded above) DestDataSet = C:\\The expected output is to have a u_velocity and a v_velocity xyz file. Each file will have the follo

Hi, I am writing to my database (SQL Server Spatial) and would like to in this case, overwrite the automatic sequential numbering system that SQL Server gives each attribute. Any idea how I would go about this?

I get this error while writing from SDE to PostGIS. The job runs forever and doesn't do anything.The specified coordinate exceeds the valid coordinate rangeIt has around 20K features. The features doesn't even read through inspector. But if I update the filter to have around 10K features, it does write.There is no issue with the features for sure. Just wondering if there is any limitation from SDE? I haven't seen this before and definitely it worked before for writing more than 100K features.Thanks

I can't figure out how to use a mongodb writer to update existing documents (specifically, I want to insert new elements in a list within the existing json structure)  I don't even see any parameter to set the writer to update or upsert.

I have a workspace that is using a polygon drawn by the user to search multiple layers, write a html report and email the html report to the user. The html report is generated using the htmlreportgenerator, htmllayouter and writehtmlfile. The workspace is run in FME server.In the workspace, I'm saving the username, email and polygon to a SQL database to keep a record of what reports are run. However, I would like to be able to save the html report to the table as well so that it can be retrieved to see what results have been provided in the report. It would not be possible to rerun the report as the data changes and it is important to see the data results as it was generated for the user at that time. Is it possible to do this and if so what attribute type would you use to write the the html output to the SQL table?If this can't be done, does FME server save the output of the workspace somewhere? The HTML report would have the date and time appended to the report name so

Hi,  I have about 50 feature classes in a geodatabase. In the feature classes, some of the field names are the same but a lot are different.For example: in one feature class field names are – Sample_ID, Easting_NAD83_UTMz19, Northing_NAD83_UTMz19, Au_INAA_ppb, Ag_INAA_ppm, Fe_ICPMS_ppm, Fe_INAA_ppm, Ca_ICPOES_ppm. In another feature class, field names are – Sample_ID, Easting_NAD83_UTMz19, Northing_NAD83_UTMz19, Ag_INAA_ppm, Au_ICPMS_ppb, Fe_INAA_ppm. I want to create a new feature class called “INAA_merged” where every field that contains “_INAA_” will be in it as well as the Sample_ID, Easting/Northing fields. I’d like all the other fields containing for ex: “_ICPMS_” and “_ICPOES_” to be deleted.    So basically I want to merge all the fields together in one feature class that have the same name and delete all the others.    Is this possible? Is there a way to set up conditions for merging – ie to keep certain fields if they contain certain characters and to delete others?