Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Link Between Excel & P3

5 replies [Last post]
Thu, 2008-04-24 06:10
Mustafa Ismayilzada
User offline. Last seen 5 years 29 weeks ago. Offline
Joined: 25 Jun 2007
Posts: 26
Groups: Petro-Chem / Oil & Gas
Hi Everybody,

Is it possible to create a link between excel spread sheet and primavera? For example I have got excel sheet with the activities and percentage column. While updating progress in excel, same thing to be done somehow automatically in primavera "percentage complete - %" column in order to avoid double handling.

Thanks,
Mustafa
Top

Replies

Wed, 2008-04-30 23:24
#1
Mustafa Ismayilzada
User offline. Last seen 5 years 29 weeks ago. Offline
Joined: 25 Jun 2007
Posts: 26
Groups: Petro-Chem / Oil & Gas
Ravi/Paul,

I appreciate your help. Thanking you very much indeed.

Cheers
Mustafa
Top
Wed, 2008-04-30 23:19
#2
A D
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
Mustafa,

I Doubt. U can do update P3 and then it will get automatically changed in excel file. For tat u can use pervasive ODBC Drivers.

But, u need to do double handling, if u want data to be updated from execel to P3. Pauls article will explain u in detail about the linking of database between Excel and P3, but requires double handling.

Cheers,

Ravi
Top
Wed, 2008-04-30 07:07
#3
Paul Harris
User offline. Last seen 1 year 48 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
There is an article on my web site under technical articles that may help you and the drivers may be downloaded from my software section.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au
Top
Thu, 2008-04-24 06:40
#4
Mustafa Ismayilzada
User offline. Last seen 5 years 29 weeks ago. Offline
Joined: 25 Jun 2007
Posts: 26
Groups: Petro-Chem / Oil & Gas
Ravi,

Thanks, but this is still double handling. As you said this is to easy. I am talking about having the excel spread sheet somewhere in the network. As soon as lets say in my case offshore construction super updates the percentage in excel, it automatically mirrors in primavera percentage column.

Thanks in advance
Top
Thu, 2008-04-24 06:31
#5
A D
User offline. Last seen 4 years 16 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
Use Import / Export.

Go to tools --> Project Utilities --> Export.

Its very easy and self-explanatory

The only thing to look out is that excel extension will be Wk1 here and not xls.

Also, import / export will work only for MS Excel 2003 and not 2007.

Export will take necessary activties to excel, while import will bring it back those activities from excel to P3 after updating.

:-)

Ravi
Top