Siebel Loyalty Administration Guide > Working with Siebel Loyalty Program Members > Bulk Loyalty Membership Administration >

About Importing Loyalty Members and Transactions Using Siebel EIM

You can use Siebel Enterprise Integration Manager (EIM) to perform bulk imports of loyalty members and transactions into the Siebel database from other data sources. Detailed information on using Siebel EIM to import data into the Siebel database is provided in Siebel Enterprise Integration Manager Administration Guide. This topic outlines information that is specific to importing loyalty member data into the Siebel database.

About Assigning Loyalty Server Keys

The recommended method of bulk importing loyalty members and transactions into the Siebel database is to import the data into the EIM tables EIM_LOY_MEMBER and EIM_LOY_TXN, then process transaction data with the Loyalty Batch Engine to make sure that members' balances and point blocks are updated appropriately.

To enable the imported loyalty member transactions to be processed by the Loyalty Batch Engine, each imported member must be allocated a valid server key number. You can specify a server key number for each member to be imported in the MEMBER_MEM_KEY_NUM field in the EIM table EIM_LOY_MEMBER. For performance reasons, it is important that the server keys are distributed evenly across the imported members, so do not assign the same key to all members. For detailed information on how to assign server keys, see Setting Up Server Keys for Siebel Loyalty.

NOTE:  When a new loyalty member is added to the Siebel Loyalty application through the user interface, Siebel Loyalty automatically assigns a key to the new member and updates the informational field, Number (#) of Members Assigned, in the Server Key Map list. Be aware that the Number (#) of Members Assigned field is not updated for members imported into Siebel Loyalty using EIM. This limitation does not affect the correct functioning of the Siebel Loyalty application.