1. create a filter where activity status is not equal to compelte
2. create a template for the export include the following
activity id, activity description, original duration remaining duration, physical % complete, actual start, actual finish
when you export this tempate chose the filter that you use created in step 1.
3. export this info to excel and update the remaining duration, physical % complete, actual start, actual finish fields
make sure to also incluse the start and finish TIMES. The actual start time should be i.e. 8:00 am or the earlies start time in all of the calendars being used and the actual finish time should be lates time of all your calendars being used i.e. 5:00 PM
4. save the file and import the data
5. Change the data date the TIME for the data date should be i.e. 8:00 am or the earlies start time in all of the calendars being used.
Member for
16 years 3 monthsglad that I could help
glad that I could help
Member for
19 years 4 monthsI am not sure how I missed
I am not sure how I missed the * on physical % complete. My bad. Thanks a ton for providing the work around.
Member for
16 years 3 monthsas I previously stated any
as I previously stated any column that has an asterick * on it is not importable
as you can see below from the excel file that physical % complete is one of those fields.
(*)Physcial % Complete(%) is one of those fields
Here is the work around Export the field called Activity % Complete (%)
then populate this with the % complete and import this Actviity % Complete back into P6
then go to tools global change and select New
make the parpameters look like this
where Activity % complete is greather than 0%
then physical % complete = activity % complete
then select change
then select Commit Changes (lower right)
then exit the global change
do this AFTER every time that you import a new % complete
Member for
19 years 4 monthsyes, thats correct
yes, thats correct
Member for
16 years 3 monthswhat % does not change
what % does not change physical ?
Member for
19 years 4 monthsI am using Physical %
I am using Physical % complete column in update % complete but for some reason % complete does not change.
I ahve checked formatting and all which seems to be fine.
Member for
16 years 3 monthsany column that has an
any column that has an asterick * on it is not importable
Member for
19 years 4 monthsThanks, Getting quite a bit
Thanks, Getting quite a bit of errors. % complete not going through but actual dates are.
Member for
16 years 3 months1st export the data that is
1st export the data that is to be updated
1. create a filter where activity status is not equal to compelte
2. create a template for the export include the following
activity id, activity description, original duration remaining duration, physical % complete, actual start, actual finish
when you export this tempate chose the filter that you use created in step 1.
3. export this info to excel and update the remaining duration, physical % complete, actual start, actual finish fields
make sure to also incluse the start and finish TIMES. The actual start time should be i.e. 8:00 am or the earlies start time in all of the calendars being used and the actual finish time should be lates time of all your calendars being used i.e. 5:00 PM
4. save the file and import the data
5. Change the data date the TIME for the data date should be i.e. 8:00 am or the earlies start time in all of the calendars being used.
6. Analyze the results.