I require a web based application that can manage the invitation process for events.
The system needs to:
* maintain a guest list - full contact details + notes. The guest information will be entered either directly into the system single data entry style or imported as a CSV. So some type of SQL DB.
* maintain a list of different 'event profiles'. This would include specific information about a particular event i.e its name, total number of tickets available, basic description of the event.
* various documents and form letters need to be assigned to each event profile. These might include a invitation form letter as well other documents such as directions to the event, documents on dress code. The managers of the system will then assign each document to the event profiles.
* send various invitations to guests (email + print merge) based on what event (event profile) they have been invited to.
* manage RSVP (most likely manually because RSVP will come in many forms)
* keep track of invitations send and RSVPs received. Cross reference RSVPs received with the numbers of tickets available for the event so not too many people are invited.
* allow multiple users to manage invitation process and track who invites what guest.
* keep history of what guests were invited to what events
This is a proto type and requires only basic design work for the interfaces.
The system needs to be web based as different managers are located in different locations.