Returned Forms Import Guide

CSV Order Friendly Name Description Required for new record? Required for update? Other Requirements Sample CSV Data
1 User ID The ‘User ID’ that this form is assigned to. YES YES Enter a valid user ID. This user ID must already exist in the OrchestrateIT database. 21F857431E
2 Form Name The friendly name of the form that the user is being assigned. NO N/A Enter a valid form name. This form name must already exist in the OrchestrateIT database. Contract
3 Form Campus The name of the campus on which this form is stored. NO N/A Enter a valid campus name. This campus must already exist in the OrchestrateIT database. Gold Coast
4 Date Returned The date that the user returned this form to the school. YES NO Enter a valid date (DD-MM-YYYY). The date must either be today or historic – you cannot enter a future date. 17-11-2015
5 Attachment Path The path to the file you want to assign to this record. This file will be automatically copied to the OrchestrateIT attachments directory and renamed. NO NO Enter a valid file path to a local drive or network share. D:\files\12345 Form.pdf
6 Form Code A unique code name of the form the user is being assigned. NO YES Enter a valid unique identifier with no spaces. CONTRACT2015