This discussion is archived
4 Replies Latest reply: Jun 10, 2012 8:41 PM by 693136 RSS

Re-ordering Activty Codes in P3

917992 Newbie
Currently Being Moderated
I usually use P6 for general scheduling. But a client has asked us to export to P3. When I do, the ordering of activity codes is incorrect for them to import into their system.

Is there a way to re-order the activity codes in P3, or in P6 prior to export so they show up in the correct order?
  • 1. Re: Re-ordering Activty Codes in P3
    cruz878 Journeyer
    Currently Being Moderated
    See : "What information will convert from Product Management to P3? [ID 892486.1]"

    Excerpt from the above:

    P3 only supports 10 characters for the activity codes, the converter will f irst truncate the first 10 characters from the Product Management activity codes being converted.
    It will then take the maximum amount of activity codes that can be converted equaling 64 characters total.
  • 2. Re: Re-ordering Activty Codes in P3
    917992 Newbie
    Currently Being Moderated
    This doesn't have anything to do with re-ordering of activity codes.

    I created my codes with the proper amount of characters and lengths in P6, when converting to P3, the codes and their respective character lengths held, they just got jumbled up.
    IE: in P6 I have:
    Act Code Char Length
    WRKP 3
    RESP 4
    AREA 4
    MODF 6
    BIDI 6
    PHAS 2
    CATW 1
    FOW1 10
    FOW 2 10
    FOW3 10



    in P3 it becomes:
    Bidi 6
    Wrkp 3
    Resp 4
    Area 4
    Modf 6
    Phas 2
    Catw 1
    FOW1 10
    FOW2 10
    FOW3 10
    WBS

    I need the P3 file to maintain the same order of Activity Codes I have in P6. WRKP must be first, followed by RESP, etc.
  • 3. Re: Re-ordering Activty Codes in P3
    cruz878 Journeyer
    Currently Being Moderated
    hmmm... not sure what is causing this. It could be ordering by the primary key on the P6 table.

    Assumming you have access to the P6 database try taking a look at the ACTVTYPE table and check if the P3 order matches the sequential order of ACTVTYPE.ACTV_CODE_TYPE_ID.

    Without knowing the detail of your data structure it's hard for me to write an exact SQL query to extract this data but you can try the below:

    SELECT actv_code_type_id, actv_code_type
    FROM actvtype
    WHERE actv_code_type IN ('WRKP','RESP','AREA','MODF','BIDI','PHAS','CATW','FOW1','FOW2','FOW3');
  • 4. Re: Re-ordering Activty Codes in P3
    693136 Newbie
    Currently Being Moderated
    And you will lose the order of the data within each Activity Code too. P6 assignes a hidden number acording to the order that the Activity Codes are shown in the list (which you can change with the arrows), and does not export them to P3.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points