CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviCase (Moderator: Dave Greenberg) »
  • Mass Activity Attendance
Pages: [1]

Author Topic: Mass Activity Attendance  (Read 1633 times)

leapywca

  • Guest
Mass Activity Attendance
November 11, 2009, 01:35:54 pm
Hey there,

So we have this requirement from our business partner (from now on referred to as BP in post) to try and implement a system as follows:

Our BP has a Health Program. People enrolled in the Health Program are required to attend fitness classes - which are modeled as activities in our system currently. So, it's easy to enroll them in the classes from that standpoint. However, our BP may have people that are either in other Programs (such as one for teens for instance) whom still attend the classes. So, in order to accomplish this, that is why we modeled the classes as activities because activities allow you to enroll multiple people. We added an advanced multi-select with some dates for a month. However, say you have 30 people in a class one week and only 27 the next and 32 the week after. There's currently no way of keeping track of this other than creating a new activity for each (from what I know). So the question is, is there a way to enroll multiple people in an activity (where the activity is a month's worth of classes) and for each person have a drop-down or something indicating how many times they attended the activity that month?

The way our BP currently does it is:
1 - people sign in
2 - at end of month BP has a spread sheet of all the names as rows, and dates as columns. They simply check off each person.
3 - the spreadsheet then totals how many times they attended each month

Reason our BP wants this:
For reporting purposes. They want to be able to report how many times an individual attended the classes in a given month.

Any help would be great!

Thanks!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mass Activity Attendance
November 11, 2009, 07:41:51 pm

u basically need 2 sets of data:

1.what "classes" has a person signed up for

2. what "classes" has the person attended

I've basically modelled this as 2 tables (and a 3rd data table) in the sfschool model. Its a fair amount of code

http://svn.civicrm.org/sfschool/trunk/

search for files called ExtendedCare

lobo

A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

leapywca

  • Guest
Re: Mass Activity Attendance
November 12, 2009, 07:45:31 am
hey lobo
Thanks for your reply. Writing a new page for this is definitely a good option. I was wondering if it would be possible to modify the existing "New Activity" page so that it could accomodate the requirement for having a text field for each contact added in the "New Activity" page to store the days attended by that individual. Tracking attendence is higher priority than tracking signups.
So my question was how can the existing "New Activity" page be used to do it?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mass Activity Attendance
November 12, 2009, 12:04:05 pm

i dont think activity is the best model/structure to track attendance.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviCase (Moderator: Dave Greenberg) »
  • Mass Activity Attendance

This forum was archived on 2017-11-26.