CiviCRM Community Forums (archive)

Hi, i run a diving club and i need a solution to handle my class enrolments.

i have several squads that attend several sessions per week as well as a dive school where the kids only come once a week.

how do i set up civievent to handle this?

i tried to set up custom price sets but all those sets go into the one field in the database. not helpful when it comes to reports where im trying to convert the report into a class roll.

so how do i make it so that one person can register for a class that has multiple options to choose from plus depending on how many classes they choose to attend per week depends on how much they pay.

cheers for any help.

i exported my report into csv and the fee levels have been exported into the same field.:
ie, "Monday 4:30 to 5:15pm,Tuesday 4:30 to 5:15pm,Monday 5:15 to 6:00pm,Monday 6:00 to 6:45pm,Wednesday 6:00 to 6:45pm" is just one big field.\, ie in the one cell in the spreadsheet.

event title	event date	fee level	total price
dive school	12/01/2010	Monday 4:30 to 5:15pm,Tuesday 4:30 to 5:15pm,Monday 5:15 to 6:00pm,Monday 6:00 to 6:45pm,Wednesday 6:00 to 6:45pm	$750

make sense?

is there a way to have all the in separate cells like this?

event title	event date	fee level 1	fee level 2	fee level 3	fee level 4	fee level 5	total price
dive school	12/01/2010	Monday 4:30 to 5:15pm	Tuesday 4:30 to 5:15pm	Monday 5:15 to 6:00pm	Monday 6:00 to 6:45pm	Wednesday 6:00 to 6:45pm	$750