Kourier Integrator Online Help

Related Files Entry

Purpose

To define the list of related files or tables to be used by the export specification. Related files are files which share the same exact data structure as the primary export data file, but have their data in either another file (or a "comma file" in MultiValue environments). The Related Files feature in Kourier Integrator allows you to combine information from related files into one SQL table for ease of reporting using just one export specification, saving you time setting up and maintaining you data exports.

It is common for many applications to segment transactional files by year (or using comma files) to save historical information for a file. For example, the current year's General Ledger File might be named GL while the prior year's General Ledger files are named GL-2008 and GL-2007. If using comma files, the archive files might be called GL,GL2008 and GL,GL2007. For more information on using this feature, please refer to the Related Data Files Guide.

Available Toolbar Commands

Click the Done icon in the toolbar to save the current list of related files and return to the export specifications main page.

Click the Cancel icon in the toolbar to close the window and return to the export specifications main page without saving any changes.

Click the Help balloon to open the help for this page.

To save any changes you make after creating or editing the list of related files you must save your changes using either the New, Save, or Save As toolbar commands on the export specifications main page.

File/Key Field

KT_EXPORTS/Export Name

Cautions

Enter valid file names in the list, they are not validated until running a Test or Service.

Fields

Field Name

Description - Usage - Notes

Enter List of Export Files

In the edit text field, enter the name of each related file on a separate line. Use carriage return for additional files.

You should ensure that you only enter valid file names because file names will not be validated during this process. The file names will only be checked when the export specification is run with the Test command, or when processed from within a Service.