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.

Serveture_Time_and_Pay_file_email.png

 

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.

mceclip0.png

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

Import_Export_-_Home.png

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

The_import_batch_has_been_processed_successfully.png

  • Go to Time Entry > Sheetview > Actions > Refresh - the transaction will appear
    Time_Entry_-_Sheet_View.png

 

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.
    Admin_Tool_-_System_-_Import_Export_Mapping.png

 

  • In the Mapping Type Group, select WorkN Time Card Import.Import_Export_Mapping_Type.png
    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.
    Mapping_Type_Data.png

  • Ensure you have permission for the WorkN Time Card Import under Admin Tools > Report > Advance Query tab > WorkN Time Card Import > User; Save.
    Admin_System_Server_Report.png

  • Ensure the Overtime Plan is configured for the Order under Order > Detail > Date > OT Plan
    Order_-_Detail.png

 

Import - Basic Steps

  1. Open Back Office > Import Export
  2. Select Import Export Batch Wizard
    Import_Export_Batch_Wizard.png

  3. Fill in the Description.
    Import_Export_Batch_-_WorkN.png

  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
    Process_Import_Export_Batch.png

  9. The pop-up message “The import batch has been processed successfully” will display; click OK
  10. The Validation and Error screen will open
    Validation___Error.png

  11. Go to Time Entry > Sheetview > Actions > Refresh - the transaction will appear
    Time_Entry_-_Sheet_View.png

Import When Additional Overtime Processing Is Needed

  1. Open Back Office > Import Export

  2. Select Import Export Batch Wizard

  3. Fill in the Description.
    Import_Export_Batch_-_Import_Batch.png

  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.”
    OT_Processing_Required.png

  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
    The_import_batch_has_been_processed_successfully.png

  12. The OT Processing screen will open.
    OT_Processing.png

  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
    Time_Entry_-_Sheet_View.png

 

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.
    Validation___Error__detail_.png

  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.


    V_E_-_Process_Batch.png

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

  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:
        Error_-_Ignore_from_Import.png

 

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.

WorkN_CSV_File.png

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

WorkN Assignment ID. A unique identifier that will associate the Supplier and Assignment within Classic. This ID is stored in the database only and is not visible on the UI. 

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

 

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.

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share