[Qgis-developer] Plugin to synchronize an attribute table between QGIS and LibreOffice?

Stefan Keller sfkeller at gmail.com
Sun Apr 26 07:35:55 PDT 2015


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 <remi.cura at gmail.com>:
> 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 <sfkeller at gmail.com>:
>>
>> 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 <wenzeslaus at gmail.com>:
>> >
>> > On Sat, Apr 25, 2015 at 11:49 AM, Stefan Keller <sfkeller at gmail.com>
>> > 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 at lists.osgeo.org
>> >> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>> >
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>


More information about the Qgis-developer mailing list