Sample: Loading roles to organizations
This sample shows you how to assign
roles to organizations and then load this data into the database.
About this sample
This sample assigns the Category Manager role to the sample organization.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.
Procedure
- Open the command-line interface and navigate to the appropriate
directory:
- WC_installdir/bin
- WCDE_installdir\bin
- Enter the following command to load the Category Manager role
data into the database:
- ./dataload.sh ../components/foundation/samples/DataLoad/Member/Organization/wc-dataload.xml –DLoadOrder="Organization,OrganizationRole"
- dataload ..\components\foundation\samples\DataLoad\Member\Organization\wc-dataload.xml –DLoadOrder="Organization,OrganizationRole"
Verifying results
To verify that the role assigned to the sample organization was loaded into the database, run the following SQL command:SELECT * FROM MBRROLE WHERE MEMBER_ID IN (SELECT ORGENTITY_ID FROM ORGENTITY WHERE ORGENTITYNAME IN
('Sample Organization','HR Department','Retail Department'))