Avionté Time and Pay File - Import/Export into Back Office

A company that is using the 24/7 WORK app can use the Avionté Time and Pay File to import during their Time Entry Process in the Back Office. This file can be imported via the Import/Export Menu item in Back Office.

Video

CHAPTERS

Receive Import File
Import Process - Overview
Mapping and Permission Configuration
Import When Additional Overtime Processing Is Needed
Troubleshoot The Import When Errors Occur
Troubleshooting - Error Examples
Reference: File Fields Guide

Receive Import File

The Avionté Time and Pay file will be sent to you via email. This will need to be imported into Avionté Back Office.

Import Process - Overview

The file is loaded using the Import/Export function in the Back Office. 

1. Navigate to Back Office > Import Export.
   
2. Click New Batch.
   
3. Enter a Description for the batch run.
4. Select the Mapping Group of WorkN Time Card Import.
5. Processing Method should auto-populate to WorkN Time Card Import. This would have been configured in Admin Tools > Category: System > Select: Import Export Mapping 
6. Browse for the CSV file downloaded via email you have on your computer that you are going to be importing.
7. In the Parameter section select a Value [week end date] for the Accounting Period parameter. 
8. Click Finish.

• Click “Process Import Export Batch”. If there were any errors, a grid will pop up showing all the lines from the import file, and any lines with errors will have a plus sign at the far left of the row.  Expand out the plus sign to see the error.
  • Note: Nothing will be imported until the file is 100% error-free.

• If the file import ran successfully, you will get a message letting you know that the import was successful, and the import-export batch will automatically be closed.

• Go to Time Entry > Sheetview > Actions > Refresh - the transaction will appear
  

Mapping and Permission Configuration

Upon set up, you will be provided with WorkN terms and asked to "map" these codes to Avionté standards. This is how the Import will know what transaction type to map the employees’ pay records to. As a reminder, WorkN is another name for the 24/7 product.

• To begin, go to Admin Tools > Category: System > Select: Import Export Mapping.
  

• In the Mapping Type Group, select WorkN Time Card Import.
  Ensure under Mapping Type Group Details the Group Code AND Processing Method both are set to WorkN Time Card Import 

• Select the Mapping Type Data tab; enter a Source System Value of "Regular" and a Mapped Value of "Reg;" Save.
  
  
  
• Ensure you have permission for the WorkN Time Card Import under Admin Tools > Report > Advance Query tab > WorkN Time Card Import > User; Save.
  
  
  
• Ensure the Overtime Plan is configured for the Order under Order > Detail > Date > OT Plan
  
  

Import - Basic Steps

1. Open Back Office > Import Export
2. Select Import Export Batch Wizard
   
   
   
3. Fill in the Description.
   
   
   
4. Select Mapping Group = WorkN Time Card Import
5. Click the Browse button; browse your computer to find the export file from the email received, and select it
6. Under Parameter > Accounting Period, select a Value [week end date]
7. Click Finish
8. Click on Process Import Export Batch
   
   
   
9. The pop-up message “The import batch has been processed successfully” will display; click OK
   
10. The Validation and Error screen will open
    
    
    
11. Go to Time Entry > Sheetview > Actions > Refresh - the transaction will appear
    

Import When Additional Overtime Processing Is Needed

1. Open Back Office > Import Export

2. Select Import Export Batch Wizard

3. Fill in the Description.
   
   
   

4. Select Mapping Group = WorkN Time Card Import

5. Click the Browse button; find the export file from the email you received

6. For Parameter > Accounting Period, select a Value [week end date]

7. Click Finish

8. Click on Process Import Export Batch

9. A pop-up message for OT Processing Required appears: “There are transactions that require additional OT Processing. Please press ‘Process OT’ to start.”
   
   
   

10. Click OK. [This occurred because the talent has an existing transaction in Time Entry that the system needs to apply the Overtime calculation against]

11. A pop-up message “The import batch has been processed successfully” will display; Click OK
    
    
    

12. The OT Processing screen will open.
    
    
    

13. Click Process OT

14. A pop-up message appears for Import Export Batch OT Complete “Completed OT Processing;” click OK

15. Go to Time Entry > Sheetview > Actions > Refresh - transaction will appear
    

Troubleshoot The Import When Errors Occur

