Migrating notes archives problem

HCL Domino Domino Forum
1

We are migrating notes archives that are right now on a “network drive” and we want to move them on a Domino Server. The problem is that some archives are encrypted by the user, so we cannot move them on a Domino Server. The user and the server will not have access to the Database. (the server will not have access to read ACL)

Is there as tool that can scan encryption on databases (with an api, wmi,etc) and tell us how many we have?

Thanks

2

Subject: Migrating notes archives problem

I imagine you could get some useful results from a LotusScript agent running with an admin or server ID under a Windows account that has full access to the network drive. The process would be something like the following pseudocode:

  • Open a connection to the drive with a Windows API call

  • Traverse the directory structure looking for files with .nsf extension.

  • Attempt to open each database that’s found.

  • If you open the file successfully, record the filename, template name and any other data you want to a survey database.

  • If you fail to open the file successfully, create a similar failure record with just the filename.

First issue with this approach: Do you know that every database on the network drive is an archive? If not, then you may need to make some assumptions, such as looking only for files with the pattern a_*.nsf.

Another issue: If you can’t read the database it could be either because it’s encrypted, or because it’s set to enforce a consistent ACL that doesn’t include the ID you are using for the agent. Not sure there’s an easy way to distinguish these cases.

One route around both issues would be to get the users to execute the code, which would allow you to look up their archive location from the mail database’s archive profile, and then access the database under their own ID. Of course you’d need to get them to execute the code (e.g. triggered by opening the Inbox folder) and report the results centrally (mail message, write to a server database).

I believe Wolcott’s Automated Deployment Toolkit (ADT) product offers some of these capabilities in its surveys. There may be others.

Hope that helps,

Rupert Clayton

Chicago

3

Subject: RE: Migrating notes archives problem

Sounds a good idea.

Yes that’s only archives files on the directory… i’ll open them with sess.getDatabase(“”,\server\path.…) i’ll see what are the results and see what i’ll do after.

Thanks