[Qgis-user] Re: Bookmarks

[Alister Hood]

Copying back to the list.

> -----Original Message-----
> From: Chuck Young [mailto:wylie1066 at gmail.com]
> Sent: Tuesday, 28 June 2011 4:34 p.m.
> To: Alister Hood
> Subject: Re: [Qgis-user] Re: Bookmarks
> 
> As always there are things to be careful of.  In my case this was the
only data
> in the db that I needed to replicate.
> 
> Note on MS Access to work with bookmarks etc in spatialite:
> 
> I just tried manipulating data in the bookmarks table using MS Access
through
> the ODBC driver for spatialite.  Found here:  http://www.ch-
> werner.de/sqliteodbc/
> 
> The section where the driver package I needed was here.
>
------------------------------------------------------------------------
-------
> ----------
>     For Win32 operating systems a binary package is available as an
NSIS
> <http://nsis.sf.net/>  installer in sqliteodbc.exe <http://www.ch-
> werner.de/sqliteodbc/sqliteodbc.exe> . It was made with SQLite
2.8.17/3.7.6.3
> and a MinGW cross compiler, and contains the driver DLLs and programs
for
> installation and uninstallation of the ODBC driver.
>
------------------------------------------------------------------------
-------
> ----------
> 
> I added one record to a linked table and opened Qgis, went to the
bookmarks
> form and the added record was there and it went to the coordinates
assigned to
> it.
> 
> Hope this helps!
> 
> Chuck
> 
> 
> On Mon, Jun 27, 2011 at 6:13 PM, Alister Hood
<alister.hood at synergine.com>
> wrote:
> 
> 
> 	Ah.
> 
> 
> 	 -----Original Message-----
> 	> From: Chuck Young [mailto:wylie1066 at gmail.com]
> 	> 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
> 	<alister.hood at synergine.com>
> 	> 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 <wylie1066 at gmail.com>
> 	>       > Subject: [Qgis-user] Re: Bookmarks
> 	>       > To: Qgis-user at lists.osgeo.org
> 	>       > Message-ID:
> 	<BANLkTinFHdLSwixaZHKsrUu9QPevS5PUJA at mail.gmail.com>
> 	>       > 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
> 	<wylie1066 at gmail.com>
> 	>       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
> 
>