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 FROM EXCEL

5 replies [Last post]
Mon, 2004-06-14 12:52
Forum Guest
User offline. Last seen 10 weeks 14 hours ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None


CAN ANYONE TELL ME HOW TO IMPORT A LONG ACTIVITY LISTING WITH DURATIONS FROM EWXCEL TO P3
Top

Replies

Thu, 2004-06-17 01:09
#1
MK TSE
User offline. Last seen 4 years 17 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
To overcome create the spreadsheet, I usually create 2 dummy activities in P3, then export them in DBF format with selected fields.
Open DBF in Excel, do my edit and save it in DBF.
Then import.
Top
Tue, 2004-06-15 02:16
#2
Forum Guest
User offline. Last seen 10 weeks 14 hours ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Dear Luca

Its very urgent on the subject matter. Please contact me on following e-mail.
lasmodn@yahoo.com

I am waiting your reply

William peter
Top
Tue, 2004-06-15 01:13
#3
Luca Basile
User offline. Last seen 9 years 34 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Pay attention to save the file in DBIII format and not DBIV, otherwise P3 will not be able to read it.

Before to run the import You must have close the file in excel or again P3 will be not able to read it.
Top
Tue, 2004-06-15 01:08
#4
Luca Basile
User offline. Last seen 9 years 34 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
In Your excel file for each column insert these heading:
ACT Fill with Activity ID
TITLE Fill with Activity title (if You need)
OD Fill with Original duration

Example
ACT TITLE OD
A1000 Cut & fill 10
A1010 Stabiliz 8
Etc …

Then in excel select all the area and from the menu select “Insert->Name->Define” and give a name. You are making a database
Save the file in DBIII format

In P3 “Tools->Project Utilities->Import” write down the path, to Your file example “C:Projfile.dbf” and run it
Top
Tue, 2004-06-15 01:06
#5
Shahzad Munawar
User offline. Last seen 9 years 21 weeks ago. Offline
Joined: 2 Jul 2003
Posts: 551
Groups: None
This topic was discussed hundred times. So find this in reserch:

Transfer data from Excel to P3
Top