[QGIS-Developer] Appending text data to a geopackage

[Paolo Cavallini]

Hi Carlo,

I think I didn't explain my problem well: I have new data coming as
text, and I'm looking for an easy way of appending these to an existing
gpkg table.

Thanks.


Il 10/10/2018 02:30 PM, Carlo A. Bertelli (Charta s.r.l.) ha scritto:
> What about working on a geometric view with properly configured rules
> while on PostgresSQL or with a trigger on other DBMSs (SQLite too)? It
> seems the easiest way to avoid the shell. Maybe there could even be a
> way with a virtual file based on internal SQLite... Just a thought...
> c
>
> On Wed, Oct 10, 2018 at 8:39 AM Paolo Cavallini <cavallini at faunalia.it
> <mailto:cavallini at faunalia.it>> wrote:
>
>     Hi all,
>
>     I have a simple problem for which I cannot find a simple solution: I
>     have a table in a gpkg, and I have to add often data coming from text.
>     Ideally I'd like to paste the text as a new record, having it parsed
>     automatically. Currently this only seems possible from an SQL shell.
>     Anything I'm overlooking?
>
>     All the best, and thanks.
>
>     -- 
>     Paolo Cavallini - www.faunalia.eu <http://www.faunalia.eu>
>     QGIS.ORG <http://QGIS.ORG> Chair:
>     http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
>
>     _______________________________________________
>     QGIS-Developer mailing list
>     QGIS-Developer at lists.osgeo.org <mailto:QGIS-Developer at lists.osgeo.org>
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
>
> -- 
> --------------------------------------------------------------------------
> Carlo A. Bertelli
>    Charta servizi e sistemi per il territorio e la storia ambientale srl
>           Dipendenze del palazzo Doria,
>           vc. alla Chiesa della Maddalena 9/2 16124      Genova (Italy)
>           tel./fax +39(0)10 2475439  +39 0108566195  mobile:+39 393
> 1590711
>    e-mail: bertelli at chartasrl.eu <mailto:bertelli at chartasrl.eu>     
> http://www.chartasrl.eu
> --------------------------------------------------------------------------
>
>
>

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20181010/89ed446c/attachment-0001.html>