Can you add a field to the MY Timecard?

Home Forums Microsoft Project Discussion Forum Can you add a field to the MY Timecard?

Viewing 7 reply threads
  • Author
    Posts
    • #393517
      John Murphy
      Member

      We are hoping to export the timecards from PWA and send them to our internal TimeTrack system. To do this, each timecard entry needs to have a TT Activity code (Deliver Implem/Project Mgt/ Process Improvement/ etc.) assigned to it. So I just added a TimeTrack Activity Code field to my PWA instance at task level. My hope is to add the field to the My TimeCard view to allow each team member to select a TT Activity for each entry in his or her TimeCard. I can choose the TT Activity field in the MY TimeCard view but it is not showing up.

      Any help or comments would be appreciated.

      Thanks
      John

    • #393520
      Avatar photoLarry Christofaro
      Participant

      John, does the TT activity code need to be selected with each time entry or is it a custom task field assigned to the task? If it is assigned to the task then you can simply export the time records with that assigned field. Otherwise you might want to try the timesheet category feature. That is something you can choose at the time when the timesheet is entered. I also don’t understand your last sentence that you an choose it but it doesn’t show up. Hope that helps…

    • #393563
      John Murphy
      Member

      Larry,

      I can understand that I can add the Activity as a custom TASK field and then export the field with the time records. However, I am hoping to have the person entering the time choose what Activity to assign each individual Actual. Given that fact, I tried the time card billing category feature and added another category in addition to the STANDARD default one. However it seems that I cannot change it in the My Timecard view.

      As for my last sentence in my post, I added the Activity to the MY TimeCard view. However when i go look at this view, the new field is not there. 🙁

      Thanks
      john

    • #393568
      Avatar photoLarry Christofaro
      Participant

      The billing category is selected when you add a task. Tasks are initially added to the timesheet as Standard. I don’t believe there is a way to change it.

    • #394001
      John Murphy
      Member

      It looks like I will need to have the Activity set by the PM and then grab that when I get the time out via oData. I have to test that out.

      Thanks
      John

    • #397040
      John Murphy
      Member

      Larry

      I am again working on the possibility of implementing Timecards for us and then send the time to our internal Time Tracking system.

      To be able to do this I need Activity assigned to each timecard entry. I added Activity as a Task field and then added it to the My Timecard view and did not make the field read only. So I am able to change the Activity code in my timecard.

      However I do not see the field in my oData TimesheetLineActualDataset table. Why and can I add it?

      Also given I may need to merge Activity from the Task Table with my TimesheetLineActualDataset table, is there a good view of the overall odata schema to show me how the tables are related … how they can be joined?

      Thanks
      John

    • #397046
      Avatar photoLarry Christofaro
      Participant

      Not sure there is a schema other than a lot of feeds. I tend to join them when I connect them to an Excel workbook. You should be able to connect the timesheet line to the Task using the TaskID (I think that’s the field name anyway). Hope that helps.

    • #397048
      John Murphy
      Member

      Larry

      I had not looked at the Timesheet Lines table …

      Should be good to go now …

      Thank you!
      John

Viewing 7 reply threads
  • You must be logged in to reply to this topic.