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

jeremyasmith

Avatar

jeremyasmith

jeremyasmith

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)