Visibility of Fields: Example of Importing Employees

This example provides a sample .IFB file for importing employees. The employee visibility depends on S_CONTACT_BU to resolve the organization, S_POSTN_CON for the position, S_PER_RESP for responsibility, and S_PARTY_PER for the relationship between the S_PARTY and S_CONTACT.

[Siebel Interface Manager]
      USER NAME = "SADMIN"
      PASSWORD = "********"
      PROCESS = Import New Employee
[IMPORT New Employee]
TYPE = SHELL
INCLUDE = "Import Employee"
INCLUDE = "Import Contact"
INCLUDE = "Import Contact1"
[Import Employee]
      TYPE = IMPORT
      BATCH = 666
      TABLE = EIM_EMPLOYEE
ONLY BASE TABLES = S_PARTY, S_CONTACT, S_EMP_PER, S_PARTY_PER, S_PER_RESP, S_USER
; For S-contact
DEFAULT COLUMN = CON_ACTIVE_FLG, "Y"
      DEFAULT COLUMN = CON_DISACLEANSEFLG, "N"
      DEFAULT COLUMN = CON_EMAILSRUPD_FLG, "N"
      DEFAULT COLUMN = CON_DISPIMGAUTHFLG, "N"
      DEFAULT COLUMN = CON_EMP_FLG, "Y"
      DEFAULT COLUMN = CON_PO_PAY_FLG, "N"
      DEFAULT COLUMN = CON_PRIV_FLG, "N"
      DEFAULT COLUMN = CON_PROSPECT_FLG, "N"
      DEFAULT COLUMN = CON_PTSHPCONTACTFL, "N"
      DEFAULT COLUMN = CON_PTSHPKEYCONFLG, "N"
      DEFAULT COLUMN = CON_SENDSURVEY_FLG, "N"
      DEFAULT COLUMN = CON_SUPPRESSEMAILF, "N"
      DEFAULT COLUMN = CON_SUPPRESSFAXFLG, "N"
; For vertical version
      DEFAULT COLUMN = CON_COURT_PAY_FLG, "N"
      DEFAULT COLUMN = CON_INVSTGTR_FLG, "N"
      DEFAULT COLUMN = CON_SPEAKER_FLG, "N"
      DEFAULT COLUMN = CON_SUSPECT_FLG, "N"
; For S-EMP_PER
DEFAULT COLUMN = ACCEPT_SR_ASGN_FLG, "N"
      DEFAULT COLUMN = CNTRCTR_FLG, "N"
      DEFAULT COLUMN = INT_NEWS_APPR_FLG, "N"
      DEFAULT COLUMN = EMP_CPFINALAPPRFLG, "N"
      DEFAULT COLUMN =  STORE_BUDGET_FLG, "N"
      DEFAULT COLUMN = STORE_FORECAST_FLG, "N"
[Import Contact]
TYPE = IMPORT
        BATCH = 666
        USE INDEX HINTS = TRUE
TABLE = EIM_CONTACT
ONLY BASE TABLES = S_PARTY, S_CONTACT_BU 
[Import Contact1]
TYPE = IMPORT
        BATCH = 666
TABLE = EIM_CONTACT1
ONLY BASE TABLES = S_PARTY, S_CONTACT, S_POSTN_CON