Siebel Enterprise Integration Manager Administration Guide > EIM: Examples of Common Usage > EIM Import Process Examples >

Visibility of Fields: Example of Importing Employees

This example is specific to Siebel Industry Applications.

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 = "SADMIN"

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