Setting up Generic Table Imports
To set up a Generic Table Import:
- 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.
- Select Maintenance > System Administration > Interfaces > Mapping Definitions.
- Create an XML mapping definition for each table import. See Generic Table Import XML tag reference.
-
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.
- Select Maintenance > System Administration > Interfaces > Interface Types.
- Add an interface type for your table import.
-
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
-
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.
-
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.
-
Use the Job Scheduler to run the import process.
See Job Scheduler.