Sample: Loading member groups

This sample shows you how to insert an access group and customer segment into the database.

About this sample

This sample inserts the following access group and customer segment into the database:

• Access group - AccessGroup1

• Customer segment - TestMemberGroup

If you prefer to work with data in XML format instead of in CSV format, we 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

1. (Developer) On a command line, go to the WCDE_installdir\bin directory.

2. (Linux) Open a command line in the Utility server Docker container. 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:

   • (Linux) ./dataload.sh ../samples/DataLoad/Member/MemberGroup/wc-dataload.xml –DLoadOrder=MemberGroup

   • (Developer) dataload ..\samples\DataLoad\Member\MemberGroup\wc-dataload.xml –DLoadOrder=MemberGroup

Verifying results

1. To verify that the access group for the new member group was loaded into the database:

   1. Open the Organization Administration Console.

   2. Click Access Management > Member Groups > View Access Groups.

   3. Verify that AccessGroup1 is listed as one of the access groups.

2. To verify that the customer segment for the new member group was loaded into the database:

   1. Open the Management Center.

   2. Open the Marketing tool and from the Store list, select Madisons.

   3. From the explorer view, click Customer Segments. The Customer Segments - List page displays.

   4. Verify that TestMemberGroup is listed as a customer segment.

Cleaning up the data

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