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

[Matthias Kuhn]

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 <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
>>
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer