[QGIS-Developer] Appending text data to a geopackage

[Paolo Cavallini]

Right, obrigado Alex.


Il 10/26/2018 11:11 AM, Alexandre Neto ha scritto:
> 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 <mailto: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 <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
>>>>     <tel:+39%20010%20856%206195>  mobile:+39 393 1590711
>>>>     <tel:+39%20393%20159%200711>
>>>>        e-mail: bertelli at chartasrl.eu
>>>>     <mailto:bertelli at chartasrl.eu>      http://www.chartasrl.eu
>>>>     --------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>
>>>     -- 
>>>     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
>>     -- 
>>     Marco Bernasocchi
>>     QGIS.org Co-chair
>>     marco at opengis.ch <mailto:marco at opengis.ch>
>>     +41 (0)79 467 24 70 <tel:+41794672470>
>>
>>     OPENGIS.ch Logo <https://www.opengis.ch>
>>
>>
>>     _______________________________________________
>>     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
>
>     -- 
>     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
>
> -- 
> Alexandre Neto
> ---------------------
> @AlexNetoGeo
> http://sigsemgrilhetas.wordpress.com
> http://gisunchained.wordpress.com
>
>
> _______________________________________________
> 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

-- 
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/20181028/d7126849/attachment.html>