FastTrack360 Version 12 Online Help
Searching for Existing Timesheet Import Batches
- Fiona Sims
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.
Related content
Classification-Public