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.

Importing progress percentage not working

14 replies [Last post]
Tue, 2009-05-05 20:49
kier legard
User offline. Last seen 15 years 8 weeks ago. Offline
Joined: 31 Jul 2006
Posts: 96
Groups: None
hi to all,

Im using p6 and im updating my schedule by importing it to excel and updating and exporting back to p6.The problem is when I update the duration percent complete it is not updated when imported to p6 .What seems to be the problem.


regards,

kier
Top

Replies

Sat, 2009-05-09 04:55
#1
Arnold Puy
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Hady,

Equal or not equal, still you have to filter or use the "If Paramaters" if you are going to use the global change.

The easiest way is to show the % complete type on the column.

Regards.
Top
Sat, 2009-05-09 04:30
#2
Hady Shendy, PMP
User offline. Last seen 12 years 27 weeks ago. Offline
Joined: 11 Jun 2006
Posts: 34
Groups: None
Hi Arnold
your method may enough if the % were equals.

Regards
Top
Fri, 2009-05-08 23:49
#3
Arnold Puy
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Hady,

Even without utilizing the global change, you can easily change the % complete type by showing them into column and use the command fill down.

Regards.
Top
Fri, 2009-05-08 09:03
#4
Hady Shendy, PMP
User offline. Last seen 12 years 27 weeks ago. Offline
Joined: 11 Jun 2006
Posts: 34
Groups: None
try to create user field, when export to excel be sure to add that field
in excel use it as your % completion
in P6 use globel change to convert that field to Duration or Physical duration.

Regards
Top
Wed, 2009-05-06 07:07
#5
Arnold Puy
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi,

I don’t think so...

Top
Wed, 2009-05-06 06:54
#6
Luca Basile
User offline. Last seen 10 years 1 week ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Wow
you think that with the new version they improve and make the planners life easier instead ...

May be in PM7 the opportunity will be back

L
Top
Wed, 2009-05-06 06:52
#7
Arnold Puy
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Luca,

Yes, I have tried all the PCT fields in P6 and export to Excel. All of them having the (*) next to column title.

Have a nice day too.

Regards,

Arnold
Top
Wed, 2009-05-06 06:35
#8
Luca Basile
User offline. Last seen 10 years 1 week ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Hi
did you try to export all PCT fields and see which one has not the * near by?
Is how I have done to find out which one I could use for my update

Sorry for the missunderstanding on PM5-PM6.

Have a nice day
Luca
Top
Wed, 2009-05-06 06:19
#9
Arnold Puy
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Luca,

I forgot about PM5 but if you have done and it works for you then it’s fine. However, in P6 it doesn’t work. Anyway, thanks for the info.

Regards,

Arnold

Top
Wed, 2009-05-06 06:10
#10
Luca Basile
User offline. Last seen 10 years 1 week ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Hi
I just done a progress update on PM5 this morning, using "’Activity % Complete(%)" and worked

May be in PM6.2 this field is not locked


L
Top
Wed, 2009-05-06 06:05
#11
Arnold Puy
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Luca,

You just mentioned the asterisks (*) in the heading cannot be imported. However, "Activity % Complete" also has.

How can you export back to P6? Can you tell us?

Regards,

Arnold
Top
Wed, 2009-05-06 05:51
#12
Luca Basile
User offline. Last seen 10 years 1 week ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Hi
from excel you have to import back the "Actvity % Complete"
All other PCTs that have an * near the headings are not importable back in Primavera Enterprise

L
Top
Wed, 2009-05-06 05:28
#13
Arnold Puy
User offline. Last seen 10 years 2 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Kier,

You need to change your remaining duration: Because Duration % Complete equals to (OD - RD)/OD*100.

Where: OD is taken from the current plan & not from the baseline.

HTH.

Arnold
Top
Wed, 2009-05-06 00:30
#14
P6 Support
User offline. Last seen 15 years 41 weeks ago. Offline
Joined: 6 May 2009
Posts: 4
Groups: None
Duration % complete probabaly not a field that is importable. Any field that has an asterisks in the heading cannot be imported.
Top