Split a (potentially huge) local archive database into yearly archive databases who would be stored on CDs or DVDs

Hi,

As a Lotus Notes Administrator, I’d like to set up (for each user) a “Transfer Archive to yearly archive” process:

split a (potentially huge) local archive database into yearly archive databases who would be stored on CDs or DVDs, according to their size.

Is there any easy way to achieve this?


Up to now, I :

  1. create manually empty yearly databases (by copying the “current” archive database - design only)

  2. set up the “Archive Options” in the “current” archive database

  3. select the documents related to one year in the “current” archive database and use the “Archive Tool” to perform the archive to the related yearly archive database

  4. repeat steps 2. and 3. for each year

This procedure works but it’s a bit heavy and is almost impossible to be set up and performed by a “lambda” Notes user.


I suppose I should write an agent who:

  1. scans the “current” archive database and detects the oldest document (let’s suppose this document is year 2002)

  2. creates automatically a local “Archive 2002” database, a local “Archive 2003” database, a local “Archive 2004” database, a local “Archive 2005” database

( 2005=current year-2 ; current year and current year-1 documents shoud stay in the “current” archive database).

  1. fills the yearly archive databases with the related documents:
  • scan all folders and copy and delete year 2002 documents to archive 2002 database

  • scan all folders and copy and delete year 2003 documents to archive 2003 database

  • scan all folders and copy and delete year 2004 documents to archive 2004 database

  • scan all folders and copy and delete year 2005 documents to archive 2005 database


Did anybody meet the same problem to solve?

Are they existing resources anywhere related to this goal?

(code resources - we’d like to avoid the use of another expensive third part product)

We’re still in Lotus Domino R6.5, maybe dedicated tools exist in relaese 7?

Any suggestions are welcome…

Thank you by advance,

Philippe Pierlot

Lotus Dmino Administrator,

Belgium

Subject: Split a (potentially huge) local archive database into yearly archive databases who would be stored on CDs or DVDs

Salut Philippe,

Est-ce que tu as trouvé une façon de t’aider pour faire tes archives?

J’aimerais bien savoir si il existe un outils du genre avant de développer nous même ce que tu décris ci bien plus haut.

a+.

I Will like to know if you found something usefull to help you to archive your mail database?

Steve

Subject: RE: Split a (potentially huge) local archive database into yearly archive databases who would be stored on CDs or DVDs

Bonjour,

Je dois dire que ce problème n’est pas encore résolu de manière satisfaisante chez nous, mais cela fait longtemps que je n’y ai plus regardé du fait du repositionnement de nos priorités. Je suis maintenant occupé à d’autres développements très urgents…

La solution provisoire que nous utilisons maintenant au cas par cas est simplement de configurer et utiliser l’archive tool dans l’archive database vers une ou plusieurs “archive d’archive” database…

Amicalement,

Philippe Pierlot