locked
Extracting Timesheet data directly from SQL Server RRS feed

  • Question

  • Hi, 

    I want to extract TimeSheet data directly from SQL Server but didn't know which tables contain this information.

    Kindly help me to identify the database tables.

    Regards,

    Mehar

    Friday, September 21, 2012 12:00 PM

All replies

  •  Hi Mehar is there any reason why you would want to do so? Microsoft can change the backend on you but my understanding is that the reporting database views are guaranteed to stay the same meaning much less chance of reports breaking if a patch necessitated a change.

    Take a look at the various timesheet views in the project server reporting database.


    Ray Letts Arbutus Solutions

    Friday, September 21, 2012 4:23 PM
  •  Hi Mehar is there any reason why you would want to do so? Microsoft can change the backend on you but my understanding is that the reporting database views are guaranteed to stay the same meaning much less chance of reports breaking if a patch necessitated a change.

    Take a look at the various timesheet views in the project server reporting database.


    Ray Letts Arbutus Solutions

    Ray, 

    I am developing a utility to migrate data from Project Serve 2010 Timesheets to QuickBooks.

    Regards,

    Mehar

    Saturday, September 22, 2012 6:39 AM
  • Hi Mehar,

    You can go to Reporting database for that, and check the Views for Timesheet. There are many different view available, for example MSP_TimesheetLine_UserView. Apart from this, you can fetch data from Reporting's Tables (please do not add/update data!) as well, it replicates Published database.

    Hope this answer you question.

    Thanks


    Thanks, Kashif

    Sunday, September 23, 2012 8:31 AM
  • Download the Project SDK from MSDN. I t has a complete schema for the reporting db in it.

    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Sunday, September 23, 2012 10:32 AM
  • Hi, 

    I want to extract TimeSheet data directly from SQL Server but didn't know which tables contain this information.

    Kindly help me to identify the database tables.

    Regards,

    Mehar

    Hi Mehar--

    Please see the below Gallery script :
    http://gallery.technet.microsoft.com/projectserver/Server-20072010-SQL-Get-f1252098

    H
    ope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Monday, September 24, 2012 4:37 AM
  • You basically need the MSP_TimesheetLine_UserView for the timesheet data, the MSP_TimesheetActuals table for the daily entries and the MSP_TimeByDay table for the timesheet reporting period info. The join is pretty straightforward.

    The SDK can help you determine which fields to do selection so that you get the desired records.

    Treb Gatte | @tgatte | http://AboutMSProject.com

    Monday, September 24, 2012 6:55 AM