How to manage Project Server 2003 resource calendar exceptions via

R

Rasmus Anker

Hi Project Newsgroup

I’m trying to find a way to manage calendar exceptions (i.e. vacations) at the Enterprise Resource Level via SQL. The plan is to make an application that writes directly to the SQL database.

Via Project Pro I would normally chose:
- Tools/Options/Open Enterprise Resource Pool…
- Select a resource and open it
- Make the necessary changes to the resource calendar
- Save the resource

Is there a way to do this via SQL? In which tables do I find the information?

I have tried to make the changes to the table MSP_CALENDAR_DATA. This works, but I have to manage the calendar exceptions for each project the resource is a member of. It would be a better solution if I could mange the enterprise resource calendar, and not the project specific resource calendar.

So sum up: In which table do I find the enterprise resource calendar exceptions?

Looking forward to your reply

Regards
Rasmus Anker
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Base calendar interaction with a resource calendar 0
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Individual vacation calendars in a team resource 0
Unable to use PSI to create/add an enterprise calendar 0
Extracting resource Calendar Exceptions 3
Project Server 2007: how to extract calendar exceptions? 6
Modify enterprise resource calendar exceptions via PSI 3
MS Project Overwrites Max. Resource hrs 0

Top