User 1
| First Name | Chris |
|---|---|
| Last Name | Manning |
| Username/Email | mailto:cmanning@foo.com |
| Password | updateMe |
| Access | Team Member |
| Company | <Your Company> |
| Home Group | Marketing |
| Job Role | Business Analyst |
User 2
| First Name | Jennifer |
|---|---|
| Last Name | Campbell |
| Username/Email | jcampbell@foo.com |
| Password | updateMe |
| Access | Project Manager |
| Company | <Your Company> |
| Home Group | Marketing |
| Job Role | Project Manager |
User 3
| First Name | Jill |
|---|---|
| Last Name | Sullivan |
| Username/Email | jsullivan@foo.com |
| Password | updateMe |
| Access | Help Desk |
| Company | <Your Company> |
| Home Group | Sales |
| Job Role | Sales Rep |
User 4
| First Name | Marc |
|---|---|
| Last Name | Lewis |
| Username/Email | mlewis@foo.com |
| Password | updateMe |
| Access | Portfolio Manager |
| Company | <Your Company> |
| Home Group | Finance |
| Job Role | Controller |
User 5
| First Name | Pam |
|---|---|
| Last Name | Reynolds |
| Username/Email | preynolds@foo.com |
| Password | updateMe |
| Access | Project Manager |
| Company | Your Company> |
| Home Group | Marketing |
| Job Role | IT |
User 6
| First Name | Ray |
|---|---|
| Last Name | Andrews |
| Username/Email | randrews@foo.com |
| Password | updateMe |
| Access | Administrator |
| Company | Your Company> |
| Home Group | Resource Manager |
| Job Role | none |
Download a Kick-Start Template
-
Click the Main Menu icon
-
Click System > Kick-Starts > Import Data.
-
Click More Options to see the full list of import options.
-
Select the Access Level, Company, Group, Job Role, and User objects that you want to import.
Input company information
-
Open the Workfront.xlsx file you just downloaded.
TIPWhen working with very wide data sheets, you may want to use your spreadsheet editor’s Freeze Pane (or equivalent) tool to make the spreadsheet easier to work with. -
Go to the ‘CMPY Company’ sheet.
It should be empty unless companies are already in the system.
-
Specify TRUE into the isNew column.
-
Repeat this action for each company being added. (In this example, complete this action for rows 3-6, because four companies are being added.)
-
Specify a unique ID.
This must be done for each row for the ID column. Integers starting at 1 work well when creating new records.
-
Set a Name.
Specify the names of each customer in the setName column.
-
Go to the GROUP Group sheet.
Unless you have already created groups in Workfront, this sheet should display only the Default Group provisioned with every account of Workfront.
-
Set the isNew column.According to the scenario, 4 groups will be imported, so specify TRUE into rows 4 through 7 for the ‘isNew’ column.
-
Specify a unique ID.
This must be done for each row for the ID column. Integers starting at 1 work well when creating new records.
-
Set a Name.
Specify the names of each department in the setName column.
Specify role information. Go to the ROLE Role sheet.
-
Unless you have already created or deleted roles in your account, this sheet should display 8 roles that are provisioned with every account of Workfront.
-
Set True statement.
Seven Job Roles are importing, input TRUE into rows 12 through 18 for the ‘isNew’ column.
-
Specify a unique ID.
This must be done for each row for the ID column. Integers starting at 1 work well when creating new records.
-
Provide a names for each role by typing it in the setName column.
-
Provide additional details as needed.
Include billing rates, cost rates, and descriptions for the Roles you are creating, as needed.
-
Go to the USER User sheet to input User Information.
Unless you have already created users in your account, this sheet should display only the Admin User that is provisioned with every account of Workfront.
-
Set True value by specifying TRUE into rows 4 through 9 for the ‘isNew’ column, since 6 users are being imported.
-
Set a unique ID by specifying a unique ID in each row for the ID column. Typically integers starting at 1 work well for new records.
-
Input the names of each user into the ‘setFirstName’ and ‘setLastName’ columns.
-
Set detail values by specifying values into the ‘setEmail,’ ‘setPassword,’ and ‘setUsername’ columns.
-
Specify Access Level values.
For example, Chris Manning, who is a Team Member, look up the ID on the ACSLVL Access Level sheet for the Team Member access level. Copy the ID into your clipboard, and on the USER User sheet paste it in the setAccessLevelID column on Chris’ row.
Repeat this step for each user and access level.
-
Specify Home Group details.
According to the scenario, Chris Manning belongs to the Marketing group. On the GROUP Group sheet, locate the ID for the Marketing group, copy it into the clipboard, and on the USER User sheet paste it in the setHomeGroupID column on Chris’ row. Repeat this step for each user and group assignment.
-
Specify Company details.
All the users in this scenario belong to the same company. On the CMPY Company sheet, locate the ID for the *Your Own Company *company, copy the ID into the clipboard, and on the USER User tab, paste this value into each row of the ‘setCompanyID’ column.
Repeat this step for each user and group assignment.
-
Specify Job Role details.
According to the scenario, Chris Manning will have the Business Analyst role. On the ROLE Role sheet, locate the ID for the Business Analyst role, copy it into the clipboard, and on the USER User sheet paste it in the ‘setRoleID’ column on Chris’ row. Repeat this step for each user and group assignment.
-
Fill in other user details, as needed, then save the file.
-
Import the Excel File.
Follow the directions provided in Import data into Adobe Workfront using a Kick-Start template.
Workfront
