Cannot Reuse a Campaign Item in the Campaign Manager (272708)

WORKAROUND

Manually modify the Campaign_Item table for the Web site's SQL Server Commerce database.

NOTE: Analysis reports may be using the original entry in this table. Before you perform then following steps, verify that removal or recovery of this Campaign Item will not affect analysis information.

1. Open the Microsoft SQL Server Enterprise Manager.
2. When you have successfully gained access to SQL Server, expand the Commerce database that is related to your site.
3. Select the Campaign table if you are attempting to recover a Campaign, select the Customer table if you are attempting to recover a customer, or select the Campaign_Item tables if you are attempting to recover either an Ad, Direct Mail, or Discount Campaign Item.
4. Right-click the table, and then select Open Table - Return All Rows.
5. If you want to recover the deleted Campaign Item, do the following:
   
   
   1. In the appropriate dt_< >_archieved column, locate the Campaign Item you want to recover (dt_customer_archieve - Customer table, dt_camp_archieved - Campaign table, and dt_campitem_archieved - Campaign_Item table).
   2. Highlight the contents of the cell, and then use the CTRL+0 (CTRL + Zero) key combination to enter a NULL value in the cell.
      
      NOTE: The value in this cell must be a NULL value. Pressing the space bar or entering <NULL> does not provide the necessary NULL content.
6. If you want to reuse this Campaign Item, do the following:
   
   
   1. Locate the appropriate u_< >_name column for the campaign item you want to reuse (u_customer_name - Customer table, u_camp_name - Campaign table, and u_campitem_name - Campaign_Item table).
   2. At the end of the name, append OLD, 1, ARCH, or any character(s) to rename this item with a different name.

You can now open the BizDesk Campaign Manager and either re-use the desired Campaign Item name or see that the deleted Campaign Item has been recovered.