Information
is entering into Log file after you clicked on Save button on PC-Panel.
There are 4 different types of log file entries:
- Start of the program
- Entry for Pay As You Go mode
- Entry for Pre-Paid mode
- End of the program
Bellow is an
example of such entry:
| Start
of the program |
| #2003-02-04 11:10:59# |
Program creates this
entry every time when you start or click Refresh button in Cafe Manger. This is current Date and Time |
| Entry
for Pay As You Go mode |
| "PC 1, 15:50,16:50,1:00|0.90, ,0.60, , , , , , |
Member:$6.00, $7.50,15" |
This entry is in Comma
Separated Values format. From left to right :
- PC-Panel number (PC 1)
- Starting time (15:50)
- Ending time (16:50)
- Time spent (1:00)
- Break down charges for additional services i.e. Coffee, Tea etc.
Additional Services are separated
by two pipes symbols (|). Two additional
services were paid for: 0.90 and 0.60
- Charge Category and charge for time spent (Member:$6.00)
- Total ($7.50)
- Member ID (15) |
| Entry
for Pre-Paid mode |
| "PC 4,
00:10,00:00,00:10|,,,,,,,,|Guest:$1.00, $1.00," |
- PC-Panel number
(PC 4)
- Time bought (00:10)
- Time left (00:00)
- Time spent (00:10)
- Break down charges for additional services i.e. Coffee, Tea etc.
Additional Services are separated
by two pipes symbols (|).
- Charge Category and charge for time spent (Guest:$1.00)
- Total ($1.50)
- Member ID (blank in this case) |
| End
of the program |
| "End Total
8.50" |
Program
adds this entry every time you Exit the program or when new Log file
is created. See Advanced options |
The log file can be imported into the
Microsoft Access or Microsof Excel.
Open Blank MS Access database. From File Menu select Get External data >
Import.
Select Files of Types : Text Files (.....*.csv...)
Navigate to the Cafe Manager log file you would like to import and Open it.
Then follow instructions of the Wizard Import.
|