Ah. -----Original Message----- > From: Chuck Young [mailto:[email protected]] > Sent: Tuesday, 28 June 2011 9:40 a.m. > To: Alister Hood > Subject: Re: [Qgis-user] Re: Bookmarks > > What I found is that the Spatialite db file "qgis.db" is located in the > Users/(My User Name)/.qgis folder. (I am using Win 7)
Looks like it is a sqlite file, but not a spatialite file :) I was wondering what I could open it with... QGIS of course! > To replicate the bookmarks to another machine just copy that file into the > correct position on the new machine. Restart Qgis. That worked fine. Yes, but this will wipe out some other settings as well, as the file doe not only include bookmarks. But what I can do is open the bookmarks table from qgis.db, open the attribute table, and select and copy all the rows. Then I can open the bookmarks table from qgis.db on the target computer, toggle editing and do "Edit-Paste features". > After I did that I also worked to try to set up a bit different sort. I > exported the tbl_bookmarks table to CSV the sort and re-index and re-import, > but that added some kind of character in front of the xmin field which trhew > all references off. I used MS Excel 2010 to do the csv work so there is > probably a glitch in the csv format between Excel and Spatialite that added the > extra character. After the re-import to a new table all one has to do is use > the Spatialite sql query builder to rename the tables. After the updates are > finished you must restart Qgis. > > I think that if the extra character were not there it csv export, update, re- > import would have worked fine. > > I will try doing it in MS Access to see if I can get a cleaner set of records. > > So I went to the spatialite gui and set up a set of update queries to allow me > to update names and thus to be able to sort on the name field in the Bookmark > form in Qgis. > > I hope this helps. > > Chuck > > > On Sun, Jun 26, 2011 at 11:46 PM, Alister Hood <[email protected]> > wrote: > > > Hi, what way are you doing it? > I know of two rather laborious ways: > 1) go through the bookmarks one at a time, copying and pasting from the > coordinate and scale displays at the bottom of the main QGIS window. > 2) go through the bookmarks one at a time, using the "P2P QGIS" plugin > to grab the window extent of each bookmark. I wonder if it would take > much to modify the P2P plugin to also share bookmarks... > > Alister > > > Date: Sun, 26 Jun 2011 23:07:18 -0700 > > From: Chuck Young <[email protected]> > > Subject: [Qgis-user] Re: Bookmarks > > To: [email protected] > > Message-ID: <[email protected]> > > Content-Type: text/plain; charset="iso-8859-1" > > > > > Never mind. I figured it out. If anyone else has a question on this > let me > > know. There may be another way to do it but what I found works. > > > > > Thanks > > > > Chuck > > > > On Sun, Jun 26, 2011 at 3:19 PM, Chuck Young <[email protected]> > wrote: > > > > > I understand that bookmarks are global at present and that they are > > > available to all projects. I would like to / need to have the > ability to > > > copy the bookmarks from one installation to another so all those on > the > > > project can use the same bookmarks. > > > > > > I saw some discussion on this from several months ago but it didn't > seem to > > > be resolved at that time. > > > > > > Is that possible? Is there a way to save them / export / import > them to > > > get them to the second machine??? > > > > > > Thanks > > > > > > Chuck Alister _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
