<div dir="ltr">Hi Paolo,<br><div><br>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.</div><div><br></div><div>Alexandre Neto<br></div></div><br><div class="gmail_quote"><div dir="ltr">Paolo Cavallini <<a href="mailto:cavallini@faunalia.it">cavallini@faunalia.it</a>> escreveu no dia sexta, 26/10/2018 às 09:48:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>yes, thanks. aa bit of a hack, I wish we could have a cleaner
solution; thanks a lot for the suggestion.</p>
<p>all the best.<br>
</p></div><div text="#000000" bgcolor="#FFFFFF">
<br>
<div class="m_-7567969109828649497moz-cite-prefix">Il 10/24/2018 10:08 PM, Marco
Bernasocchi ha scritto:<br>
</div>
<blockquote type="cite">
<p>Import the new text as csv in qgis anc copy paste it to the
gpkg layer?</p>
<p>ciao<br>
</p>
<div class="m_-7567969109828649497moz-cite-prefix">On 10.10.18 16:18, Paolo Cavallini
wrote:<br>
</div>
<blockquote type="cite">
<p>Hi Carlo,</p>
<p>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.</p>
<p>Thanks.<br>
</p>
<br>
<div class="m_-7567969109828649497moz-cite-prefix">Il 10/10/2018 02:30 PM, Carlo A.
Bertelli (Charta s.r.l.) ha scritto:<br>
</div>
<blockquote type="cite">
<div dir="ltr">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...
<div>c</div>
<br>
<div class="gmail_quote">
<div dir="ltr">On Wed, Oct 10, 2018 at 8:39 AM Paolo
Cavallini <<a href="mailto:cavallini@faunalia.it" target="_blank">cavallini@faunalia.it</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi
all,<br>
<br>
I have a simple problem for which I cannot find a simple
solution: I<br>
have a table in a gpkg, and I have to add often data
coming from text.<br>
Ideally I'd like to paste the text as a new record,
having it parsed<br>
automatically. Currently this only seems possible from
an SQL shell.<br>
Anything I'm overlooking?<br>
<br>
All the best, and thanks.<br>
<br>
-- <br>
Paolo Cavallini - <a href="http://www.faunalia.eu" rel="noreferrer" target="_blank">www.faunalia.eu</a><br>
<a href="http://QGIS.ORG" rel="noreferrer" target="_blank">QGIS.ORG</a>
Chair:<br>
<a href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/" rel="noreferrer" target="_blank">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a><br>
<br>
<br>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="m_-7567969109828649497gmail_signature" data-smartmail="gmail_signature">--------------------------------------------------------------------------<br>
Carlo A. Bertelli<br>
Charta servizi e sistemi per il territorio e la storia
ambientale srl <br>
Dipendenze del palazzo Doria, <br>
vc. alla Chiesa della Maddalena 9/2 16124
Genova (Italy)<br>
tel./fax +39(0)10 2475439 <a href="tel:+39%20010%20856%206195" value="+390108566195" target="_blank">+39 0108566195</a>
mobile:<a href="tel:+39%20393%20159%200711" value="+393931590711" target="_blank">+39 393 1590711</a><br>
e-mail: <a href="mailto:bertelli@chartasrl.eu" target="_blank">bertelli@chartasrl.eu</a>
<a href="http://www.chartasrl.eu" target="_blank">http://www.chartasrl.eu</a><br>
--------------------------------------------------------------------------<br>
<br>
<br>
<br>
</div>
</div>
</blockquote>
<br>
<pre class="m_-7567969109828649497moz-signature" cols="72">--
Paolo Cavallini - <a class="m_-7567969109828649497moz-txt-link-abbreviated" href="http://www.faunalia.eu" target="_blank">www.faunalia.eu</a>
<a href="http://QGIS.ORG" target="_blank">QGIS.ORG</a> Chair:
<a class="m_-7567969109828649497moz-txt-link-freetext" href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/" target="_blank">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a></pre>
<br>
<fieldset class="m_-7567969109828649497mimeAttachmentHeader"></fieldset>
<pre class="m_-7567969109828649497moz-quote-pre">_______________________________________________
QGIS-Developer mailing list
<a class="m_-7567969109828649497moz-txt-link-abbreviated" href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a>
List info: <a class="m_-7567969109828649497moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
Unsubscribe: <a class="m_-7567969109828649497moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></pre>
</blockquote>
<div class="m_-7567969109828649497moz-signature">-- <br>
<div class="m_-7567969109828649497moz-signature">
<div class="m_-7567969109828649497moz-signature"> <span style="text-align:left;color:#000000;font-family:'Verdana',sans-serif;font-size:10pt">Marco Bernasocchi</span><br>
<span style="text-align:left;color:#000000;font-family:'Verdana',sans-serif;font-size:10pt">QGIS.org Co-chair</span><br>
<a href="mailto:marco@opengis.ch" target="_blank"> <span style="text-align:left;color:#000000;font-family:'Verdana',sans-serif;font-size:8pt">marco@opengis.ch</span> </a><br>
<span style="text-align:left;color:#000000;font-family:'Verdana',sans-serif;font-size:8pt"><a href="tel:+41794672470" target="_blank">+41 (0)79
467 24 70</a></span><br>
<div><br>
<a href="https://www.opengis.ch" target="_blank"> <img src="cid:part17.AF6B1933.C30F916C@faunalia.it" alt="OPENGIS.ch Logo" width="200" height="80"></a>
</div>
</div>
</div>
</div>
<br>
<fieldset class="m_-7567969109828649497mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
QGIS-Developer mailing list
<a class="m_-7567969109828649497moz-txt-link-abbreviated" href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a>
List info: <a class="m_-7567969109828649497moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
Unsubscribe: <a class="m_-7567969109828649497moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></pre>
</blockquote>
<br>
<pre class="m_-7567969109828649497moz-signature" cols="72">--
Paolo Cavallini - <a class="m_-7567969109828649497moz-txt-link-abbreviated" href="http://www.faunalia.eu" target="_blank">www.faunalia.eu</a>
<a href="http://QGIS.ORG" target="_blank">QGIS.ORG</a> Chair:
<a class="m_-7567969109828649497moz-txt-link-freetext" href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/" target="_blank">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a></pre>
</div>
_______________________________________________<br>
QGIS-Developer mailing list<br>
<a href="mailto:QGIS-Developer@lists.osgeo.org" target="_blank">QGIS-Developer@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Alexandre Neto</div><div>---------------------</div><div>@AlexNetoGeo</div><div><a href="http://sigsemgrilhetas.wordpress.com">http://sigsemgrilhetas.wordpress.com</a></div><a href="http://gisunchained.wordpress.com">http://gisunchained.wordpress.com</a><br></div></div>