The the way to import from excel is by using the database file format ( ie .DBF).
To do this is simple, first export some dummy activities from P3 to a .DBF file (this facility exists in P3). Go to Toolsproject utilitiesExport, and set up the format (ie fields/columns) you want to export to. Remember you must always include the activity id. Further, the file name for a .dbf file should never exceed 8 characters, and these should preferably be alpha or numeric characters.
You can then open this file either in Excel or Access. Excel is the better option. You can the erase the dummy activities and keep the headings as a template. If you are creating an activity file the fields you need to export is Activity ID; Activity Description; original duration; Calendar; activity codes.
Once you have the template add the activities that you want to add with their codes, durations etc. When you are ready to save, in Excel, open a new file, and copy paste your file into the new file. Save this file as a .dbf, remembering the rule about 8 characters. Once this is done import the file into P3. Another rule is make sure you do not duplicate activity IDs.
The reason for using the .dbf formats, is that P3, Excel and access have less problems as this is a standard format used by all three these programs, and hence there are less pitfalls.
Hope this helps,
Regards,
Philip J
Member for
21 years 5 months
Member for21 years5 months
Submitted by Rajesh Moolakkandam on Wed, 2004-12-29 05:41
Never create a wk file of your own.The best way is as Mr Razi Khan suggested-export your project to wk format. But remember to select all data fields from the current/base layout as required.
Member for
22 years 7 months
Member for22 years7 months
Submitted by Dayanidhi Dhandapany on Tue, 2004-12-28 09:39
you have to check your range before you import activity data from excel(i.e exporting of data to p3). if the range is not selected properly, redefine the range, then exporting the data to p3 will not be a problem.
Member for
21 yearsRE: Import activity data from excel
Hi Saied,
The the way to import from excel is by using the database file format ( ie .DBF).
To do this is simple, first export some dummy activities from P3 to a .DBF file (this facility exists in P3). Go to Toolsproject utilitiesExport, and set up the format (ie fields/columns) you want to export to. Remember you must always include the activity id. Further, the file name for a .dbf file should never exceed 8 characters, and these should preferably be alpha or numeric characters.
You can then open this file either in Excel or Access. Excel is the better option. You can the erase the dummy activities and keep the headings as a template. If you are creating an activity file the fields you need to export is Activity ID; Activity Description; original duration; Calendar; activity codes.
Once you have the template add the activities that you want to add with their codes, durations etc. When you are ready to save, in Excel, open a new file, and copy paste your file into the new file. Save this file as a .dbf, remembering the rule about 8 characters. Once this is done import the file into P3. Another rule is make sure you do not duplicate activity IDs.
The reason for using the .dbf formats, is that P3, Excel and access have less problems as this is a standard format used by all three these programs, and hence there are less pitfalls.
Hope this helps,
Regards,
Philip J
Member for
21 years 5 monthsRE: Import activity data from excel
Never create a wk file of your own.The best way is as Mr Razi Khan suggested-export your project to wk format. But remember to select all data fields from the current/base layout as required.
Member for
22 years 7 monthsRE: Import activity data from excel
Hello Saied,
you have to check your range before you import activity data from excel(i.e exporting of data to p3). if the range is not selected properly, redefine the range, then exporting the data to p3 will not be a problem.
Cheers!!!
Daya
Member for
21 years 4 monthsRE: Import activity data from excel
Hello Saied
First export the fields into a file of WK1 format. Then fill the same file with datas. Then Import from the same file.
Hope it will solve your problem.