Imports to Activity Codes in P5

D
DANG CORP 👤 Member for 21 years 8 months

As to my previous post,



i do this alot too, and the place i am currently working,

managers changes there code assignment monthly too!



but not to worry, i ask them to do it in excel, and i import them directly, and easily.



so check this out David and friends,

it can create code fast and directly, instead of doing so many loops to get the code in.





http://www.dangcorp.com/toolbox.aspx



Vu Dang

D
David Kelly 👤 Member for 21 years 7 months

You must get the Dictionary.xls version you need from the Primavera Tech support site. This uses the SDK to update activity code dictionaries directly form Excel. Its not perfect - the SDK is a bit flaky - but it sure beats typing.

N
Niek Zonneveld 👤 Member for 21 years 3 months

Glenn,



You can do this through outline codes in MS Project (providing that you are not using 2007)



- create an outline field in MSP ("act-code", for instance)

- define a code mask for "act-code" in MSP and allow for new codes by default

- copy/paste from Excel (using a dummy task for each code)

- save the mpp, close MSP

- Import the mpp into P5/P6



H.T.H.



Niek.

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
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