<!DOCTYPE html><html><head>
<style type="text/css">body { font-family:'DejaVu Sans Mono'; font-size:12px}</style>
</head>
<body>Am 10.11.2015, 16:00 Uhr, schrieb kimaidou <kimaidou@gmail.com>:<br><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div dir="ltr"><div><div><div>Hi,<br><br></div>You could probably try the last "master" QGIS and processing, as René-Luc (rldhont) added a couple of days ago the ability to save scripts and algs result layers into a spatialite database. Combined with the tool "Refactor" ( visible in the Processing toolbox), and using your initial spatialite table, this could do the trick without the need to create a new plugin for this.<br></div></div></div></blockquote><div><br></div><div>Nice! Seems to work so far! </div><div>Now some people should be really really brave and make the sqlite entry the first in the dropdown menu when saving to file and push ESRI shapefile to the end ;)</div><div><br></div><div>Thanx for the hint</div><div>Bernd</div><div><br></div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div dir="ltr"><div><div><br></div>Regards<br></div>Michaël<br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-11-10 15:42 GMT+01:00 Bernd Vogelgesang <span dir="ltr"><<a href="mailto:bernd.vogelgesang@gmx.de" target="_blank">bernd.vogelgesang@gmx.de</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="direction:ltr" text="#000000" bgcolor="#FFFFFF"><div>Hi Micha,</div><div><br></div><div>yeah, working with spatialite dbs "seriously" is still quite uncomfortable.</div><div>When I try, I mostly have to use all available means to get the work done: DBManager, QSpatialite, SpatialiteGUI. Unfortunately I easily forget how sql works, so doing "easy" stuff becomes very time consuming and frustrating.</div><div><br></div><div>Do you think it would be technically possible to create a plugin like Table Manager plugin, that records the changes you want to do to the table and then creates the necessary sql commands and performs all that stuff in one go?</div><div><br></div><div>Cause this would be sth I really would be interested donating money on!</div><div><br></div><div>Cheers</div><div>Bernd</div><div><div class="h5"><div><br></div><div>Am 10.11.2015, 15:26 Uhr, schrieb Micha Silver <<a href="mailto:micha@arava.co.il" target="_blank">micha@arava.co.il</a>>:<br></div><br><blockquote style="margin:0 0 0.80ex;border-left:#0000ff 2px solid;padding-left:1ex">
I have found that QGIS cannot "see" any spatialite column that comes
after the "geometry" column. When I alter a table, adding a column
in a Spatialite, the new column which is after the geometry column
in the database table just does not appear in QGIS. If I recreate
the table, reordering the columns so that the geometry is last, all
is good again.<br>
<br>
Is this a bug? or am I missing something?<br>
<br>
It's quite annoying considering that sqlite does not have any simple
way to shuffle the columns around, other than dropping and
recreating the table. And if I have foreign constraints defined, it
becomes a whole row of dominoes that come down...<br>
<br>
Thanks,<br>
Micha<br>
</blockquote><br><br><br></div></div><div><div>-- </div><div>Bernd Vogelgesang<br>Siedlerstraße 2<br>91083 Baiersdorf/Igelsdorf<br>Tel: 09133-825374</div></div></div><br>_______________________________________________<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="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div>
</blockquote><br><br><br><div id="M2Signature"><div>-- </div><div>Bernd Vogelgesang<br>Siedlerstraße 2<br>91083 Baiersdorf/Igelsdorf<br>Tel: 09133-825374</div></div></body></html>