[Qgis-user] ID field does not show up

[Julian Bogdani]

Hi,
it's not a spatialite db I want to add to my project, but a simple text table. I need to load external attributes from plain text tables and join with my vector layers. I'll not be able to perform the join until ID fields does not show up.
I think that the missing ID field should be considered a bug, because we should be able to manage external data as they are, without filters.


-----
Julian Bogdani
jbogdani at gmail.com
http://bradypus.net





On 19 Aug 2012, at 9:55 , Andre Joost wrote:

> Am 18.08.2012 23:43, schrieb Julian Bogdani:
>> In reference to a previous post and to
>> http://gis.stackexchange.com/questions/31732/primary-key-field-hidden-on-atributes-tables-addes-to-qgis
>> here are the files showing the problem.
>> I'm running QGIS 1.8 on MacOS Snow Leopard.
>> 
> 
> Hi,
> 
> I have tested your database and encountered the same problem.
> I think it is because there are no geometry information in your database. So far it is only a sqlite database, not a spatialite one.
> 
> I have created a new test sqlite database with a point layer, but DB Manager would not let me copy your geometryless table to my database.
> 
> So I opened your database with qspatialite, and that plugin added tables geom_cols_ref_sys, geometry_columns and spatial_ref_sys to it. Now I could drag and drop table "test" from your database to mine using DB Manager. And adding that table to the canvas by checking geometryless tables, gives the correct table view with ID and text field.
> 
> I think the problem will not accur if you create a sqlite database within qgis, and start with a geometry layer.
> 
> HTH,
> Andre Joost
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120819/58a3756f/attachment.html>