Reseller Sign-In/Apply

Reseller Zone

Welcome

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

Welcome

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

Welcome

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 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

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.

Area

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