Re: Merging Yojimbo DBs

[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 .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>

Re: Merging Yojimbo DBs

[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 .
>>> To unsubscribe, send mail to: <[EMAIL PROTECTED]>
>>> List archives:  
>>> 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 .
>> To unsubscribe, send mail to: <[EMAIL PROTECTED]>
>> List archives:  
>> 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 .
>To unsubscribe, send mail to: <[EMAIL PROTECTED]>
>List archives:  
>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 .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>

Re: Merging Yojimbo DBs

[Rhet Turnbull]

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 .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
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 .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
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 .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>

Re: Merging Yojimbo DBs

[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 .
>To unsubscribe, send mail to: <[EMAIL PROTECTED]>
>List archives:  
>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 .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>

Re: Merging Yojimbo DBs

[pete boardman]

On 17 Dec 2007, at 11:49, Jacob Lyles 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.


It's relatively straightforward (although extremely tedious) to open  
up sqlite databases and dump their contents.  You can even compare  
two sqlite dumps ...


> diff file1.txt file.txt
732d731
< INSERT INTO "ZBLOB" VALUES(3, 770, 1,  
'06C16BD6-6D53-4068-8172-04FD1F092592', NULL,  
X'62706C6973743030D4010203040506070A59246172636869766572582476657273696F 
6E5424746F7058246F626A656374735F100F4E534B657965644172636869766572120001 
86A0D1080954726F6F748001AA0B0C13141C1D25262B2E55246E756C6CD30D


If this was an iPhone hack of interest to millions, no doubt someone  
would study it in great detail, but for a one-off task it's going to  
be quicker and easier to export some data from one file, swap the  
database for another one, and import it again...


While reading the database file is probably safe enough, I expect  
that there are warnings in the Yojimbo documentation to the effect  
that one shouldn't try to mess with the data other than via the  
correct interface. So I think the solution is to identify the changed  
items somehow and export/import them using commands or AppleScript.


pete



--
--
This message is sent to you because you are subscribed to
 the mailing list .
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
List archives:  
Have a feature request, or not sure if the software's working 
correctly? Please send mail to: <[EMAIL PROTECTED]>