none
Access Calendars via PSI RRS feed

  • Question

  • Hello everybody,

    I'm facing a problem concerning enterprise calendars. I'm developing a software for Project Server 2010 that reads the resources' work per day and shows aggregate values per project and per month. For this purpose I'm trying to build a method which check whether a given resource is assigned on a given date. Here, the calendar comes into game. As far as I've read the SDK Documentation there is no way to access detailed enterprise calendar information of the type "Saturday/Sunday are non-working days". Unfortunately those non-working days are not part of the CalendarExceptionDataSet class.

    Hence my question is: Is there any way to access those information via code (C#)? I've already had a look at the property PROJ_OPT_DAYS_PER_MONTH which excludes weekends, but which I'm not able to take to explicitly see whether a given date is a weekend. I know there are ways of accessing this information via the System Calendars class but since there are several calendars employed in the company it has to be read off dynamically.

    Thanks a lot for your help,

    Tom

    Tuesday, August 21, 2012 6:07 PM

Answers

  • Hello,

    I want to share the definitive answer with you:

    You can't access calendar information except for calender exceptions and cal_uid and cal_name via PSI. 

    But there is the possibility to employ the "EpmAssignmentByDay_UserView" of the Reporting Database to get to know which days are planned as working days and which not.

    Thanks a lot! Tom

    • Marked as answer by BIS HD Thursday, November 29, 2012 5:11 PM
    Thursday, November 29, 2012 5:11 PM

All replies

  • Hi Tom--

    To get he Resource exception, You may need to use the Resource Class & read the exceptions using resourcedataset & ResourceCalendar table.
    http://msdn.microsoft.com/en-us/library/office/websvcresource.resourcedataset.calendarexceptions_di_pj14mref

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, August 22, 2012 5:32 AM
  • Hello Amit,

    unfortunately that does not help, since weekends are not stored within the Ressource exception class. In addition we are using a project enterprise calendar, not special resource calendars. 

    If I'm wrong, correct me.

    Thank you!

    Wednesday, August 22, 2012 8:26 AM
  • Hello,

    I want to share the definitive answer with you:

    You can't access calendar information except for calender exceptions and cal_uid and cal_name via PSI. 

    But there is the possibility to employ the "EpmAssignmentByDay_UserView" of the Reporting Database to get to know which days are planned as working days and which not.

    Thanks a lot! Tom

    • Marked as answer by BIS HD Thursday, November 29, 2012 5:11 PM
    Thursday, November 29, 2012 5:11 PM