The Timesheet Import module allows time and attendance information that is captured outside of the FastTrack360 system to be imported into the system so that electronic timesheets can be created, approved, paid and billed.
The Timesheet Import module imports timesheets via an import batch process, which groups together a collection of timesheet data that is processed together to create timesheets within the FastTrack360 Time and Attendance module. The timesheet import batch process consists of the following general steps:
Uploading the timesheet import file.
Defining the field mapping.
Queuing the timesheet import batch for processing. Each of these steps is described in more detail below.
| Info |
|---|
...
When keying in timesheets, the UI does not support negative values, however via Timesheet Import please be aware that negative values if included will be imported. Where an imported timesheet with a negative value is approved, the negative value will display in the interpreted timesheet. |
In addition to the information provided in the following sections of the online help, you can download the following Timesheet Import User Guide for more information about using the Timesheet Import module (click on the icon below to download).
| View file | ||
|---|---|---|
|
Uploading the Timesheet Import File
...
A set of field mappings that are configured when importing a timesheet import file can be saved as a template, which can be applied whenever an import file that originates from the same source is processed in the future. This prevents the need to manually configure the field mapping each time an import is processed. For more information, see Saving Field Mapping Templates.
Queuing the Import Batch for Processing
...
If the validation succeeds the import batch is sent to the Process Queue, where the batch undergoes processing. The amount of time that it takes for a queued batch to complete processing depends on a number of factors such as the following:
the number of prior import batches already queued for processing the number of individual rows within the import file.
...
any timesheets that can be successfully created based on the data in the import file are created in the Time and Attendance module and the status of the timesheets is set to Submitted
the status of the batch is set to Completed or Completed with Exceptions.
Notifications if applied to the related Timesheet Workflow will dispatch as follows:
Instant: will not dispatch as a mass trigger of notifications following import may compromise system performance for users.
Scheduled: will dispatch to ensure that where the imported timesheets have not yet been approved, reminders will be sent to the approver(s) allocated in the Timesheet Workflow.
Once the processing of an import batch is completed you can do the following:
...
If a system error occurs when an import batch is queued for processing the status of the batch will be set to Failed and no timesheets will be created in Time and Attendance. If this occurs, you will need to process the original import file as part of a new timesheet import batch.
| Child pages (Children Display) |
|---|