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 dont 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.
Member for
19 years 5 months
Member for19 years6 months
Submitted by Mark Chapman on Tue, 2007-03-20 06:29
Ive sent another PM - another reason for no email is the attachment. I presume its an executable in which case I will give you my personal email address.
Member for
23 years
Member for23 years
Submitted by Steven Oliver on Tue, 2007-03-20 06:18
Member for
20 years 8 monthsRE: Populating P3 Activity Codes
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 dont 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.
Member for
19 years 5 monthsRE: Populating P3 Activity Codes
Ive sent another PM - another reason for no email is the attachment. I presume its an executable in which case I will give you my personal email address.
Member for
23 yearsRE: Populating P3 Activity Codes
Did you get it to work ?
Member for
19 years 5 monthsRE: Populating P3 Activity Codes
I dont think youve opened your maul yet. Go to PP home page and down the bottom are your Private Messages.
Member for
23 yearsRE: Populating P3 Activity Codes
Incoming
Member for
19 years 5 monthsRE: Populating P3 Activity Codes
PM sent. Thanks
Member for
23 yearsRE: Populating P3 Activity Codes
Found a copy, let me have your e-mail and Ill forward to you.
Member for
19 years 5 monthsRE: Populating P3 Activity Codes
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.
Member for
23 yearsRE: Populating P3 Activity Codes
Yes, there is a sample file provided with the P3 cd