User Data Populate

Use the following as a reference when you load these tables.

MEMBER (MEMBER_ID( **1**), TYPE='U', STATE=1)
USERS (USERS_ID=MEMBER.MEMBER_ID, DN ( **2**), REGISTERTYPE='R', PROFILETYPE=( **3**) , LANGUAGE_ID)
USERREG (USERS_ID=USERS.USERS_ID, STATUS=1, LOGONID, SALT ( **4**), LOGONPASSWORD ( **5**), PASSWORDEXPIRED=0 )
ADDRBOOK (MEMBER_ID=USERS.USERS_ID)
ADDRESS (MEMBER_ID=USERS.USERS_ID, STATUS='P', NICKNAME=USERREG.LOGONID, SELFADDRESS=1 (**6**))
MBRREL ( **7**)
MBRROLE ( **8**)
 

Where:
 
**1**  The MEMBER_ID primary key space (KEYS table) is shared by the USERS, ORGENTITY, and MBRGRP tables.
 
**2** The DN should be lowercase and in the following format: "uid=" + logonid + "," + parent_organization_DN"
**3** Type 'C' is for consumer direct users; 'B' is for a business direct users. Consumer direct users are listed in the WebSphere Commerce Accelerator. B2B direct users are listed in the Organization Administration Console.
**4** A random string that is unique to each user. This string is appended to the password before hashing.
**5** The encrypted logon password that is generated when you use the wcs_password utility, which takes the plain text password and SALT value as input values.
**6** A user can have only one permanent self-address (SELFADDRESS=1, STATUS='P'). This is the address that is associated with the user registration. Other permanent addresses in the user address book should have SELFADDRESS=0 and STATUS='P'. Any old addresses that change are marked temporary (STATUS='T').
**7** One row in the MBRREL table should be created for each ancestor. For example, if you are creating a user under the default organization, then create one record to indicate that the parent (sequence=1) is the default organization, and the grandparent (sequence = 2) is the root organization.
**8** The MBRROLE table defines the roles that the user plays in the system. By default, you want a user that registers to a store to have the Registered Customer role (-29) in the store organization


Optionally, you can also load the following tables:

    USERPROF
    BUSPROF
    USERDEMO
    MBRATTRVAL