Community & Support

Help sought regarding timetable creation

Hi everyone,

I would love some advice and or help with a problem I'm having.

I'm setting up a site for an arts festival. The problem is with the timetable of events.

I'm:

  • experienced as a webadmin
  • kinda new as a webcoder (well, in PHP, stronger in Perl)
  • comfortable with drupal
  • new to CCK and Views

I would like a site that has:

  • a page for each participant, showing a bio and a block with a list of the events they're in
  • a page for each event
  • a page for each venue, with details on how to get there and a block with a list of events they're hosting
  • a diary-like view of events so folks can browse what's on (Calendar view wouldn't have enough info)

So, while I can do all this by hand, I'm sure that there is a better way of doing it. For example, I'd like to be able to remove a participant who pulls out at the last moment and know that all the events they're in no long list that participant. Or remove a cancelled event and know it won't appear in the diary.

I've taught myself drupal over the last couple of weeks to do this project, and have no clue about where to start with handling this problem. I suspect the answer lies somewhere between taxonomy, CCK and views, but if someone could suggest how best to tackle this you'll save my brain from exploding :)

Even better, if you know of a module that would cover this situation, that would be fantastic! My previous searches on 'calendar', 'timetable' and the like have resulted in hits on actual Drupal conferences or the like.

Thanks in advance,
Tim

Comments

There's nothing out of the

There's nothing out of the box as far as I know.
When I saw your thread title, I thought of station module's schedule module, as that creates nice weekly timetables. But it's too closely tied to station module, and while I'd like to uncouple it and make it into a generic timetable module, it's so far down on my TODO list it's untrue. But depending on how much coding you want to do, it might be a place to start.
Otherwise, a timetable can be made with views and dates. AFAIK that's how they did the conference timetable for DrupalCon last summer.

For participants, I would use the flag module and create a flag called "participate". Flags are like bookmarks, and after all, is a user participates in an event, that is the same as them personally bookmarking that node. Flag has great views support, so you can get a list of all events for a user, all users for an event, etc.
For venues, I'd use a content type and CCK noderef so events point to a venue. Then views again can pull all events for a venue (and you can embed that into a node template for the venue).
For a diary, I'd customize a view. You can use calendar navigation but with a list or table view, and once you get into theming you can do all sorts of things like group by venue, and so on. Will take a fair bit of coding work though!

_

You might be able to automate a lot of these related actions with the http://drupal.org/project/rules module.

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.