<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi Alessandro,</p>
<p>Interesting. Deferred handling of bad layers is kind of related, but not exactly the same.</p>
<p>In my case I want to "bulk-change" a lot of layers (60+) from Postgis to Geopackage. The data itself is already converted and has exactly the same structure. After the data source change I want the data source to be permanent in the new project. So it is not just one or two, but a lot of layers. Some of them have additional filters, some don't.</p>
<p>Or - even better - allow to switch back and forth between Postgis and Geopackage from within the same project.</p>
<p>But <a href="https://github.com/qgis/QGIS/pull/8359" target="_blank" rel="noopener noreferrer">https://github.com/qgis/QGIS/pull/8359</a> is already a very good start. Would it also handle "bulk" change for all data from the same source?</p>
<p>Thanks,<br />Andreas</p>
<p>On 2018-11-05 16:49, Alessandro Pasotti wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<div dir="ltr">
<div dir="ltr"> </div>
<div dir="ltr">If you mean change data source functionality, this is now available in <a href="https://github.com/qgis/QGIS/pull/8359" target="_blank" rel="noopener noreferrer">https://github.com/qgis/QGIS/pull/8359</a></div>
<div dir="ltr"> </div>
<div>There is also a new "Change data source..." menu entry in the layer's contextual menu, implemented for rasters and vectors.</div>
<div> </div>
<div> </div>
<div dir="ltr"> </div>
</div>
<br />
<div class="gmail_quote">
<div dir="ltr">On Mon, Nov 5, 2018 at 4:46 PM Paolo Cavallini <<a href="mailto:cavallini@faunalia.it">cavallini@faunalia.it</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin: 0 0 0 .8ex; border-left: 1px #ccc solid; padding-left: 1ex;">
<div>
<p>This seems a good candidate for an extra function of the browser. Probably a simple Py script or a plugin should do, at least as a prototype.</p>
<p>Better add a ticket not to forget?</p>
<p>All the best.</p>
<p><br /></p>
<br />
<div class="m_-7399573642453891244moz-cite-prefix">Il 11/05/2018 03:17 PM, Andreas Neumann ha scritto:</div>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<p>Hi,</p>
<p>Ok - I am doing it in the text editor.</p>
<p>I also had to change</p>
<p><provider encoding="System">postgres</provider></p>
<p>to</p>
<p><provider encoding="System">ogr</provider></p>
<p>After doing this change, it worked.</p>
<p>Andreas</p>
<p>On 2018-11-05 15:01, Alessandro Pasotti wrote:</p>
<blockquote style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0;">
<div dir="ltr">
<div class="gmail_quote">
<div dir="ltr">On Mon, Nov 5, 2018 at 2:54 PM Andreas Neumann <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>> wrote:</div>
<blockquote class="gmail_quote" style="margin: 0 0 0 .8ex; border-left: 1px #ccc solid; padding-left: 1ex;">
<div style="font-size: 10pt; font-family: Verdana,Geneva,sans-serif;">
<p>Hi,</p>
<p>I have a relatively complex QGIS project with data storage in QGIS and would like to change the data source of all layers to Geopackage.</p>
<p>I already have a Geopackage with the exact same data structure like in Postgis (automatic export from Postgis through ogr2ogr).</p>
<p>Now I wonder what the best approach is to change all data sources from Postgis to Geopackage?</p>
<p>Texteditor and search/replace or is there something more comfortable?</p>
</div>
</blockquote>
<div> </div>
<div>Hi Andreas,</div>
<div> </div>
<div>you could first check if it works correctly with one layer, from the python console vl.changeDataSource('/my/new/path|layername=mylayername', 'layer_name', 'ogr')</div>
<div> </div>
<div>then exit without saving the project, make a backup and try search replace.</div>
<div> </div>
</div>
<br /> -- <br />
<div class="m_-7399573642453891244gmail_signature" dir="ltr">Alessandro Pasotti<br /> w3: <a href="http://www.itopen.it" target="_blank" rel="noopener noreferrer">www.itopen.it</a></div>
</div>
</blockquote>
<p><br /></p>
<br /><fieldset class="m_-7399573642453891244mimeAttachmentHeader"></fieldset><br />
<pre>_______________________________________________
Qgis-user mailing list
<a class="m_-7399573642453891244moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="m_-7399573642453891244moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="m_-7399573642453891244moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br />
<pre class="m_-7399573642453891244moz-signature">--
Paolo Cavallini - <a class="m_-7399573642453891244moz-txt-link-abbreviated" href="http://www.faunalia.eu" target="_blank" rel="noopener noreferrer">www.faunalia.eu</a>
<a href="http://QGIS.ORG" target="_blank" rel="noopener noreferrer">QGIS.ORG</a> Chair:
<a class="m_-7399573642453891244moz-txt-link-freetext" href="http://planet.qgis.org/planet/user/28/tag/qgis%20board/" target="_blank" rel="noopener noreferrer">http://planet.qgis.org/planet/user/28/tag/qgis%20board/</a></pre>
</div>
_______________________________________________<br /> Qgis-user mailing list<br /> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br /> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote>
</div>
<br clear="all" /><br />-- <br />
<div class="gmail_signature" dir="ltr">Alessandro Pasotti<br />w3: <a href="http://www.itopen.it" target="_blank" rel="noopener noreferrer">www.itopen.it</a></div>
<br />
<div class="pre" style="margin: 0; padding: 0; font-family: monospace">_______________________________________________<br /> Qgis-user mailing list<br /> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br /> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br /> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</blockquote>
<p><br /></p>
</body></html>