Importing into P6 using Microsoft Excel
- Created
- 2
- 3
I have been using P6 a long time but only import actuals and changes using MS Excel occassionally. I have forgotten the "little things", - it is not importanting all of the data - what are the common mistakes? - Do I have to put a U somewhere or include some account code or something, possibly some things cannot be updated? I do not know what I am forgetting.
2 replies
Oldest first- 0Rodel Marasigan ·
Basic Importing Note P6 using
Basic Importing Note P6 using MS Excel
1) Any fields with * are calculated field and cannot be imported
2) There are 5 tables that can be updated using MS Excel such as:
a) Activity table (TASK)
b) Activity Relationships (TASKPRED)
c) Expenses (PROJCOST)
d) Resources (RSRC) - resource library
e) Resource Assignment (TASKRSRC)Default columns per subject area Activities Activity Relationships Expenses Resources Resource Assignments Activity ID Predecessor Activity ID Resource ID Activity ID Activity Status Successor Expense Item Resource Name Activity Status WBS Code Relationship Type Activity Status Resource Type Resource ID Activity Name Predecessor Activity Status Budgeted/Planned Cost Unit of Measure Role ID Start Successor Activity Status Actual Cost Role ID Cost Account ID Finish Predecessor Project Remaining Cost Default Units / Time Resource Type Resources Successor Project At Completion Cost Price / Unit Predecessor WBS Start Successor WBS Finish Predecessor Activity Name Successor Activity Name Lag Predecessor Primary Resource Successor Primary Resource Note:
Italic text indicates that the column is required for importing and exporting. The column cannot be removed from the export template and must exist in the import file to import successfully.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?