Data Storage in Domlog

HCL Domino Domino Forum
1

I am attempting to gain some understanding of how the simple function Creation Date works. Ive been trying to figure out the best way to break some huge Domlog.NSF databases into smaller ones. The problem is if I copy a portion of the Domlog View Requests into another Domlog database (Say DomlogJan2008) the Date Column becomes the date and time that the copy was made and not the date and time that the original document was actually created. As one might imagine this plays hell with the intent of a “log”.

The column is generated by using Simple Function and Creation Date. So it must go into the record and grab this date somewhere. I am thinking that if I could just convert this to a string, in another column, or something then I could copy a column of strings to the new database and the information would not change.

Would appreciate any thoughts on this.

      Thanks,

           Steve Lister
2

Subject: Data Storage in Domlog

Rather than use the UI copy/paste, use an agent to copy the documents using the NotesDocument.CopyToDatabase method. This should preserve the creation date on the document.

3

Subject: CopytoDatabase

Thanks for the idea Dave! I used this in an agent and it copied the database; however, with the column (DATE and TIME) it put in the time that it was copied rather than the original time and date the document was created. To solve the problem I created, in the agent, a variant and loaded it with the date/time string. I then used the ReplaceItemValue method to put the original date/time into the DATE and TIME column. This works like a champ. I tried this with some smaller Domlogs and it is reasonably fast.

Cheers,

    Steve