How to clean a Primavera P6 XER file using the XER File Parser
| | | |

How to clean a Primavera P6 XER file using the XER File Parser

In the third part of our Primavera P6 databases and data cleansing series, we will show how to use the parser to clean an xer file In the third part of our Primavera P6 databases and data cleansing series, we will show how to use the parser to clean an xer file.  But if you haven’t read…

How to Print a Calendar from Primavera P6, with some help
| |

How to Print a Calendar from Primavera P6, with some help

In this quick tutorial we show how to create a 12-month formatted calendar in Excel based on the data extracted from an xer file using the handy Xer-Reader utility. Hopefully I will soon provide a more technical explanation on how the code works in the xer reader wiki. Michael has written excellent article about calendars and…

Create a P6 Project Dashboard in Excel
| | | |

Create a P6 Project Dashboard in Excel

Tutorial Files Excel Spreadsheet (Excel 2007+): PTuts_Project_Dashboard.xlsm – 1.5Mb One of our previous site manager told us (the project control team), that if we bring to him another report that have more than 1 page, he will just throw it away (sic), actually managers care only about the big picture, and don’t bother reviewing every…

How To Link A P6 Schedule To The BOQ With Different Levels Of Detail
| | |

How To Link A P6 Schedule To The BOQ With Different Levels Of Detail

Tutorial Files Excel Spreadsheet (Excel 2007+): PlannerTuts_BOQ_Pay_Item.xlsx P6 Schedule and BOQ challenges A contract’s Bill of Quantities is always meant to be more details than the schedule, at least in theory. In many cases,  the planner and the estimator are not working in perfect coordination and you may end with two different level of details…

Using Primavera’s .Xer File Parser – Import WBS From Excel Without The SDK
| | |

Using Primavera’s .Xer File Parser – Import WBS From Excel Without The SDK

In this tutorial we explain how to import a WBS dictionary in Primavera P6 without the SDK.   NOTE: The steps needed to transform a classical WBS presentation (which is WBS Path and Description) to a format understood by the database (which is parent / child) is covered in Steps 1 to 6 of this…

How To Import WBS From Excel To Primavera P6 Using The SDK
| | |

How To Import WBS From Excel To Primavera P6 Using The SDK

In this tutorial we explain how to use the Oracle Primavera P6 SDK to import a WBS from Excel to Primavera P6. We are using the WBS.xls P6 SDK spreadsheet made available by Oracle Support. The SDK is a very handy tool, but the data must exactly respect the required format, we used a sample…

Convert WBS to Activity Codes in Oracle Primavera P6
| |

Convert WBS to Activity Codes in Oracle Primavera P6

The idea of this tutorial was inspired by a question in LinkedIn forum, a planner have received a primavera schedule using WBS, as in the oil and gas industry it is very useful to have different layouts to present the schedule to different audience, and more importantly the Work breakdown structure is based on geographic area in the construction phase, and systems in the commissioning phase, the tutorial will use the APEX sample schedule to convert a WBS to activities codes, it is assumed you
have already worked with the Primavera P6 SDK.