Import timesheet data to Actual Work field RRS feed

  • Question

  • I get an export of timesheet data from an ERP system into .xls.

    The columns are:  Name|WBS Code|Date|Hours

    I am trying to do a mapped import to Project.  I'm planning to map as follows:

    Name to Resource Name

    WBS Code to WBS

    Hours to Actual Work

    But what do I map the Date field to???  I used Date1, and it did the import, but scattered the data all over.

    Wednesday, March 9, 2016 3:58 PM

All replies

  • Hi William,

    I have never tried to do this my self. I would say you map the date to "TimeByDay".

    JSR works together with a company called TPG, they design interfaces between ERP and PPM on a daily basis. Maybe you could contact them to get some insight? To find more about them you can read about a training I had with them on my blog.

    Kind regards,


    Friday, March 11, 2016 6:28 AM
  • Erik,

    Thanks, But I don't show "TimeByDay" in the pull down menu when I go to set the mapping.  I'm using Project 2010.  Maybe that's a new thing in 2013?


    How do I contact JSR?

    Friday, March 11, 2016 12:59 PM
  • The TimeByDay has always been part of the database, but I don't know how it could be accessed. JSR won't be able to help much, I think a partner like TPG The Project Group or Sensei could be of more use. They create 3rd party tools and know how to use the data structure to populate ERP systems.

    Here are two quick links to get a hold of them:

    And of course you are still welcome to contact JSR at: (The site is only available in Dutch, sorry guys)

    Kind regards,


    • Edited by Erik van Hurck Monday, March 14, 2016 6:55 AM nuance in answer
    Monday, March 14, 2016 6:54 AM