Page 6 - Microsoft Word - ISD-Importroutine-2017-V03

Procedure for running the CXC Import Routine

Save the zip file (Import_csv) on your computer.
Note: Please ensure that all the files above are located in the same folder. The files contained in the
zip files are as follows:

* readme.md
* token - a file containing the authorization token required by the code
* import_csv.py - source code for the import
* import_csv.exe - a windows-based executable that can be run without installing
python

Running the executable

1. At the command prompt, type the following:

import_csv.exe --token token <file_to_import.csv>

2. The <file_to_import.csv> is generated from the Online Registration System (ORS) by ISD
with the following fields.

1. Candidate ID
2. Test <start time>
3. Test <end time>
4. Extra time
5. Session ID
6. Test Code
7. Test sitting name
8. Building Name

The csv file should follow the formatting agreed upon and *requires* all the timestamps to be
ISO-formatted in the UTC time zone. The file can contain multiple test sittings. See format of file
as shown below:

5