<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
I don’t know if this is bad advice in the GRASS WIKI or a bug in a GRASS database module. I have some vector files that were somehow imported into a dbf DBMS last year. I wanted to switch them all to sqlite. The GRASS WIKI advises…
<div class=""><br class="">
</div>
<div class="">Convert automatically all GRASS 6 vector maps to GRASS 7 (including attribute transfer from DBF to SQLite)</div>
<div class=""><br class="">
To become readable in GRASS 7, all vector maps in a mapset need to be updated to the improved vector file format (i.e., rebuild the topology with v.build.all along with the change to the SQLite database backend (SQLite is the new default in GRASS 7 instead
of DBF in GRASS 6, using db.connect and v.db.reconnect.all).<br class="">
<br class="">
Run this in GRASS GIS 7:<br class="">
<br class="">
# first rebuild topology for all vector maps in current mapset
<div class="">v.build.all</div>
<div class=""> </div>
# define new default DB connection (switch from DBF to SQLite)
<div class="">db.connect -d</div>
<div class=""><br class="">
</div>
# transfer all attribute tables from DBF to SQLite and clean old DBF tables
<div class="">v.db.reconnect.all -cd</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">The vectors already had GRASS 7 topology, but I ran v.rebuild.all just to be sure. No problem.</div>
<div class=""><br class="">
</div>
<div class="">db.connect -d ran with no problem</div>
<div class=""><br class="">
</div>
<div class="">But v.db.reconnect.all -cd did not create tables in the sqlite database and corrupted the existing connection of the first table it hit. Fortunately, I made a backup of the mapset before I started this.</div>
<div class="">
<div class=""><br class="">
</div>
<div class="">GRASS 7.1.svn (Spain_fieldwork_medlands_ERTS89_Z30):~ > v.db.reconnect.all -cd<br class="">
<br class="">
--------------------------------------------------------------------------------<br class="">
Reconnecting vector map <catastro@surveyboundaries> (1 of 9)...<br class="">
--------------------------------------------------------------------------------<br class="">
Copying table <catastro> to target database...<br class="">
Traceback (most recent call last):<br class="">
File "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/scripts/db.droptable", line 99, in <module><br class="">
main()<br class="">
File "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/scripts/db.droptable", line 77, in main<br class="">
used = grass.db.db_table_in_vector(table)<br class="">
File "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/etc/python/grass/script/db.py", line 184, in db_table_in_vector<br class="">
from vector import vector_db<br class="">
ImportError: No module named vector<br class="">
ERROR: Unable to drop table <catastro><br class="">
GRASS 7.1.svn (Spain_fieldwork_medlands_ERTS89_Z30):~ > <br class="">
<br class="">
</div>
<div class="">Michael<br class="">
<div apple-content-edited="true" class="">
<div style="letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="orphans: 2; text-align: -webkit-auto; text-indent: 0px; widows: 2; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<span class="Apple-style-span" style="border-collapse: separate; orphans: 2; text-indent: 0px; widows: 2; border-spacing: 0px;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<span class="Apple-style-span" style="border-collapse: separate; orphans: 2; text-indent: 0px; widows: 2; border-spacing: 0px;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<span class="Apple-style-span" style="border-collapse: separate; orphans: 2; text-indent: 0px; widows: 2; border-spacing: 0px;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<span class="Apple-style-span" style="border-collapse: separate; orphans: 2; text-indent: 0px; widows: 2; border-spacing: 0px;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<span class="Apple-style-span" style="border-collapse: separate; orphans: 2; text-indent: 0px; widows: 2; border-spacing: 0px;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<span class="Apple-style-span" style="border-collapse: separate; orphans: 2; text-indent: 0px; widows: 2; border-spacing: 0px;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<span class="Apple-style-span" style="border-collapse: separate; orphans: 2; text-indent: 0px; widows: 2; border-spacing: 0px;">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px;" class="">
____________________</div>
<div style="font-variant: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<font face="Helvetica" size="3" class="">C. Michael Barton</font></div>
<div style="font-variant: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<font face="Helvetica" size="3" class="">Director, Center for Social Dynamics & Complexity </font></div>
<div style="font-variant: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<font face="Helvetica" size="3" class="">Professor of Anthropology, School of Human Evolution & Social Change</font></div>
<div class=""><font face="Helvetica" size="3" class="">Head, Graduate Faculty in Complex Adaptive Systems Science</font></div>
<div style="font-variant: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<font face="Helvetica" size="3" class="">Arizona State University</font></div>
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px;" class="">
<br class="">
</div>
<font face="Helvetica" size="3" class=""><font class="">voice: </font><font class="">480-965-6262 (SHESC), 480-965-8130/727-9746 (CSDC)</font><br class="">
<font class="">fax: 480-965-7671 (SHESC), 480-727-0709 (CSDC)</font><br class="">
</font>
<div style="font-variant: normal; letter-spacing: normal; line-height: normal; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<font face="Helvetica" size="3" class="">www: <a href="http://www.public.asu.edu/~cmbarton" class="">
http://www.public.asu.edu/~cmbarton</a>, <a href="http://csdc.asu.edu" class="">http://csdc.asu.edu</a></font></div>
<br class="">
</div>
<br class="">
</div>
</span><br class="Apple-interchange-newline">
</div>
</span><br class="Apple-interchange-newline">
</div>
</span><br class="Apple-interchange-newline">
</div>
</span><br class="Apple-interchange-newline">
</div>
</span><br class="Apple-interchange-newline">
</div>
</span><br class="Apple-interchange-newline">
</div>
</span><br class="Apple-interchange-newline">
</div>
</span><br class="Apple-interchange-newline">
</div>
<br class="Apple-interchange-newline">
</div>
<br class="Apple-interchange-newline">
</div>
<br class="Apple-interchange-newline">
<br class="Apple-interchange-newline">
</div>
<br class="">
</div>
</div>
</div>
</body>
</html>