首页 > 代码库 > S导入部门数据

S导入部门数据

技术分享

技术分享

导入部门数据分两步骤,EXCEL模板可以一样

一、导入部门主数据,导入时选择INSERT

[Public]ConnectString=host="siebel://10.10.0.43:2321/HC_CRM/SMObjMgr_chsConnectUserName=SADMINConnectPassword=Apex#0111RepositoryName=Siebel RepositoryEXCEL_SHEET_NAME=Sheet1HierarchyLevel=1ProcessNum=10[Object]BOName=Internal DivisionBCName1=Internal DivisionBCName2=BCName3=[Field]ActiveField1=Name,Type,Organization Flag,APEX Region NameActiveField2=ActiveField3=Field1=Name,部门;Type,组织类型;Organization Flag,组织标志;Field2=Field3=[PickMapField]PickMapField1=APEX Region Name,Name,区域名称PickMapField2=PickMapField3=[MVGField]MVGField1=MVGField2=MVGField3=[KeyField]KeyField1=Name,部门KeyField2=KeyField3=

 

二、根据部门更新父部门、责任人和职位,导入时选择UPDATE

[Public]ConnectString=host="siebel://10.10.0.46:2321/HC_CRM/SMObjMgr_chsConnectUserName=SADMINConnectPassword=Apex#0111RepositoryName=Siebel RepositoryEXCEL_SHEET_NAME=Sheet1HierarchyLevel=1ProcessNum=10[Object]BOName=Internal DivisionBCName1=Internal DivisionBCName2=BCName3=[Field]ActiveField1=Name,Partner Manager PositionActiveField2=ActiveField3=Field1=Name,部门Field2=Field3=[PickMapField]PickMapField1=Partner Manager Position,Name,职位PickMapField2=PickMapField3=[MVGField]MVGField1=MVGField2=MVGField3=[KeyField]KeyField1=Name,部门KeyField2=KeyField3=

 

S导入部门数据