Setting up Generic Table Imports

To set up a Generic Table Import:

  1. Decide on what data and what table to import and create the CSV data file. For information about field columns and formats, see the Workforce Management database schema.
  2. Select Maintenance > System Administration > Interfaces > Mapping Definitions.
  3. Create an XML mapping definition for each table import. See Generic Table Import XML tag reference.
  4. Specify this information:
    Mapping Name
    Specify the Generic Table Import mapping name. For example, SO BUDGET PAY COST TABLE IMPORT.
    Import Table
    TABLE_IMPORT_CONFIGURATION

    By default, the Import Table field is not displayed. You must use config mode to configure this field to display and become editable. See Using config mode.

    Mapping Description
    Specify the mapping description.
    XML
    Insert your XML mapping definition in this field.
  5. Select Maintenance > System Administration > Interfaces > Interface Types.
  6. Add an interface type for your table import.
  7. Specify this information:
    Interface Type
    Specify the Generic Table Import Interface type name. For example, SO BUDGET PAY COST TABLE IMPORT.
    Type
    Import
    Wbityp Javaclass
    com.workbrain.app.wbinterface.table.TableTransaction
    Default Transformer Class
    com.workbrain.app.wbinterface.table.TableTransformer
  8. Specify this information to create a scheduled import task in the Job Scheduler:
    Task Type
    Import Task
    Import Task Parameters: Interface Type
    Select the interface type you created in Step 3.
    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.
  9. Specify this information to create a scheduled interface task in the Job Scheduler:
    Task Type
    Interface Task
    Interface Task Parameters: Interface Type
    Select the interface type you created in Step 3.
    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 created in Step 2.
  10. Use the Job Scheduler to run the import process.