其实没有这么复杂,将雇佣状态列输入10表示在职,人员类别列输入101表示正式再导入就正常了。
问题原因在于实施工具这两列只识别编码,可是编写工具人员忘写标注说明了。
我和你一样也有同样的问题,先导入部门档案,再导入人事档案成功,在系统里发现没有数据,后来经过检查发现人事档案有两个表,而我们只导入了一个。
--导入部门档案
delete from UFDATA_003_2012.dbo.Department
insert into UFDATA_003_2012.dbo.Department
(cDepCode,bDepEnd,cDepName,iDepGrade,cDepPerson,cDepProp,cDepPhone,cDepAddress,cDepMemo,iCreLine
,cCreGrade,iCreDate,cOfferGrade,iOfferRate,bShop,cDepGUID,dDepBeginDate,dDepEndDate,vAuthorizeDoc
,vAuthorizeUnit,cDepFax,cDepPostCode,cDepEmail,cDepType,bInheritDutyBasic,bInheritWorkCalendar
,cDutyCode,cRestCode)
select cDepCode,bDepEnd,cDepName,iDepGrade,cDepPerson,cDepProp,cDepPhone,cDepAddress,cDepMemo,iCreLine
,cCreGrade,iCreDate,cOfferGrade,iOfferRate,bShop,cDepGUID,dDepBeginDate,dDepEndDate,vAuthorizeDoc
,vAuthorizeUnit,cDepFax,cDepPostCode,cDepEmail,cDepType,bInheritDutyBasic,bInheritWorkCalendar
,cDutyCode,cRestCode
from UFDATA_002_2012.dbo.Department
其实人事档案有两个表
--删除目标数据表数据(第一个表)
delete from UFDATA_003_2012.dbo.Person
--插入目标数据表数据
insert into UFDATA_003_2012.dbo.Person
(cPersonCode,cPersonName,cDepCode,cPersonProp,fCreditQuantity,iCreDate,cCreGrade,iLowRate
,cOfferGrade,iOfferRate,cPersonEmail,cPersonPhone,dPValidDate,dPInValidDate)
select cPersonCode,cPersonName,cDepCode,cPersonProp,fCreditQuantity,iCreDate,cCreGrade,iLowRate
,cOfferGrade,iOfferRate,cPersonEmail,cPersonPhone,dPValidDate,dPInValidDate
from UFDATA_002_2012.dbo.Person
-----------------------------------------------------------------------------------------------
--删除目标数据表数据(第二个表)
delete from UFDATA_003_2012.dbo.hr_hi_person
--插入目标数据表数据
insert into UFDATA_003_2012.dbo.hr_hi_person
(cPsn_Num,cPsn_Name,cDept_num,iRecordID,rPersonType,rSex,dBirthDate,rNativePlace,rNational
,rhealthStatus,rMarriStatus,vIDNo,MPicture,rPerResidence,vAliaName,dJoinworkDate,dEnterDate
,dRegularDate,vSSNo,rworkAttend,vCardNo,rtbmRule,rCheckInFlag,dLastDate,vstatus1,nstatus2
,bPsnPerson,cPsnMobilePhone,cPsnFPhone,cPsnOPhone,cPsnInPhone,cPsnEmail,cPsnPostAddr,cPsnPostCode
,cPsnFAddr,cPsnQQCode,cPsnURL,CpsnOSeat,dEnterUnitDate,cPsnProperty,cPsnBankCode,cPsnAccount
,pk_hr_hi_person,bProbation,cDutyclass,bTakeTM,MPictureqpb,rIDType,rCountry,dLeaveDate,rFigure
,rWorkStatus,EmploymentForm,rPersonParameters,bDutyLock,bpsnshop,CardState,FirstHTBeginDate
,LastHTEndDate,cPsn_NameEN,sysAge,SysCompage,SysWorkAge,CRegion,NatrueType,cShiftType,cDefaultBC
,dEnterDutyClassDate,cRestType,JobNumber,PersonDepart,CardEffectiveBeginTime
,CardEffectiveEndTime,KeyPerson,cLeaveReson)
select cPsn_Num,cPsn_Name,cDept_num,iRecordID,rPersonType,rSex,dBirthDate,rNativePlace,rNational
,rhealthStatus,rMarriStatus,vIDNo,MPicture,rPerResidence,vAliaName,dJoinworkDate,dEnterDate
,dRegularDate,vSSNo,rworkAttend,vCardNo,rtbmRule,rCheckInFlag,dLastDate,vstatus1,nstatus2
,bPsnPerson,cPsnMobilePhone,cPsnFPhone,cPsnOPhone,cPsnInPhone,cPsnEmail,cPsnPostAddr,cPsnPostCode
,cPsnFAddr,cPsnQQCode,cPsnURL,CpsnOSeat,dEnterUnitDate,cPsnProperty,cPsnBankCode,cPsnAccount
,pk_hr_hi_person,bProbation,cDutyclass,bTakeTM,MPictureqpb,rIDType,rCountry,dLeaveDate,rFigure
,rWorkStatus,EmploymentForm,rPersonParameters,bDutyLock,bpsnshop,CardState,FirstHTBeginDate
,LastHTEndDate,cPsn_NameEN,sysAge,SysCompage,SysWorkAge,CRegion,NatrueType,cShiftType,cDefaultBC
,dEnterDutyClassDate,cRestType,JobNumber,PersonDepart,CardEffectiveBeginTime
,CardEffectiveEndTime,KeyPerson,cLeaveReson
from UFDATA_002_2012.dbo.hr_hi_person
person没进person,请
我导入的是execl文件可以老是不行,可以帮忙看看吗
软件中人员档案中,你选择人员类别没有?人员类别选择全部,看看有没有人