RES: [Qgis-user] exporting joined table to excel

Ramon Andinach custard at westnet.com.au
Sun Jun 26 15:56:44 PDT 2011


I think there might be a step missing.

The new join tool doesn't create a new physical layer, but a virtual one.

So to make it visible outside qgis, you need to save the layer you joined to first.
I'd save it as some new name, and you can save it directly into CSV if you wish.

-ramon.

On 27/06/2011, at 05:25 , Frederico Mestre wrote:

> It is a shapefile, but in the dbf was only possible to see the fields in the shapefile, not the joins. I just generated a new shape with the joined fields and only then opened the dbf in excel.
> 
> Thanks for the suggestion! 
> 
> Frederico Mestre
> 
> 
> -----Mensagem original-----
> De: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] Em nome de Alex Mandel
> Enviada em: domingo, 26 de Junho de 2011 21:45
> Para: qgis-user at lists.osgeo.org
> Assunto: Re: [Qgis-user] exporting joined table to excel
> 
> On 06/26/2011 01:03 PM, Frederico Mestre wrote:
>> Hello,
>> 
>> How can export a table, which can be opened in excel (such as .csv), when I've got joined tables that I joined using the vector properties window join tool?
>> 
>> Bye,
>> 
>> Frederico Mestre
>> 
>> 
> 
> If the layer is a shapefile then the dbf is openable in Excel already, no need to export. If it's in a database like Postgis or Spatialite then both of those have tools to export or dump csv.
> 
> Alternately if you Right click on any vector layer loaded and do a Save As... Comma Separated Values is an output option.
> 
> Enjoy,
> Alex
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user




More information about the Qgis-user mailing list