IBM SG24-6320-00 manual Profile types

6320ch_DEV_before_migration.fm Draft Document for Review July 28, 2004 7:33 pm

All organizations without a parent organization, that is organizations for which the MEMBER_ID column of ORGENTITY is set to null, will have

Root Organization assigned as their parent organization.

If this is not desired, you must update the MEMBER_ID column for the organizations that must have other parent organizations before migrating.

All users without an entry in the BUSPROF table will have Default Oganization assigned as parent organization.

If this is not desired, you must update create a business profile, containing references to the desired parent organization, for the relevant users before migrating.

Also, remember to set the profile type to B (Business user) for the relevant users.

Users with an entry in BUSPROF and with PROFILETYPE set to B (Business user) will be assigned the organization, pointed to by the ORGUNIT_ID or ORG_ID columns, as follows:

–If ORGUNIT_ID is not null, the organization pointed to by ORGUNIT_ID, is used. as the user’s parent organization

–If ORGUNIT_ID is null and ORG_ID is not null, the organization pointed to by ORG_ID, is used as the user’s parent organization.

–If both ORGUNIT_ID and ORG_ID are null, the user is assigned Default Oganization as parent organization.

Since business users should not be assigned Default Oganization, we recommend that you ensure that all your business users an entry in BUSPROF with the right organization specified in ORGUNIT_ID.

Profile types

The WebSphere Commerce Suite V5.1 and WebSphere Commerce V5.6 schema allows for three profile types, as defined by the PROFILETYPE column of the USERS table:

C- Consumer (B2C)

B- Business (B2B)

null - No profile data

It is recommended to clean up this column such that all users have either a Consumer or a Business profile, that is to say: ensure that no rows in the USERS table have the PROFILETYPE column set to null.

106Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide