Setting Up Employee Exports

To set up an Employee Export:

Note: Due to the page size limitation for DB2 and DB2 z/OS, the column size for each column in the import/export tables are set to 100 by default for performance purposes. The default column size may be insufficient for columns that contain a large amount of data and manual adjustment may be required in order to run import/export tasks successfully. Please contact Infor Support for more details.
  1. Decide on the fields to export and their mapping.
  2. Create or edit the XML export mapping.

    Create or edit the export mapping definition in the Mapping Definitions page. The application is installed with a default Employee Export XML mapping definition called HR EXPORT. This mapping definition exports all the fields listed in the Employee Export Interface Field Specification. See Employee Export Interface Logic.

  3. Specify this information to create a scheduled task in the Job Scheduler (parameters with asterisks (*) are required):
    Task Type*
    Export Task

    Interface Task Parameters:

    Interface Type*
    HR EXPORT
  4. Configure the interface task parameters.

    HR Export Task Parameters:

    Mapping*
    Specify the export mapping definition name that specifies the XML export mapping directives for your employee export. The XML mapping definition must be defined in the Mapping Definitions page. The default Employee Export mapping definition is HR EXPORT - use this definition to map all the employee fields as-is.
    Where Clause

    (Optional) Specify the SQL clause that specifies which employees to filter in the export task. For example: EMP_NAME LIKE 'S%'.

    File Name*
    Specify the path and file name of where the export file is located.
    Performs Difference

    (Optional) Select the Performs Difference check box to specify to only export the employees whose specified attributes in the mapping have changed since the last successful employee export. See Export Record Status Field (Column 2).

    When you run the initial employee export task with this option selected, the application creates two directories: /compare and /new. These directories reside in the same location of the exported output file.

    UDF Definitions To Export (blank for all)

    (Optional) Specify a comma-delimited list of UDF names to export. Leave this field blank to export all UDFs. The maximum number of UDFs to export is 20. Use the database look-up icon to select the available employee UDFs.

    Balances to Export (blank for all)

    (Optional) Specify a comma-delimited list of balance names to export. Leave this field blank to export all balances. The maximum number of balances to export is 10. Use the database lookup icon to select the available balances.

    Create Transaction When No Records Are Found
    (Optional). Select to create an export transaction even if no records are found to export.
    Transmitter Class*

    Specify the transmitter class for the employee export. The standard application installs with these transmitter classes:

    com.workbrain.app.export.process.CSVTransmitter

    This transmitter class exports the data to a file in CSV format:

    com.workbrain.app.export.process.FixedWidthTransmitter

    This transmitter class exports the data to a file in fixed width format. A fixed width definition file must be supplied for this option.