Import staff holiday / vacation records into MS Project from ExchangeServer or from a flat file or d

[Pete]

We have a MySQL database store of holiday records for staff, and we
want to upload this information into MS Project.

The MySQL database also populates staff calendars in Outlook via
Exchange Server and can also do flat file exports, or can provide the
information via a SOAP connector - so lots of possible ways on the
output side.

Can anyone suggest how to do the input part? Is there a plug-in we
could buy?

Many thanks.

 

[Paul Conroy]

You'll have to write a windows service which runs periodically to extract
data from your database and input into Project Server via the PSI. The SDK is
a good place to start.

 

[Mike Glen]

Hi Pete,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Pete]

Thanks Mike and Paul - We don't have Microsoft Project's Server
edition, so I won't post on the server newsgroup. I will try to find
someone with PSI/SDK knowledge!

Pete

 

[Mike Glen]

You're welcome, Pete

In that case, try posting on the developer newsgroup.

Mike Glen
Project MVP



Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials