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, the duration will be ignored.
- If duration is provided with a start date, the finish date is calculated.
- If the start date and the finish date are provided, duration is calculated.
- If duration is provided without a start date or a finish date, an error message will be displayed.
- If only the duration is provided, an error message will be displayed.
- If only the start date is provided, an error message will be displayed.
- If only the end date is provided, an error message will be displayed.
- If the start date and the duration are provided, the finish date will be calculated.
- If the start date and the finish are provided, 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, should show same as P6Start | If not provided, should show same as P6Finish | Duration calculated between planned start and Planned finish | If not provided, should show same as P6Start | If not provided, 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, March 2, 2026