This article explains how to extract a payroll file from Timerack and import it into Avionté. 

Time Import Configuration (One-time Initial Setup)

Generate payroll file in Timerack

Import file into Avionté

Time Import Configuration (One-time Initial Setup)

For a user to access the Time Rack time import in Avionté, the user will need to have permissions to the time import in Avionté's Admin Tools. Follow the below steps to grant users access to import time from Timerack.

1) Open Admin Tools.

2) Click Report.

3) Click the Advance Query tab.

4) Filter for the Time Rack Import and click it.

5) Select the User radio bubble.

6) Find the user that needs access.

7) In the Advance Query Users section on the right, mark the checkbox next to the username of the User(s) who need access to import time.

8) Click the Save button.

Generate payroll file in Timerack

2) Use the Pay Period Policy dropdown menu to select the Pay Schedule for which you want to extract data. 

3) Use the Pay Period dropdown menu to select the Pay Period for which you want to extract data. 

4) Mark the checkboxes in the Select Level section to select the Organization Levels for which you want to extract data.

5) Click the Fetch button.

6) Check for errors by using the scroll bar on the right of the data to scroll down the list. Correct all timecard errors and then repeat steps 1-5.

Red asterisk (*) before First Name	Punch is not attached to an assignment on timecard
Red asterisk (*) after Last Name	Timecard is missing the In or Out punch (punch is unpaired)

7) Click the Save File Only button.

8) Enter the Password associated with your Timerack login credentials.

9) Click OK.

10) A message will display at the top of the page that Payroll submitted successfully. Click OK to dismiss the message.

11) Click Payroll History.

12) Locate the applicable file in the list (most recent will appear on top). In the Action column, click the button with the red arrow pointing down to download the file to your computer.

Import file into Avionté

1) Navigate to the Import Export section

2) Click New Batch

3) From the Mapping Group drop-down menu, choose Time Rack Mapping. This selection will also default the Processing Method to Time Rack Import.

4) Enter a free-text description in the Description field

5) Click the Browse button and select the Timerack pay file to import

1. Note: A run-time error will populate if the file you are importing is open on your computer. Be sure to close the file before attempting to import.

6) Indicate if the pay file contains column headers

7) Select the proper Accounting Period Date from the Parameter section

8) Enter a free-text description in the TimeEntry Batch Name field

9) Click Finish. The New Batch window will close.

10) Click Process Import Export Batch.