Edit/add doesn't make user a member

4 years 10 months ago #230225 by marse7
Thanks - comprofiler has the correct info but changing it does not change the info on the site. I might have to sync the tables or something.

At worst, I do it by hand...

Really appreciate your help.
4 years 10 months ago #230227 by marse7
Found a stupidly simple way to do this using both CB Subs import function and CB Juice. Can't detail it right now but I'll be back!


4 years 10 months ago #230254 by marse7
The solution (I think) is simple but requires some manual work. CB Subs will add any user based on a delimited file. So new users can be added by exporting the list from the old DB using CB Juice and then the file can be winnowed to only include those users who are new since the migration. That's step one. CB Subs has the ability to mass update any user to any plan by using their IDs. You can also supposedly add users directly into a plan by creating a delimited text file with:

This text file is multiple lines (one line per user) comma-separated list with following format: userid,planid,statusSingleChar,SubscriptionDateISO.
Status: A = Active, X = Expired, C= Unsubscribed/Cancelled.
Example: 63,1,A,2009-01-01 00:00:00

I haven't tried this but I'm sure it would work and it may be easier than the two step process I am describing but I had some inconsistencies with keying the Membership plan. I will try it both ways at some point.

So, what I know works is: 1) add any new users by using CB Juice and 2) upgrade any current and/or added users directly by using their ID in CB Subs > CB Paid Subscriptions > New Import subscriptions.

Or -

Just try to create a text delimited file to do both at one time.

Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.138 seconds
Facebook Twitter Google LinkedIn