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