Import says Success but Subscriptions don't change
- steve2simpson
- OFFLINE
- Posts: 18
- Thanks: 0
- Karma: 0
12 years 7 months ago - 12 years 7 months ago #179168
by steve2simpson
Import says Success but Subscriptions don't change was created by steve2simpson
Hi All,
I have spent a few days searching this site trying to find out what I am doing wrong.
I am trying to expire all users in a plan using the CBSubs Import function. I use the import plan by selecting:
1. The current plan and "Active" status.
2. Then select the same plan with a "Expire" status. (also tried with "unsubscribed")
3. Select today's date.
4. Select "Yes" to import behavior
Imported runs and show success but there is no change in subscription status. All user subscriptions still show active both in CBSubs and CB usermanager.
CBSubs 1.2.2
CB 1.7
Joomla 1.5.22
Thank you in advance for your help,
SS
See supporting screen shots.
I have spent a few days searching this site trying to find out what I am doing wrong.
I am trying to expire all users in a plan using the CBSubs Import function. I use the import plan by selecting:
1. The current plan and "Active" status.
2. Then select the same plan with a "Expire" status. (also tried with "unsubscribed")
3. Select today's date.
4. Select "Yes" to import behavior
Imported runs and show success but there is no change in subscription status. All user subscriptions still show active both in CBSubs and CB usermanager.
CBSubs 1.2.2
CB 1.7
Joomla 1.5.22
Thank you in advance for your help,
SS
See supporting screen shots.
Last edit: 12 years 7 months ago by steve2simpson.
Please Log in or Create an account to join the conversation.
- nant
- OFFLINE
- Posts: 25532
- Thanks: 1834
- Karma: 877
12 years 7 months ago #179180
by nant
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic Re: Import says Success but Subscriptions don't change
Well the import functionality is not meant to do this.
Its not a batch processing function for existing subscriptions.
Its not a batch processing function for existing subscriptions.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in or Create an account to join the conversation.
- steve2simpson
- OFFLINE
- Posts: 18
- Thanks: 0
- Karma: 0
12 years 7 months ago #179181
by steve2simpson
Replied by steve2simpson on topic Re: Import says Success but Subscriptions don't change
Thanks for the quick reply Nick.
What would be the best way to expire all users in a plan?
What would be the best way to expire all users in a plan?
Please Log in or Create an account to join the conversation.
- nant
- OFFLINE
- Posts: 25532
- Thanks: 1834
- Karma: 877
12 years 7 months ago #179183
by nant
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic Re: Import says Success but Subscriptions don't change
You would have to run a query on the database - Kyle needs to propose query.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in or Create an account to join the conversation.
- krileon
- ONLINE
- Posts: 68605
- Thanks: 9108
- Karma: 1434
12 years 7 months ago #179186
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Re: Import says Success but Subscriptions don't change
Query wouldn't be appropriate as none of the triggers would fire meaning if you have any plans using any of the integrations to perform actions on expiration they wouldn't execute. If that's not a problem for you then the below would expire every active subscription of a given plan.
Please replace PLAN_ID with your plans actual ID and replace jos_ if it's not your database prefix. This is to be run on your database via phpmyadmin or other database management software.
Code:
UPDATE `jos_cbsubs_subscriptions` SET `status` = 'X', `expiry_date` = NOW() WHERE `plan_id` = PLAN_ID AND `status` = 'A'
Please replace PLAN_ID with your plans actual ID and replace jos_ if it's not your database prefix. This is to be run on your database via phpmyadmin or other database management software.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in or Create an account to join the conversation.
- steve2simpson
- OFFLINE
- Posts: 18
- Thanks: 0
- Karma: 0
12 years 7 months ago - 12 years 7 months ago #179187
by steve2simpson
Replied by steve2simpson on topic Re: Import says Success but Subscriptions don't change
Kyle,
Can you provide the same SQL statement against one user ID?
I'd like to test against one first.
To confirm, after the user is "expired" they will be able to login and select a new membership. Correct?
Thank you for "dumbing it down" for me. Sometimes this stuff is a little over my head.
SS
Can you provide the same SQL statement against one user ID?
I'd like to test against one first.
To confirm, after the user is "expired" they will be able to login and select a new membership. Correct?
Thank you for "dumbing it down" for me. Sometimes this stuff is a little over my head.
SS
Last edit: 12 years 7 months ago by steve2simpson.
Please Log in or Create an account to join the conversation.
Moderators: beat, nant, krileon