BOXI Personal Folder Content Archival Tool
Author: Brian Yaremych, Analytics8, byaremych@analytics8.com
Platform: BOXI R2 tested
Version: 1.0
Notes:
Personal Folder Content Archival Tool is a utility that automatically moves user personal folder content to the Recycle Bin folder for archival prior to user deletion to ensure no content is lost. To retain ownership information, report content is moved to a subfolder (named corresponding to the user), created under the Recycle Bin folder.
This utility DOES NOT delete users (or anything for that matter) from the BOXI environment.
I’ve found this tool to be a time-saver when working in large environments with a lot of user turnover. It’s a bit of a niche tool, but hopefullly you may find it useful… Have fun!
Requirements:
-
Oracle table (“USERS_TO_BE_DEL”) must be created and loaded for input to the tool. Table must contain column “USER_NAME” containing the user BOXI Account Name marked for eventual deletion.
-
Appropriate host machine CLASSPATH set (setclasspath.bat which lists required SDK components included for reference). Necessary JARs can be found on any machine with server or client tools install.
-
Oracle 9i+ install on host machine (or minimally the Oracle driver ojdbc14.jar file which is required on in the CLASSPATH)
-
“Recycle Bin” folder created in BOXI environment.
Command line usage:
$java archive_personal_folder -u boxi_username -p boxi_password -s boxi_cms -dbhost Oracle DB host machine -dbport DB port -dbservice TNS/service name -dbuser DB user -dbpw DB password
BOXI Personal Folder Content Archival.zip (9.0 KB)
crystal01 
(BOB member since 2006-08-30)
(BOB member since 2003-11-27)