Kick-Starts scenario: simple project and task import preparation
Describes in detail the available settings and controls for a basic Project and Task Import using the Kick Start method.
Scenario
The implementation team would rather import project and task information for active projects as opposed to manually inputting this data into the system.
Projects projects
The following table displays four Projects and their basic details that need to be mapped into the Kick Start file formats.
This scenario assumes users are already imported into Adobe Workfront. If users are not already in Workfront, subsitute different names or complete the Kick Start Scenario with users prior to this scenario.
-
Implement Workfront.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto Planned Start Date Today Project Manager Jennifer Campbell Project Sponsor Marc Lewis Group Marketing Company YourCompany -
Implement HR System.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto Planned Start Date July 14, 20XX Project Manager Pam Reynolds Project Sponsor Marc Lewis Group Marketing Company YourCompany -
Implement Document Management System.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto Planned Start Date August 22, 20XX Project Manager Jennifer Campbell Project Sponsor Ray Andrews Group IT Company YourCompany -
Implement New Calendar System.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto Planned Start Date September 6, 20XX Project Manager Pam Reynolds Project Sponsor Ray Andrews Group IT Company YourCompany
Task list task-list
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.
Parent tasks inherit the Duration, Work, and Percent Complete of children tasks. It is not necessary to set those values for that will become summary tasks.
-
Configure.
-
Import users.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto html-authored no-header Assigned to Ray Andrews Parent task 1 Duration 1 hour Work 1 hour Percent complete Workfront: 0%
HR: 100%
Docs: 100%
Calendar: 100%
-
Set permissions.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 layout-auto html-authored no-header Assigned to Ray Andrews Parent task 1 Pred 2 Duration 1 hour Work 1 hour Percent complete Workfront: 0%
HR: 100%
Docs: 100%
Calendar: 100%
-
Build groups.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 layout-auto html-authored no-header Assigned to Ray Andrews Parent task 1 Pred 4 Duration 2 days Work 4 hours Percent complete Workfront: 0%
HR: 100%
Docs: 100%
Calendar: 25%
-
Prepare training.
table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header Assigned to Chris Manning Duration 2 days Work 4 hours Percent complete Workfront: 0%
HR: 100%
Docs: 50%
Calendar: 100%
-
Build ongoing support policies.
table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header Assigned to Chris Manning Duration 2 days Work 4 hours Percent complete Workfront: 0%
HR: 100%
Docs: 50%
Calendar: 0%
-
Roll out.
table 0-row-2 layout-auto Pred 1, 6, 7 -
Train users.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto html-authored no-header Assigned to Chris Manning Parent task 8 Duration 1 day Work 2 hours Percent complete Workfront: 0%
HR: 0%
Docs: 0%
Calendar: 0%
Download Template
Go 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.
Set the values for the following project fields:
-
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 project schedule
Input the ID of the schedule that you want the project to use in the setScheduleID field
-
Set the project Planned Start Date
Input the date and the time in the setPlannedStartDate column with the time and the date when you want the project to start. If left empty, Workfront imports the project with the current day’s date and a timestamp of that day’s midnight according to the browser’s timezone.
-
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.
Input Task Details
You can add information about the tasks on the project, as you import the project using kick-starts.
Open the Workfront.xlsx file you just downloaded. 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.
Set the values for the following task fields:
-
Set IDs
Input a unique ID in each row for the ID column. -
Set Names
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. -
Set Users
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 Duration
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.table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 Acceptable value Minutes M Hours H Days D Weeks W Months T 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.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 Duration Type Acceptable Value Calculated Assignment A Calculated Work W Effort Driven D Simple S -
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 setTaskConstraint columns are not used to build out the timeline of this project because we are relying on predecessor relationships. You can input a date for each task instead. If you do this, be sure you also provide a valid task constraint in the setTaskConstraint column. Review 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 Import data into Adobe Workfront using a Kick-Start template.