Using readers and writers to extract and load data.
Recently active
hi, what I do wrong when convert osm pbf to shp? i try to create a simple workspace but i got nothing = and i try manual add reader and writer, and i have errors = can anyone help me?
Hi,FME Server is not able to lunch the workbench which is able to work correctly via desktop.If I select only one reader+writer that is able to work. However when I launch the whole reader-writer, than is getting error. I have attached the Smallworld-emacs error and the log file.My goal is that I would like to download the whole data from SMALLWORLD to SL3/FFS any different database format daily via fme server schedules. I have prepared a workbench you can find below. 1 million records include.
Hi,I have a TXT file (point cloud) containing 2 columns col1=X and col2=Y.I want to create groups every 1cm (according to X axis) and compute for each group Xmean, Ymean, Ymin and Ymax.I think it is necessary to create a point cloud and then create slice of points (every 1cm) but I don't know how to do this.Thank you for your help.
Hi,I'm new to spatial data and ECW files. I've got a ECW file that needs to be inserted into a postgis raster database. All the proper extentions are installed on the database side. I currently load the file into a RasterTiler and then into a postgis writer. The rastertiler was needed otherwise it would not load the file into the database. I'm not sure when raster size I should use, but it's currently set to 256 by 256. But when my colleague tries to view the file from the postgis raster database with several different GEO applications, the error always says that spatial data is missing. So: how to I check if the source file has spatial data? Do I need to change something to the postgis raster writer? Or maybe to the RasterTiler transformer? Thanks so much! In advance for any help.
Hi, Im trying to convert my from Esri shapefile to PostgreSQL database, but the result is not good because the geometry is gone. Im using FME for the first time and dont know where is the problem. Please help!
I have an 8-bit raster image (jp2) which I need to convert to ecw format. A fatal error occurred and the message was "ECW writer: This format does not support writing the RGB/RGBA bands in the raster with other extra bands. Please remove the extra bands and try again". How can I fix it?
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.