[Qgis-user] Problem managing data

[Brent Wood]

Hi Eva,
If you want to be able to work with the data as if it was a spreadsheet using Excel, rather than actually create a spreadsheet, it is possible.

You can open the dbf in Excel as an ODBC data source (don't import to a spreadsheet copy of the dbf). This does NOT create a spreadsheet file with the data, but directly opens the dbf in Excel.
And of course you can open the shapefile in QGIS.
Both approaches should allow you to view & edit the content, but I'm not sure if you can open & edit concurrently in both tools.
A more robust approach would be to use Postgis instead of the shapefile, and do the same thing - open the Postgis table via ODBC in Excel & directly in QGIS. The underlying database provides a multi-user & concurrent user control/capability that a shapefile cannot.

Also note that if you are using point features (a bit trickier with lines/polygons but still feasible as WKT columns) you can use a csv file instead of a spreadsheet, & open that in both QGIS & Excel. 

Note that Excel is a single user application, so assumes that it has total control of the data source - which it does not in such cases - so you may need to close & reopen Excel to view changes made to the data by tools other than Excel. A ODBC link is likely to be the best way to get around this.

Cheers
Brent Wood

      From: Siki Zoltan <siki at agt.bme.hu>
 To: Eva Mosquera <eva_mosquera_lopez at hotmail.com> 
Cc: "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>
 Sent: Tuesday, December 29, 2015 12:36 AM
 Subject: Re: [Qgis-user] Problem managing data
   
Dear Eva,

AFAIK there is no direct solution to edit ods/xls/xlsx files from QGIS.
There are two possible scenarios:
1. Edit your speadseet data in Libre|Open|MS office and open it in QGIS 
and join it to your spatial data. If your spreadsheet is open in both QGIS 
and Excel it can cause trouble.

2. Open you spreadsheet in QGIS and save as a QGIS editable format (e.g. 
dbf, sqlite) and edit these data. If you need again these data in a 
spreadsheet convert it back (probably through csv format).

Hope it helps you,

Zoltan

On Mon, 28 Dec 2015, Eva Mosquera wrote:

> Hello everybody!I need to use the data I have in my shpfile in qgis in excel. I need an excel spreadsheet that is able by itself to keep updated with the data changes in qgis. And I don't know how to do this.
> I'm trying to import the database (dbf) in excel but I have problems with the type and characteristics...
> Thank you very much
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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