Goal: Create a Windows Service that will sync predefined mailboxes with an MS Sql Table. User must be able to add Record in table which will be inserted into Calendar of user specified. (same goes for modify/delete). If user adds appointment in Exchange it will show in DB Table.
Deadline: The project must be completed by 4. September 2006
Deliverables: Project Files (including Source+simple documentation) , Installer for files
Appointment can be added / modified / Deleted through UI of Resource Planer (existing Application) or through MS Exchange. In resource UI a resource is assigned to an existing Mailbox. If appointment is added in Resource Tool it should create an appointment in Mailbox assigned to resource.
In an INI File the user can define which mailboxes are to be written to DB Table. Once appointment is created in Exchange for the montored mailbox a record is entered into agenda table. A message ID will be stored to clearly identify the appointment. When the appointment is modified in Exchange the record in DB must be changed accordingly. If user changes appointment through UI the change must also reflect in Exchange.
Structure of INI File:
ExchServer=/o=First Organization/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=IPOINT-QMXVNLMO
ApptBookedByText=Booked by %sn
Addr1=/o=First Organization/ou=First Administrative Group/cn=Recipients/cn=Administrator
Addr2=/o=First Organization/ou=First Administrative Group/cn=Recipients/cn=Christian
Addr3=/o=First Organization/ou=First Administrative Group/cn=Recipients/cn=Klaus
Addr4=/o=First Organization/ou=First Administrative Group/cn=Recipients/cn=Manfred
Addr5=/o=First Organization/ou=First Administrative Group/cn=Recipients/cn=olaf