[QGIS-Developer] Appending text data to a geopackage

Paolo Cavallini cavallini at faunalia.it
Fri Oct 26 01:48:13 PDT 2018


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  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/
>>
>> _______________________________________________
>> 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
> -- 
> 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
> 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/20181026/32b94f47/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/32b94f47/attachment-0001.png>


More information about the QGIS-Developer mailing list