Dynamics Community Forum Thread Details

While uploading from excel file geeting error Number of error found is >10000

iam uploading and excel file with .csv format using an class which having code below to upload:

Actual error msg is : Number of errors found is >10000

i should get the msg this info(strfmt('%1(ILFS), %2(IFIN) ,%3(IIML) records are uploaded in %4 table.',j,k,l,tableName)); but not geeting

void uploadMFMaster()
{
    #AviFiles
    ITL_COC_MFTable             _COC_MFTable;
    Filename                    filename1;
    FilePath                    filePath;
    filenameType                filenameType;
    str                         sheetName;
    str                         strSQL;
    str                         filepathstr;
    real                        a;

;

sysOperationProgress = new SysOperationProgress(1);

    tableName   = "COC Mutual Fund Master";
    i           = 2;
    j           = 0;
    k           = 0;
    l           = 0;

    setPrefix("@SYS54767");
    sysOperationProgress.setAnimation(#AviFileMove);
    sysOperationProgress.setCaption("@SYS54767");

[filePath, filename1, filenameType] = fileNameSplit(filename);

if(filenameType!='.xls')
throw error('File should be in xls format');

    app = SysExcelApplication::construct();
    Workbooks = app.Workbooks();
    COMVariant1 = new COMVariant();
    WinAPI::fileExists(fileName);

    COMVariant1.bStr(fileName);
    Workbook = Workbooks.Add(COMVariant1);
    Worksheets = Workbook.worksheets();
    Worksheet = Worksheets.itemFromNum(1);
    Cells = Worksheet.Cells();

    firstRow = this.findFirstRow();
    lastRow = this.findLastRow();
    rows     = lastRow;

    sysOperationProgress.setTotal(rows);
    ttsbegin;
    while(i <=rows)
    {
         // Modified on 05 Aug 2010 at 11:53:14 by Hemant
         /*insertion of record into current company*/
         this.uploadrecords();
         /*insertion of record into current company ends*/

         /*insertion of same record into other company*/
         if(curext() == "ILF")
          {
             changecompany("IFN")
             this.uploadrecords();

             changecompany("IIM")
             this.uploadrecords();
          }
         if(curext() == "IFN")
          {
             changecompany("ILF")
             this.uploadrecords();

             changecompany("IIM")
             this.uploadrecords();
          }

          if(curext() == "IIM")
          {
             changecompany("ILF")
             this.uploadrecords();

             changecompany("IFN")
             this.uploadrecords();
          }
          /*insertion of same record into other company ends*/

         changecompany(curext())
         // Modified on 05 Aug 2010 at 11:53:14 by Hemant - End
         i++;
    }
    ttscommit;
    if (j > 0 && k > 0 && l>0)
        info(strfmt('%1(ILFS), %2(IFIN) ,%3(IIML) records are uploaded in %4 table.',j,k,l,tableName));

}

Quick Links

Leaderboard