Sample: Loading address books
This sample shows you how to load
user addresses into the database.
About this sample
This sample loads addresses for the following users:- Ryan Johnson
- Olivia Lee
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:
- ./dataload.sh ../components/foundation/samples/DataLoad/Member/Person/wc-dataload.xml –DLoadOrder=PersonAddressBook
- dataload ..\components\foundation\samples\DataLoad\Member\Person\wc-dataload.xml –DLoadOrder=PersonAddressBook
Verifying results
To verify that the address information for the users was loaded into the database, run the following SQL command:select nickname,address1,city,state from address
where nickname in('ryanjohnson2','olivialee','sophiawilliams') and selfaddress=0