Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 Importing Predecessors and Successors from Excel

In the Open Standard
Cynthia StifflerMember for 14 years 3 months
Created
5
7
0

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

Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    Nigel Winkley ·
    #1

    CynthiaBest way to is export

    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

    Report
  2. 0
    Mohammad Waseem Anwar ·
    #2

    export as a relationship in

    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

    Report
  3. 0
    Mohammad Waseem Anwar ·
    #3

    sample file

    sample file link

     

    http://depositfiles.com/files/uld18qlsl

     

    manwer@pbad.sbg.com.sa

    Report
  4. 0
    Cynthia Stiffler ·
    #4

    I have tried this several

    I have tried this several times here is my import file, can you help with what I am missing?

    TASK Sheet

    task_codestatus_codewbs_idtask_typetask_nametarget_work_qtyactv_code_area_658_idactv_code_unit_658_idactv_code_responsibility_658_idresource_listpred_listsucc_listclndr_iddelete_record_flag
    Activity IDActivity StatusWBS Code(*)Activity TypeActivity Name(*)Budgeted Labor Units(h)AreaUnitResponsibility(*)Resources(*)Predecessors(*)SuccessorsCalendar NameDelete This Row
    W3-DTDE-1TBBS-1010Not StartedBL-G.23Task DependentINSTALL DTD PIPING (EMBEDDED) UNIT 1 ELEV. 516.5-520  [1-TB-BS-LIFT-2]46.71555556 U1ICSICI-PipefittersW3-C-1-TBBS-0201W3-C-1-TBBS-0207W3-5 Day - No Wthr 

     

    TASKPRED sheet

    pred_proj_idproj_idpred_task_idtask_idpred_typelag_hr_cntdelete_record_flag
    (*)Predecessor Project(*)Successor ProjectPredecessorSuccessorRelationship TypeLag(d)Delete This Row
    BL-GBL-GW3-C-1-TBBS-0201W3-C-1-TBBS-0207FS0 

     

    Report
  5. 0
    Cynthia Stiffler ·
    #5

    I cannot get predecessors or

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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?