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=
执行成功后如图