> On Sep 5, 2015, at 11:26 AM, Markus Neteler <[email protected]> wrote: > > On Sat, Sep 5, 2015 at 7:51 PM, Michael Barton <[email protected]> wrote: >> 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… >> >> Convert automatically all GRASS 6 vector maps to GRASS 7 (including >> attribute transfer from DBF to SQLite) > > > https://grasswiki.osgeo.org/wiki/Convert_all_GRASS_6_vector_maps_to_GRASS_7 > > ... > >> The vectors already had GRASS 7 topology, but I ran v.rebuild.all just to be >> sure. No problem. >> >> db.connect -d ran with no problem >> >> But v.db.reconnect.all -cd did not create tables in the sqlite database > > But the sqlite file is there?
yes > >> and corrupted the existing connection of the first table it hit. >> Fortunately, I >> made a backup of the mapset before I started this. > > Perhaps a problem on Mac? > This is strange - I have converted so many mapsets like that ..., even > with lots of vector maps inside. > The wiki page is there for a long time, I didn't see such reports so far. I had to make a new mapset and then copy the files from the old mapset to the new one. All went into sqlite fine that way. > >> GRASS 7.1.svn (Spain_fieldwork_medlands_ERTS89_Z30):~ > v.db.reconnect.all >> -cd >> >> -------------------------------------------------------------------------------- >> Reconnecting vector map <catastro@surveyboundaries> (1 of 9)... >> -------------------------------------------------------------------------------- >> Copying table <catastro> to target database... >> Traceback (most recent call last): >> File >> "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/scripts/db.droptable", >> line 99, in <module> >> main() >> File >> "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/scripts/db.droptable", >> line 77, in main >> used = grass.db.db_table_in_vector(table) >> File >> "/Applications/GRASS/GRASS-7.1.app/Contents/MacOS/etc/python/grass/script/db.py", >> line 184, in db_table_in_vector >> from vector import vector_db >> ImportError: No module named vector > > Maybe something got broken in GRASS 7.1? > > I would definitely use 7.0 for such operations. I’ll check Michael > > Markus > >> ERROR: Unable to drop table <catastro> >> GRASS 7.1.svn (Spain_fieldwork_medlands_ERTS89_Z30):~ > >> >> Michael >> ____________________ >> C. Michael Barton >> Director, Center for Social Dynamics & Complexity >> Professor of Anthropology, School of Human Evolution & Social Change >> Head, Graduate Faculty in Complex Adaptive Systems Science >> Arizona State University >> >> voice: 480-965-6262 (SHESC), 480-965-8130/727-9746 (CSDC) >> fax: 480-965-7671 (SHESC), 480-727-0709 (CSDC) >> www: http://www.public.asu.edu/~cmbarton, http://csdc.asu.edu _______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
