Tips on using this forum..

(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.

Is there any way to Import Activity IDs Values?

6 replies [Last post]
Tricia Rennie-Hos...
User offline. Last seen 3 years 2 weeks ago. Offline
Joined: 12 Oct 2011
Posts: 5
Groups: None

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.

Replies

Zoltan Palffy
User offline. Last seen 10 hours 25 min ago. Offline
Joined: 13 Jul 2009
Posts: 2743
Groups: None

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.

Tricia Rennie-Hos...
User offline. Last seen 3 years 2 weeks ago. Offline
Joined: 12 Oct 2011
Posts: 5
Groups: None

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

Emad Mofarej,PMP,...
User offline. Last seen 1 year 51 weeks ago. Offline
Joined: 18 Feb 2012
Posts: 39
Groups: None

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.

Zoltan Palffy
User offline. Last seen 10 hours 25 min ago. Offline
Joined: 13 Jul 2009
Posts: 2743
Groups: None

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. 

Tricia Rennie-Hos...
User offline. Last seen 3 years 2 weeks ago. Offline
Joined: 12 Oct 2011
Posts: 5
Groups: None

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.

Zoltan Palffy
User offline. Last seen 10 hours 25 min ago. Offline
Joined: 13 Jul 2009
Posts: 2743
Groups: None

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