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 Predecessors and Successors from Excel

14 replies [Last post]
Tue, 2005-10-18 11:36
Kashyap Mothali
User offline. Last seen 12 years 24 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 23
Groups: None
Is there a way to import both the predecessor and successor information from a spreadsheet (like excel) into P3?

I tried exporting a blank template from P3 first but all I could do was the successors (through the Successor Relationships Option), not predecessors.

Any suggestions will be appreciated. Thanks,

Kashyap Mothali
Top

Replies

Thu, 2005-10-20 10:25
#1
Kashyap Mothali
User offline. Last seen 12 years 24 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 23
Groups: None
This is great stuff!!! Thanks again,David.

Kashyap

p.s. - I noticed that although I am able to modify relationships, I am unable to delete the same through the excel spreadsheet and see the changes in P3. However, since deltions are generally fewer than adds, I don’t mind doing this manually in P3 itself!
Top
Thu, 2005-10-20 01:19
#2
Sen Moc
User offline. Last seen 18 years 16 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
Thanks Zhang for your clarification and information.
Top
Thu, 2005-10-20 01:16
#3
Zhang Haixiang
User offline. Last seen 3 years 28 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
RA is not a software. It’s a programming interface.
programmer can use RA to access P3 object.
There is a file ra.dll on P3 CD, together with a lot of sample to demo how to using RA by VB/VBA/MS-Access...

Top
Wed, 2005-10-19 23:00
#4
Sen Moc
User offline. Last seen 18 years 16 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
David,

Will appreciate very much if you could list down other uses of this RA software.

Thanks again.
Top
Wed, 2005-10-19 22:56
#5
Sen Moc
User offline. Last seen 18 years 16 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
David,

You mean, there is an RA Software included in the original Installation CD of P3? Or is it still necessary to request Primavera?

Please advise, since I don’t have the installation CD right now.

Many Thanks.
Sen
Top
Wed, 2005-10-19 18:21
#6
David Kelly
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas
You copy the entire "RA" directory from the P3 distribution CD to your hard disk. I usually put it underneath the main "P3WIN" directory. The spreadsheet is under the "samples\excell" directory. "Activities.xls" and "project.xls" are enabled with "RA" instructions in the macros to read and write to P3 tables directly, but you will be asked to login with your usual P3 ID. RA is an amazing piece of kit, and the best kept P3 secret.
Top
Wed, 2005-10-19 14:46
#7
Kashyap Mothali
User offline. Last seen 12 years 24 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 23
Groups: None
David,

How do you access this "activities.xls" sample spreadsheet?
Top
Wed, 2005-10-19 09:46
#8
David Kelly
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas
Now that PC’s are fast enough, don’t neglect the RA software that you get free of charge with P3 3.1. The sample RA enabled excel spreadsheet "Activities.xls" allows both successors AND predecessors to be read and written directly to P3
Top
Wed, 2005-10-19 08:26
#9
Kashyap Mothali
User offline. Last seen 12 years 24 weeks ago. Offline
Joined: 4 Apr 2005
Posts: 23
Groups: None
Thanks all...Will try out the options asap.

Kashyap
Top
Wed, 2005-10-19 03:20
#10
Sukumaran Subaram...
User offline. Last seen 8 years 40 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Hi,

After the work out, save the Excel file as one of the following extension before import to P3:
a) Lotus 123 - .WKS / .WK1
b) dBASE III - .DBF

Regards.
Top
Tue, 2005-10-18 21:07
#11
Sen Moc
User offline. Last seen 18 years 16 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
I mean, what you actually see in the "Act ID" column of the spreadsheet are the Predecessors and in the Successor ID column are the Successors of the activity.

Sen
Top
Tue, 2005-10-18 21:02
#12
Sen Moc
User offline. Last seen 18 years 16 weeks ago. Offline
Joined: 30 Aug 2005
Posts: 123
Groups: Petro-Chem / Oil & Gas
Kashyap san,

Yes, you are correct. When exporting P3 to spreadsheet, only “Export Successor Activity” option is available. What you will get in the spreadsheet is a list with column headings: Act ID, Successor ID, Lag & Relationship. You will notice that if one (1) activity has so many successors, the activity will be listed in the Act ID column more than once equal to the number of successors this activity has. Actually this is the default view after exporting to spreadsheet, you can easily see the successors activity.

Now, here’s the trick if you want to see all the predecessors of an activity in a spreadsheet: Try to “sort” all the activities according to Successors.

Hope this helps.

Regards.
Sen
Top
Tue, 2005-10-18 14:31
#13
Philip Jonker
User offline. Last seen 15 years 21 weeks ago. Offline
Joined: 7 Nov 2004
Posts: 852
Groups: None
Hi guys,

The trick is to set up a couple of dummy activities, and link them, and then export. This will give you the template you need.

Regards
Top
Tue, 2005-10-18 11:44
#14
Jose Frade
User offline. Last seen 3 years 7 weeks ago. Offline
Joined: 7 Jun 2005
Posts: 144
Groups: None
Some time ago it was posted a macro that would do that.
The complete macro was for exporting from MSProject into P3, but with the necessary change it will work.

Try to find related topics posted by colleague Hannes de Bruyne on the 19AUG05

BR
JMFrade
Top