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 >>> <cavall...@faunalia.it <mailto:cavall...@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@lists.osgeo.org >>> <mailto:QGIS-Developer@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: berte...@chartasrl.eu <mailto:berte...@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@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 > ma...@opengis.ch <mailto:ma...@opengis.ch> > +41 (0)79 467 24 70 <tel:+41794672470> > > OPENGIS.ch Logo <https://www.opengis.ch> > > > _______________________________________________ > QGIS-Developer mailing list > QGIS-Developer@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/
_______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer