Customize project web access timesheets

[Shiva Chaitanya]

Hi

Is there any possibility to get the timesheets lock automatically. I mean
today's timesheet has to be locked down by midnight 12 and the next day's
timesheet has to be opened automatically.

Any thoughts on this would be greately appreciated

 

[Stephen Sanderlin]

Sure, you could create either a windows service or a sharepoint timer
job to close the period(s) using the Timesheet PSI service. See the
Admin.UpdateReportingPeriods() method, TimePeriodDataSet.TimePeriodsRow
class, and the PeriodState enumeration.

http://msdn.microsoft.com/en-us/library/websvcadmin.admin.updatereportingperiods.aspx
http://msdn.microsoft.com/en-us/library/websvcadmin.timeperioddataset.timeperiodsrow_methods.aspx
http://msdn.microsoft.com/en-us/library/websvcadmin.periodstate.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

 

[Shiva Chaitanya]

Hi Stephen

Thank you very much for the information. We don't have sharepoint server
synchronized with project server. Can we do that without interference of
sharepoint.

Thank you
Shiva Chaitanya.

 

[Stephen Sanderlin]

Are you not using Project Server 2007?

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

 

[Shiva Chaitanya]

Hi Stephen

We are using project server 2003.

Thank you
Shiva Chaitanya

 

[Stephen Sanderlin]

Shiva,

In PS03, you could set the value of WPRD_STATE to 1 for the appropriate
row in the MSP_WEB_TIME_PERIODS row using a scheduled query in the SQL
Server Agent.

HTH,
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