pls help
While uploading from excel file geeting error Number of error found is >10000
*This post is locked for comments
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?
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));
}
What are you uploading?
How are you uploading?
What is the actual error message?
What have you actually done?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156