none
SQL Project Server Calendars Tables RRS feed

  • Question

  • Where calendars are store inside sql database? I mean holidays (exceptions) and working weeks entries?
    Wednesday, February 24, 2016 2:12 PM

All replies

  • Hi,

    Project server published database table [MSP_CALENDARS] which contains all the CALENDARS information at project. It can be joined on [MSP_PROJECTS] table to get the CAL_UID but "NOT SUPPORTED".

    See those posts or thread which might also give you some ways to do it:

    • http://msproject-kk.blogspot.fr/2013/02/export-resource-exceptions-details-non.html
    • https://social.technet.microsoft.com/Forums/projectserver/en-US/a8f15497-e036-49f4-834d-8f84276e5869/project-2013-how-to-create-a-resource-working-time-exception-report?forum=projectprofessional2010general#df581333-c2ce-41b1-bbda-1f863ec9ba3e
    • https://epmxperts.wordpress.com/2011/09/05/retrieve-all-calendar-exceptions-for-each-project-in-project-server/
    • https://msdn.microsoft.com/en-us/library/office/websvccalendar_di_pj14mref?f=255&MSPPError=-2147217396

    Hope this helps,


    Guillaume Rouyre, MBA, MVP, MCC |

    Thursday, February 25, 2016 8:00 AM
    Moderator
  • I dont want to get its links to projects, i want to read its settings and exceptions.

    But i think all this data i need is serialized into CAL_INFO binary field. No way to parse it within going extreme.

    Monday, February 29, 2016 2:44 PM
  • Were you able to parse the Cal_Info binary field and read the Calendar data ? what method did you employ to read the Calendar data in MS Project?

    I am facing a similar issue while trying to read the Calendar info from SQL while calculating the Working days in a date range which is based on the calendar that MS Project utilizes.

    Regards,

    Agasthya


    agasthya

    Tuesday, November 7, 2017 5:34 AM