Plan, execute, measure and optimize customer experiences

Can a campaign diagram be "undeleted"?

Accepted Solution Solved
Reply
Contributor
Posts: 48
Accepted Solution

Can a campaign diagram be "undeleted"?

 

We copied a production diagram into a different business context on the same server the we use for testing purposes. The CAMP code was never changed and the diagram has been deleted. We would like to bring it back to change the CAMP code so that reporting based on the CDM does not show duplicate records. 

 

Thanks,


Accepted Solutions
Solution
‎02-20-2017 01:48 PM
Contributor
Posts: 36

Re: Can a campaign diagram be "undeleted"?

Hi,

 

There is no built-in "undelete" functionality. You are supposed to implement scheduled environment backups (of metadata, content server repository, WIP etc) of a production environment.

 

So theoretically you could temporarily halt operations, revert back in time to a backup, do what you need, then go back to the present state.

 

In reality, it is much easier to just delete or fix the garbage directly in the CDM database. Campaign Code change will only require 1 or 2 simple SQL updates to CI_CAMPAIGN and to CI_CELL_PACKAGE table (that one only if you have run the campaign and stored the contact history).

 

You can also modify your reporting to exclude any data from non-production business context by referring to "Business_Context_Nm" column of the CI_Campaign table.

 

Hope if helps!

 

 

 

 

-------
Dmitriy Alergant, Tier One Analytics

View solution in original post


All Replies
Solution
‎02-20-2017 01:48 PM
Contributor
Posts: 36

Re: Can a campaign diagram be "undeleted"?

Hi,

 

There is no built-in "undelete" functionality. You are supposed to implement scheduled environment backups (of metadata, content server repository, WIP etc) of a production environment.

 

So theoretically you could temporarily halt operations, revert back in time to a backup, do what you need, then go back to the present state.

 

In reality, it is much easier to just delete or fix the garbage directly in the CDM database. Campaign Code change will only require 1 or 2 simple SQL updates to CI_CAMPAIGN and to CI_CELL_PACKAGE table (that one only if you have run the campaign and stored the contact history).

 

You can also modify your reporting to exclude any data from non-production business context by referring to "Business_Context_Nm" column of the CI_Campaign table.

 

Hope if helps!

 

 

 

 

-------
Dmitriy Alergant, Tier One Analytics
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 144 views
  • 1 like
  • 2 in conversation