retrieve infomration using TimeSheet.ReadTimesheetByPeriod Method

Answered retrieve infomration using TimeSheet.ReadTimesheetByPeriod Method

  • Friday, June 11, 2010 9:14 PM
     
     

    Hi : 

    I am new to PSI.  Just want to know if I retrieve using TimeSheet.ReadTimesheetByPeriod . 

    xxx.WebSvcAdmin.

    TimePeriodDataSet timeperiodDs = admin.ReadPeriods(xxx.WebSvcAdmin.PeriodState.All);

     

    Guid periodUID = timeperiodDs.TimePeriods[0].WPRD_UID;

    timesheetDs = timesheet.ReadTimesheetByPeriod(myUid, periodUID, xxxTimesheet.WebSvcTimesheet.

    Navigation.Current);

    I  am not sure how to retrieve the information just using the data table. 

    Thanks for your assistance. 

    kkmick

     

     

     

All Replies

  • Monday, June 14, 2010 11:01 PM
    Moderator
     
     
    Can you please elaborate on exactly what you are trying to do? I'm not sure that I understand your question.
    Stephen Sanderlin, Project MVP -- MSProjectExperts
  • Tuesday, June 15, 2010 12:40 PM
     
     

    Hi Stephen

    I am trying to retrieve information from the readtimesheet method.  I would like to retrieve one timesheet at a time for a certain period.  All the employee hours and projects that are associate with it.  Write the records out one at a time to a text file. 

    Thanks,

    kkmick

  • Tuesday, June 15, 2010 3:20 PM
     
     Answered

    Sorry for the Proposed As Answer, it wasn´t my intention to click this option.

    Here is my right response ;-) :

    foreach

     

    (TimesheetDataSet.ActualsRow actual in timesheetDs.Actuals){

    decimal billable_overtime_milliseconds = actual.TS_ACT_OVT_VALUE;

    decimal billable_milliseconds = actual.TS_ACT_VALUE;

    decimal non_billable_overtime_milliseconds = actual.TS_ACT_NON_BILLABLE_OVT_VALUE;

    decimal non_billable_overtime_milliseconds = actual.TS_ACT_NON_BILLABLE_VALUE;

    }

    Regards,

    Jorge.

    [ The ultimate for Project Server 2007 || http://www.projecttimesheet.com/about-en.php ]

  • Tuesday, June 15, 2010 7:59 PM
     
     

    Thank Jorge.  I will use your method to retrieve my timesheet information.