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
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
