we need to unsubscribe a lot of subscribers in our campsite database from a couple of old publications and keep them subscribed to one publication only. Before I start to play with database directly, I would like to ask whether there is any possibility to use campsite API for this purpose?
1. DELETE FROM SubsSections WHERE IdSubscription IN (SELECT Id
FROM Subscriptions WHERE IdPublication = <pub>)
2. DELETE FROM Subscriptions WHERE IdPublication = <pub>
> Hello all,
>
> we need to unsubscribe a lot of subscribers in our campsite database from a
> couple of old publications and keep them subscribed to one publication only.
> Before I start to play with database directly, I would like to ask whether
> there is any possibility to use campsite API for this purpose?
>
> Thank you very much,
> Michal
>
>
thank you for your quick answer, I will do it this way. However, in near future we are going to develop Campsite-SugarCRM connector and I believe that it should be done using Campsite API. Are there any plans for implementation of such API (for management of subscribers) into Campsite/Newscoop already?
It's on our to-do list for the next release, but aside from putting on the list, not much else has been done with it yet. We'd definitely appreciate it if TOL could take a leading role on this and will be in touch with you about specific steps.
Douglas Arellanes Director of Innovation Sourcefabric, o.p.s.