Sample: Loading member attributes

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

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

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