[Qgis-developer] Plugin to synchronize an attribute table between QGIS and LibreOffice?
What about a plugin to open and synchronize an attribute table between QGIS and LibreOffice? This would also require to write a LibreOffice extension. As an inspiration see this ArcGIS extension called "gisconnector" [1] --S. [1] http://www.gislounge.com/gisconnector-excel-synchronize-data-selections-filters-arcgis-excel/ ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Plugin to synchronize an attribute table between QGIS and LibreOffice?
On Sat, Apr 25, 2015 at 11:49 AM, Stefan Keller wrote: > > What about a plugin to open and synchronize an attribute table between > QGIS and LibreOffice? There was a talk at FOSS4G PDX 2014 which described combination of PostGIS/PostgreSQL+QGIS+LibreOffice: Geodesign: An Introduction to Design with Geography — Matthew Baker, Denver Public Schools, Critter Thompson, Placematters https://vimeo.com/106233274 5:00-15:00 > This would also require to write a LibreOffice extension. > As an inspiration see this ArcGIS extension called "gisconnector" [1] > > --S. > > [1] http://www.gislounge.com/gisconnector-excel-synchronize-data-selections-filters-arcgis-excel/ > ___ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Plugin to synchronize an attribute table between QGIS and LibreOffice?
Hi Vaclav Thanks for the hint. Interesting talk about Geodesign (which to me is a synonym decision support) and open source tools like PostGIS, QGIS and LibreOffice. But there, QGIS is connected to LibreOffice via PostgreSQL/PostGIS. I'm looking for a direct connection between QGIS and LibreOffice calc. -S. 2015-04-25 18:43 GMT+02:00 Vaclav Petras : > > On Sat, Apr 25, 2015 at 11:49 AM, Stefan Keller wrote: >> >> What about a plugin to open and synchronize an attribute table between >> QGIS and LibreOffice? > > There was a talk at FOSS4G PDX 2014 which described combination of > PostGIS/PostgreSQL+QGIS+LibreOffice: > > Geodesign: An Introduction to Design with Geography — Matthew Baker, Denver > Public Schools, Critter Thompson, Placematters > https://vimeo.com/106233274 > 5:00-15:00 > >> This would also require to write a LibreOffice extension. >> As an inspiration see this ArcGIS extension called "gisconnector" [1] >> >> --S. >> >> [1] >> http://www.gislounge.com/gisconnector-excel-synchronize-data-selections-filters-arcgis-excel/ >> ___ >> Qgis-developer mailing list >> Qgis-developer@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/qgis-developer > ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Plugin to synchronize an attribute table between QGIS and LibreOffice?
Hey, you could use SQLite as an itermediary. As far as I know, QGIS can natively read/write into SQLite tables, and use it anyway. And as far as I know, Open Office can easily read and write data in/from SQLIte. It would be very close to what you want, without the need to write a QGIS extension. You would just have to write the LibreOffice plugin Cheers, Rémi-C 2015-04-25 22:07 GMT+02:00 Stefan Keller : > Hi Vaclav > > Thanks for the hint. > Interesting talk about Geodesign (which to me is a synonym decision > support) and open source tools like PostGIS, QGIS and LibreOffice. > But there, QGIS is connected to LibreOffice via PostgreSQL/PostGIS. > I'm looking for a direct connection between QGIS and LibreOffice calc. > > -S. > > > 2015-04-25 18:43 GMT+02:00 Vaclav Petras : > > > > On Sat, Apr 25, 2015 at 11:49 AM, Stefan Keller > wrote: > >> > >> What about a plugin to open and synchronize an attribute table between > >> QGIS and LibreOffice? > > > > There was a talk at FOSS4G PDX 2014 which described combination of > > PostGIS/PostgreSQL+QGIS+LibreOffice: > > > > Geodesign: An Introduction to Design with Geography — Matthew Baker, > Denver > > Public Schools, Critter Thompson, Placematters > > https://vimeo.com/106233274 > > 5:00-15:00 > > > >> This would also require to write a LibreOffice extension. > >> As an inspiration see this ArcGIS extension called "gisconnector" [1] > >> > >> --S. > >> > >> [1] > >> > http://www.gislounge.com/gisconnector-excel-synchronize-data-selections-filters-arcgis-excel/ > >> ___ > >> Qgis-developer mailing list > >> Qgis-developer@lists.osgeo.org > >> http://lists.osgeo.org/mailman/listinfo/qgis-developer > > > ___ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer > ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Plugin to synchronize an attribute table between QGIS and LibreOffice?
Hi Rémi You're probably right: Having a lightweight database in between would have some advantages since LibreOffice (calc) locks files. On the other hand a database makes adding rows more complicated... Cheers, S. 2015-04-26 16:11 GMT+02:00 Rémi Cura : > Hey, > you could use SQLite as an itermediary. > As far as I know, QGIS can natively read/write into SQLite tables, and use > it anyway. > And as far as I know, Open Office can easily read and write data in/from > SQLIte. > > It would be very close to what you want, without the need to write a QGIS > extension. > You would just have to write the LibreOffice plugin > > Cheers, > Rémi-C > > 2015-04-25 22:07 GMT+02:00 Stefan Keller : >> >> Hi Vaclav >> >> Thanks for the hint. >> Interesting talk about Geodesign (which to me is a synonym decision >> support) and open source tools like PostGIS, QGIS and LibreOffice. >> But there, QGIS is connected to LibreOffice via PostgreSQL/PostGIS. >> I'm looking for a direct connection between QGIS and LibreOffice calc. >> >> -S. >> >> >> 2015-04-25 18:43 GMT+02:00 Vaclav Petras : >> > >> > On Sat, Apr 25, 2015 at 11:49 AM, Stefan Keller >> > wrote: >> >> >> >> What about a plugin to open and synchronize an attribute table between >> >> QGIS and LibreOffice? >> > >> > There was a talk at FOSS4G PDX 2014 which described combination of >> > PostGIS/PostgreSQL+QGIS+LibreOffice: >> > >> > Geodesign: An Introduction to Design with Geography — Matthew Baker, >> > Denver >> > Public Schools, Critter Thompson, Placematters >> > https://vimeo.com/106233274 >> > 5:00-15:00 >> > >> >> This would also require to write a LibreOffice extension. >> >> As an inspiration see this ArcGIS extension called "gisconnector" [1] >> >> >> >> --S. >> >> >> >> [1] >> >> >> >> http://www.gislounge.com/gisconnector-excel-synchronize-data-selections-filters-arcgis-excel/ >> >> ___ >> >> Qgis-developer mailing list >> >> Qgis-developer@lists.osgeo.org >> >> http://lists.osgeo.org/mailman/listinfo/qgis-developer >> > >> ___ >> Qgis-developer mailing list >> Qgis-developer@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/qgis-developer > > ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Plugin to synchronize an attribute table between QGIS and LibreOffice?
Hi, Did you try to open a .ods file with QGIS? IIRC it is supported by GDAL and hence it should be straightforward to open it in QGIS. Matthias On 04/26/2015 04:35 PM, Stefan Keller wrote: > Hi Rémi > > You're probably right: > Having a lightweight database in between would have some advantages > since LibreOffice (calc) locks files. > On the other hand a database makes adding rows more complicated... > > Cheers, S. > > 2015-04-26 16:11 GMT+02:00 Rémi Cura : >> Hey, >> you could use SQLite as an itermediary. >> As far as I know, QGIS can natively read/write into SQLite tables, and use >> it anyway. >> And as far as I know, Open Office can easily read and write data in/from >> SQLIte. >> >> It would be very close to what you want, without the need to write a QGIS >> extension. >> You would just have to write the LibreOffice plugin >> >> Cheers, >> Rémi-C >> >> 2015-04-25 22:07 GMT+02:00 Stefan Keller : >>> Hi Vaclav >>> >>> Thanks for the hint. >>> Interesting talk about Geodesign (which to me is a synonym decision >>> support) and open source tools like PostGIS, QGIS and LibreOffice. >>> But there, QGIS is connected to LibreOffice via PostgreSQL/PostGIS. >>> I'm looking for a direct connection between QGIS and LibreOffice calc. >>> >>> -S. >>> >>> >>> 2015-04-25 18:43 GMT+02:00 Vaclav Petras : On Sat, Apr 25, 2015 at 11:49 AM, Stefan Keller wrote: > What about a plugin to open and synchronize an attribute table between > QGIS and LibreOffice? There was a talk at FOSS4G PDX 2014 which described combination of PostGIS/PostgreSQL+QGIS+LibreOffice: Geodesign: An Introduction to Design with Geography — Matthew Baker, Denver Public Schools, Critter Thompson, Placematters https://vimeo.com/106233274 5:00-15:00 > This would also require to write a LibreOffice extension. > As an inspiration see this ArcGIS extension called "gisconnector" [1] > > --S. > > [1] > > http://www.gislounge.com/gisconnector-excel-synchronize-data-selections-filters-arcgis-excel/ > ___ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer >>> ___ >>> Qgis-developer mailing list >>> Qgis-developer@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/qgis-developer >> > ___ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
