Skip to content

Is there any way to Import Activity IDs Values?

Tricia Rennie-HoseineeMember for 15 years
Created
6
3
0

I have about 100 activity ID values to create for a New Activity ID. I would like to know if anyone has developed a way to import these values to an Activity ID or do I have to create each one?

I tried doing it via an import using Excel but that did not work.

6 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    yes setup the columns that

    yes 

    setup the columns that you want create 1 new activity in p6

    right click and select export to excel 

    use this a your template to populate new activities any column with and asterisks * in ti CAN NOT be imported

    populate the spreadsheet save file in excel 

    import into p6 

    done 

     

  2. 0
    Tricia Rennie-Hoseinee ·

    I did that and populated the

    I did that and populated the Excel with the new values hoping it would have imported the new values to the Activity ID in P6 but it gave an error for each one that it was not a valid Activity ID value.

  3. 0
    Zoltan Palffy ·

    look at the excel file the

    look at the excel file the activity ID CAN NOT BE a FORMULA also each activity ID begins with a ' this makes it text so if you export the activity A1000 and looked at the cell it would look like 'A1000. Or if it was activity 1000 it would really be '1000 when you look inside of the cell. Follow this format and do not use formulas or move anything around after your export the existing activity to excel as your template. 

  4. 0
    Emad Mofarej,PMP,PSP,CDT,CCM ·

    Zoltan Activity ID(task_code)

    Zoltan 

    Activity ID(task_code) cannot be updated directly by using the excel update function, as it is the unique identifier that P6 uses to recognize where to update everything else.

    Think about it! How P6 will be able to understand which activity updated?

    Of coarse there is a Task_ID identifier which is never imports or exports in a conventional excel options. You can use it and change Activity ID (task_code) if you know how to use SDK, API or even directly manipulate XER or XML file (XERparserbuilder) but these methods are not for the faint of heart. On top of that in lots of organizations you will not grant access to SDK, API or even able to import and export schedule XER files freely.

     

    But there is a very easy workaround. 

    1- Add a TEXT user defined field.

    2-Export excel with the userdefined field and other required fields.

    3- Enter your new activity ID's in the user defined field.

    4- Import excel file to P6.

    5- Run a global change to copy user defined field data to the Activity ID

    couple of points:

    1- make sure the activity ids are unique by using excel conditional formatting or remove duplicate function. 

    2- if you are rearranging Activity ID's you might receive the global change error. In that case i would suggest adding something at the begining of all of the activity ID's and after completing the Activity ID changes go back and use replace function to remove that part.

  5. 0
    Tricia Rennie-Hoseinee ·

    Oh thank you so much that

    Oh thank you so much that worked. I was able to bring in the multiple Activity Ids.

  6. 0
    Zoltan Palffy ·

    Tricia glad I could help Emad

    Tricia glad I could help 

    Emad you are wrong I do this all of the time I also have an excel spreadsheet that will aslo import the wbs assignment as well as the predecessor.

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?