pasobdigital.blogg.se

1. Primavera p3 sdef problem opening calendar file run stopped manual#
2. Primavera p3 sdef problem opening calendar file run stopped code#

Primavera p3 sdef problem opening calendar file run stopped code#

The Project Code definitions are stored in a Table called PCATTYPE. Now let’s see how P6 stores the data in the database with the help of Excel. You then define values for your new Project Code. Let’s say you define a new Project Code in P6. We will use a simple example to show how Data you input into P6 client are stored in the database. NB: Generated by PL/SQL Developer (using a demo version) 1.2) An Example – Where Data is Written in the P6 DB For example, resource spread data are not stored in the database at all.įor illustration only, here an example of a P6 database diagrams (showing only some tables) that illustrates the many interconnections. In reality there are only around 20 most used tables that you need really to be familiar with.Ĭalculated Fields are not stored in Primavera’s Database as they are calculated on the fly based on other stored fields. The tables are referenced to each other by relations between Primary key and foreign Key,įor a description of all the tables check this Primavera documentation, unzip the file, then read the file called PMSchema.html.įortunately, you don’t need to understand the relations between all 170 tables (whew!). Primavera P6 stores data in a more then 170 tables, every tables contains fields, and every field stores records.

1) A Quick Understanding of Primavera’s P6 Data Structure 1.1) How is Data stored in the P6 PMDB Database? That’s why in this P6 tutorial we will show a general overview of P6’s data structure, and basic concepts in P6’s database management ( tables, fields, primary key).

Primavera p3 sdef problem opening calendar file run stopped manual#

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.

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.