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 Profiles (Moderator: Dave Greenberg) »
  • Alumni Directory
Pages: [1]

Author Topic: Alumni Directory  (Read 1111 times)

zesgar

  • I post occasionally
  • **
  • Posts: 107
  • Karma: 2
  • CiviCRM version: 4.3.4
  • CMS version: Joomla 2.5
Alumni Directory
December 19, 2011, 07:41:07 am
We are running an alumni/donor site and want to track years that alumni were at our organization.  We have over 80 years.  How would I best capture this information and possibly be able to run reports off of it or let them see others in the same year?

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Alumni Directory
December 19, 2011, 08:10:10 am
I will need a little more information on what you want to achieve exactly. You should be able to do things like that using relationships, (smart) groups and reports. Did you have a look at the CiviCRM manual http://book.civicrm.org/user/?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

zesgar

  • I post occasionally
  • **
  • Posts: 107
  • Karma: 2
  • CiviCRM version: 4.3.4
  • CMS version: Joomla 2.5
Re: Alumni Directory
December 19, 2011, 09:16:28 am
Yes, I have looked through the book. 

We were going to set up the years as a custom field so on forms they wouldn't take up a ton of room(ex: a drop down box or multiselect box) .  But reporting off of custom fields is a little more difficult.  Plus custom fields only have a maximum of 10 fields, we need 80+  .  So my next idea was to set up the years as tags.  But that is going to be one huge list of years at the bottom of our forms.    Any ideas?

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Alumni Directory
December 19, 2011, 11:22:30 am
Quote from: zesgar on December 19, 2011, 09:16:28 am
Plus custom fields only have a maximum of 10 fields, we need 80+
If you mean a Custom Field is limited to 10 options - not so. Certainly when setting up the field first time you are limited to 11 i believe, you can then add more, one at a time, after saving - or you can insert additional options in the dbase with same basic (ie even I can do it) sql skills
hope that helps
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

zesgar

  • I post occasionally
  • **
  • Posts: 107
  • Karma: 2
  • CiviCRM version: 4.3.4
  • CMS version: Joomla 2.5
Re: Alumni Directory
December 19, 2011, 11:25:55 am
Perfect!  Appreciate it.  Knowing that now.  What would you recommend using for years? 

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Alumni Directory
December 19, 2011, 12:26:16 pm
Is it year by year you want to save or is it a range of years? So what does the alumni table look like? I would in principle use custom fields, that should work for you.
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Alumni Directory

This forum was archived on 2017-11-26.