Merging Yojimbo DBs

2007-12-17 Thread Jacob Lyles


RE: ~/Library/Application Support/Yojimbo/Database.sqlite file


Anyone have a way to merge several of these into one (working) Yojimbo DB?

I have several backed up versions which have different contents and I'd like
to unify them.

Thanks,

Jacob



-- 
--
This message is sent to you because you are subscribed to
  the mailing list yojimbo-talk@barebones.com.
To unsubscribe, send mail to: [EMAIL PROTECTED]
List archives:  http://www.listsearch.com/yojimbotalk.lasso
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: [EMAIL PROTECTED]


Re: Merging Yojimbo DBs

2007-12-17 Thread Matthew Smith
If you have a .Mac account you could use its syncing capability to do this.

-- 
Matthew Smith

 
On Tuesday, December 18, 2007, at 04:22AM, Jacob Lyles [EMAIL PROTECTED] 
wrote:


RE: ~/Library/Application Support/Yojimbo/Database.sqlite file


Anyone have a way to merge several of these into one (working) Yojimbo DB?

I have several backed up versions which have different contents and I'd like
to unify them.

Thanks,

Jacob



-- 
--
This message is sent to you because you are subscribed to
  the mailing list yojimbo-talk@barebones.com.
To unsubscribe, send mail to: [EMAIL PROTECTED]
List archives:  http://www.listsearch.com/yojimbotalk.lasso
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: [EMAIL PROTECTED]



-- 
--
This message is sent to you because you are subscribed to
  the mailing list yojimbo-talk@barebones.com.
To unsubscribe, send mail to: [EMAIL PROTECTED]
List archives:  http://www.listsearch.com/yojimbotalk.lasso
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: [EMAIL PROTECTED]


Re: Merging Yojimbo DBs

2007-12-17 Thread Matthew Smith

Actually, I was thinking more of creating separate user accounts on the 
computer for each version of the database. .Mac would treat them as separate 
databases.

-- 
Matthew Smith

 
On Tuesday, December 18, 2007, at 10:41AM, Rhet Turnbull [EMAIL PROTECTED] 
wrote:
I strongly suspect that .Mac would get very confused if the contents  
of the databases varied much. Presumably what Matthew suggested would  
go something like this: sync the Yj database to .Mac. Disable syncing  
and replace the Yj database with one of the other versions. Re-enable  
syncing and sync to .Mac again. If you do this, .Mac may think that  
items not in the new database were deleted and also delete them  
from .Mac instead of merging them.  You can probably tell the .Mac  
sync service to merge the .Mac and local version but I think this is  
risky, especially if the databases are large.

Then again, messing the with the raw sqlite databases is even riskier  
since you don't know anything about Yojimbo's internal data schema.   
A quick peek at the database using sqlite databrowser ( http:// 
sqlitebrowser.sourceforge.net/) shows that the schema is non-trivial  
and I sure wouldn't want to mess with it!

The easiest way to do this is to export all the contents in Yojimbo  
then swamp databases and import everything back into Yojimbo.  This  
is pretty easy to do: Select the library collection, select  
everything in the Library (Cmd-A), select File | Export and export  
them to a new folder.  Then swap databases, and select File | Import  
in Yojimbo and re-import everything.  The downside is that you'll  
lose all metadata when you do this: e.g. tags, collections, labels,  
flags; also encrypted items will be decrypted for export so you'll  
have to re-encrypt them.

Whatever you do, make sure you backup all the Yj databases before you  
begin!

Cheers,
Rhet

On Dec 17, 2007, at 5:15 PM, Matthew Smith wrote:

 If you have a .Mac account you could use its syncing capability to  
 do this.

 -- 
 Matthew Smith


 On Tuesday, December 18, 2007, at 04:22AM, Jacob Lyles  
 [EMAIL PROTECTED] wrote:


 RE: ~/Library/Application Support/Yojimbo/Database.sqlite file


 Anyone have a way to merge several of these into one (working)  
 Yojimbo DB?

 I have several backed up versions which have different contents  
 and I'd like
 to unify them.

 Thanks,

 Jacob



 -- 
 --
 This message is sent to you because you are subscribed to
  the mailing list yojimbo-talk@barebones.com.
 To unsubscribe, send mail to: [EMAIL PROTECTED]
 List archives:  http://www.listsearch.com/yojimbotalk.lasso
 Have a feature request, or not sure if the software's working
 correctly? Please send mail to: [EMAIL PROTECTED]



 -- 
 --
 This message is sent to you because you are subscribed to
   the mailing list yojimbo-talk@barebones.com.
 To unsubscribe, send mail to: [EMAIL PROTECTED]
 List archives:  http://www.listsearch.com/yojimbotalk.lasso
 Have a feature request, or not sure if the software's working
 correctly? Please send mail to: [EMAIL PROTECTED]


-- 
--
This message is sent to you because you are subscribed to
  the mailing list yojimbo-talk@barebones.com.
To unsubscribe, send mail to: [EMAIL PROTECTED]
List archives:  http://www.listsearch.com/yojimbotalk.lasso
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: [EMAIL PROTECTED]



-- 
--
This message is sent to you because you are subscribed to
  the mailing list yojimbo-talk@barebones.com.
To unsubscribe, send mail to: [EMAIL PROTECTED]
List archives:  http://www.listsearch.com/yojimbotalk.lasso
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: [EMAIL PROTECTED]


Re: Merging Yojimbo DBs

2007-12-17 Thread TjL
FWIW my experience with dot-Mac and Yojimbo with about 1100 items in
my DB is nothing short of horrible.  It continually times out, throws
an error, tries the resync the entire DB, fails again.

I suspect (but can't prove) that dot-Mac's failure to sync Yojimbo was
responsible for the bulk of about 1gb of upload traffic I had last
month when I tried to use it.

Until someone comes out with a new way to sync across a LAN, I've
turned off Yojimbo syncing in dot-Mac.  At the very least make good
backups before you go.

TjL

ps - I'd happily pay for an app to sync my Yojimbo DBs between 2-3
computers w/o needing dot-Mac

-- 
--
This message is sent to you because you are subscribed to
  the mailing list yojimbo-talk@barebones.com.
To unsubscribe, send mail to: [EMAIL PROTECTED]
List archives:  http://www.listsearch.com/yojimbotalk.lasso
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: [EMAIL PROTECTED]