(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
I have imported activities from an excel spreadsheet. Can you also import Predecessors and Successors? I tried in the file but they did not import with the activities.
Thanks
Printer-friendly version
Send to friend
Hi Cynthia,
There are a couple of things to be aware of when working in and out of excel.
1/ Choose the right worksheet for the field you want to amend and import.
The (*) symbol in the header defines what fields you can't import/ export in that specific worksheet.
I.e. you can't import budget hours from the Task Sheet but you can from the Resource Assignment sheet.
2/ Ensure your import setting are correct i.e you're ticking the boxes for the worksheets you've changed and wish to update when importing.
In your case I'll be importing the predecessors and successors from the 'taskpred' worksheet and ensuring this box is ticked in the import dialogue box.
Hope that helps.
Regards,
Chris Hall
I cannot get predecessors or successors to import but the activities have all imported. see above for same of import page.
I have tried this several times here is my import file, can you help with what I am missing?
TASK Sheet
| task_code | status_code | wbs_id | task_type | task_name | target_work_qty | actv_code_area_658_id | actv_code_unit_658_id | actv_code_responsibility_658_id | resource_list | pred_list | succ_list | clndr_id | delete_record_flag |
| Activity ID | Activity Status | WBS Code | (*)Activity Type | Activity Name | (*)Budgeted Labor Units(h) | Area | Unit | Responsibility | (*)Resources | (*)Predecessors | (*)Successors | Calendar Name | Delete This Row |
| W3-DTDE-1TBBS-1010 | Not Started | BL-G.23 | Task Dependent | INSTALL DTD PIPING (EMBEDDED) UNIT 1 ELEV. 516.5-520 [1-TB-BS-LIFT-2] | 46.71555556 | U1 | ICS | ICI-Pipefitters | W3-C-1-TBBS-0201 | W3-C-1-TBBS-0207 | W3-5 Day - No Wthr |
TASKPRED sheet
| pred_proj_id | proj_id | pred_task_id | task_id | pred_type | lag_hr_cnt | delete_record_flag |
| (*)Predecessor Project | (*)Successor Project | Predecessor | Successor | Relationship Type | Lag(d) | Delete This Row |
| BL-G | BL-G | W3-C-1-TBBS-0201 | W3-C-1-TBBS-0207 | FS | 0 |
export as a relationship in excel and in pred column add pred activity id and in sucessor column add succesor activity id of your logic than import.u can change the realationshipa and adjust the leg according to your requirment and than import back.
my email : manwer@pbad.sbg.com.sa
br
waseem
Cynthia
Best way to is export from P6 using a dummy project with a few linked activities in it. This then gives you a template to use for the import. Just delete the original activities and paste in yours in the right columns of course.
Used this method several times, thanks to engineers working in Excel. As long as you put your info in the right columns it works well
Hope this helps
Cheers
Nige
Email: PPadmin@planningplanet.com
Replies