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.

IMPORTING EXCEL FILES INTO P3

3 replies [Last post]
Thu, 2005-10-06 10:27
Sriram Iyer
User offline. Last seen 5 years 44 weeks ago. Offline
Joined: 4 Nov 2003
Posts: 15
Groups: Petro-Chem / Oil & Gas
Helllo,
Can u suggest me to Import the Excel data file in to P3.

Top

Replies

Thu, 2005-10-06 22:33
#1
Simon Mawdsley
User offline. Last seen 10 years 3 weeks ago. Offline
Joined: 22 Mar 2004
Posts: 11
Groups: None
A tip is to export a simple project to excel first so you are certain to have the exact column headings when you import them back.

Remember it’s ok to delete some of the columns as you can import part of the data only. Just be careful of the information that is contained in hammocks, it’s best to filter these out until you are confident about the export/import routine.
Top
Thu, 2005-10-06 21:42
#2
Sukumaran Subaram...
User offline. Last seen 8 years 39 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Sriram,

Save the Excel file using the following file extension before you import the data:
a) Lotus 123 - .WKS / .WK1, or
b) dBASE III - .DBF

P3 does not support excel extension.

Cheers!!!
Top
Thu, 2005-10-06 21:13
#3
Sen Moc
User offline. Last seen 18 years 16 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
In P3, go to Tools/Project Utilities/Import...

But before importing the Excel Data, make sure that the cell formats, column headings, etc matches with P3.

To be sure, create first an initial project in P3, create at least 1 or 3 temporary activities then Export to Excel.
Transfer your data to this exported file. Then Import this.

Regards.
Top