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, 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

  1. Open the command-line interface and go to the following directory:
    • WC_installdir/bin
    • WebSphere Commerce DeveloperWCDE_installdir\bin
  2. Enter the following command:
    • AIXLinux./dataload.sh ../samples/DataLoad/Member/MemberGroup/wc-dataload.xml –DLoadOrder=MemberGroup
    • WebSphere Commerce DeveloperWindowsdataload ..\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 AuroraESite.
    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 that is loaded in this sample from the database, run the CleanUp.sql file in the /samples/DataLoad/Member/MemberGroup directory.