[QGIS-Developer] Appending text data to a geopackage

[Alexandre Neto]

Hi Paolo,

After loading  the text as a delimited text layer, If the attributes are
formatted exactly as the destination table, you can GDAL's Import vector
into PostGIS database processing tool, which contains an "append" option.

Alexandre Neto

Paolo Cavallini <cavallini at faunalia.it> escreveu no dia sexta, 26/10/2018
às 09:48:

> yes, thanks. aa bit of a hack, I wish we could have a cleaner solution;
> thanks a lot for the suggestion.
>
> all the best.
>
> Il 10/24/2018 10:08 PM, Marco Bernasocchi ha scritto:
>
> Import the new text as csv in qgis anc copy paste it to the gpkg layer?
>
> ciao
> On 10.10.18 16:18, Paolo Cavallini wrote:
>
> 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>
> 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
>> QGIS.ORG Chair:
>> http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>>
>>
>> _______________________________________________
>> QGIS-Developer mailing list
>> 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
> <+39%20010%20856%206195>  mobile:+39 393 1590711 <+39%20393%20159%200711>
>    e-mail: bertelli at chartasrl.eu      http://www.chartasrl.eu
> --------------------------------------------------------------------------
>
>
>
>
> --
> Paolo Cavallini - www.faunalia.euQGIS.ORG Chair:http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
>
> _______________________________________________
> QGIS-Developer mailing listQGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
> --
> Marco Bernasocchi
> QGIS.org Co-chair
> marco at opengis.ch
> +41 (0)79 467 24 70 <+41794672470>
>
> [image: OPENGIS.ch Logo] <https://www.opengis.ch>
>
>
> _______________________________________________
> QGIS-Developer mailing listQGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>
>
> --
> Paolo Cavallini - www.faunalia.euQGIS.ORG Chair:http://planet.qgis.org/planet/user/28/tag/qgis%20board/
>
> _______________________________________________
> QGIS-Developer mailing list
> 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

-- 
Alexandre Neto
---------------------
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20181026/e75ea4f7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 6671 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20181026/e75ea4f7/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 6671 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20181026/e75ea4f7/attachment-0003.png>