Exchange Server Sync with SQL

Closed

I have a table in SQL server 2005 that i need to have code to keep it sync'ed with multiple address books in Microsoft Exchange Server.

the 'syncing' is a one way from the table to exchange server.

Once a day the service (or the scheduled app) will run and delete the address books(s) we have contacts for (not all address books on the exchange server) then recreate those books as per the contacts in the table.

There are more than one address book.

The table has the following fields:

SELECT [BookName]

,[ContactID]

,[FacilityNumber]

,[HomePhone]

,[CellPhone]

,[Comments]

,[Department]

,[Country]

,[Organization]

,[Address]

,[City]

,[State]

,[Zip]

,[OfficePhone]

,[FaxNumber]

,[Greeting]

,[FirstName]

,[LastName]

,[DisplayName]

,[Title]

,[EmailAddress]

,[Salutation]

FROM MyContacts

[BookName] : there could be more than one address books. This field will have the address book name that the contact belongs to.

[ContactID] and [FacilityNumber]: these are informations that i want stored in the contact (if Exchange server allows custom fields.

Other fields are obvious..

- All variables must be in a XML, ini, or any other easily changed file format.

- variables will include:

? ? ? ? .. Connection String

? ? ? .. SQL statment (use the same statement as mentioned on top, but alow the statement to be changes.. however field names will be the same and safe to hard code the field names). This gives me the ability down the road to use "as FirstName" for example to change the source of the SQL statement.

? ? ? .. All Exchange server properties.

- Languages allowed: C# or [url removed, login to view] (pref C#)

- Source code must be included.

## Deliverables

* * *This broadcast message was sent to all bidders on Tuesday Sep 22, 2009 7:12:40 PM:

(message broadcast about Exchange<->SQL server project) Hi; I forgot to mention that the 'syncing' is a one way from the table to exchange server. Once a day the service (or the scheduled app) will run and delete the address books(s) we have contacts for (not all address books on the exchange server) then recreate those books as per the contacts in the table. I hope this clarify the project

Skills: PHP

See more: server languages, city of hope, sql microsoft, microsoft server, microsoft exchange service, exchange server net, code ed, php file exchange, sql statement stored, php connection select, microsoft exchange php, exchange server change, exchange contacts, php sync, address book source sync, exchange day, sql exchange, sql microsoft project, net sync, php server project, sync service, sync code, php statment, book languages, sql select select

Project ID: #2888398

Awarded to:

Robotapps

See private message.

$182.75 USD in 2 days
(102 Reviews)
5.4

10 freelancers are bidding on average $164 for this job

radzivil

See private message.

$169.15 USD in 2 days
(92 Reviews)
6.1
jawadh

See private message.

$212.5 USD in 2 days
(83 Reviews)
6.0
Fedrek

See private message.

$191.25 USD in 2 days
(11 Reviews)
5.1
jimmyzhong

See private message.

$127.5 USD in 2 days
(9 Reviews)
5.0
dsysoft

See private message.

$170 USD in 2 days
(36 Reviews)
4.3
domenetuk

See private message.

$212.5 USD in 2 days
(6 Reviews)
3.7
kpooja1987

See private message.

$93.5 USD in 2 days
(1 Review)
0.5
bhubaneu

See private message.

$199.75 USD in 2 days
(0 Reviews)
0.0
arunbkumareu

See private message.

$85 USD in 2 days
(0 Reviews)
0.0