Calendar in Project Server

E

erickwidya

i got Enterprise Calendar and already set its holidays inside in, all the
project use this Calendar

can i access this Calendar using code? since i can't find any information
about this

thanks,
erick
 
S

Stephen Sanderlin

If you want to access the calendar as defined on Project Server, you'll
want to use the Calendar PSI. Consult the SDK for more information.

If you want to access it in some other way, please post a clarification
to your question.

--
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
 
E

erickwidya

thanks for the reply Stephen

If you want to access it in some other way, please post a clarification to
your question. -> so i basically want to remind Resource if the Task in
Project related to them is gonna Due (remind xx working days before due date)

is there a method regarding this one?

thanks,
erick
 
E

erickwidya

yes i'm aware of that..

but our client needs a little bit sophisticated, they want to be remind 4
times before task due date

the reminder gonna be levelling (4 level) from User to CEO
 
S

Stephen Sanderlin

E

erickwidya

any code insight?

i fairly new to project server...been 2 weeks on this one :D

thanks,
erick
 
E

erickwidya

any code insight?

i'm not sure how to get Resource PSI

i'm new on this matter

thanks,
erick
 
S

Stephen Sanderlin

I suggest downloading the SDK and taking a shot at it using that as a
reference. If you run into trouble, we will be glad to help.

Unfortunately, if you're totally (or mostly) unfamiliar with the
concepts of PS development, not much of what I can tell you will be of
much use. You need to go through the SDK and establish a basic
understanding of the foundational concepts first.

--
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
 
E

erickwidya

yes, i already download the SDK and i'm using that as a reference..i'm able
to read the Projects and Resources and also task due date using that as
reference..

but when it comes to Calendar, i got no clue at all..
 
S

Stephen Sanderlin

Erickwidya,

The Calendar PSI will give you calendar exceptions for enterprise
calendars, while the Resource PSI will give you calendar exceptions for
resources. The Calendar Exceptions are interesting to work with, but as
you've discovered they can be challenging. It's rather difficult to
explain without code on a screen and a lot of coffee :eek:) The best thing
I can suggest to just "shotgun" it in a console app and work through it.

Off the top of my head, here's your basic flow:
1) Retrieve calendar exceptions and their durations from the
aforementioned PSI services.
2) Determine if there are any calendar exceptions between today and
(today + n). Evaluate for any overlap between the two types of calendar
exception and adjust the value of x accordingly by addding the duration
(x) of said exceptions to (today + n), which results in (x').
3) Create a list of assignments that have a finish date less than or
equal to (x' + today + n) and process according to your business rules.

Hope that helps...
Steve

--
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
 
E

erickwidya

hue2..thanks Stephen

i still have no clue regarding what u said but i will try based on what u
said, hopefully i'm gonna return with some code then :D

i'm gonna search for calendar exception now

thanks for putting me on right direction
 
E

erickwidya

already look at the project server...at the SDK, Calendar PSI only use for
populate combobox in ProjTool project..

there's no example for using Calendar Exception like u said stephen..

or i'm looking at wrong SDK??
 
S

Stephen Sanderlin

Ah, you need to look at PJSDK2007.chm, not just the code samples. Here
it is online:
http://msdn.microsoft.com/en-us/lib...rcedataset.calendarexceptionsrow_members.aspx
and
http://msdn.microsoft.com/en-us/lib...dardataset.calendarexceptionsrow_members.aspx


--
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
 
E

erickwidya

i give up exploring Calendar PSI, i came to solution to use List that
determine the holiday (identic as Enterprise Calendar in Project)

then calculate the due date using code..it all work fine :D

thanks all,
eRiCk
 
S

Stephen Sanderlin

E

erickwidya

hi, stephen

Was there something specific
about using the PSI that made it difficult to use or understand? -> very hard to understand since i learn it by doing and never using an approach that used Webservice that returned Dataset and use it all along the way (if i'm not mistake about it :D) and also because i can't find any code example for it, if i can find it then i can learn how it works
 
S

Stephen Sanderlin

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

Top