Describes in detail the available settings and controls for a basic Project and Task Import using the Kick Start method.
The implementation team would rather import project and task information for active projects as opposed to manually inputting this data into the system.
The following table displays four Projects and their basic details that need to be mapped into the Kick Start file formats.
|Project Name||Planned Start Date||Project Manager||Project Sponsor||Group||Company|
|Implement Workfront||Today||Jennifer Campbell||Marc Lewis||Marketing||Your Company|
|Implement HR System||July 14, 20XX||Pam Reynolds||Marc Lewis||Marketing||Your Company|
|Implement Document Management System||August 22, 20XX||Jennifer Campbell||Ray Andrews||IT||Your Company|
|Implement New Calendar System||September 6, 20XX||Pam Reynolds||Ray Andrews||IT||Your Company|
This scenario assumes users are already imported into Workfront. If users are not already in Workfront, either subsitute different names or complete the Kick Start Scenario with users prior to this scenario.
The following task list displays overly simplified task lists for the projects. The only difference between projects is the start dates and progress made on each project.
|#||Task Name||Assigned To||Parent Task||Pred||Duration||Work||Percent Complete|
|2||Import Users||Ray Andrews||1||1 hour||1 hour||0%||100%||100%||100%|
|3||Set Permissions||Ray Andrews||1||2||1 hour||1 hour||0%||100%||100%||100%|
|4||Build Groups||Ray Andrews||1||3||30 min||30 min||0%||100%||100%||100%|
|5||Build Report||Ray Andrews||1||4||2 days||4 hours||0%||100$||100%||
|6||Prepare Training||Chris Manning||2 days||4 hours||0%||100%||50%||100%|
|7||Build Ongoing Support Policies||Chris Manning||2 days||4 hours||0%||100%||50%||0%|
|9||Train Users||Chris Manning||8||1 day||2 hours||0%||0%||0%||0%|
Parent task inherit the Duration, Work, and Percent Complete of children tasks. It is not necessary to set those values for that will become summary tasks.
NOTE: The instructions provided in this scenario are not as explicit as the step-by-step directions provided in Kick Start Scenario: Company, Group and User. The assumption is you have already learned how to look up and copy values from the Company and Group sheets, so these steps will be mentioned, but not specifically outlined.
Navigate to the Kick-Starts page. Select the Company, Group, Project, Task, and User objects. Select the Include existing data checkbox (do this to quickly reference Company, Group and User IDs). Click the Download button.
Input Project Details
Open the Workfront.xlsx file you just downloaded. Go to the PROJ Project sheet.
Unless you have already created projects in Workfront, it should be empty.
NOTE: Consider using the spreadsheet's Freeze Panes tool and/or hiding or removing unneeded columns to make the sheet easier to use. However, be careful not to remove any required columns or columns to use later.
Set isNew column.
Input TRUE into rows 3 through 6 for the isNew column.
Set unique IDs.
Input a unique ID in each row for the ID column — Typically, integers starting at 1 work well when creating new records.
Set Project Names.
Input the names of each project into the setName column.
Set Task numbers.
Input values into the setTaskNumber column to control the order the tasks will appear in the project plan.
Provide project dates.
Input the Planned Start Date for each project in the setPlannedStartDate column.
Set other needed details.
Fill in other details, such as a description or current status, as needed. Look up the Group IDs for each project on the GROUP Group sheet and input them into the setGroupID column for the respective projects. Look up the Company ID for the projects on the CMPY Company sheet and input it into the setCompanyID column. Look up the User ID for each project owner on the USER User sheet and input it into the setOwnerID column. Look up the User ID for each project sponsor on the USER User sheet and input it into the setSponsorID column.
NOTE: Acceptable values for Status and Priority fields can be located by reviewing the status and priority preferences for each object in the Workflow Setup area of Workfront.
Input Task Details
Go to the TASK Task sheet.
Unless you have already created tasks in Workfront, this sheet should be empty.
The easiest way to map tasks is one project at a time (especially when the tasks are the same on each project). You can then copy the task plan for the first project and make small adjustments to the task plan for the subsequent projects. The remaining steps will assume you are creating tasks for just the Implement Workfront project. According to the scenario, you will be importing 9 tasks per project, so input TRUE into rows 3 through 11 for the isNew column.
Input a unique ID in each row for the ID column.
Input the task names into the setName column.
Confirm Project ID.
Input the ID you set for the Implement Workfront project; review the PROJ Project sheet to make sure it is the correct ID.
Go to the USER User sheet to look up the ID for the user assigned to each task and input these values in the respective cells in the setAssignedToID column.
Identify Task relationships.
For tasks 2 through 5, input a 1 in the setParentID column. For task 9, input a 8 in the setParentID column. In the setPredecessorString column, input the task number for each predecessor task. In cases where a task has multiple predecessors, like task 8 in this scenario, you will need to use a comma to separate each predecessor task ID. Predecessors can be defined with lags on non-Finish-Start relationships by using the shorthand described in the Creating Predecessor Relationships article.
Set the duration for each task by inputting number of hours, days, weeks, or months for the task in the setDuration field. Then input the duration unit in the setDurationUnit field.
|Time Unit||Acceptable Value|
|Minutes can also be represented as fraction of an hour (eg., minutets = 5 hours)|
Set the amount of effort for each task in the setWorkRequired field. Then input the work unit in the setWorkUnit field. If the Work Required value is different from the duration, you will also need to input an A into the setDurationType field.
|Duration Type||Acceptable Value|
Input the whole number representation of the percent complete in the setPercentComplete field for each task. This value should not include the percent symbol (%).
Include a description and other details for each Task you are creating, as needed.
The setPlannedStartDate and setTaskConstraintcolumns are not used to build out the timeline of this project because we are relying on predecessor relationships. You can, of course, input whatever date for each task instead. If you do this, be sure you also provide a valid task constraint in the setTaskConstraint column. Reveiw the Task Constraintand related articles for details on valid values for this field.
In the case of this scenario, the easiest way to build out the tasks for the other projects you are importing is to copy the tasks you just defined and paste them below, starting on row 12. Then you will:
- Renumber the values in the ID column.
- Update the setProjectID column to the value you set for the next project.
- Update the setParentID and setPredecessorString values to reflect the new IDs assigned to this project's tasks.
- Update task assignments and percent complete.
- Repeat these steps for the next project's tasks.
Import the Excel File
Follow the directions provided in the Importing Kick Start Files section of this article.