Ok, so 6.5 used to use the ACTOR and ACTORLINK tables for user and usergroups. Does anyone know the corresponding tables that are used in BOXI 3.1 with an Oracle backend (versus MySQL)?
We want to migrate the users and groups without actually using the Import Utility Wizard or BIAR file for that matter.
cias (BOB member since 2010-11-18)
You simply can’t… you can no longer query the XI repository in such powerfull and easy way. Recreating security in XI is not a simple import deal. You should redefine it from scratch and be trained maybe regarding XI new security concepts. it is never wasting times in my opinion
bernard timbal 
(BOB member since 2003-05-26)
You can have a look to the BOBdownload’s area to find useful macro to extract data from the CMS …
Thanks for the responses but I think our intent is quite simple:
Identify the users, groups, and associated user passwords in BO .5
Extract these users from Oracle
Import these users into the corresponding tables in BOXI 3.1 (Oracle as a backend).
Does anyone know which table in BOXI 3.1 handles users and groups? That really is the information we are looking for…
cias (BOB member since 2010-11-18)
In 6.5 there are 50 tables that act as a BO repository.
In XI R2 or XI 3.0/3.1 there are few about 6 tables that takes the repository role. The entire structure of the repository is changed in XI and above versions. There is no way you can directly take records from one database and update the other one.
You have to do the whole setup from scratch as suggested by Bernard.
BO_Chief 
(BOB member since 2004-06-06)
And on top of that, the data in the repository tables of BO versions XI and higher is encrypted. So no more direct fiddling with data in the repository.
Marek Chladny 
(BOB member since 2003-11-27)
.
I always recommend more time planning than doing.
If you had done the most basic research you wouldn’t even be thinking of things this way.
XI is a totally different beast to 6.5, plain and simple.
Mak 1 
(BOB member since 2005-01-06)
Ok, so I take it, this is not possible. However, I am assuming the following is possible:
Export the users/groups from oracle to a .txt file
Use the Import Utility Wizard to import the users/groups into 3.1 using the .txt as the source.
Any other way you can think of besides this? I just assumed that the underlying BO table structure would provide the capability to perform such actions.
Knowing that this might not be possible. Is it also impossible to reset the Admin password like we were able to do so in 6.5 via the database?
cias (BOB member since 2010-11-18)
Hi,
This topic answers your question:
Marek Chladny (BOB member since 2003-11-27)
Yes, it is possible to import users from text file. But the text file must be in a format that is correctly understandable by Import Wizard. Please check the BO Admin guide, it is explained clearly how to import users in bulk from a text file.
Note : The users imported will have Enterprise Authentication.
BO_Chief (BOB member since 2004-06-06)
Thanks for the posts folks!
cias (BOB member since 2010-11-18)