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:

Import

Press this button to load the contains of the data file into the main grid of the screen. If the data file contains an *UNKNOWN COLUMN* error, the Import button will not be available to press.

Save

Press this button to save the data shown in the grid. Importing the data does not automatically save it. The system is giving you a change to verify the data looks correct before you save it.

Cancel

Press this button to clear the data shown in the grid. You would do this if you decided the data was not what you wanted and you did not want to save it.

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.

Date or Start Date

The date for which you want to load the data. This is in your local date format. If you want to load statistics for a weekly or monthly period, do not use the Date column, use the Period column.

Period

The statistics period for which you want to load the data. If you specify a Date column, you don't need to include this column.

Location

The location for which you want to load the data.

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.

Department or Dept

The code of the department for which you want to load the data.

Category or Cat

The code of the category for which you want to load the data.

Group

The code of the group for which you want to load the data.

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.

Casual Labour Hours

Number of hours for casual labour.

Casual Wages

Value of wages for casual labour.

Damage

Value of damages (stock adjustments due to damage, theft, and so on).

Fulltime Labour Hours

Number of hours for fulltime labour.

Fulltime Wages

Value of wages for fulltime labour.

Markdown

Value of markdowns.

Overtime Labour Hours

Number of hours for overtime labour.

Overtime Wages

Value of wages for overtime labour.

Parttime Labour Hours

Number of hours for parttime labour.

Parttime Wages

Value of wages for parttime labour.

Total Wages

Total wages value.

Total Labour Hours

Total number of hours for labour.

Trolley Count

Trolley count.

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)