Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet?

When we look at Excel file exported from Primavera P6, there are some columns have an asterisk (*). What does it mean?

I will explain in this article.

All the columns which have the asterisk mean they can not be imported into P6, i.e. we can not change their value and import into P6. There is a reason for this, for example the field may be a calculated field, or may be data rolled up from elsewhere.

For example, in the software some data about Resource Assignments is made visible at the activity level; Budgeted Labor Units is available to show as a column in the Activity View and can be exported to Excel at the Activity Level.  However the data in this column is actually a ‘rolled up’ total of the Budgeted Units for each of the Resource Assignments on that activity which have a Resource Type of Labor.

Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet-2

So when you adjust Total Budget Labor Units and Import back to P6, it does not know how to distribute unit to 3 resource assignment.

Below is all the available fields that can be imported into P6. They are grouped by data type in several sheet:

Download : p6-importable_fields

The last worksheet in the document (Default Columns) also highlights which fields are mandatory for import/export.

When doing import you need to ensure that the data in the Excel spreadsheet is in the correct format for P6 to understand. To achieve this we recommend that you first export from P6 to Excel so that you have a spreadsheet with the correct format.

If you cannot import a field that is listed as importable, make sure the field has a leading apostrophe (‘)

When using the import function to update or replace an existing project, you must have the ‘<Project Superuser>’ project Security Profile for the project, or be an ‘Admin Superuser’.

 

Advertisements

Author: Khuong Do

Khuong Do is a Project Planner in Civil, Transportation and Oil & Gas Industry. He has worked as a Primavera Consultant Specialist since 2006 . He holds a Civil Engineering degree and a Bachelor of Information Management System. Now he is working in Petronas RAPID project, one of the biggest Refinery and Petrochemical complex, in Pengerang – Malaysia.

3 thoughts on “Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet?”

  1. i thought of a solution to import IDs for example.
    how about importing it to a user defined field then use global change to copy it to IDs ? will that work?

    Like

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s