[Qgis-user] Importing layers with id column to SpatiaLite

[Anita Graser]

Hi,

When importing a layer,. which contains a column called id, into SpatiaLite
with DB Manager, that column contents gets mangled. e.g. this test layer:

id;name;geom
123456789012;asdf;POINT(1 1)
3;lkdl;POINT(1 2)
212455;dksl;POINT(2 2)

will be imported with ids 1, 2, 3 (equal to the row numbers) rather than
the original id values.

The only way to avoid this that I could identify so far, is to rename the
column to e.g. myid as in:

myid;name;geom
123456789012;asdf;POINT(1 1)
3;lkdl;POINT(1 2)
212455;dksl;POINT(2 2)

Then the layer is imported with all three original columns plus an
automatically generated id column.

Imho, there should at least be a warning before the import replaces the
content of an existing id column with row numbers ...

Is this a known issue? Should I open a ticket?

Best wishes,
Anita
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160214/6bdeb8ec/attachment.html>