In this second part of Primavera P6 databases and data cleansing series, we will discuss the data structure of an XER file, and how the XER File Parser & Builder works. As the XER File Parser is a manual process (it does not honour P6 business rules), it is handy for the user to have a working knowledge of the P6 database. That’s why in this P6 tutorial we will show a general overview of P6's
Oracle Primavera P6 Database : Articles and Tutorials
Read these important articles related to understanding the Oracle Primavera P6 database (pmdb).
6 Ways To Clean Up Your Primavera P6 Database Nightmare18 Comments
This is the first part in our series on Primavera P6 databases and data cleansing. Many of you work in Primavera P6 databases that are a complete nightmare - hundreds of global calendars, duplicate resources all over the place, redundant codes and more copies of projects than anyone should ever need in their lifetime. You may act like these don't bother you, but somehow logging in to P6 in the
How to Clean Your P6 POBS Table On MSSQL & Oracle DB19 Comments
In my last post I went deep on how to quickly clean POBS data from a Primavera P6 XER file using a simple text editor. And we discovered that removing POBS data from an XER file greatly improved the import time for large XER files. A big thanks to readers who left comments on that post letting me and you know that there are some 3rd party tools (free and paid) that handle this in a more automated