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.

Brand New to P5 - Import questions

6 replies [Last post]
Thu, 2007-05-24 13:51
Maya C
User offline. Last seen 15 years 42 weeks ago. Offline
Joined: 21 May 2007
Posts: 19
Groups: None
I am brand new to P5 and I am stumbling while importing from Excel files. I have these questions.

1) Should WBS codes be manually created (and referenced in the Excel Files)in P5 before exporting activities?

2) For some reason, my START dates are not importing correctly. They are defaulting to the DATA date. I have a DURATION column and FINISH colum and they are populating correctly, however all my START dates are defaulting to data dates.

I would really appreciate if anybody can shed some light on these issues.

Many thanks.
Top

Replies

Fri, 2007-05-25 09:32
#1
David Moses
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 20 Oct 2004
Posts: 122
Groups: Petro-Chem / Oil & Gas
That is great !!!

Keep on planning.....

Regards
Top
Fri, 2007-05-25 09:23
#2
Maya C
User offline. Last seen 15 years 42 weeks ago. Offline
Joined: 21 May 2007
Posts: 19
Groups: None
That really helps. This forum is great!

Thanks for your time, David and Oliver!
Top
Fri, 2007-05-25 08:59
#3
Oliver Melling
User offline. Last seen 5 years 5 days ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
I agree with David,

you must have relationships between your activities in order to schedule the work. Otherwise all activities will move to the data date as there is nothing telling them they can’t start immediately.
Top
Fri, 2007-05-25 08:32
#4
David Moses
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 20 Oct 2004
Posts: 122
Groups: Petro-Chem / Oil & Gas
Hi There,

You are importing activities.Ok.

But if there is no relationship b/w activities, whether you import it or not, it is logical to see the start dates as data dates on the program.

Start dates, durations and finish dates are not enough to create a cpm. Relationship of those activites has to be defined as well.

Hope this helps
Top
Fri, 2007-05-25 08:16
#5
Maya C
User offline. Last seen 15 years 42 weeks ago. Offline
Joined: 21 May 2007
Posts: 19
Groups: None
I am not importing relationships, just activities.

Can you create WBS by importing?

Top
Fri, 2007-05-25 08:08
#6
David Moses
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 20 Oct 2004
Posts: 122
Groups: Petro-Chem / Oil & Gas
Hi There,

Did you check the relationship of activities?

I mean, while importing or exporting are you also importing or exporting predecessors or successors of activities.

It may cause such problem.

Regards,
Top