Bug report #6196

QGIS not opening SQLIte file generated by FME

Added by Jonathan Moules about 5 years ago. Updated about 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:-
Affected QGIS version:1.8.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No

Description

I have a SpatiaLite file I created in FME. It looks valid in SQLiteStudio, but when I try and "connect" to it in QGIS 1.8.0.1 I get:

"Failure exploring tables from: C:/2 Temp Data/temp_test.sl3

no such column: type"

I've tried this with two different datasets so far, both give this error; I've attached one of the SQLite files (contains OS Meridian data).

Copy_of_temp_test.7z (947 KB) Jonathan Moules, 08/15/2012 07:04 AM

History

#1 Updated by Even Rouault about 5 years ago

This file is not a Spatialite DB, but a SQLite DB with a table organization and geometries in FGF (FDO Geometry Format : http://trac.osgeo.org/fdo/wiki/FDORfc16 ). You can open it through OGR - that handles it well - with the "Open Vector Layer" menu item.

#2 Updated by Jonathan Moules about 5 years ago

Ah, that makes sense. Didn't realise there was a difference, but FME does say "SQLite Spatial (FDO)" under the writer.

You may wish to make the SpatiaLite reader capable of determining this itself and informing the user (the difference between the filetypes isn't something I guess users should be able to determine themselves after all). If so, change this ticket to "feature", otherwise, please close it.
Thanks.

#3 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to invalid
  • Status changed from Open to Closed

Also available in: Atom PDF