X++ Job to update worker contact information by excel upload
Upload a excel file to update the already existing Worker contact information HR/Common/Workers/List Edit/Profile->Contact Information. Note: In the Excel file all the columns should be formatted as Text and the fields should be given according to below header format. PersonnelNumber, contactdescription, contacttype,contact,contactext,primarycontact,privatecontact 123,abc, email address, abcxyz@blogger.com, ,yes,no static void EmployeeContactInfo(Args _args) { SysExcelApplication application; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet worksheet; SysExcelCells cells; COMVariantType type; System.DateTime ShlefDate; FilenameOpen filename,filenameopen; dialogField dialogFilename; Dialog dialog; LogisticsLocation logisticsLocation ; LogisticsElectronicAddress logisticsElectronicAddress; DirPartyLocation dirPartyLocation; HcmWorker hcmWorke