Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
With 2.14.1 under Windows 10, I am trying to save a .dbf attribute-only table as a .sqlite table. However, the response is an error.
My procedure: right-click the .dbf in the QGIS table of contents and Save As... In the subsequent Save Vector Layer As... panel I click the Geometry Type as "No Geometry", as seen in this screenshot:
Here's the resulting error statement. What am I doing wrong?
Can't tell you why your export doesn't work in general, but can give you another way of exporting.
Create the database first via new layer or browser and add the table using the DB-Manager. Use the options button to let the program set the needed options, then you don't have to care about the rest.
The problem is that the save layer as-tool is not yet ideal to work with databases. There is also no option to add data to an existing one. Therefore i would recommend the DB-Manager.
The problem is probably that you are keeping "Add saved file to map" as an option. However, wasn't the file actually saved in spite of the error?
Testing this with a loaded non-spatial CSV file (wasn't sure how to get a DBF file loaded as per your example), and doing save-as with an SQLite but keeping "Add saved file to map" ticked, I get the same error.
The requested SQLite file was created in the requested folder.
