Skip to content
ProjectControls.com
Oracle Primavera - PM6

Imports to Activity Codes in P5

In the Open Standard
Glenn DouglasMember for 20 years 5 months
Created
4
3
0
Hi all,

Is it possible to import a list of codes from say ’Excel’ straight to the Activity Codes?
Or do I have to manually input them?
(there are hundreds & I’d like an easy option if there is one).

Cheers
Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Niek Zonneveld ·
    #1
    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.
    Report
  2. 0
    Glenn Douglas ·
    #2
    Niek,

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

    Glenn
    Report
  3. 0
    David Kelly ·
    #3
    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.
    Report
  4. 0
    Dang Corp ·
    #4
    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
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?