Project Server 2007: how to extract calendar exceptions?

[Ivo]

I'm trying to build an SSRS report that lists all resource calendar
exceptions that are recorded via the 'Change Working Time' form and I'm
struggling to find a way to extract this from the DB.

Apparently the data is available through a web service but can't really be
pulled into a report (http://msdn.microsoft.com/en-us/library/ms423156.aspx)

Any suggestions?

Thanks in advance

 

[Jan De Messemaeker]

Hi,

I can do it from the open project using VBA but maybe that os not your aim?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Ivo]

Hi Jan,

I'm trying to get the data by querying the SQL DB so that I can write a
report.

Ivo

 

[Stephen Sanderlin]

You should be able to accomplish this using the Calendar PSI, which you
can consume in SSRS just like any other web service.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com

 

[jpa]

Hi,
I'd also like to decode calendar exception information.
And I am quite new with using Calendar PSI.
Could you please give me an exmaple of the function able to decode the
CAL_INFO field for instance?
Thanks in advance
jpa

 

[jpa]

Hi Jan,

I am also trying to visualize calendar exceptions information...
Could you please indicate which VBA code are you using?
Thanks in advance
jpa

 

[Stephen Sanderlin]

The CAL_INFO data in the RDB is in binary. You should not use this --
you need to use the PSI.

Actually, with apologies I must revise my earlier suggestion... if
you're trying to retrieve Resource calendar exceptions only, you need to
use the ReadResources
(http://msdn.microsoft.com/en-us/library/websvcresource.resource.readresources.aspx)
method in the Resource PSI. The Calendar PSI will only return calendar
exceptions for enterprise calendars.

There is an example of how to use the ReadResources method in the
article I linked to above. To retrieve the Calendar Exception
information, you simply need to iterate through the rows in the
CalendarExceptions DataTable. The RES_UID property of each
CalendarExceptionsRow contains the GUID of the resource to which the row
applies.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com