The most important columns are wbs_id, wbs_short_name, wbs_name and parent_wbs_id. The table for the WBS dictionary is called PROJWBS.
Click on Load XER file, select TEXT.xer file then click OK. Open the Excel XER File Parser spreadsheet. Step 2 – Open the Xer file using the Excel Parser Utility. xer file with minimal data.įor the purposes of this tutorial, the name of the schedule is Test, and the WBS code, is Sample Oil, Gas WBS. Import to a test database first.Ĭreate a blank dummy schedule in P6 – don’t add any WBS or activities. xer file directly to a production database, it’s too easy to contaminate P6 global data objects. xer file, first import it as a separate project, and check if everything is ok, then you can update your program. Never directly update a program from a modified. xer file, and make sure to always build a new. It can be very useful to understand how the P6 database is organized (WBS, Activity Codes, Resources, etc.)Īlso, here are some best practices on working with the XER File Parser utility:Īlways work on a copy of the. The description of the tables of Primavera P6 r8.2 database tables are available here.
There are a lot of courses available on database structures. Understand the type of relationships between tables in the database Understand what a Foreign Key is used for Understand what a Primary Key is used for Primavera P6 has a well defined database at its core, but you don’t need to be an IT graduate to understand how it works.
It is definitely one of the most powerful utilities for Primavera P6, either standalone or enterprise, and it is much safer to use than the SDK, as you don’t write directly to the Primavera database – unlike the SDK.Ĭomplete this tutorial by downloading the following files: xer file, and gives the user the ability to modify some information and to build a new. Essentially, the File Parser is an excel file that can read the data contained in a. To load the WBS data into Primavera P6, instead of using the SDK we will use the XER File Parser utility provided by Oracle. 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 tutorial. In this tutorial we explain how to import a WBS dictionary in Primavera P6 without the SDK.
0 kommentar(er)
