This manual will help you understand how to use the program for converting data from
the QR-7550 via USB Flash to Excel on your PC.
We understand that this manual may leave some questions open. Please do not
hesitate to contact us if something is unclear.
Our telephone number is 1800 220 110. Email: john@alltime.com.au
Regards, Western Sunset Pty Ltd, http://www.westernsunset.com.au
Computer requirements for running the converter program.
Your PC should have the following minimum features:
1. Windows 98 or later.
2. .NET
If you don’t have .NET on your PC, then you can locate the installation program
in the “drivers” folder on the USB-stick purchased from source.
3. Excel 2003 or later.
If you have an earlier version some specialties in the program might
cease functioning or operate with some disturbances.
Please note.
The converter program is designed to work under the following conditions.
1. When inserting the USB-stick into your PC, the program starts automatically.
Your PC may be blocked for “Autostart”. In such cases open “My computer” and you
can locate the USB-stick under the name “Alltime”.
In the above folder you can locate the program “converter.exe”. Double click on
this program and then the Converter program will start.
2. The converter program is located on the USB-stick and the program can be
run from the USB stick.
3. The USB-stick is also used for transferring settings from PC to the
QR-7550 and collecting data from the QR-7550 to open in your PC.
4. Setting the QR-7550.
Use the converter program to design suitable settings for your QR-7550.
The settings will be stored on the USB-stick. Insert the USB-stick into your
QR-7550.
Press the button marked “Load settings” on QR-7550.
5. Collecting data from QR-7550.
Insert the USB-stick into your QR-7550. Press the button marked “Save data” on
your QR-7550. Bring the USB-stick to your PC and start the converter program.
Manual for the converter program.
How to start the program.
Insert the USB-stick into your PC. The program starts automatically. If not go
to My Computer, and search for the USB-stick under the name Alltime. Open the
content on the USB-stick and Double-click on the program “converter.exe”.
Converter opens, click on File and choose your language.
Main menu.
On the main menu above you can locate the choices:
Convert: This menu is used for converting data from QR-7550 to Excel (or your
own text format).
Device settings: Here you make your own choices on how to setup the QR-7550.
Employees: Here you can register your employees and which card number they
will have during different pay periods.
We will explain the different choices in this order: Device settings, Employees and Convert.
Device settings.
Under the sub menu Device settings you can locate the following options:
1. Choose device number.
If you have more than one QR-7550 in your Time and Attendance system you
should give each QR-7550 a different device number or have different settings in
different machines and have different employees with same card numbers in different
machines etc. The device number is set directly on the QR-7550 by pressing Function for 3 seconds, choose device number and set the number on the device.
Note. You can copy the settings for one device number to another device number.
2. Choose Active for the device.
3. Choose pay period and specify the last day in the pay period.
(Monthly choose 31).
5. Choose Day advance time.
6. Specify daylight saving time by starting and ending dates for one year.
Your QR 7550 will follow the year and understand the rule from these settings.
7. Choose display settings.
Choose between 24 hour and 12 hour am/pm and then choose language.
8. Choose Print options.
Choose between the different timecard print formats of minutes or 1/100 of an hour.
(1/100 only show as minutes in Excel spreadsheet).
9. Option. (Opt) External Time Signal.
This is setup in two steps.
Step 1. Define three possible signal time lengths, you may want to use,
in seconds (A, B and C). Recommended is usually 3, 4 and 5 seconds.
Step 2. Signals:
Choose signal 1. Setup signal 1 by days, time of day and length.
Choose signal 2. Setup signal 2 by days, time of day and length.
.
Note. You can have up to 48 different signals in the same QR-7550 fitted with relay.
If you have more than one QR-7550 terminal.
Choose the next device number. Please note, that you might save time, by using the
option of "copy from" the settings from the first device.
When finished:
When you have made all your settings for all your devices press the button
“Create setting file(s)” and the settings you have made in your converter program
will be transferred to the USB stick and ready to load into each device.
Note. If you already have settings on your USB stick these will be
overwritten.
Employees:
When entering this submenu you will see the following picture:
Here you can specify your employees by employee number and name. You can also
specify which time card number each employee will have during the pay period
in the different QR-7550 devices.
Note. If one employee is supposed to use only one device it is enough to
specify their card number for that device.
New time cards for a new pay period.
When an employee is supposed to have another card number in another period
you can specify that. Choose an employee. Press the Edit button and then add the new card number.
Now a window opens where you can specify another time card number for this
employee during another pay period.
Convert to Excel.
The recommendation is:
Specify all employee time card numbers for the pay period before converting.
It is easier for later input.
When you have inserted the USB Flash into the QR-7550 (The same for all terminals) then press the button “Save Data” it will transfer the
data in the clock to the USB Flash.
Insert the USB-Flash into your PC. Start the converter program. Choose convert
from the main menu (The default value).
Now there are two options:
Convert to text file.
This option is designed for those needing their own export format.
This manual does not describe this option. For help, contact Western Sunset
Pty., Ltd.
Convert to Excel.
Choose from the options given here:
Do header = Create headlines.
Show excel = The Excel program is showen on your screen.
Keep Excel open = Do not close Excel after conversion.
Separate devices = One work sheet for each device.
Separate employees = One work sheet for each employee.
Separate pay periods = One work sheet for each pay period.
Under convert you can locate the options:
Pay period.
Device settings = Use the pay period setting in the device, or,
specify type of pay period = override QR-7550 settings.
Text or Excel:
Choose Excel as the text alternative is not described in this manual.
Click convert.
Your Excel spreadsheet is created:
In this case we have choosen one page per employee and pay period.
You are now able to do corrections for missing punches by entering in the
expected time for the missing time card punch.
Total for the day will automatically be calculated.
The daily totals and the accumulated running total are shown on the spreadsheet.
On the right hand side of the spreadsheet you may add your own calculation
formulas for overtime, sick leave, annual holiday leave etc.
In the example above we have inserted a new line for the date 24-03-2008 and made the note Sick.
We have also inserted missing punches in the format of hh:mm.
We have also added a column Overtime (For more than 8 hours) and entered in the daily overtime.
Finally we have totalled all overtime at the bottom.
Note. The time format shall always be hh:mm. In the new column Overtime we
have specified in Excel, Format/cells/time/hh:mm.
End.
(c) Copyright 2011 { Western Sunset Pty Ltd } All Rights Reserved. Alltime is a trade mark owned by Western Sunset Pty Ltd.
