New "In Progress" and "Completed" Activities
In the input CSV file for a new activity creation, the following applies to:
- Actual Start
- Actual Finish
- Actual Duration
The invalid values for any of the date and duration columns will result in error.
uuu_P6ActualStart | uuu_P6ActualFinish | uuu_P6ActualDuration | uuu_P6ActivityStatus | uuu_P6PercentComplete | Behavior |
---|---|---|---|---|---|
Valid date entered and on or after Project Schedule Start Date | Valid date entered and >= uuu_P6ActualStart | Not applicable | Not applicable | Not applicable | Activity will be created with Activity Status as "Complete" Activity Complete will be 100% Actual Duration will be duration between Actual Start and Actual Finish. uuu_P6RemainingStart and uuu_P6Reamining Finish will not show any dates as the activity is complete If provided, the remaining dates in the input CSV file for completed activity will be ignored and remaining duration will be 0 (zero) Note: If not provided in the CSV input file, the P6Start, P6Finish, P6PlannedStart, and P6PlannedFinish will be the project start date; otherwise, the user-provided dates will be retained. |
No date entered for uuu_P6Start, uuu_P6Finish and entered uuu_P6ActualStart | No Value provided | No Value provided | No Value provided | Valid value entered | Activity will be created with Activity Status as "In Progress" Activity Percentage as entered in input CSV file Actual Duration will be 0 (zero), if not entered Note: If not provided in the CSV input file, the P6Start, P6Finish, P6PlannedStart, and P6PlannedFinish will be the project start date; otherwise, the user-provided dates will be retained. The uuu_P6RemainingStart will be the Actual Start Date and the uuu_RemainingFinish will be the uuu_P6RemainingStart + uuu_P6RemainingDuration |
Valid date entered for uuu_P6Start, uuu_P6Finish but no uuu_P6ActualStart is provided. | Valid date entered and on or after Project Schedule Start Date | No Value provided | No Value provided | No Value provided | Activity will be created with Activity Status as "Completed" Actual Start and Actual Finish Dates are shown with same date as provided in Actual Finish Date and Activity % Complete should be 100% (one hundred percent) Actual Duration will be duration between Actual Start and Actual Finish Note: If not provided in the CSV input file, the P6Start, P6Finish, P6PlannedStart, and P6PlannedFinish will be the project start date; otherwise, the user-provided dates will be retained The uuu_P6RemainingStart and uuu_P6Reamining Finish will not show any dates because the activity is complete (if provided in the input CSV file for completed activity, then the dates will be ignored and remaining duration will be 0) Actual Duration will be total duration between Actual Start and Actual Finish |
No Value provided | No Value provided | Valid value entered for uuu_P6Actual Duration | No Value provided | No Value provided | Activity will be created with Activity Status as "Not Started" Activity Complete will be 0% (zero percent) Actual Duration value will be ignored if entered without uuu_P6ActualStart If the uuu_P6Start and uuu_P6Actual Start are both entered, then those dates are retained; otherwise, the uuu_P6Start and uuu_P6Finish will be the project start date, if it exists The uuu_P6PlannedStart will be same as uuu_P6Start, and the uuu_P6PlannedFinish will be same as uuu_P6Finish The uuu_P6RemainingStart and uuu_P6Remaining Finish will be the same as uuu_P6Start and uuu_P6Finish |
Valid date entered in uuu_P6Start and uuu_P6Finish Valid date entered and on or after Project Schedule Start Date | Valid date entered and <= uuu_P6ActualStart | Not applicable | Not applicable | Not applicable | Error message indicating that the uuu_P6ActualFinish cannot be earlier than uuu_P6ActualStart |
Last Published Monday, August 28, 2023