I am trying to duplicate a subscription service including all of the recipients subscribed to the service I am duplicating, but there does not seem to be a way to do it?

Avatar

Avatar
Validate 1
Level 2
jeremyasmith
Level 2

Likes

4 likes

Total Posts

13 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
jeremyasmith
Level 2

Likes

4 likes

Total Posts

13 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Boost 3
Boost 1
Affirm 1
View profile
jeremyasmith
Level 2

22-05-2018

We are doing some work on cleaning up some of our subscription services and before I purge any of the recipients I want to make a copy <service>_old.

There does not seem to be any way in Adobe Campaign 6.1 to duplicate a subscription service including the data. (unless I am missing something)

I did manage to do it using SQL:

"insert into nmssubscription (irecipientid, iserviceid, tscreated) select irecipientid, 870095082, tscreated from nmssubscription where iserviceid = 80900568;"

But I am worried about any consequences of doing this.

Any advice much appreciated

Jeremy

Accepted Solutions (0)

Answers (0)