Importing schedule activities

Schedule activities can be imported from Primavera P6 using the built-in integration or imported from a CSV file if you use another tool.

You can import Schedule Activities from Primavera P6 using the built-in integration or imported from a CSV file if you are using another tool. If you are using P6, see Primavera P6 Integration. You can link Schedule Activities to the control accounts on the Cost Worksheet to provide information for time phased data calculations. See also Incorporating schedule Information in Cost.

Tip!

A Schedule Activity can be linked to multiple control accounts. To do this when importing, repeat the Schedule Activity row for each control account it will be linked to.

Importing schedule activities

  1. Go to Schedule Activities in Cost.
  2. Click the Import button in the toolbar and select Import from CSV.
  3. Click Download Template.
  4. Complete the template and save it.
  5. Click Browse to find your CSV file.
  6. Select Delete all existing records and replace, if you want to use this data to replace any existing data.
  7. Click Import.

Example Import file

Control
Account
Code
NameCodeActivity
Weight
Use
Activity
Dates
Baseline
Early
Start
Baseline
Early
Finish
Current
Percent
Complete
Percent
Complete
Method (Days)
[control
Account
Code]
[name][code][weighting][useDatesFor
Control
Account]
[schedule.
baseline
EarlyStart]
[schedule.
baseline
EarlyFinish]
[current
Percent
Complete]
[percent
Complete
Method]
A-001Sub Area 1 - Clear & GrubSA001-011Y2018-03-152018-04-150MAN
A-001Sub Area 1 - CompactSA001-021Y2018-03-252018-04-200MAN
A-001Sub Area 1 - Concrete PourSA001-031Y2018-04-222018-05-300MAN
A-002Sub Area 2 - Misc EarthworksSA002-011Y2018-03-202018-06-300MAN
A-003Sub Area 3 - Misc EarthworksSA003-011Y2018-04-012018-05-300MAN
A-003Sub Area 3 - ConcreteSA003-021Y2018-05-012018-06-100MAN
A-001Site Wide Civil WorksSA000-011Y2018-03-012018-04-300MAN
A-002Site Wide Civil WorksSA000-011Y2018-03-012018-04-300MAN
A-003Site Wide Civil WorksSA000-011Y2018-03-012018-04-300MAN

Tip!

The sample import shown here links SA-000-01 Site Wide Civil Works to three control accounts on the Cost Worksheet. Ensure the dates are the same on each of the rows, and that they are formatted correctly using the YYYY-MM-DD format.