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.

Copy Status from one P6 schedule to another

7 replies [Last post]
Diane Resenna
User offline. Last seen 3 years 35 weeks ago. Offline
Joined: 1 Mar 2016
Posts: 9
Groups: None

Hello -I'm trying to put a newer schedule's activity statuses into an older schedule (physical % complete, actual start, actual finish, and remaining duration).

Is there a way to somehow copy this information from one schedule to another? (versus manully updating every single activity's status)

Thanks in advance.

Replies

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

that depends on how you export it if you use the normal file export then select excel the wbs MUST come with it there is no choice to unselected it and it MUST be exported

Understand that EVERY wbs has the PROJECT ID as the first part of the wbs. I think that the problem that you have is that when you exported from project A you DID NOT change the first part of the wbs name (the PROJECT ID) to project B prior to importing so the data was updated but the wbs info was not.

Diane Resenna
User offline. Last seen 3 years 35 weeks ago. Offline
Joined: 1 Mar 2016
Posts: 9
Groups: None

Thanks everyone for the replies.

The main intent of the exercise is to import the activities' status', but not logic changes.

When doing the export to excel, then importing, that seems to work however the activities go out of the WBS structure. Is there any way to import from excel and have the activities remain in the correct WBS?

Kannan CP
User offline. Last seen 6 weeks 6 days ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Zoltan,

I meant the normal project import.

If we have an updated schedule, we can import it to the existing baseline or previous updated project, to reflect the changes.

Best Regards

Kannan

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

Kannan

it is possible to use my suggested post export the info to excel from the newer schedule and import it into the older schedule 

Kannan CP
User offline. Last seen 6 weeks 6 days ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Is it not possible to update the existing project by doing the import project function

 

Regards

Kannan

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

the other option is to export actual start, actual finish and remaining duration to an excel file from one schedule and import this information into the other schedule but Raymunds way is the easiest

Raymund de Laza
User offline. Last seen 34 weeks 3 days ago. Offline
Joined: 23 Nov 2009
Posts: 762
Hi.. In maintain baseline window Assign the older schedule as baseline in the new updated schedule. Then use update baseline and set the data needed to copy. Hope this will help