INSERT，需将公司ID匹对到以下EXCEL表
INSERT，需将公司ID匹对到以下EXCEL表
[Public]
ConnectString=host="siebel://10.10.0.46:2321/HC_CRM/SMObjMgr_chs
ConnectUserName=SADMIN
ConnectPassword=Apex#0111
RepositoryName=Siebel Repository
EXCEL_SHEET_NAME=Sheet1
HierarchyLevel=1
ProcessNum=10
[Object]
BOName=Account
BCName1=UT Account Infrastructure
BCName2=
BCName3=
[Field]
ActiveField1=APEX Sales Organization,APEX Sales Channel,APEX Price Group,APEX Trade Condition,Condition Description,APEX Crurecy,APEX Account Kemu Group,APEX Sales Division,NR SCC,APEX Tax Type,NR Price Group,Connection Status,Service Type,APEX Account Kemu Group Code
ActiveField2=
ActiveField3=
Field1=APEX Sales Channel,分销渠道;Condition Description,条款说明;APEX Account Kemu Group,客户等级;Connection Status,状态;Service Type,是否同步到SAP;APEX Account Kemu Group Code,公司表ID;NR SCC,是否SCC客户
Field2=
Field3=
[PickMapField]
PickMapField1=APEX Sales Organization,Pay Condition Code,销售组织;APEX Price Group,Pay Condition Code,销售地区;APEX Trade Condition,Pay Condition Code,国际贸易条款;APEX Crurecy,APEX SAP Crurrency Code,货币;APEX Sales Division,Group Code,销售组,Pay Condition Code,销售部门;NR Price Group,Pay Condition Code,价格组;APEX Tax Type,Low,税分类
PickMapField2=
PickMapField3=
[MVGField]
MVGField1=
MVGField2=
MVGField3=
[KeyField]
KeyField1=
KeyField2=
KeyField3=
导入成功后保存下来，记录ID值
备注：
提交数据后需要删除
方一：在数据库中删除
SELECT * FROM S_ORG_EXT_XM ORDER BY LAST_UPD DESC
DELETE FROM S_ORG_EXT_XM WHERE row_id in ('1-42QOE
1-42QOD
1-42QOA
1-42QOB
1-42QOC
1-42QO9
1-42QO6
1-42QO5
1-42QO8
1-42QO7')方二：
EXCEL模板
[Public]
ConnectString=host="siebel://10.10.0.46:2321/HC_CRM/SMObjMgr_chs
ConnectUserName=SADMIN
ConnectPassword=Apex#0111
RepositoryName=Siebel Repository
EXCEL_SHEET_NAME=Sheet1
HierarchyLevel=1
ProcessNum=10
[Object]
BOName=Account
BCName1=UT Account Infrastructure
BCName2=
BCName3=
[Field]
ActiveField1=Id
ActiveField2=
ActiveField3=
Field1=Id,CRMID
Field2=
Field3=
[PickMapField]
PickMapField1=
PickMapField2=
PickMapField3=
[MVGField]
MVGField1=
MVGField2=
MVGField3=
[KeyField]
KeyField1=Id,CRMID
KeyField2=
KeyField3=
执行成功后如图