none
retrieve infomration using TimeSheet.ReadTimesheetByPeriod Method RRS feed

  • Question

  • 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

     

     

     

    Friday, June 11, 2010 9:14 PM

Answers

  • 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 3:20 PM

All replies

  • 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
    Monday, June 14, 2010 11:01 PM
    Moderator
  • 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 12:40 PM
  • 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 3:20 PM
  • Thank Jorge.  I will use your method to retrieve my timesheet information. 

     

     

    Tuesday, June 15, 2010 7:59 PM