Define Interface Group – A summary of the activity

Data Transfer Setup - An overview

What you can do in this activity

Interface Utility:  Interface Utility is used to interface between external applications such as Notepad / ASCII files and the application tables such as SQL. The main objectives of the utility are:

Interface Group: Before defining interfaces, you are to define interface groups based upon whether the interface

After defining the interface groups, you can proceed to create multiple interfaces, and assign each interface to an interface group.

Upload or download: You must specify the type to which the interface group belongs, based on interface modes such as upload or download. If you specify the interface type to be “Upload” the interface will be used for uploading data from ASCII files to the application tables.

If you specify the interface type to be Download, the interface will be used for downloading data from the application tables to the ASCII files.

Partial upload: If you had specified “Upload”, you can further specify whether partial upload is allowed or not allowed. If you specify “Partial upload“ the interface will upload data even if any error messages are logged. Errors, such as non-conformity of the data type, data range, values etc, may be logged in during data validation. When “partial upload” is specified, the system will upload records other than those that contain errors.

You can disable partial upload, if you wish to abort the upload process if any error is logged. You can also disable the interface group. See Interface Utility Process

Getting familiar with the pages inside

Use the page…

…to carry out task

Define Interface Group

Defining interface group

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Prerequisites

User permissions must be set for the login user in Security Definitions component.

The date format must be set in User Preferences component

 

 

 

 

 

 

 

 

 

 

 

 

What you can do in this activity

To define interface groups

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

To define interface groups

You can define interface groups for a data transfer setup component.