New and Existing Activities Through CSV Import
For the new activities with uuu_P6ActivityStatus as "Not Started" the following cases apply for Start, Finish, and Duration:
Note: Invalid values for any of the date and duration columns will result in error.
- If duration is provided without a start date, then the duration will be ignored.
- If duration is provided with a start date, then the finish date is calculated.
- If the start date and the finish date are provided, then duration is calculated.
- If duration is provided without a start date or a finish date, then an error message will be displayed.
- If only the duration is provided, then an error message will be displayed.
- If only the start date is provided, then an error message will be displayed.
- If only the end date is provided, then an error message will be displayed.
- If the start date and the duration are provided, then the finish date will be calculated.
- If the start date and the finish are provided, then the duration will be calculated.
Note: Any new activities created without any dates entered in the input CSV file will retain the Project Start Date.
uuu_P6Start | uuu_P6Finish | uuu_P6Duration | uuu_P6PlannedStart | uuu_P6PlannedFinish | uuu_P6PlannedDuration | uuu_P6RemainingEarlyStart | uuu_P6RemainingEarlyFinish | uuu_P6RemainingDuration | Behavior after Import |
|---|---|---|---|---|---|---|---|---|---|
No value entered | No value entered | No value entered | No value entered | No value entered | No value entered | No value entered | No value entered | No value entered | Activity will be created with default value as project Start date for Start, Finish, Planned Start, Planned Finish, Remaining EarlyStart, Remaining EarlyFinish. |
Valid date entered >= Project Start Date | Valid date >=Project Start Date and > uuu_P6Start | Calculated field if not provided explicitly | If not provided then should show same as P6Start | If not provided then should show same as P6Finish | Duration calculated between planned start and Planned finish | If not provided then should show same as P6Start | If not provided then should show same as P6Finish | Duration calculated using remaining start and remaining finish | Activity will be created with duration calculated based Start and Finish Dates |
No date entered, then same as uuu_P6PlannedStart; otherwise, retain the date entered | No date entered, then same as uuu_P6PlannedFinish; otherwise, retain the date entered | Calculated field if not provided explicitly | Valid date entered >= Project Start Date | Valid date >= Project Start Date and uuu_P6PlannedStart | Duration calculated between planned start and Planned finish | No date entered, then same as uuu_P6PlannedStart; otherwise, retain the date entered | No date entered, then same as uuu_P6PlannedFinish; otherwise, retain the date entered | Duration calculated using remaining start and remaining finish | Activity will be created with duration calculated based Start and Finish Dates |
No date entered, then same as uuu_P6RemainingEarlyStart; otherwise, retains the date entered | No date entered, then same as uuu_P6RemainingEarlyFinish; otherwise, retains the date entered | Calculated field if not provided explicitly | No date entered, then same as uuu_P6RemainingEarlyStart; otherwise, retains the date entered | No date entered, then same as uuu_P6RemainingEarlyFinish; otherwise, retains the date entered | Not applicable | Valid date entered >= Project Start Date | Valid date >= Project Start Date and uuu_P6RemainingStart | Duration calculated using remaining start and remaining finish | Activity will be created with duration calculated based Start and Finish Dates |
The validations mentioned above will be applied to the following dates and durations:
- uuu_P6PlannedStart
- uuu_P6PlannedFinish
- uuu_P6PlannedDuration
- uuu_P6RemainingDuration
- uuu_P6RemainingEarlyFinish
- uuu_P6RemainingEarlyStart
Last Published Monday, August 28, 2023