Skip to content

Populating P3 Activity Codes

Mark ChapmanMember for 20 years 5 months
Created
9
1
0
Is it possibly to transfer these codes in from Excel?

9 replies

Oldest first
  1. 0
    Steven Oliver ·
    Yes, there is a sample file provided with the P3 cd
  2. 0
    Mark Chapman ·
    I am not sure here who has the CDs. Anyone able to send me a copy of this program/file. PP me and I will send email address.
  3. 0
    Steven Oliver ·
    Found a copy, let me have your e-mail and I’ll forward to you.
  4. 0
    Mark Chapman ·
    PM sent. Thanks
  5. 0
    Steven Oliver ·
    Incoming
  6. 0
    Mark Chapman ·
    I don’t think you’ve opened your maul yet. Go to PP home page and down the bottom are your Private Messages.
  7. 0
    Steven Oliver ·
    Did you get it to work ?
  8. 0
    Mark Chapman ·
    I’ve sent another PM - another reason for no email is the attachment. I presume it’s an executable in which case I will give you my personal email address.
  9. 0
    Bijaya Bajracharya ·
    I presume you have already made the code stucture in P3 but you want to assign them using spreadsheet. The process inloved are:

    Tools/Project Utilities/Export
    Add or modify one of the Export to include only Actity ID and actity codes in Lotus. The default output file is P3.wk1 but you can change the name in Format tab.

    Once exported, open you P3.wk1 using Excel.
    Make all the changes you need to make.
    But don’t make any changes in format or column widths etc. It must be saved in same format i.e. lotus wk1.

    When you have made all these changes, close P3.wk1. Import the P3.wk1 back to P3.

    you should have all the codes as in your spreadsheet now.

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?