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