none
how to connect project server timesheet to other systems? RRS feed

  • Question

  • Hi,

    our compnay has a system which register both enter and exit for all staff. at the end of each month all these data will be gathered and imported to our company MIS. there is a timesheet in the MIS which is programmed by Oracle and all staff enter their actual work hours on each projects' activities.Now we are going to setup project server to take advantage  of all its featurs. one of them is timesheet. with Project server we can plan all resources and we see all planned man-hour in timesheet. How is it possible to enter actual man-hour for each period like what we used to have in our MIS based on data in enter and exit system?

    thanks

    Saturday, March 7, 2015 3:34 PM

Answers

  • Sam-Net,

    I think the real question is whether you want your users to enter timesheets manually or you want the entry/exit system to auto populate these timesheets.

    You have few options:

    1) You could do your own custom coding like here: http://www.mpug.com/articles/project-programming-integrating-project-servers-timesheet-with-an-access-control-system/

    2) You could use a third party product like these: http://www.timecontrol.com/use-cases/ms-project-server, http://archive.constantcontact.com/fs109/1112227710467/archive/1112305423066.html, 

    3) Or you could keep collecting actuals like you are doing today, and then just do the 'integration' at the reporting level. That way you have planned data from Project Server, and Actuals from your entry/exit system.


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    • Marked as answer by Sam-Net Monday, March 9, 2015 6:39 AM
    Sunday, March 8, 2015 5:04 PM
    Moderator

All replies

  • Sam-Net,

    I think the real question is whether you want your users to enter timesheets manually or you want the entry/exit system to auto populate these timesheets.

    You have few options:

    1) You could do your own custom coding like here: http://www.mpug.com/articles/project-programming-integrating-project-servers-timesheet-with-an-access-control-system/

    2) You could use a third party product like these: http://www.timecontrol.com/use-cases/ms-project-server, http://archive.constantcontact.com/fs109/1112227710467/archive/1112305423066.html, 

    3) Or you could keep collecting actuals like you are doing today, and then just do the 'integration' at the reporting level. That way you have planned data from Project Server, and Actuals from your entry/exit system.


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    • Marked as answer by Sam-Net Monday, March 9, 2015 6:39 AM
    Sunday, March 8, 2015 5:04 PM
    Moderator
  • Sam-Net,

    I think the real question is whether you want your users to enter timesheets manually or you want the entry/exit system to auto populate these timesheets.

    You have few options:

    1) You could do your own custom coding like here: http://www.mpug.com/articles/project-programming-integrating-project-servers-timesheet-with-an-access-control-system/

    2) You could use a third party product like these: http://www.timecontrol.com/use-cases/ms-project-server, http://archive.constantcontact.com/fs109/1112227710467/archive/1112305423066.html, 

    3) Or you could keep collecting actuals like you are doing today, and then just do the 'integration' at the reporting level. That way you have planned data from Project Server, and Actuals from your entry/exit system.


    Cheers,

    Prasanna Adavi, Project MVP

    Blog:   Podcast:    Twitter:    LinkedIn:   

    thanks for your quick reply,

    the first solution is the bet in my opinion. The second one doesn't cover all my needs and the third one has a big problem.By using the third choince, i would lose actual data for rescheduling.

    I think we have to take some points of the first solution and do some custom coding

    thank

    Monday, March 9, 2015 6:38 AM