[QGIS-Developer] Appending text data to a geopackage

Marco Bernasocchi marco at opengis.ch
Wed Oct 24 13:08:11 PDT 2018


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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20181024/ef20c006/attachment.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/20181024/ef20c006/attachment.png>


More information about the QGIS-Developer mailing list