Setting up generic table imports

You must first decide what data and what table to import and create the CSV data file.

See Creating CSV files.

For information about field columns and formats, see the Workforce Management database schema.

  1. Select Maintenance > System Administration > Interfaces > Mapping Definitions.
  2. Click Create New Entry.
  3. Specify this information:
    Mapping Name
    Specify the mapping name, such as SO BUDGET PAY COST TABLE IMPORT.
    Import Table
    TABLE_IMPORT_CONFIGURATION
    Note: By default, the Import Table field is not displayed. You must use config mode to show this field and to make it editable.

    See "Using config mode" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.

    Mapping Description
    Specify a description of the mapping.
    XML
    Insert your XML mapping definition in this field.

    See Generic Table Import XML tag reference.

  4. Click Save.
  5. Select Maintenance > System Administration > Interfaces > Interface Types.
  6. Click Create New Entry.
  7. Specify this information:
    Interface Type
    Specify the interface type name, such as SO BUDGET PAY COST TABLE IMPORT.
    Type
    Select Import.
    Wbityp Javaclass
    Specify com.workbrain.app.wbinterface.table.TableTransaction.
    Default Transformer Class
    Specify com.workbrain.app.wbinterface.table.TableTransformer.
  8. Click Save.
  9. Specify this information to create a scheduled import task in the Job Scheduler:
    Task Type
    Select Import Task.
    Import Task Parameters: Import Type
    Select the interface type that you created in the Interface Types page.
    Import Task Parameters: Transformer Class Name
    Select the Use Default Transformer check box to use the transformer that is defined in the interface type, unless you want to use an alternate transformer class or a transformer script.
  10. Specify this information to create a scheduled interface task in the Job Scheduler:
    Task Type
    Select Interface Task.
    Interface Task Parameters: Interface Type
    Select the interface type that you previously created in the Interface Types page.
    Interface Type Specific Parameters: Mapping Name
    Specify the name of the XML mapping definition that translates, inserts, or updates the application table. Select the mapping definition that you previously created in the Mapping Definitions page.
  11. Use the Job Scheduler to run the import process.
    See "Job Scheduler" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide.