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.

How To Export & Import Primavera P6 Schedule Status Using Excel

9 replies [Last post]
Emily Foster
User offline. Last seen 1 year 47 weeks ago. Offline
Joined: 19 Aug 2011
Posts: 625
Groups: None

Get your updates via Excel. Here's how to export & import Primavera P6 schedule status using Excel http://ed.gr/l3vm

Replies

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

you can do that but 1st you must update the actual start date if the activity has just started. If the activity is already in progress you can simply update the activity % complete or the duration % complete both will updated the remaining duration/ 

Kannan CP
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Thanks Zoltan..

Kannan CP
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Hi Emily,

Instead of Duration (%), why cant we use the Activity (%) column which will easier for the team member to filled in, and while importing it P6 will automatically calculate the remaining duration.

Regards

Kannan

Emily Foster
User offline. Last seen 1 year 47 weeks ago. Offline
Joined: 19 Aug 2011
Posts: 625
Groups: None

Yes, Primavera P6 automatically computes the Remaining Duration from the Duration % complete or vice versa. But since P6 will not read columns with an (*) it will not read in the Duration % Complete(%) values.  We therefore need to provide the Remaining Duration(d) column data.

Removing the (*) from the column header does not change the fact that P6 does not import Duration % Complete(%) values.

Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

1. this depeneds on your percent % type setting for each activity. If you have your % complete type set to duration and if put in a duration % complete in the status tab then the remaining duration will be automatically calculated for you. ie orginal duration 10 days you staus the % complete as 50% then the remaining duration is 5 days. 

2. NO thats the whole point of the (*) it tells you what you can not import. The only way around is is to use SDK and that only works for version 8.4 and under.

Kannan CP
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Hi Emily,

1. In the report it is specified that, in addition to the duration %, remaining duration also to be filled in. In my understanding, for duration% progress type, based on the duration%, the remaining duration will be changed automatically, or vice versa.

In that case, the filled in duration% by the team member will be changed based on the required remaining duration, or it should be a physical% progress type.

2. If we remove the (*) from the column heading, it will be read by P6?

 

Best Regards

Kannan

Emily Foster
User offline. Last seen 1 year 47 weeks ago. Offline
Joined: 19 Aug 2011
Posts: 625
Groups: None
Richard Edwards
User offline. Last seen 5 years 11 weeks ago. Offline
Joined: 15 Dec 2016
Posts: 3
Groups: None

Sounds like an interesting topic.  Can you please try again with the link.  The one you listed doesn't seem to go anywhere.

Richard Edwards
User offline. Last seen 5 years 11 weeks ago. Offline
Joined: 15 Dec 2016
Posts: 3
Groups: None

Sounds like an interesting topic.  Can you please try again with the link.  The one you listed doesn't seem to go anywhere.