sample ifb file

Siebel Interface Manager]

            USER NAME = "SADMIN"

            PASSWORD = "SADMIN"

            PROCESS = Import All Opty

 

 

[Import All Opty]

            TYPE = SHELL

            INCLUDE = "IMPORT OPTY"

;;          INCLUDE = "IMPORT OPTY POSTN"

            INCLUDE = "IMPORT OPTY CON"

            INCLUDE = "IMPORT OPTY PROD"

            INCLUDE = "IMPORT OPTY SRC"

            INCLUDE = "IMPORT OPTY ATT"

 

 

[IMPORT OPTY]

            TYPE = IMPORT

            BATCH = 1000

            TABLE = EIM_OPTY

            ONLY BASE TABLES = S_OPTY

                       

 

;;[Import OPTY POSTN]

;;          TYPE = IMPORT

;;          BATCH = 2000

;;          TABLE = EIM_OPTY

;;          ONLY BASE TABLES = S_OPTY, S_OPTY_POSTN

;;          INSERT ROWS = S_OPTY, FALSE

;;          UPDATE ROWS = S_OPTY, TRUE

                       

[Import OPTY CON]

            TYPE = IMPORT

            BATCH = 3000

            TABLE = EIM_OPTY

            ONLY BASE TABLES = S_OPTY, S_OPTY_CON

            INSERT ROWS = S_OPTY, FALSE

            UPDATE ROWS = S_OPTY, TRUE

 

 

[Import OPTY PROD]

            TYPE = IMPORT

            BATCH = 1000

            TABLE = EIM_OPTY1

            ONLY BASE TABLES = S_OPTY, S_OPTY_Prod

            INSERT ROWS = S_OPTY, FALSE

            UPDATE ROWS = S_OPTY, TRUE

 

[Import OPTY SRC]

            TYPE = IMPORT

            BATCH = 2000

            TABLE = EIM_OPTY1

            ONLY BASE TABLES = S_OPTY, S_OPTY_SRC

            INSERT ROWS = S_OPTY, FALSE

            UPDATE ROWS = S_OPTY, TRUE

 

[Import OPTY ATT]

 

 

Siebel Interface Manager]

      USER NAME = "SADMIN"

      PASSWORD  = "SADMIN"

      PROCESS   = Export CAMPAIGN Data

 

[Export CAMPAIGN Data]

            TYPE = SHELL

            INCLUDE = "EXPORT CAMPAIGN"

            INCLUDE = "EXPORT CAMP CON"

 

 

[EXPORT CAMPAIGN]

            TYPE = EXPORT

            BATCH = 5000

            TABLE = EIM_SRC

;;          EXPORT MATCHES = (ROW_ID IN ('1-6OXUD','1-VLC0', '1-VLC7', '1-VLCE'))

;;          ONLY BASE TABLES=S_SRC

           

[EXPORT CAMP CON]

            TYPE = EXPORT

            BATCH = 6000

            TABLE = EIM_CAMP_CON

;;          EXPORT MATCHES = (SRC_ID IN ('1-6OXUD'))

;;          ONLY BASE TABLES = S_CAMP_CON

 

The .ifb file should be similar to the following:

 

TYPE = IMPORT

BATCH = 555

TABLE = EIM_CONTACT2

ONLY BASE TABLES = S_PARTY, S_CONTACT, S_CON_ADDR

INSERT ROWS = S_PARTY, FALSE

INSERT ROWS = S_CONTACT, FALSE

INSERT ROWS = S_CON_ADDR, FALSE

UPDATE ROWS = S_PARTY, FALSE

UPDATE ROWS = S_CON_ADDR, FALSE

ONLY BASE COLUMNS = S_PARTY.PARTY_TYPE_CD, S_PARTY.PARTY_UID, \

    S_CONTACT.BU_ID, S_CONTACT.PERSON_UID, S_CONTACT.PRIV_FLG, S_CONTACT.PR_OU_ADDR_ID, \

    S_CON_ADDR.ACCNT_ID, S_CON_ADDR.ADDR_PER_ID, S_CON_ADDR.CONTACT_ID, S_CON_ADDR.ORG_GROUP_ID, \

    S_CON_ADDR.RELATION_TYPE_CD, S_CON_ADDR.START_DT

MISC SQL = EXPR_S_CONTACT_PR_OU_ADDR_ID

LOG TRANSACTIONS = FALSE