We are currently in the process of making the majority of our data files available in CSV format.
Please regularly review the attached progress log which contains the details of the files which are available for integration.
If you would like more information please contact your Account Manager or call 0113 222 2007.
The CSV files will conform to official CSV guidelines. For more information on the guidelines click here
Please be aware of the following file formatting notes which will assist with your integration;
|File Formatting Notes|
|CSV files will not contain headers and footers. Instead, each CSV file will be accompanied by an audit file which states the file creation date and number of rows within the file. This audit file will be available alongside the CSV file in the same download area.|
|Blank text values will appear as ," ",|
|Null dates will appear as ,,|
|Dates will be in the format yyyy/mm/dd|
|True and False fields will contain either 'True' or 'False', not 0 or 1|
|Decimal fields will contain a max 2 decimal places|
Please note the files will be downloaded in a .zip format