Browse Ask a Question
 
Tools
Rss Categories

"Invalid Campaign ID" Error during Transfer Memberships Sold

Author: Todd Chaplin Reference Number: AA-00497 Views: 2325 Created: 09/15/2012 04:49 PM Last Updated: 09/15/2012 04:49 PM 0 Rating/ Voters

Symptom

 When transferring data using the advanced mapping, the integration gives an error "Invalid Campaign ID" when using advanced mapping to map to the Gift Campaign even though the campaign ID was chosen using a lookup.

Cause

 This is due to the fact that the RE system is configured to use the Campaign ID while the RE Integration is set to use the Campaign Description (or vice versa).

Solution

 To correct this, first determine what you are using as the Campaign reference: 

 * Select Tools, User Options
 * On the Records tab, highlight Campaigns
 * Check what the value is for Campaign Format

If the value is Campaign ID, run the following script on your database:

UPDATE USR_REI_PARAM_DFLT_TYP
SET SEARCH_VAL = 1
WHERE DISPLAY_NAM = 'Gift.Campaign'

If the value is Description, run this script:

UPDATE USR_REI_PARAM_DFLT_TYP
SET SEARCH_VAL = 5
WHERE DISPLAY_NAM = 'Gift.Campaign'

Applies To

 The "Transfer Memberships Sold" function in Raiser's Edge Integration.

Info Ask a Question