Imports to Activity Codes in P5
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
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
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.
Niek,
Thanks for that ill give it a go in the morning.
Glenn
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.