troubleshooting Question

Need a way to import & export entries from SQL to Exchange Calendars

Avatar of tabush
tabush asked on
Exchange.NET Programming
4 Comments1 Solution240 ViewsLast Modified:
We have a custom written database application that we use in-house to manage legal cases. it has a scheduling component which allows each user to put scheduled items relating to cases. i am looking for a way to syncronize these entries to each user's outlook calendar (we have exchange 2003).

as we store all scheduled entries in a SQL table, i would like a way to move that data into Exchange - i would think there is a tool that i can put on the exchange server, give it the right admin credentials to access all mailboxes, and that tool can "create" calendar appointments based on the data in the database. perhaps it can run every 10 minutes or so, scan all entries in my database, and replicate them to the proper outlook accounts.
i can add in to my database each users AD username and password if necessary.

If this is not possible, then is there a standard way i can have my application (which is all web-based, asp.net) call up a new schedule window (using the outlook client) with pre-filled in information? for example, if the user is looking at a particular case, they click "new event" and the scheduler just brings up a "new appointment window" from the user's outlook, with the subject field already pre-populated with data (kind of like the way a "mailto" hyperlink can contain the subject/body of an e-mail. then the appointments are saved directly to outlook/exchange.
i'm guessing this might require an outlook plugin or something - anyone know of a good one?

any help in the matter is greatly appreciated!
ASKER CERTIFIED SOLUTION
Stacy Spear
President/Principal Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros