Using readers and writers to extract and load data.
Recently active
In earlier version this error did not acccur
I am trying to load ArcGIS Pro Annotations which in the source system have also Leading Line. Annotations are successfully loaded into the FGDB, but, although I populated (hopefully correctly) all geodb_text_leader_line* attributes, Leading Lines are not visible.Does anyone have maybe working example on how Annotations containing Leading Line should be loaded in ESRI GDB?
Hello. I have created some geometries (using Bufferer and Extruder) from 2d coordinate points. Can anybody let me know how I can export them as IFC Geographic Elements in an IFC file?
Hi, see the attached, I'm reading MVT Tileset and want to fan out the output file GDB dataset on zoom level and fanout the feature types too on fme_feature_type, I get an error saying the schema doesn't have the correct element, but it does! All help appreciated. The fmw is self contained, it downloads MVT tilesets (not too big).The error at write time is:ERROR |Esri Geodatabase Writer: Feature Type Definition 'bl' was requested, but not defined. Please visit https://www.safe.com/support
When attempting to load in a VRT Raster, created with GDALBUILDVRT that is in Int8 Format, FME says it is invalid. I am licensed to use the VRT format. I am using FME 2021. I am using the correct VRT Raster format when loading it into my workspace. It seems rather strange that FME would not support VRTs in Int8 formats. I am using GDAL 3.7.1-1 to create my Raster VRT's. Either using the commandline tool directly or manually creating VRT's in QGIS results in the same error. GEOTIFF writer: Setting feature type level option 'geotiff_compression_method' to value 'deflate' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option 'geotiff_jpeg_compression_level' to value '25' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option 'geotiff_deflate_compression_level' to value '6' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option '
Does FME have the ability to export Milsoft's Windmil .gdb to an Esri .gdb?
Hello, I'm currently working on .dgn files I am using FME to make attribute changes and adjustments. However, I have the impression that FME automatically divides the objects or cells in my plan, as soon as I enter my .dgn data in the script, without any transformers being used... Here's an overview of the data before and after FME: I also tried using an aggregator. But the objects and geometry in the output dgn file are still not aggregated as in the original dgn file (see the second photo).I would like the geometry of the objects not to be affected. Have you ever had this problem, and if so, do you have a solution to solve it? Thank you in advance.
Heya FME specialists, another PostGIS question:As a start I have a PointZ PostGIS table created with a PostGIS writer in workbench.Next I have a very simple workbench to duplicate some PostGIS tables from the production server to my local server for offsite development / analyses:I use a PostGIS FeatureReader with schema and generic because I want to dynamically create a clone of the table which is altered (data AND schema) in production without having to update readers and writers. This works wonderful!The one problem I have is that the geometry column definition changes from PointZ to GeometryZ:Original:( pkey serial NOT NULL, the_geom geometry(PointZ,28992), CONSTRAINT testpoint_pkey PRIMARY KEY (pkey))Duplicate:( pkey integer NOT NULL, the_geom geometry(GeometryZ,28992), CONSTRAINT testpoint_pkey PRIMARY KEY (pkey))I double checked to make sure the Create Generic Spatial Columns parameter is unchecked. Do I need to change another parameter or do I forget a crucial step? I att
I am attempting to use the Oracle Spatial Object reader to read-in ESRI feature classes that are stored in an Oracle database. The feature geometries are simple - point/line/polygon feature classes. When I attempt to read them into FME, everything seems to work, except for the feature geometry. When exposing fme_type, all records are set to fme_no_geom. However, when using the Esri Geodatabase (ArcSDE Geodb) reader on the same feature classes, the geometries are kept and works correctly. Is there something that I am missing when using the Oracle Spatial Object reader? I am using FME Desktop 2021.2.6.
Hi all, So I have been trying to connect to our ArcGIS Portal for the last couple of days with no luck. Our Portal uses windows directory/single sign on and I have tried connecting to the FME writer using my Portal credentials (I am an admin in Portal) but it fails. Portal is on a separate server to our desktop FME, which has it's own machine. I firstly tried to connect by just adding the reader in filling in the credentials, but this failed. I then looked up some documentation on here (https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/arcgisportalfeatures/arcgisportalfeatures.htm ) which mentions setting up a web connection using one of their templates, so I tried doing this but it ultimately failed. However looking at more forum posts I see most people seem to connect to their Portal just by configuring the reader connection, so this morning I have been focusing on that side of it but it keeps coming back with the error 'Fetching Feature Types Erro
Reading a feature class from file geodatabase and writing it in another file geodatabase fails, I wanted to read a feature class from file geodatabase and write it in another file geodatabase but it appears not to work What might be the issue here? Thank you Best Jamal
I am looking to rewrite a process to use FME instead of SSIS. The process reads data from .trk files. But I am not able to find any reader for .trk files in FME. Please suggest.
Hello, I read CSAR raster files with the FME reader for this type of file but when I look at the layers, only one numeric value is given for each pixel in the contributor layer (see red circle in attachment). If the CSAR file is opened in CARIS, three metadata values are available: feature ID (which is a character), start and end date of the measurement. Am I missing a step to be able to read this information in FME ? Thank you!Kind regards, Yasmin
I am running checks on data. Any fails in checks, they will be written to a tab in the spreadsheet. If there are no fails, the tab won't be created. In the case of failures, is there a way for me to print a message to say "Checks ok" into a new tab?
Hello, I tried to make a workbench that write ifc from our data base (building).When i try to read the final file, FME cannot because of syntax error for the ISO10303-21 format. Each building has one ".." value that cause the problem.#35=IFCBUILDING('O6Hu3fDbRB2OEJH5wcfNLw',#23,'51_102','','',#34,$,'51_102',..,$,$,$); If i change the ".." by a $ (that mean 'Null' according to BuildingSmart) the file is fine and FME is ok to read it. Does someone know what parameter or attribut I missed in my workbench that cause the ".." ? Thanks !
Hi! I have encountered some difficulties as I am trying to check whether certain microstation files contains empty levels. I've studied the feature-reader for Microstation datasets, but I cannot find a way to read empty levels but only levels that has content within. My hypothesis is that the feature reader outputs all the levels that is associated with a feature, and hence, misses the empty layers.For Autocad files, I had the same issue initially. However that was solved by using a Schema (Any Format) - reader on the Autocad-file dataset and hence reading all the layers as fme-feature-types. Any ideas?
Hi guys, I am still learning FME and have made a few workspaces which are working well for me however I am doing a merge with a SQL non spatial and a mapinfo tab file and am trying to make an end result of the poly's having no fill or patterns, just an outline and being transparent. I have tried many things, the closest I have gotten is creating the attribute mapinfo brush transparent and setting to True, and if I create a pattern with Mapinfo styler the transparency works - obviously with the pattern though, I have tried doing an attribute expose and remove for the mapinfo_brush_background and foreground. Sorry I have been trying to do this for a couple of hours and tried all sorts of combos but just can't get it. Thanks in advance Garry
"" Error connecting to PostgreSQL database(host=, port=, dbname=, user='postgres', password=): 'could not connect to server: Connection timed out (0x0000274C/10060) "" How do I get FMe server to connect to my PostgreSQL db stable every time ?
The input-data are in e57-formate and we want to split them up into a huge amount of small pnts-files for using them in Cesium JS.We need a tileset.json-file for each pnts-file. There should be an overall tileset.json-file in an superior folder listing all children tileset.json-files. Each generated file (pnts and tileset.jsons) should not exceed a specific file size (e.g. 2 MB). We are using version FME 2023.0. Our workbench has an e57-point-cloud-reader, a PointCloudExpressionEvaluator, a PointCloudSplitter and a Cesium-point-cloud writer. The data are splitted by the attribute set in the PointCloudSplitter. How is it possible to get multilevel tileset.jsons? We already created an superior tileset.json-file and many pnts-files. The problem in this case is the big size of the generated tileset.json. In another case many tileset.json- and pnts-file-doublets. The problem in this case is the missing tileset.json-entry-file.
Does anyone know of a way to use FME to generate a .lyrx file with symbology that I could then use in ArcGIS Pro? I think a lyrx file is just XML under the hood? Making and remaking layers in ArcGIS Pro is a pretty huge pain point for me, and I'd love to see someone make a transformer / writer to help with this, so that I can just specify a data source, specify symbology parameters and click 'Run' in FME to generate this > add to ArcGIS Pro, instead of using ArcGIS Pro's laggy interface to click around in the symbology pane. @mark2atsafe thought you might know of a solution? Thank you
I've downloaded a geopackage file from Data Map Wales (in the UK) containing listed buildings and whenever I load it into FME Desktop it seems to miss a field containing a date, all the other fields are there. I've used DB Browser for SQLite to read the file and the missing field is definitely in there and contains data. In FME Desktop I've tried using a reader and a featurereader to load the file, both approaches fail to recognise this field. I've also tried in QGIS and the field does not load in there either. I initially thought that the data might be malformed in some way but the fact that it reads fine in DB Browser for SQLite suggests otherwise. Does anybody have any ideas as to how I can read this date field? The data is available from this website Listed Buildings | DataMapWales (gov.wales)
I need to create a summary slide with multiple sections/placeholder tables on one slide, so I need to have my font size to be 10pt for example. So far it seems that FME hard codes the table font to 18pt. Thanks, Joey
I want to reproject DWG files with Pipe Network features from UTM Zone 17 NAD83 (Original) to MTM 10 NAD83 CSRS using ON83CSv1.gsb.when I use ArcGIS data interoperability and EsriReprojector, it reproject all feature except Pipe Network features.is there any sollution for it?
Hello,I am experiencing difficulties reading an Oracle Spatial table with FME.The table (linestring) has about 250K records.FME starts to log the first 10000 records after about 10 minutes. And then 10000 at a time every 6 minutes.The table is displayed in GeoMedia and also QGis in about 5 minutes.Feature Caching is disabled.I have tried both with the reader and with a SqlCreator. Same results.What checks/configurations can I try?This is the first time it happens and not sure if some metadata could be wrong or corrupted.This sounds strange because of the tests with other products.TIARoberto
Has anyone encountered issues with 4-band jp2000 files written by FME Server crashing in Kakadu? The error is:"A `jp2_channels' object indicates the presence of " "more colour channels than the number which is associated with the " "specified colour space. This may happen while reading a JP2-family " "data source which contains an illegal channel definitions (cdef) " "box, or it may happen while writing a JP2-family file if the " "`jp2_channels' object has been incorrectly initialized."