Where are notes stored in Logos 4?

Yikes! They shouldn't have done that.

Notes are stored in ...\Logos4\Documents\{random}\Documents\Notes

Your Logos4 folder will be in a different place depending on which version of Windows you're running.

XP: C:\Documents and Settings\{username}\Local Settings\Application Data\Logos4

Vista/Win7: C:\Users\{username}\AppData\Local\Logos4

Thanks so much, Rosie. Does this mean all notes files are now in one database file called "notes.db"? As far as I know, this was not the case in Libronix 3.

Does this mean all notes files are now in one database file called "notes.db"?

Yes. L4 uses one database to store all documents of one type like notes, guides, reading plans etc.

FYI, you might want to change your forum user-name so that spam bots can't harvest your email. Instructions are here:
http://wiki.logos.com/Changing_Forum_Display_Name

FYI, you might want to change your forum user-name so that spam bots can't harvest your email. Instructions are here:
http://wiki.logos.com/Changing_Forum_Display_Name

Thanks for pointing this out. I was also surprised to see my e-mail there as previously my name appeared in my postings. When I followed the steps on the Wiki, my Display Name was already set as my name, not as my e-mail address. So I saved my name again and hope that this post contains my name! 

And no, it did not work. Not sure where the problem lies! [:(]

You have to follow the wiki article exactly!

Yes. L4 uses one database

Thats wrong, sorry Dave.. [:(]

The Notes are actually master/detail format:

 the master (header info for name) is stored in: <Logos4>\Documents\<random>\Documents\DocumentInfo.db

Yes the note details are (as you say) in: <Logos4>\Documents\<random>\Documents\Notes\Notes.db 

its also not as simple as replacing both files as all "document types" are related to this DocumentInfo.db replacing it or Notes.db alone or even both will cause data loss, any new documents [see pic] created since will have disappeared, or if note was in existance it will have have recently added content missing:

If you are going to make a backup I would advise you are better off backing up the whole of the <random>documents folder..

Failure to back up the lot WILL get you unexpected results and result in data integrity issues, however, there is little point of doing that at present because we have no way of forcing Logos to do a one way sync up to the server.

Should we restore our documents from this snapshot, as well as losing all new documents, the restored data may also vanish too unless you start Logos offline.

I was looking at a way of exporting notes to a file from a backup, and then re-adding them to the current files with a new name, but sadly its not as simple as it sounds, theres a lot of data-integrity checks, and stuff that needs hacked/altered in the data to get it to work, so its been shelved for now while I consider how it might be done, but dont hold your breath it may be months

Regards
Dominic

[edited by: DominicM at 1:03 AM (GMT -8) on Sun, May 9 2010] sometimes I know English is my second language

Thats wrong, sorry Dave..

The Notes are actually master/detail format:

Thanks for the clarifying info and the warning, Dominic.

Should we restore our documents from this snapshot, as well as losing all new documents, the restored data may also vanish too

Are you stating that if I restore the full documents folder, and some of the documents are no longer on the server, I will lose all my documents? See http://community.logos.com/forums/t/14534.aspx

It's definitely safer to restore the whole <random>\Documents folder as I've done that on a number of occasions (but with current data).

You have to follow the wiki article exactly!

Thanks, Dave. It looks like I did some shortcuts. Let's hope this one works! 

Are you stating that if I restore the full documents folder, and some of the documents are no longer on the server, I will lose all my documents? See http://community.logos.com/forums/t/14534.aspx

no, I phrased it badly, I think, this is what I was thinking.

When I examined my netbook  DocumentId.db file I found there were some with a state of deleted, so was concerned if the server also kept a record of the deleted state, it would automatically re-delete the "deleted documents".

However Now I am back home and look at my desktop DocumentId.db file,  which was a clean reinstall at 4.0b , I dont have any documents in a deleted state so I presume that must be a hangover from earlier beta testing.

Only Logos can tell us if the server stores the deleted state, presuming the deleted state is not kept on server after resyncing, this would mean the server should update the restored notes/documents with anything newer on the server, and put the deleted notes back to the server, but obviously am reluctant to try, and documents created and deleted in between time of Backup and restoration will obviously still remain lost.

Only Logos can tell us if the server stores the deleted state,

That's a complicated one. A deletion cannot be maintained indefinitely as that would prevent a new document from being created with the same name. The important thing we know is that sync records are timestamped, so if the document appears with a newer timestamp (having been re-created) the delete sync record would be removed. The complicating factor is the number of  user L4 instances (with the User Id being that {random} folder name). I imagine the delete record would exist for each User Id and be applied when the other L4 instance(s)  come online. If all those are applied and then the document appears from an old backup, I can see it being sync'd as new document, otherwise it could be deleted...

I think the above posts raise some important points.

I believe that Logos needs to tell us what the sync rules are for updates and deletes.

We need to know what might happen if we restore to a backup from a few days earlier.

We need tools to export our Notes etc, or to be able to have direct control of what syncs, and if a "delete-message" from the Logos Cloud will wipe out a Note we attempt to recover from a file-level restore of the application directory.

The current methods offered in the Logos4 application do not appear to form a solid system that can be trusted with months or years of Notes and study.

I believe that Logos needs to tell us what the sync rules are for updates and deletes.

We can certainly ask!

We know that there are some issues as per http://wiki.logos.com/Bug$3a_L4_failing_to_sync_documents.