When importing an Primavera P6 XER file, P6 Professional could be very slow or hanged when it starts to import Risk Category like the picture below. Primavera P6 Import with Risk Category These Risk Category comes from a Primavera model or database that use Risk Analysis application. If we do not use this Risk Analysis... Continue Reading →
Primavera P6 export to Excel. How to color WBS level automatically
After export activity table from Primavera P6 to Excel, it’s very hard to distinguish WBS level. I will show you how to color WBS level automatically so we can have report like in P6. Step 1: Follow this article to insert the "WBS Level" column : https://doduykhuong.com/2018/04/01/primavera-p6-export-to-excel-how-to-identify-wbs-level-for-activity/ Step 2: Go to Conditional Formatting -> Manage Rules Create... Continue Reading →
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... Continue Reading →
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
Usually Microsoft Project saves file as MPP format. However, Primavera allows us to import Microsoft Project files in MPX format. So, here is the tool help you to convert MPP to MPX. Download from Google Drive: https://drive.google.com/file/d/0ByHnieTJNwKGdGVybE5LaElOcnM/view?usp=sharing&resourcekey=0-9JeuQrLavBI1ix781GGGRQ Download from Onedrive: https://1drv.ms/u/s!Air459YMTPJdkMEVJTjjyOf6L-1QCg?e=Xqusjj
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: You want to export only the summary data to excel. So we will tick the "Show Summaries Only" option. However, you only want to export summary data at the lowest level. Because... Continue Reading →
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: 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... Continue Reading →
You must be logged in to post a comment.