Sample: Loading organizations

This sample shows you how to insert new organizations into the database.

About this sample

This sample loads the following organizations into the database:
  • Sample Organization
  • HR Department
  • Retail Department

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/Organization/wc-dataload.xml –DLoadOrder=Organization
    • WebSphere Commerce DeveloperWindowsdataload ..\samples\DataLoad\Member\Organization\wc-dataload.xml –DLoadOrder=Organization

Verifying results

To verify that the organizations were loaded into the database:
  1. Open the Organization Administration Console.
  2. Click Access Management > Find Organizations.
  3. Search for each of the following organizations:
    • Sample Organization
    • HR Department
    • Retail Department

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/Organization directory.