Schedule Data
      Back to home
      1. Turbo-Chart Help
      2. Schedule Data

      P6 Layouts and Spreadsheet Import

      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 Location Codes (if also being used)
      • Text UDF for Filter Code value (this field is not a required field, but can also be used)

      KB1.IMG01

      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

      KB3.IMG02-1

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

      4. Any Grouping and Sorting options may be applied

      KB3.IMG03

      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 Heading

      		 P6 Data Field Data Type
      Name Activity ID Text Values
      Description Activity Name Text Values
      ShapeCode P6 UDF for Shapes Text Values
      FilterCode P6 UDF for Filters Text Values
      LocationCode P6 UDF for Locations Text Values
      Start P6 UDF for Start Position Numeric Values
      End P6 UDF for End Position Numeric Values
      Start Date Start Date Format
      Finish Date Finish Date Format

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

      KB3.IMG05

      And then enter the New Title required for the column

      KB3.IMG06

      Apply to all the required Data Fields

      KB3.IMG04-1

      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