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, 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/Organization/wc-dataload.xml –DLoadOrder=Organization

   • (Developer) dataload ..\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 loaded in this sample from the database, run the CleanUp.sql file in the /samples/DataLoad/Member/Organization directory.