Adding import tasks to the Job Scheduler

The import task imports the CSV file from a file location on the Job Scheduler or file server into the application import staging table (WBINT_IMPORT). The CSV file is imported without any validation, with each field being processed into the fields of the import staging table in the order that they appear.

These steps apply to CSV format input files.

To add an import task to the Job Scheduler:

  1. Select Maintenance > System Administration > Job Scheduler.
  2. Click Add Schedule.
  3. In the Task section, specify this information:
    Task Description
    Specify the description of the task. The name must be unique and descriptive to help users identify the task.
    Task Type
    Select Import Task.
    Task Affinity
    Assign the task to a specific scheduler to be run. By assigning tasks to various schedulers, the system can distribute the running of tasks across different schedulers, which may be running on different computers.

    A scheduler is the process that performs task runs. Schedulers can be unique and individually named. Task affinity names are the names of the schedulers. Schedulers are run separately from the application server; you can have 50 schedulers running for one application server. By default, your task is run on the unnamed default scheduler.

  4. In the Scheduled Time section, specify this information:
    Run at
    Specify the time of day to run the task.
    Timezone
    Change the time zone, if required. By default, your local time zone is used.

    For example, if a user in Mumbai, India schedules a task to run at 6:00PM Asia/India time zone (default), the task is run at 6:00PM their local time (GMT+5).

    If a user in Mumbai, India schedules a task to run at 6:00PM American/New York time zone, the task is run at 6:00PM EST (GMT-5).

  5. In the Scheduling Time section, select one of these four options:
    • Once: To schedule only one run of this task.
    • Daily: To schedule runs in intervals of days or seconds. Complete one of these two fields:
      • Every ... Day(s): Specify the number of days between runs.
      • Interval ... Second(s): Specify the number of seconds between runs. The application allows for a minimum of 5 seconds between runs (-1 indicates that the field is not used).
    • Weekly: To schedule runs by day of week. Select the check boxes to indicate on which days of the week the task is to be run.
    • Monthly: To schedule runs by month, and by day of month. Select one of these two options:
      • Day ... Of: Specify the day of month to indicate on which date the task is to be run.
      • Of: Select the week of the month (for example, Second) and the day of week (for example, Thursday) from the drop-down lists to indicate on which day the task is to be run.

      Select the check boxes to indicate on which months of the year the task is to be run. If you do not select a month, the task is not run.

  6. In the Scheduling Range section, specify this information:
    Start On
    Specify the start date of the task run.
    End By
    Optionally, specify the end date of the task run. To run the task indefinitely, leave the field blank.
  7. Click Submit.
    If the task was successfully scheduled, the confirmation message "Task Successfully Scheduled" is displayed.
  8. Click OK.
    The new import task is displayed in the list on the Job Scheduler Task Schedules page.
  9. Click Parameters corresponding to the import task.
    The Import Task page is displayed.
  10. Specify this information:
    Import Type
    Select the interface type to be imported. See Viewing available interface types.
    Transformer Class Name
    Specify the Java class that implements the import task to translate the CSV format into the staging table. For the Java class names, see the specific standard import interface. Select the Use Default Transformer check box to use the transformer that is associated with the selected interface type.
    Transformer Script Name
    Specify the Groovy extension script that implements the task to translate the file into the staging table.
    Note: If you don't see the Transformer Script Name field, clear the Use Default Transformer check box.
    File Name
    Specify the file name, including the absolute path to the CSV import file. The file must be on the Job Scheduler or file server.
    UTF-8 Encoded
    Optionally, select this check box if the incoming file is UTF-8 encoded.
    Performs Difference
    Optionally, select this check box if you want the import task to perform a difference between the CSV file and the CSV file of the previous run import task. Only the information that is different is imported into the staging table.

    Two directories (/compare and /new) are created in the same location as the import file for the performs difference function.

    When you run an import task, the application creates an /old directory in the same directory where the CSV file resides. The CSV file is moved into the /old directory with the date and timestamp appended to the file name after the import task is executed. This copy of the CSV file is compared to the future CSV file during the next run of the import task

    Delimiter
    This field is hidden by default and is optional.

    Use the Delimiter drop-down field to select a delimiter for the CSV import file. The default delimiter is a comma (,).

    For information on using different delimiters, see Setting up imports.

    Do Not Fail Task if File is Not Located
    This check box is hidden by default and is optional.

    Select this check box if you do not want the import task to fail if the file is not available or not found. An error is logged in the log file rather than a failure. The failure count (No. Of Failures) in the Job Scheduler screen will not be incremented if the task fails due to the file not being found.

    File is PGP Encrypted
    This check box is hidden by default and is optional.

    Select this check box when you are importing a PGP encrypted file into WFM. After import, the encrypted file is placed in the OLD directory on the Job Scheduler machine.

    Encrypt Bad File
    This check box is hidden by default and is optional.

    Select this option to maintain file encryption in the event Job Scheduler fails to import the file and places it in the BAD directory.

    For more information on enabling these fields and setting up PGP encryption for file imports, see "File Encryption Using the PGP Library" in the Infor Workforce Management Multi-tenant Configuration Guide.

  11. Click Submit.
  12. Click OK.