Reseller Sign-In/Apply

Reseller Zone


Get access to your Reseller Dashboard today and explore our Knowledge Base, Downloads, Assets and Support Tickets.

Login to your account

Reseller Sign-In/Apply

Reseller Zone


Get access to your Reseller Dashboard today and explore our Knowledge Base, Downloads, Assets and Support Tickets.

Login to your account

How to export clockings from JT

This article looks at the setup required to export clockings from a Jarrison Time database, with the intention of easily importing the same clockings into another Jarrison Time database. Note that this export will provide first and last clockings of each day, not all clockings. If all clockings are required a report should be used, but the report will need to be manually formatted in order to import successfully.

1) Open the File Creator in Jarrison Time by going to Setup > File Creator, or clicking the toolbar icon.

2) Add a new entry, name it appropriately and set a location to save the export file. Export Type should be Daily.

3) On the General tab enable the option for Multiple Records per Employee, and enable a header record.

4) The Details tab should be set as seen below. Add Employee Number, Date, and First In fields, configured as below. Each should be separated by a comma (constant). Append a constant “:00” as there is no hh:mm:ss format.

3) Then click Copy under the Rows section, and select the copied row (2).

4) Change the First In field to Last Out.

The export is now ready for use. Below is a sample of an output file, run for a single employee on one day.

ClockingExport4 1

This file is ready to be imported by changing the import location in the other database. From Setup > System Configuration > Import tab, change the Location to IMPORT FILE and then Browse for the export file location.

A clocking import can now be performed to bring in the exported clockings. Afterwards remember to change the import location back to what it was.

Related How to export clockings from JT Articles

Still a bit stuck?

Send us a support message below.

Glossary of Terms

.Net Framework

(known as “dot net”) .Net is a software development framework for building and running applications on Windows.

Access Control

Access control refers to the restriction of people’s ability to clock on biometric devices based on location and/or time. Advanced access control includes anti-passback and zone sequencing.

Access Groups

Access Groups in Jarrison Time are combinations of Devices and Time Zones, used to determine on which devices and at which times members of the Access Groups may clock. Access Groups also facilitate restrictions based on too much or too little clocking in specified time-frames.

Access Groups can by synchronized or imported by Third-Party Import, or by users.

Access Zone

In Jarrison Time an Access Zone is how devices are grouped together to form logical zones for the purposes of access control. The option is available with the JT Live module.

Adjustments (Manual Adjustments)

Adjustments are the method of covering absence of time by employees in Jarrison Time. Examples of adjustments would be Annual leave and Sick leave. Adjustments are typically applied by a user via Daily Details as needed, or can be imported from file. It’s very important that Adjustments are correctly configured and applied as paid or unpaid. (Unpaid will result in Short Time.)

Anti Passback

Anti Passback is a form of access control where people are restricted from clocking on the device most recently clocked on, until they have clocked at another device.

Approval Bypass

Approval Bypass is a feature of Jarrison Time Approvals that allows for the first approval tier to be approved without any exceptions being cleared.


Approvals are a system-wide setting that forces users to correct Exceptions and then lock periods from further editing, ready for submission to payroll.

Jarrison Time allows for up to three tiers of Approvals: Daily Summary (timesheet), Pay totals, Department totals. Starting at timesheet level, each tier needs to be approved before the next one can process.


An Area in Jarrison Time refers to a GPS location with a set radius, which designates a permitted T&A clocking area for JT Clock users.

Area Schedule

The Area Schedule is used in conjunction with JT Clock to determine where JT Clock users should clock on a given day.


Authentication in the context of access control or T&A is the means by which a person identifies themselves to biometric devices for clocking purposes.


In Jarrison Time it is possible to allow employees to earn unapproved overtime when working additional hours. The unapproved time must then be authorized (to change to payable OT) or declined by a user. Authorization categories are setup so the system knows where to send approved or declined time.

Biometric Device (Reader)

A biometric device is a type of device (also known as a reader), usually wall-mounted but can be handheld, used to authenticate a person’s identity by recognizing some part of their body. Jarrison Time is directly compatible with a wide range of biometric devices covering the following means of authentication: Fingerprint, Face, Palm. Tags and PINs can also be accepted if the device supports it.

Bouncing (Shift Sensing)

Bouncing is a system-based method of assigning Day Programs to employees based on their clocking times. The selection of Day Programs the system can apply and when to apply them needs to be configured.