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
|