From your Advanced Time and Attendance Dashboard, click the Payroll Functions tab and select Imports.
Click on Add New Record.
- Name the import Clock Data Import, (or what ever type of import you are doing)
- Select File Type Delimited
- Delimiter use: ,
- Start import at row 2 (Use position 1 as a header)
- Special formats:
- Decimal separator use: .
- Date format: MM/dd/yyyy hh:mm *MM stands for month, mm stands for minute*
- File Structure (position #’s correlates to columns A, B, C etc. on import template)
- Card ID Position 1
- Start Time Position 2
- End Time Position 3
- Total Time Leave blank
- Punch Type Position 6
- Punch Class Position 1
Now you will see it under your imports
These are the headers for the Clock Data Import template. GP Position, Department, and Work Position Pay Code does not need to be used unless it is required for you company’s setup, (Org Levels or Dimensions).
If it is required by your company setup, you need to add your levels to the Clock Data.
Make sure that you format Start Time & End Time columns, (MM/dd/yyyy HH:mm) each time you use the csv file, they will not keep formatting when closed and opened again.
When you have completed your import template setup, click on save changes and close.
From Imports in ATA, click on Execute on your Clock Data Import.
Click on Choose your File to browse to your import file.
Select your file and click on open.
Click on Upload
If there are no errors, you will receive this message. Click on Ok.
Questions / Resources
If you have questions or comments please email firstname.lastname@example.org.
Find demos, tutorials, and more at our video library.
Last Review: 06/07/2022