Steps for P6 users to prepare layouts for
working with Turbo Chart data and for Importing via Spreadsheet to Turbo Chart


Turbo Chart Data Fields

This article assumes the following User Defined Fields have been created within P6 for Turbo Chart Data

  • Numeric UDF for location start value
  • Numeric UDF for location end value
  • Text UDF for Shape Code values
  • Text UDF for Filter Code value (this field is not a required field, but can also be used)


Creating a Working Layout

To create a general purpose layout, assign the above UDF fields as additional columns in any layout.

  1. In P6 Activity View, Select VIEW > COLUMNS from the menu, or right-click on the column headers and select COLUMNS
  2. Select all the UDF fields required, and press the right Arrow to include the columns in the layout

3. The columns are now available for data entry or modification.

4. Any Grouping and Sorting options may be applied

A sample P6 Layout file LPS_WBS ACTIVITY VIEW.plf is provided in the sample data (HELP > DOWNLOAD SAMPLES within Turbo Chart). Note that the layout may not display the UDF fields as each P6 database has unique ID’s that may not display with the provided layout file.

Spreadsheet Data Import

A layout that provides data that can be imported via spreadsheet import requires the following data fields. Note that column headings must be modified to match those required by Turbo Chart:

Column HeadingP6 Data FieldData Type
NameActivity IDText Values
DescriptionActivity NameText Values
ShapeCodeP6 UDF for ShapesText Values
FilterCodeP6 UDF for FiltersText Values
StartP6 UDF for Start PositionNumeric Values
EndP6 UDF for End PositionNumeric Values
Start DateStartDate Format
Finish DateFinishDate Format
   

To modify column headings in P6, select the field to modify, then select EDIT COLUMN

And then enter the New Title required for the column

Apply to all the required Data Fields

A sample P6 Layout file LPS_SPREADSHEET IMPORT VIEW.plf is provided in the sample data (HELP > DOWNLOAD SAMPLES within turbo Chart). Note that the layout may not display the UDF fields as each P6 database has unique ID’s that may not display with the provided layout file.

A Sample Spreadsheet import file (Macro-enabled XLS file) is also provided in the sample data to display the required import columns and headings.

Once the required headers are provided, data from P6 can be copied and pasted into Turbo-Chart, through the DATA>TASKS “Paste from Clipboard” function.

Further Help

All queries relating to Turbo Chart or the sample data can be addressed via email to support@linearprojectsoftware.com

Recommended Posts