Scheduling the ERP Work Detail Export Task

You can schedule the ERP Work Detail Export Task to export the timesheet data for specified dates and employees.

  1. In the Workforce Management application, select Maintenance > System Administration > Job Scheduler.
  2. Click Add Schedule.
  3. Specify a description in the Task Description field.
  4. Select Java Task in the Task Type field.
  5. Select ERPWorkDetailExportTask from the drop-down list.
  6. Complete the Scheduled Time, Scheduling Time, Blackout Period, and Scheduling Range sections as required.
  7. Click Submit and click OK.
  8. Locate the newly created task using the task description.
  9. Click Parameters.
  10. Specify this information:
    Interface Type
    Select WORK DETAIL EXPORT from the lookup.
    Export Task
    Select WORK DETAIL EXPORT from the lookup.
    Apply to Locations
    Optionally, select locations from the lookup to limit the employees included in the generated export file. Employees must belong to a selected location for each date being processed. If an employee does not belong to that location on one of those days, that day's data will be excluded from the export.
    Days to Export
    Select one of these options:
    • Relative: This is the default option and is expected to be used on an ongoing basis. This option allows you to export timesheet records for a date range relative to the current date (the date the task is running). In this configuration, the task will always export today's data. Additional data can also be included by setting the Days Before Current Date and Days After Current Date values. For example, if Days Before Current Date is set to 1 and Days After Current Date is set to 0, the relevant timesheets for today and the previous day will be exported.
    • Absolute: This option allows you to define an explicit data range to be exported. For example, you can use this option if there is a problem with the usual ongoing export and a file must be re-generated.
    Write to Staging Table
    Select this check box to write the timesheet data into the staging table(s).
    Write to File
    Select this check box to write the timesheet data into a CSV file.
  11. Click Submit and click OK.