Sample: Assigning roles to people

This sample shows you how to assign roles to users and then load this data into the database.

About this sample

This sample assigns the Site Administrator role to a person.

If you prefer to work with data in XML format instead of in CSV format, you can configure the utility to use XML formatted files. Edit the wc-dataload.XML file and change the location elements to reference the XML files provided.


  1. HCL Commerce DeveloperOn a command line, go to the WCDE_installdir\bin directory.
  2. LinuxOpen a command line in the . Change the directory to utilities_root/bin directory. For information about entering and leaving containers, see Running utilities from the Utility server Docker container.
  3. Enter the following command to load the Admin and Person role data into the database:
    • Linux./ ../samples/DataLoad/Member/Person/wc-dataload.xml –DLoadOrder="Admin,Person"
    • HCL Commerce Developerdataload ..\samples\DataLoad\Member\Person\wc-dataload.xml –DLoadOrder="Admin,Person"

Verifying results

To verify that the role information for the new users was loaded into the database, run the following SQL command:
select DN from users where registertype in ('S','A')

Cleaning up the data

To remove the data that is loaded in this sample from the database, run the CleanUp.sql file in the /samples/DataLoad/Member/Person directory.