Creating an Input File for Access Manager Batch Maintenance

May 14, 2008 · Filed Under Code Samples, Security, Series 7

Creating users in a Series 7 namespace can be automated with Access Manager Batch Maintenance, but writing the required input file is an error prone and time consuming chore. This Visual Basic script will take a list of users from a comma-delimited file (it could be exported from Excel or some other system), create the users in the namespace, create the user classes, assign the users to their user class and then create a signon for the user. When the file is ready, the input file is run with Access Manager Batch Maintenance (via a batch file, so additional code can be inserted here if necessary). Finally, an email message is sent with the log file attached.

Notes:

This example is written in Visual Basic, and it can be run as is on a Windows system under the Windows Scripting host (a vbs file). It can also be integrated into a Visual Basic or Cognos Script application.
The message is sent via Outlook on the machine where the script is run. If you are not using Outlook or Outlook is not installed where this script is being run, then this subroutine must be replaced by alternate code.

Download the files:

accman_maintenance.vbs

users.csv

Links to social bookmarking sites.