Skip to content

Activity Code Description values rather than Code Value in Exporting Data

Brian WalkinMember for 8 years 9 months
Created
4
4
0

I would like to have Activity Code Description values rather than Code Value when I export data to Excel. 

For Example for an Activity Code: 

Code Value is Ph1       :         Code Description is Phase 1

I would like to get the description Phase 1, rather than Ph 1. I have to do V-lookups from an external Activity Code table to get the descriptions I need. Is there a was to avoid this step by including it in the export.

 

Thanks

4 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    go to edit user preferences

    go to edit user preferences click on the Application lab

    then under the Codes section under Specify how to display code values

    select Description instead of Code Value

    now get it how you want it in the tabular area then copy and paste to excel

    you can also create a UDF which is user defined field and make it a text value and import these back into P6

    then you will have them 

  2. 0
    Rodel Marasigan ·

    The code Description values

    The code Description values option in User Preference --> Application tab is only available in P6 r20 up. Not available on lower version of P6.

  3. 0
    Brian Walkin ·

    I have V20 and was able to

    I have V20 and was able to change the option in user preferences to description. thanks

  4. 0
    Zoltan Palffy ·

    glad I could help you

    glad I could help you 

Log in or join to reply

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

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