Punch Imports
Use this option to import
time clock punches into the TimeForce database from an Excel spreadsheet.
Click on the main Admin
navigation tab, and then on the Imports
link located under the System Tools
section of the screen. The main “Imports” screen opens. Click on the Import Punches link.
File Layouts
The data file must be formatted
correctly in order to be imported by the TimeForce system. The file format
is displayed on the right-hand side of the main “Punch Imports” screen.
Downloading a Template
To download a blank Excel
spreadsheet that is formatted correctly, click on the Download
Excel Template link located above the displayed file layout. In
the File Download box that appears,
click on [SAVE] and browse to the location where you would like the template
to be saved. You can then open the template file and enter your employee
information directly into this spreadsheet file.
IMPORTANT:
The punches contained in the Excel file must be in order of date. All
fields in the punch import file require a value. To skip a certain type
of data, insert a “0” into the field instead of leaving the field blank.
Importing Time Clock Punches
From
the main “Punch Imports” screen, click on the [BROWSE] icon located to
the right of the Select a file to import
field. Browse
to the location where the desired import file is stored. Either double-click
on the file to select it, or highlight the file and click on the [OPEN]
icon. The selected path and file name are displayed in the Select
a file to import field. Click on the [IMPORT] icon
to import the data from the spreadsheet file. |