Bug report #8299

db manager fails to import simple CSV into spatialite

Added by Mathieu Pellerin - nIRV almost 11 years ago. Updated almost 11 years ago.

Category:DB Manager
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:17095


I swear I successfully imported a large CSV file into a spatialite database via DB Manager recently. It's not working anymore.

Steps to reproduce:
1. Open DB manager
2. Open a spatialite database
3. Click on the Import layer/file toolbar button
4. Open the file selector and pick the attached dbmanager_test_import.csv
5. Click on the Update options button
6. Click on OK

The import process will fail with this error message: "Error 8 Loading of layer failed"

dbmanager_test_import.csv Magnifier (1.87 KB) Mathieu Pellerin - nIRV, 2013-07-15 02:55 AM

Associated revisions

Revision 7ba5f00d
Added by Jürgen Fischer almost 11 years ago

spatialite: fix handling of empty geometry column (fixes #8299)


#1 Updated by Jürgen Fischer almost 11 years ago

  • Status changed from Open to Closed

#2 Updated by Mathieu Pellerin - nIRV almost 11 years ago

Thanks jef.

Also available in: Atom PDF