P6 Importing Predecessors and Successors from Excel

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

Oracle Primavera - PM6
C
Cynthia Stiffler 👤 Member for 13 years 10 months
· Permalink

I cannot get predecessors or successors to import but the activities have all imported.  see above for same of import page.

C
Cynthia Stiffler 👤 Member for 13 years 10 months
· Permalink

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  

 

M
mohammad waseem anwar 👤 Member for 16 years 4 months
· Permalink

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   :    [email protected]

 

 

br

waseem

N
Nigel Winkley 👤 Member for 20 years 1 month
· Permalink

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

Forum Sponsor

Top Posters

Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
James Williams
74 posts
Haque Nawaz
10 posts