loading time into Workfront | Community
Skip to main content
Level 3
January 29, 2020
Question

loading time into Workfront

  • January 29, 2020
  • 2 replies
  • 474 views
Hello, We record time in Sage Intacct and then import the data into workfront. We load by project and then have tasks that we load into the Hours task field. So for example 1/15/2020 Project = ABC; Task = Project Manager; Hours = 5 (with tasks loaded into the description) 1/15/2020 Project = ABC; Task = Data Conversion; Hours = 20 (with task name loaded into description) Workfront combines these two rows on the kickstart into one hour entry in the Hours object. so you get 1/15/2020 Project = ABC; Description = Project Manager Data Conversion; Horus = 25 This is not desirable as we would like to understand the Project Manager Hours vs. the Data Conversion hours. Any ideas? John Hoebler Cross Country Consulting
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

ChrisBudgen
Level 5
February 3, 2020
Hi John, the issue is, that in Workfront you can't have multiple hour entries on one task/day combination. We solved this by creating hour types "Line 2", "Line 3" and so on. If the user adds hours manually, he just has to select a different "line", if the hours are filled by the API, we first check for an available "line" and us that to add the hour. Hope this helps! Best, Chris Chris Budgen Emakina Group
JohnHoAuthor
Level 3
February 3, 2020
Great idea!