Interface Definition Unit

The organization unit where the data transfer setup component is deployed

Date Format

The date format that is applicable to the login user. Tell me more

Interface Group Description

The interface group description

Interface Type

The interface type to which the interface group type belongs. It will be either Upload or Download

Interface Code

The unique code of the interface

Interface Description

The description of the interface

Interface Method

Select the method of data transfer in the interface. The options available are BCP(Bulk Copy Processing), ASCII and direct.  Bulk copy processing indicates the contents are copied as a bulk. ASCII indicates that the contents are transferred based on row delimiters and column delimiters. External system will directly insert records to conversion table. At present only ASCII interface method is operative

Inactive

Select the check box if you need to disable the interface

ASCII File

Select the path of the ASCII file which is the source file during data upload and destination file while data download

Purge File

Enter the path of the purge file. Purge file is used to store data from the temporary tables before data is cleared or deleted in the temporary tables. The  user can refer to these purge files in future  if required

Column Delimiter

Select the column delimiter from the drop-down list box. The options available are comma, enter char, new line, single quotes, space, tab, tilda

Row Delimiter

Select the row delimiter from the drop-down list box. The options available are comma, enter char, new line, single quotes, space, tab, tilda

Download Procedure

Enter the download procedure used to download data from application tables to ASCII files

Download Table

Select the download table which is an intermediate table used to store data fetched by the download procedure

Conversion Procedure

Enter the conversion procedure used to convert data from ASCII format to SQL format while uploading (interface type is upload) and from SQL format to ASCII format while downloading(interface type is download)

Conversion Table

Select the conversion table, which is an intermediate table, used to store data fetched by the conversion procedure

Validation Procedure

Enter the validation procedure used for performing functional validations of data and data type validations

Validation Table

Enter the validation table which is an intermediate table used to store data fetched by the validation procedure

Error Log

Enter the name of the error log file which is used to log errors during upload. Examples of errors may be validation errors, data type mismatch etc.

Upload with check

Select the check box if you wish to upload the records only after receiving manual confirmation and correction in case of error messages

Updation Procedure

Updation procedures are used for updating data into SQL tables or application tables

Schedule

Select the schedule for data transfer. The options available are daily, weekly and non-recurring. Select daily if you need to do the data transfer daily. Select weekly if you need to do the data transfer once in a week. Select non-recurring if you need to do the data transfer only once

If non-recurring specify date/time

Enter the date and time of  data transfer, if the schedule selected above is non-recurring

Day of week

Select the day of the week in which data transfer should occur if the schedule is recurring(schedule is daily or weekly)

Starting At

Enter the starting time of the data transfer

Ending At

Enter the ending time of the data transfer

Period Type

Select the period type. The options available in the drop-down list box are “At” and “Every” .If you select “At” you need to specify the time, and the data transfer occurs exactly at that time. For example if period type is “At” and “At” = 6.00 pm,  the data transfer occurs exactly at 6.00 pm

If the Period Type is “Every” the data transfer is recurring with respect to the time period mentioned. For example if  period type is “Every”  and the time specified is 5 hours in the “Every” field, then the data transfer reoccurs every 5 hours

At

Enter the time of data transfer if the period type selected above is “At”

Every

Enter the time period in which the  data transfer should reoccur if the period type selected above is “Every”

Comments

Enter the comments related to this screen