I gang

Exchange 2003 - Sync Mbx Taskslist with SQL Server 2005

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:

[Config]

DB=Agenda

SQLServer=1

DBUserName=Workdeskadministrator

ExchServer=/o=First Organization/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=IPOINT-QMXVNLMO

CycleTime=5

DaysPast=60

DaysAhead=60

SecurityLevel=0

ApptBookedByText=Booked by %sn

DateTimeFormat=%c

ShowNoPrivate=0

ShowPersonal=0

SkipCancelledMeetings=0

[Group1]

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

[Server1]

TimeDiff=+0.0

DS=Agenda

DateTimeFormat=%c

Username=WORKDESKAdministrator

Password=95B7D19B54881026ACF198

Færdigheder: .NET, ASP, System Administrator, Windows Skrivebord

Se mere: sn it, group o, delete tool, define structure, asp net resource, sql exchange sync, exchange servers, for planer, planer, olaf, modify calendar, identify, exchange server net, ds, create simple windows application, change username, change deadline, installer create, sql created, asp sql project, project net sqlserver, exchange server change, predefined, create sql installer, sql exchange

Om arbejdsgiveren:
( 8 bedømmelser ) Boeblingen, Germany

Projekt-ID: #84393