We are preparing our first BO implementation for a large number of users [1000+]. Is there any way to load the list of users from an Excel file into the Supervisor module, or into the user tables on the database? I’ve found the table OBJ_M_ACTOR, but don’t know what all of the columns are used for, or what the effect of leaving some of them null would be. We are using an Oracle 7 database.
Steven Jones
Consultant to BT Office Products International sjones@btopi.com
It’s not recommended, but it can be done. You need to be aware that all of your USERs that you add or added in more than one table. You can check out the REPOSITORY tables and what each column represents in the HTML files that are on the CD.
You will need to add the users to the OBJ_M_ACTOR table, the OBJ_M_ACTORLINK table, and need to update the OBJ_M_MAGICID table.
Run a test insert of a user and then copy what was done for that user. Also… this would all be unsupported so keep a back-up handy. It can all be done successfully though.
On the CD, read the rpsample.htm It is a sample of the SQL that is run to add ONE user to the Repository. You can ignore some of the checking as you are adding a BATCH of them, but make sure the MagicId matches.
We are preparing our first BO implementation for a large number of users [1000+]. Is there any way to load the list of users from an Excel file into the Supervisor module, or into the user tables on the database? I’ve found the table OBJ_M_ACTOR, but don’t know what all of the columns are used for, or what the effect of leaving some of them null would be. We are using an Oracle 7 database.
We are preparing our first BO implementation for a large number of users [1000+]. Is there any way to load the list of users from an Excel file into the Supervisor module, or into the user tables on the database? I’ve found the table OBJ_M_ACTOR, but don’t know what all of the columns are used for, or what the effect of leaving some of them null would be. We are using an Oracle 7 database.
Some time ago somebody posted a script to the list to load NT users into Oracle repository. It should work similar for other “user-id” sources…
WM
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at