Update Wrong item Name Using Excel File in AX 2012

if you are facing wrong item name and you have  a lot of them you can use excel file with the wrong and the correct Item Name then you can use the following code to help with the update process :

Excel sheet format is :

item code

wrong item name

correct item name 

void clicked()

{

//-->excel definations//////////////////////////

 SysExcelApplication             application;

    SysExcelWorkbooks               workbooks;

    SysExcelWorkbook                workbook;

    SysExcelWorksheets              worksheets;

    SysExcelWorksheet               worksheet;

    SysExcelCells                   cells;

    COMVariantType                  type;

    System.DateTime                 ShlefDate;

    FilenameOpen                    filename;

    dialogField                     dialogFilename;

    Dialog                          dialog;

 /////////////////////////////////////////////////////////

 //--> table definations///////////////////////////////

InventTable _inventTable;

EcoResProductTranslation ecoResProductTranslation;

    companyinfo _ci;

////////////////////////////////////////////////////////

//--> other variables /////////////////////////////////////

int row=0;

int counter=0;

ItemName itemName;

str itemDesc;

/////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////

  #Excel

    // convert into str from excel cell value

    str COMVariant2Str(COMVariant _cv, int _decimals = 0, int _characters = 0, int _separator1 = 0, int _separator2 = 0)

    {

    switch (_cv.variantType())

    {

    case (COMVariantType::VT_BSTR):

    return _cv.bStr();

    case (COMVariantType::VT_R4):

    return num2str(_cv.float(),_characters,_decimals,_separator1,_separator2);

    case (COMVariantType::VT_R8):

    return num2str(_cv.double(),_characters,_decimals,_separator1,_separator2);

    case (COMVariantType::VT_DECIMAL):

    return num2str(_cv.decimal(),_characters,_decimals,_separator1,_separator2);

    case (COMVariantType::VT_DATE):

    return date2str(_cv.date(),123,2,1,2,1,4);

    case (COMVariantType::VT_EMPTY):

    return "";

    default:

    throw error(strfmt("@SYS26908", _cv.variantType()));

    }

    return "";

    }

    ;

    dialog              =   new Dialog("Excel Upoad");

    dialogFilename      =   dialog.addField(extendedTypeStr(FilenameOpen));

    dialog.filenameLookupFilter(["@TRA60",#XLSX,"@TRA60",#XLS]);

    dialog.filenameLookupTitle("Upload from Excel");

    dialog.caption("Excel Upload");

    dialogFilename.value(filename);

    if(!dialog.run())

    return;

    filename            =   dialogFilename.value();

    application         =   SysExcelApplication::construct();

    workbooks           =   application.workbooks();

    try

    {

    workbooks.open(filename);

    }

    catch (Exception::Error)

    {

    throw error("File cannot be opened.");

    }

    workbook            =   workbooks.item(1);

    worksheets          =   workbook.worksheets();

    worksheet           =   worksheets.itemFromNum(1);

    cells               =   worksheet.cells();

 ttsbegin;

 do

   {

    try

      {

          row++;

                  itemId              = COMVariant2Str(cells.item(row, 1).value());

                  itemName           = COMVariant2Str(cells.item(row, 2).value());

                  itemDesc            = COMVariant2Str(cells.item(row, 3).value());

        if(row > 1 )

         {

             while select forupdate ecoResProductTranslation where ecoResProductTranslation.Name==itemName

             {

               ecoResProductTranslation.Name= itemDesc;

               ecoResProductTranslation.doUpdate();

                 counter++;

             }

         }

     }

  catch

     {

         Error(strfmt("Upload Failed in row %1", row));

     }

     type = cells.item(row+1, 1).value().variantType();

    }while (type != COMVariantType::VT_EMPTY);

    ttscommit;

    info(strfmt(" updated items : %1 ",counter));

    application.quit();

   // super();

}