Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

pls help

 

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

*This post is locked for comments

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    Re: While uploading from excel file geeting error Number of error found is >10000

    Sorry not a developer.

    Your script, your issue, perhaps another user could comment on your code. What I would say is try it with one record, does the error message still trigger?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: 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));

    }

     

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    Re: While uploading from excel file geeting error Number of error found is >10000

    What are you uploading?

    How are you uploading?

    What is the actual error message?

    What have you actually done?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans