If data is to be uploaded then it must be a text file of a specific format. Don't worry it is not complicated. We have opted for a very simple comma separated value (CSV) format.
CSV files are text files.
The values within them are separated by commas.
The first row contains the column headings (or field names)
Every row beneath contains a value for the field identified in the first line.
Values should be contained within double quotes i.e. "£1,000" to avoid commas in the data messing up the structure.
These text files can be created with any popular spreadsheet package such as Excel, or in a simple text editor like Notepad. Please don't use Word it will probably save a load of extra rubbish in the file.
CSV files can be exported from all database products. So you could ask your IT department to export a CSV file for you (based on one of our formats). Remember to tell them about the double quotes " around the field values.
We support Summary CSV formats - which contain the code of region followed by the number of sales etc for that region.
We support a flexible record level CSV format too.
The following are examples of formats supported