Tagged: timecard schema
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.
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…
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. 🙁
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.
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.
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?
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.
I had not looked at the Timesheet Lines table …
Should be good to go now …