Using Database Module as On Line Booking System

Using Database Module as On Line Booking System

by Michael McDermott -
Number of replies: 2

I use the database module as an on line booking system for equipment. It works well but I would like three modifications.

1. Entrants only see their own bookings, apart from admins and teachers.

2. It automatically e-mails a confirmation to the customer.

3. It automatically copies the information into Outlook at the time and date requested.

All these modifications would have to be switched on or off, so it does not interfere with normal college use of the database.

Any thoughts, suggestsions  would be very welcome. Or am I using the wrong module as I to have have data sorted by date, venue, service area and jobs and it also has to be able to upload files.

Mike

Average of ratings: -
In reply to Michael McDermott

Re: Using Database Module as On Line Booking System

by Itamar Tzadok -
  1. Set the database to require approval and don't approve anything.
  2. MDL-8377 has a patch for email notification but I'm not sure it does exactly what you want. Check it out.
  3. Whose outlook? At any rate, a quick search brought up How to: Import Appointment XML Data into Outlook Appointment Objects. You can use the RSS of the database as the XML source but currently the RSS has a 50 item limit and you will have to tweak the code to increase this number.

hth smile
Average of ratings: -