Searching for Existing Timesheet Import Batches

You can search for and list existing Timesheet Import batches that have been queued for processing, have completed processing, have been saved prior to being queued for processing or that have failed to process successfully.

Depending on the status of the import batch, you can do the following once you have listed an existing batch:

view information about the batch, such as the its status, processing date and the number of timesheets included in the batch
download the original import file that is associated with the batch
download the exception report that lists the rows from the import file that have failed to import
download the validation report that lists the rows from the import file that were imported successfully
view a list of timesheets that were successfully created in Time and Attendance as a result of processing the import batch.

To search for an existing timesheet import batch, follow the procedure below.

1.

Navigate to Time and Attendance > Timesheet Import.

The Manage Import Batches screen opens.

2.

In the Search Options tab at the top of the screen, key in or select as much information about the import batch you want to find as possible.

From Batch Number

Lowest batch ID that uniquely identifies a timesheet import batch. To find batches with a batch number equal to or greater than a specific batch number, key in the relevant batch number in this field. You can use this field in conjunction with the To Batch Number field to list batches that fall within a specific range of batch numbers.

To Batch Number

Highest batch ID that uniquely identifies a timesheet import batch. To find batches with a batch number equal to or less than a specific batch number, key in the relevant batch number in this field. You can use this field in conjunction with the From Batch Number field to list batches that fall within a specific range of batch numbers.

Start Date From

Earliest date on which the timesheet import batch was created. To list batches that were create on or after a specific date, click within this field and use the calendar control to select the relevant date. You can use this field in conjunction with the Start Date To field to list batches that were created within a specific date range.

Start Date To

Latest date on which the timesheet import batch was created. To list batches that were create on or before a specific date, click within this field and use the calendar control to select the relevant date. You can use this field in conjunction with the Start Date To field to list batches that were created within a specific date range.

End Date From

Earliest date on which processing of the timesheet import batch completed. To list batches that completed processing on or after a specific date, click within this field and use the calendar control to select the relevant date. You can use this field in conjunction with the End Date To field to list batches that ended processing within a specific date range.

End Date To

Latest date on which processing of the timesheet import batch ended. To list batches that ended processing on or before a specific date, click within this field and use the calendar control to select the relevant date. You can use this field in conjunction with the End Date From field to list batches that ended processing within a specific date range.

Status

Status of the timesheet import batch. This defaults to Any, thereby allowing you to list existing batch regardless of their status. To list only those batches that have a specific status, select one of the following options:

- Completed - if selected, only batches that have been successfully processed without any exceptions will be listed

- Completed with Exceptions - if selected, only batches that have been successfully processed with one or more exceptions will be listed

- Queued - if selected, only batches that are currently queued for processing will be listed

- Open - if selected, only batches that have been created but are yet to be queued for processing will be listed

- Failed - if selected, only batches that were queued for processing but failed due to a system error will be listed.

3.

Click Search.

The Batch List section of the screen lists the Timesheet Import batches that match the search criteria you have specified.

The Batch List section of the screen displays column of information about each of the Timesheet Import batches that are listed in the screen.

Batch Number

Displays the batch ID that uniquely identifies the listed Timesheet Import batch.

If the batch status is Open, you can click on the batch number to open the batch in the Import Wizard, which will allow you to complete the batch import process or to cancel the batch if necessary.

Start Date

Displays the date on which the listed Timesheet Import batch was created.

If the batch status is Open, you can click on the start date to open the batch in the Import Wizard, which will allow you to complete the batch import process or to cancel the batch if necessary.

End Date

Displays the date on which the listed Timesheet Import batch was completed. This column is blank for batches that have a status of Open, Queued or Failed.

Status

Displays the current status of the listed Timesheet Import batch, which may be any of the following:

Completed - indicates that the batch completed processing successfully without any exceptions
Completed with Exceptions - indicates that the batch completed processing successfully with one or more exceptions
Queued - indicates that the batch has been queued for processing but is yet to be processed
Open - indicates that the batch has been created but is yet to be queued for processing
Failed - indicates that the batch was queued for processing but a system error prevented the batch from being processed successfully.

If the batch status is Open, you can click on the batch number to open the batch in the Import Wizard, which will allow you to complete the batch import process or to cancel the batch if necessary.

No. of Timesheet in Batch

Displays the number of individual timesheets that were included in the original import file for the listed Timesheet Import batch. This column is blank unless the status of the listed batch is Completed or Completed with Exceptions.

No. of Timesheets Imported

Displays the total number of timesheets that were imported successfully as a result of processing the listed Timesheet Import batch. This column is blank unless the status of the listed batch is Completed or Completed with Exceptions.

No. of Exceptions

Displays the total number of exception errors that occurred as a result of processing the listed Timesheet Import batch. This column is blank unless the status of the listed batch is Completed with Exceptions.

No. of Leave Request Warnings

Displays the number of leave request warnings that were generated as a result of processing the listed Timesheet Import batch. A leave request warning is generated if an attendance item in the import file clashes with an existing, approved leave request on the same date. This column is blank unless the status of the listed batch is Completed or Completed with Exceptions.

For more information, see Leave Request Warnings.

Created By

Displays the username of the user who created the listed Timesheet Import batch.

Imported By

Displays the username of the user who queued the listed Timesheet Import batch for processing.

If the batch status is Open, you can click on the batch number to open the batch in the Import Wizard, which will allow you to complete the batch import process or to cancel the batch if necessary.

Source

Displays the origin of the corresponding timesheet import file, if a source was selected when the file was imported.