Home > Statistics > Screen Shots/Explanations > Statistics Entry - Import Data

Statistics Entry - Import Data

This tab is used to import statistics without needing to manually enter them on the Basic tab. Data is imported from a comma-delimited, CSV text file.

Step 1 - Select File

The first step is to enter the name of the file you want to import. Press the Data File button to browse for the required file. If the file exists, the system will show a sample structure in the grid below the file name. This grid has two columns. The system will read the first two lines of the file. The first line contains the column headings of the data in the file and is shown in the Fields column. The second row contains actual data. This is shown in the Data column of the grid. You can use these columns to ensure that the appropriate data is in the correct column. If you see a date displaying next to Trolley Count, you know you have something wrong! If a column heading is not recognised, the Data column will contain *UNKNOWN COLUMN*. A file with this error cannot be imported. You must fix the data so it contains correct columns.

Step 2 - Get Details

This section contains three buttons:

Data Grid

The main grid at the bottom of the screen shows the data that was imported. Use the buttons in Step 2 to get data into this grid and to save or cancel changes.

File Format

The file is a comma-delimited CSV text file. The first line contains a list of the column headings which will be included in the file. The available column headings are listed below. The remaining rows contain the actual data. The data should line up with the column headings. So if the fifth column in the first line is Damages, the fifth column in the remaining rows should be damages values. Here is a sample file:

Date,Location,Department,"Total Wages"

19/07/2009,ALL,BVRG,1000

20/07/2009,ALL,BVRG,11000

Double quotes should be around any value which has a space in it.

There are a number of columns which you can include in your data file. Some and mandatory key fields. Some are optional key fields and others are optional data fields.

Mandatory Key Fields

These fields must be included in your data file.

Optional Key Fields

You can use these fields to extend the level at which you want the data recorded. By default data will be loaded at the location level. However, you might want to load some statistics at the department level, or maybe the category level. You need to enter fields to the required level only. So if you wanted department level statistics, you would need Department. If you wanted category level statistics, you would need to include Department and Category columns. It is your responsibility to load the data at the required levels. If you load data for departments, this will not give you a location total. You must load the location data separately.

Optional Data Fields

These are your data fields. You include as many as you require.

Note: Sales and transaction count fields are not available because they will be loaded by the system as it processes POS transactions.