Merging Yojimbo DBs
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: Applescripting Yojimbo: Empty items?
On 12 Dec 2007, at 14:25, Jacob Lyles wrote: Any ideas how to implement in Applescript a check for empty Web Archive items? (i.e. Failed downloads) On 12/12/07 6:49 PM, pete boardman [EMAIL PROTECTED] responded: [...] This code finds some of my web archives that don't appear in the browser. [snip code for searching for empty comments field] It's as if the source URL and the comments field agree only when the web archive has been downloaded. In order to prevent (and recover) from this sort of problem, in my scripts, when I create the Web Archive (WA) item, I create it with the URL already in the comments field. Thus, I don't end up with empty WA items that (aside from being empty ) don't have an associated URL. So, searching for an empty comment field is a bit useless for me (but 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
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
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
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]
