Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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)