1. Open Back Office > Import Export

2. Select the Import Export Batch Wizard

3. Fill in the Description.

4. Select Mapping Group = WorkN Time Card Import

5. Click Browse to find the export file from the email received

6. Select a Value [week end date] for the Parameter Accounting Period

7. Click Finish

8. Click on the Process Import Export Batch button

9. The Validation and Error screen opens.
   
   
   

10. A pop-up message “The import batch has been processed successfully” displays.

11. A record with the issue will display with a “+” beside. Click on the "+"

12. An Error Description will display

13. Take the steps to correct the Error, and click on the Process Batch button

    If you have any errors, resolve them in Avionté or on the import file, then try your import again. If you made any changes to the file itself, you would have to discard your import/export batch and make a new batch for the changed file.

    
    
    
    

14. A pop-up message “The import batch has been processed successfully” displays; click OK
    
    
    

15. Go to Time Entry > Sheetview > Actions > Refresh; the transaction will appear

Troubleshooting - Error Examples

• • • Invalid or Missing Mapping: Map this transaction type in Admin Tools > Import Export Mapping on the Mapping Type Data, then reprocess the file. See below for more information.
    • No Active Assignment Schedule Found. This error occurs when an Assignment is not found for a placementId: [######] in the supplier. This indicates that the record belongs to an assignment within a different supplier and cannot be imported into the current Supplier. The User will need to either remove the record from the CSV file, discard the import export batch, and then create a new one from the new file; or, they could flag the record to Ignore from Import by entering a value of True under the NewValue column. Example:
      

Reference: File Fields Guide

Daily File Name standard format: Avionte-Time-And-Pay-Avionte-YYYYMMDD-Daily-0-MMDDYYYY.csv

This is the format for the standard WorkN Daily file that is created to be imported into Classic Back Office.

Column	Details
Transaction Date	WorkN Start Date. For Daily Files, the day the payment transaction is for. Format of MM/DD/YYYY
BOLD Assignment ID	Req Hired ID/Placement ID. A unique identifier that will associate the Supplier and Assignment within Classic. Req Hired ID is visible in the Hired Details flyout within the UI. Placement ID is visible via the Comprehensive Placement Report.
Week Ending Date	The end date of the Pay Period week. Format of MM/DD/YYYY. Is tied to the Classic Back Office Week Worked.
Pay Code	The Pay Code is the earnings to which the time is to be allocated. Logic to accept REG or Regular only. This will create the Reg Type on the Classic Back Office transaction. Should only be sending regular [REG], as the OT Plan will look at regular to apply the OT Plan Rules
Hours	The number of hours to be applied to the pay code. This will create the Pay Units on the CLASSIC Back Office transaction.
First Name	WorkN Employee First Name. Informational only, not used to aid the import.
Last Name	WorkN Employee Last Name. Informational only, not used to aid the import.
BOLD Employee ID	WorkN Avionte Candidate ID. Informational only, not used to aid the import. [Equivalent to BOLD Applicant ID on the Talent URL] WorkN Admin Portal - Avionte Candidate ID BOLD - Applicant ID on the Talent URL
Verifier Name	WorkN name of Verifier. Informational only, not used to aid the import.
Time of Verification	WorkN Date and Time of Verification. Informational only, not used to aid the import.
Branch	WorkN Branch. Informational only, not used to aid the import.
BOLD Job ID
Check-In Time	WorkN Date and Time of Check-in.
Check-In GPS	WorkN GPS coordinates at Check-in.
Check-Out Time	WorkN Date and Time of Check-out.
Check-Out GPS	WorkN GPS coordinates at Check-out.
(1-5) Break Check-In GPS	WorkN GPS coordinates at Break Check-in.
(1-5) Break Check-In Time	WorkN Date and Time at Break Check-in.
(1-5) Break Check-Out GPS	WorkN GPS coordinates at Break Check-out.
(1-5) Break Check-Out Time	WorkN Date and Time at Break Check-out.
(1-5) Break Duration	Length of the break.
Break Penalty (1-5)
Signature First Name	WorkN Signature First Name.
Signature Last Name	WorkN Signature Last Name.
Supervisor Signature URL	Contains the unique URL address that links the image of the Supervisor's Signature for the employee's WorkN time entry transaction to be applied to the Invoice.