On Sep 6, 2015 1:10 AM, "Michael Barton" <[email protected]> wrote: > > So I decided to try this with 7.0 and looked again at the mapset. It turns out that the folder is there but not the sqlite.db. > > So perhaps we need to add to the WIKI that you might need to create the sqlite.db
To my knowledge GRASS is designed to generate the file automatically, so the absence in your car is a bug. > However, when I tried to create the database, it doesn’t seem to work. > > db.createdb driver=sqlite database=$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db > dbmi: db_create_database() not implemented > dbmi: db_create_database() not implemented > > No error. Just no database. I never used that for above mentioned reason... Markus > > 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 > > > > > > > > > > > > > > > > > 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? > > > >> 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. > > > >> 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. > > > > 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
