Export Records

The Export Records dialog is available from the AV Tools File menu. This dialog allows clock data records to be exported to a CSV (comma deliniated) file. The Export Records dialog is shown below.

exportRecords.gif

From Date

The starting date of the range of records to export.

To Date

The ending date of the range of records to export.

Department

The department (or all departments) to be exported.

Include Inactive

If Include Inactive is checked, inactive employees will be included as well as active.

Delineated By

Specifies what character will deliniate each column (or field) of a record. This would most commonly be a comma.

Enclose Fields In

Some software might expect the data to be enclosed in single or double quotes. If so, select single or double quotes here.

Output Records

Each record will contain the following information. Each record will be terminated by a CR/LF (newline).

Employee Number
The employee number
Date In
The clock in date in Month/Day/Year format.
Time In
The clock in time in 24 hour format.
Date Out
The clock out date in Month/Day/Year format.
Time Out
The clock out time in 24 hour format.
Department Number
The department number.
Comment
The comments as entered on the Clock Data Edit dialog.

OK

When the OK button is pressed, a File Save-As dialog will appear. Enter the filename for where the records should be exported to.