Imports to Activity Codes in P5

Member for

21 years 1 month

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

Member for

21 years

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.

Member for

19 years 6 months

Niek,



Thanks for that i’ll give it a go in the morning.



Glenn

Member for

20 years 7 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.