Home > Statistics > Screen Shots/Explanations > 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.
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.
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. |
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.
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) |