[SOLVED] CBJUICE Expiration Date

How can I add membership expiration date to CSV export?

Post edited by: krileon, at: 2010/07/13 21:14

Rayjak wrote:

How can I add membership expiration date to CSV export?

I assume that this is really a CBSubs question since CB does not have membership expiration dates.

CBJuice is used to import users into CB/Joomla from a CSV file.

Once these users are present in CB you would need to use the CBSubs import function (please read the CBSubs documentation as it is explained in detail) to assign them to plans.

My database is already populated with plan and expiration date. Works great. The situation is as follows: One department manually enters members who walk-in, fill out a form and pay.

The accounting department verifies the data such as address, phone, email and expiration date. The accounting department processes these verifications in batch mode and finds it quicker to use the export from CBJUICE with EXCEL than to go into each member in Community Builder/User Management, click on the "Additional Info" tab for member address and then the "Subscription" tab for expiration date.

The only thing missing for my customer in the CBJUICE export is expiration date of the plan.

ok - at least i understand the use case now.

you need to do this in two passes as CB Juice cannot update CBSubs.

So you need to create 2 CSV files from your excel - one to feed CBJuice and another one to feed CBSubs.

I am sorry, I am not making myself clear. My CBSubs database does not need updating. It is perfect as is. My CB database is also perfect as is.


I need a CSV file exported from my CBSUBS database which includes name, address, phone, email and expiration date. The CSV exported file FROM CBJUICE is perfect and contains all information except it does not contain expiration date. I would like for it to include the expiration date.

I was inquiring how to add the expiration date to the EXPORTED file from CBJUICE.

Thanks for your interest.

The database table _cbsubs_subscriptions contains the expiration date. Currently CBSubs does not feature any form of exporting. Do not believe CB Juice supports CBSubs either. Best bet is build a query and export via phpmyadmin as CSV. If unaware how to do this I recommend contacting your host for information on your database softwares usage.