Sample: Loading member attributes

This sample shows you how to load member attributes for users into the database.

Feature Pack 6 or later 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=PersonAttributeValue
- dataload ..\components\foundation\samples\DataLoad\Member\Person\wc-dataload.xml –DLoadOrder=PersonAttributeValue

Verifying results

To verify that the member attribute values were loaded into the database, run the following SQL command:

SELECT * FROM MBRATTRVAL WHERE MEMBER_ID IN (SELECT USERS_ID FROM USERREG WHERE LOGONID IN ('olivialee'))

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