Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Import activity data from excel

4 replies [Last post]
Saied Aliuzzama
User offline. Last seen 19 years 13 weeks ago. Offline
Joined: 28 Dec 2004
Posts: 3
Groups: None
Hi,
I have an ongoing project for expressway of about 900km.
i am getting error: "Activity Id field not defined" while importing the activity data from excel file, which is save in .wk1 format.


Any solution at earliest will be highly appreciated.

Best Regards,
Saied Aliuzzama

Replies

Philip Jonker
User offline. Last seen 15 years 17 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
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 ID’s.

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

Rajesh Moolakkandam
User offline. Last seen 7 years 43 weeks ago. Offline
Joined: 5 Jun 2004
Posts: 15
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.
Dayanidhi Dhandapany
User offline. Last seen 3 years 12 hours ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
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
Razi Khan
User offline. Last seen 7 years 27 weeks ago. Offline
Joined: 17 Jun 2004
Posts: 74
Groups: None
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.