Export Process Parameters in IFB

These are the parameters which are only applicable to EIM Export process and are written with in the Process section in an IFB file used for export process. They are :-

ATTACHMENT DIRECTORY

• Optional parameter that specifies the directory path to where the attachments have to be exported.
• This directory path should exist on one of the Siebel server machine.
• In case of remote machine, map the path to a drive and specify the drive name to this parameter.
• Default value is <SIEBEL_HOME>\OUTPUT
• Example: ATTACHMENT DIRECTORY = X:, Where X: is mapped to \\CRMDEV02\siebsrvr\OUTPUT

CLEAR INTERFACE TABLE

• Optional parameter that specifies whether to remove the old records from the EIM table whose batch number corresponds to, as defined in the IFB file.
• Valid values are TRUE or FALSE.
• Default value is TRUE.
• Example: CLEAR INTERFACE TABLE = FALSE
• If this parameter is set to false, and some rows already exist in the EIM table for the specified batch, EIM will throw a warning.

EXPORT ALL ROWS

• This parameter specifies whether to export all rows from the Siebel base tables that were mapped to the particular EIM table specified in the IFB file.
• Valid values are TRUE or FALSE. Default value is FALSE.
• Example: EXPORT ALL ROWS = FALSE
• When you do an export on party EIM tables, set this parameter to FALSE. If not EIM will export all party records.

EXPORT MATCHES

• This parameter optionally specifies criteria that need to be satisfied before exporting the data from the base tables.
• Example: EXPORT MATCHES = S_ORG_EXT, (NAME LIKE “HP%”)
• The literal specified, is the condition that occurs after the WHERE clause in an SQL statement.