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 <cavall...@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 <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 >> 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 > > > > -- > -------------------------------------------------------------------------- > 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 > <+39%20010%20856%206195> mobile:+39 393 1590711 <+39%20393%20159%200711> > e-mail: berte...@chartasrl.eu http://www.chartasrl.eu > -------------------------------------------------------------------------- > > > > > -- > Paolo Cavallini - www.faunalia.euQGIS.ORG > Chair:http://planet.qgis.org/planet/user/28/tag/qgis%20board/ > > > _______________________________________________ > QGIS-Developer mailing listqgis-develo...@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 > +41 (0)79 467 24 70 <+41794672470> > > [image: OPENGIS.ch Logo] <https://www.opengis.ch> > > > _______________________________________________ > QGIS-Developer mailing listqgis-develo...@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.euQGIS.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 -- Alexandre Neto --------------------- @AlexNetoGeo http://sigsemgrilhetas.wordpress.com http://gisunchained.wordpress.com
_______________________________________________ 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
