Convert CSV from IW4 to EP format

If your exchange system has not yet been upgraded to produce CSVs in the new format, you may use this script to convert your files.

DISCLAIMER: This script is not guaranteed to work but the ITS can support you in making it work for you. The ITS reserves the right to discontinue the availability of the script or any support provided for it.

Step 1: If you don't have Python, download it here and install it. You will need Python 2.7.x (currently 2.7.13) or 3.6.x (currently 3.6.0).

Note: Macs have Python 2.7 pre-installed, so you won't have to do anything.

Step 2: Download the script here for Python 2.7 or here for Python 3.6.

Note: The version for Python 2.7 does not handle encoding correctly yet. If you have special letters or characters they may not import correctly. The version for Python 3.6 has no known issues about this.

Step 3: Drag the IW4 CSV offers file onto the script file.

Step 4: Enter your National Committee System ID and press Enter.

Note: If you don't know your National Committee System ID, you can find it in your NC profile (Menu: Administration -> National Committee)

Step 5: The fixed file is created and you can upload it to the Exchange Platform.