Adding 7000 new activity codes from excel to Primavera 5

V
vivek gaur 👤 Member for 14 years 1 month

As part of our Maintenance Plan we need to add a list of about 7000 new activity codes from an excel file to Primavera 5 SP6. Is there any other easier way apart from importing into Suretrak, P3 and then Primavera 5or copying and pasting individual codes from excel to Primavera 5. Does Primavera 5 have any functionality to batch import and add multiple new activity codes (in our case 7000). Any ideas and suggestions would be much appreciated.

V
vivek gaur 👤 Member for 14 years 1 month

Hi Raymund finally got around to getting Dictionary 50.xls. Can I use dictinary 50 for primavera 5 or do I need dictionary 60. Do you have any guide as to how to use this excel file. Seems to be very slow task to even add a single activity code. I basically did the following steps:

1. get activity code to select  project node I wanted

2. Inserted new activity code and

3. Then pressed set activity node. took ages and then crashed.

V
vivek gaur 👤 Member for 14 years 1 month

Hi Raymund finally got around to getting Dictionary 60.xls. Do you have any guide as to how to use this excel file. Seems to be very slow a single activity code. I basically did get activity code to select  project node I wanted and inserted new activity code and then pressed set activity node. took ages and then crashed.

R
Raymund de Laza 👤 Member for 16 years 6 months

Vivek,

Use the excel file to import through the SDK.

Search for the excel file Dictionary60

R
Raymund de Laza 👤 Member for 16 years 6 months

Hi,

Just asking if it's the Activity Code Dictionary or Activity Code Assignment?

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts