[Qgis-user] feature or bug

[Alex Mandel]

Ah, you can add non-spatial tables (eg. csv) via the standard vector
load tool, not the delimited text tool. I realize this is not obvious.
I think you can now load dbf tables this way too.

Also the alternate join with a dbf I was thinking of is in the
Vector->Data Management menu (ftools plugin).

Enjoy,
Alex

On 03/06/2012 09:55 AM, M.E.Dodd wrote:
> "Join
> tool in the properties of the layer will take care of find the matches
> as long as the same key exists in both your attribute table and the
> table of additional data you want to add on"
> 
> I had assumed this was the case however could not find a way of getting the data in in the first place, if you open a .csv then it asks about crs etc when all you want is to match the data and it does not have any coordinates.  seems such a basic issue but i could not see a way round it, its a gis so any data you enter must have coordinates but in this case you just want to match a set of data on a reference column not plot it out.
> ________________________________________
> From: Alex Mandel [tech_dev at wildintellect.com]
> Sent: Tuesday, March 06, 2012 5:32 PM
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] feature or bug
> 
> On 03/06/2012 09:05 AM, M.E.Dodd wrote:
>> When looking at the attribute table I want the first column in numeric order (they are the reference number of a set of features and I want to match by this column in a spreadsheet to other data and if they are in order this is easier, can do it without them being in order but more of a pain).  Thought I had tried this and it worked fine earlier with just a few features but now that I have entered nearly 1000 features it has decided that it won't sort and save.  Well it will sort if I click on the column head but then when saving the shapefile the .dbf is not in numeric order, instead its in the order that I digitised the data.  Have tried this several different ways and tried adding extra dummy features and saving again and with different filenames but still they appear in sorted order in the attribute table but then not in sorted order when you look at the .dbf.  Also you can sort, do the 'save edits', then close that screen and reopen it and they will be unsorted again.

>  Not entirely sure if this is supposed to happen or if it is a bug.
>>
>>
>>
> 
> This has to do with the way a shp file stores the data to begin with,
> once the order is set it's not easy to change since it's also the order
> matched to the shx and shp portions.
> 
> That said though you don't need to do the matching yourself, the Join
> tool in the properties of the layer will take care of find the matches
> as long as the same key exists in both your attribute table and the
> table of additional data you want to add on. Note: I think this tool
> currently works for csv or dbf files, so save your additional data into
> that format with your spreadsheet app.
> 
> Thanks,
> Alex
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>