advice please?

15 years 3 weeks ago #96135 by Aly
Replied by Aly on topic Re:advice please?
ok, but see I have about 900 users all with different expiration dates. It's only going to be 1 plan (1 year membership) but each of these people have different dates that they are going to need to renew.

So ...
I create the plan
export the userids
then in OpenOffice add columns for the plan, dates, etc?
then import that csv file back up
?

Please Log in to join the conversation.

15 years 3 weeks ago #96140 by beat
Replied by beat on topic Re:advice please?
Aly wrote:

ok, but see I have about 900 users all with different expiration dates. It's only going to be 1 plan (1 year membership) but each of these people have different dates that they are going to need to renew.

So ...
I create the plan
export the userids
then in OpenOffice add columns for the plan, dates, etc?
then import that csv file back up
?


In that case, simply:

1. create the plan and fully configure it (incl. all integrations)
2. export the userids and expiry date (and status if available)
3. add the plan id and status columns in openOffice (or you could add them in the select statement for the export under "2." above as constants
4. import in CBSubs as shown in manual and here:

www.joomlapolis.com/component/option,com_joomlaboard/Itemid,/func,view/catid,87/id,95089/#95089 :

File (each line: userid,planid,status,subscription date)
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

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

14 years 11 months ago #99302 by Aly
Replied by Aly on topic Re:advice please?
Just 4 columns?
Where is the user NAME so I know who is who or is that elsewhere? I have all of this in a separate Open Office spreadsheet that I need to work off of. userID info is not on that offline data list.

This is going to be rough

Please Log in to join the conversation.

14 years 11 months ago #99319 by nant
Replied by nant on topic Re:advice please?
Aly wrote:

Just 4 columns?
Where is the user NAME so I know who is who or is that elsewhere? I have all of this in a separate Open Office spreadsheet that I need to work off of. userID info is not on that offline data list.

This is going to be rough


Replied also in your other thread.

You need to use CB Juice to import these users in CB/Joomla first then use CBSubs import to assign subscriptions to these members.

Please Log in to join the conversation.

14 years 10 months ago #102809 by Aly
Replied by Aly on topic Re:advice please?
Hi,
I used CBJuice and I do NOT see userid column included.

How can I export a file with both userid and user's real name so I can edit??

Please Log in to join the conversation.

14 years 10 months ago #102811 by Aly
Replied by Aly on topic Re:advice please?
Sorry, just jos_users seems to do that just fine. (Hopefully)

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.187 seconds