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. Continue reading “Which Fields can be imported into Primavera P6 from Excel (XLS) Spreadsheet?”

Advertisements

Primavera SDK Excel File to import / export data

Even Oracle stop supporting the Excel File to import / export data, sometimes we still need to use it.

The latest version it can support is P6 version 8.3

You can download it here:

https://drive.google.com/open?id=0ByHnieTJNwKGRGpoMnJBS25HU28

Convert Microsoft Project MPP to MPX to import to Primavera

Nowadays, Microsoft Project save file as MPP format. However Primavera allow to import file as MPX format.

So, here is the tool help you to convert MPP to MPX.

https://drive.google.com/file/d/0ByHnieTJNwKGdGVybE5LaElOcnM/view?usp=sharing

Export data to Excel with “lowest level” summary data only

You create an Activity code to group data as you wish. After assigning and grouping activity by Activity code, here is the result:

1

You want to export only the summary data to excel. So we will tick the “Show Summaries Only” option.

2

3

However, you only want to export summary data at the lowest level. Because if you export all level, then in excel if you sum the value, it is a wrong number.

So, how can we show only summary data at the lowest level. The “high level” summary data should be zero.

Here is the solution.

Continue reading “Export data to Excel with “lowest level” summary data only”

Can not import Layout

Your colleague send you Primavera XER file and Layout file. After you import project successfully, you click on Layout -> Open -> Import -> Select the layout. And this error appear:

1

You may think “Wow, this layout file must be damaged. I need to tell him to send me again”.

Wait! It’s not because of the Layout file. It’s because of you’re in the wrong window. After import project maybe you’re still in Project window.

Continue reading “Can not import Layout”