Importing Schedule Activities

Click the [Import] button to launch the Activities Import file selection pop-up. Check the 'Delete existing imported records' box to remove any temporary data previously uploaded using this import tool. This option does not delete or overwrite any existing records in the system.

After selecting the upload file and clicking on [Upload], a log of any errors is displayed. On this screen, make any necessary corrections, re-validations and complete the import.

When activity start dates get modified during DM activity import, all the open submittals linked with the activity will be updated with the new start date, and the schedule dates will be re-calculated accordingly.

ASCII File Layout – Schedule Activities Import

CONTROL FILE = DMACTIVITY.CTL

When importing scheduled activities, ensure the import file is of the TXT or CSV format, and that it adheres to the following format and layout:

Database Column	Description	Data Type
DMFAI_PROJ_CODE	current project code	Char 10
DMFAI_COMP_CODE	current company code	Char 8
DMFAI_ACT_CODE	activity code	Char 10
DMFAI_ACT_DESC	activity description	Char 60
DMFAI_START_DATE	start date	DD-MMM-YYYY
DMFAI_END_DATE	end date	DD-MMM-YYYY