Primvera P6 Product Code

Aug 31, 2013 - But it can export a P3 or MPX file which P6 can import without a problem. I just installed Primavera Project Management, and Methodology. How-to-Install-the-P6-Standalone - Download as PDF File (.pdf), Text File (.txt) or read online. Also, even though you are running Primavera as a stand-alone product, a network interface card or modem. On the Product Code dialog box.

In this post, I will show you how to import Activity Code values from Excel into Oracle Primavera P6 without having to type them in or resort to programming in Java. It is a fairly common request and is nearly always met by someone offering their Java code or suggesting the use of the ODBC flavor of the Primavera SDK. Both can be difficult and time-consuming to do and involves having to install either the Primavera SDK or installing the Primavera Java API. Here I will show you how to import Activity Code values using nothing but Excel and some simple formulas. I will be loading a list of UK Train Stations which have a 3 letter code and their name.

The full list can be found on the. The technique shown here is accomplished by amending an XER file and importing the result into Primavera P6.

The general steps are: 1. Create an empty Project in Primavera P6, add and assign an activity code, then export into an XER file 2. Open the XER file in Microsoft Excel 3. Insert the rows to define the Activity Code and Activity Code Values 4. Save the Microsoft Excel worksheet as an XER file 5. Import the XER file into Primavera P6 This whole routine can usually be done in a few minutes. Creating The XER File An XER file is required to provide a place to add data about the Activity Code.

• Start the Hatch command by typing H and pressing Enter or by clicking the Hatch button in the Draw panel of the Home tab on the Ribbon. Ignore it for now. Free autocad hatch patterns. The Hatch Creation contextual tab on the Ribbon appears.

One day I will write a little more about the XER file. For this post, it is just a text file where values are separated by a tab character. This means it easy to open in Excel where changes can be made to it before saving again. A Single Activity Code Value Needs Assigning The first step is to create a brand new project in Oracle Primavera P6 and add an Activity into it. The Activity needs an Activity Code assigned to it, so create a Project Level Activity Code with one Activity Code Value and assign it to the Activity. Export the project to an XER file. This is done to avoid changing any configuration other users rely on and it also provides the correct set of columns no matter which version of Oracle Primavera P6 is being used.

Earlier versions do not have the color value used by the Visualizer. Open The XER File In Excel And Add Activity Code Values The XER file is just a tab-delimited text file that can be opened and edited using Microsoft Excel but the file extension has to be changed from.xer to.txt for this to happen. Change the extension from.xer to.txt, then start up Microsoft Excel and open the XER file posing as a.txt file. The Microsoft Excel Text Import Wizard is displayed. Verify the Delimited file type is selected and My data has headers is not checked. Click the Next > button to move to page 2. Verify Tab is the only Delimiter selected and click the Finish button to import the XER file into Excel.

It will look something like this. XER File As It Appears In Microsoft Excel A Little XER Diversion The value in column A indicates what can be found in the row. The first row is the header row and so it has ERMHDR in column A. The last row, which is not shown on the screenshot, contains%E indicating it is the end row.

There are three other rows: •%T is a Table Header and contains the name of the table in Column B. There is one for each table. •%F is a Field row and contains the list of table field names in subsequent columns.

There is one for each table and it comes immediately after the%T row. •%R is a Record row and contains the data for the record. There is one for each record and the first one comes after the%F row and all the others follow it one by one.

Creating The Activity Code Record The Activity Code record is held in a table called ACTVTYPE and so you need to find the%T record for this table and then we need to update the%R record to create the Activity Code we want to import our batch of values for. The%T record is on row 34 in the screenshot and the%R row is in row 36. Let’s assume we are creating a global Activity Code representing each train station in the UK. This is going to be a flat list for now where the Code Value contains the short code for the train station and the Description holds as much as the full name as P6 allows. The list of fields in my v16.1 of Oracle Primavera P6 are: • actv_code_type_id – the unique internal identifier for the ACTVTYPE table.

• actv_short_len – the maximum length of the Activity Code value. • seq_num – determines where it appears in the list of Activity Codes when displayed in P6.

• actv_code_type – the name of our code. • proj_id – the internal project id which is used for Project and EPS Activity Codes, but not Global Activity Codes. • wbs_id – the internal WBS id only used for EPS Activity Codes. • actv_code_type_scope – contains AS_Global, AS_EPS or AS_Project and indicates whether this is a Global, EPS or Project code respectively. The value in actv_code_type_id shouldn’t matter for the creation of the Global Activity Code, but I always set it to 1.