mass-upgrade admin feature for plans

activha wrote: @Kyle : mass import with a dummy plan does not work for users without subscription that we would like to enter into a plan, and it does not work neither for users with our negopme plan that we would put in dummy then back in negopme because the import function states that a subscription already exists

@Nant : I was thinking at url linking in integration and not url protection. And upgrading one by one 500 users is not very funny

You two have any other ideas ?

By URL integration what do you mean?
Some external action needing to take place?

I was not implying that you do it one by one.
You would need to identify all users and run a script of some kind to initialize users in newly added concepts.

For example, you need to run an SQL script to update the cb field(s) according to your CB field integration concept implemented in the new plan.

nant wrote: By URL integration what do you mean?
Some external action needing to take place?

Yes we have a script linked by url which updates mysql tables, and some CB fields updated

nant wrote: I was not implying that you do it one by one.
You would need to identify all users and run a script of some kind to initialize users in newly added concepts.

For example, you need to run an SQL script to update the cb field(s) according to your CB field integration concept implemented in the new plan.

Oupsss... this is way beyond our knowledge for now
Any chance someone could help on this ?

You need to gather a list of userid of all affected users (the ones that are currently active in the plan you are upgrading).

If the CB field CBSubs integration integration you are configuring for your new plan calls for assigning cb_field with new_value, then you can perform an SQL statement using phpmyadmin like this:

UPDATE `XXX_comprofiler` SET `cb_field` = 'new_value' WHERE `user_id` in (id1, id2, ..., idn)

Substitute XXX, cb_field, new_value and ids with your case.

I would first do a single test on one id to make sure the statement works.

Backup first of course.

Once this is completed then you can make changes to your existing plan as far as this CB Field ontegration action since you will have initialized all users.

This seems more difficult. In fact we need 1) to update all free users already registered to a free plan, and all plan NegoPME users to same plan NegoPME but with url integration applied.

What I mean is that the cb fields modifications AND the call to a url php file should be applied to each already subscriber to this NegoPME plan.

Our plans are exclusive so we cannot import into one and reimport into a new one.

This seems more difficult. In fact we need 1) to update all free users already registered to a free plan, and all plan NegoPME users to same plan NegoPME but with url integration applied.

Then to do this you need to first create your new plan. Once done use CBSubs Import from your free plan to the new plan then do it again from NegoPME to the new plan. The import feature will execute integrations. There's not much more to advise as CBSubs doesn't have a mass-upgrade feature and CBSubs import certainly isn't a substitution for one, but it's a possible workaround aside from upgrading users 1 by 1.

But as plans are exclusive doing so brings the error:
Following Users could not be subscribed (usernames) because either: (A) an exclusive active subscription exists that would conflict with the imported user subscription, or: ( it is a children plan but the parent plan subscription does not exist:

I have tried to set up a simple dummy plan but I cannot see how to import all free registered users who do not have a subscription yet to our free plan (but with active integration)