Question Status

Suggested Answer
Prabath Ranasinghe asked a question on 19 Feb 2014 8:11 PM

Hi

Today I got a mail from one of my team member with the following error. It will comes when user try to import data from excel. (SysDataImportExcel)

 

 

If we comment following line of code it will execute without error. And also if we debug the code it will execute without any error.

 

 

can someone help to resolve this issue...

 

thanks

Prabath

Reply
Suggested Answer
UMESH PANDIT responded on 19 Feb 2014 9:53 PM

Hi Pabath,

Open AOT and compile the class SysDataImportExcel Class also check correct version of MS Excel has been installed.

--

Thank you
Note - This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft.
Reply
Prabath Ranasinghe responded on 19 Feb 2014 10:27 PM

yes. We did it earlier. This error comes only for one company.

Reply
Petr Senhal responded on 8 Jan 2015 11:56 AM

I experienced another weird behaviour of progress bar in excel import. Normally there should be two bars but the second which provides progress on records in actual table is not visible. It's annoying when you can't see the progress especially if importing large data.

I found the reason. The progress bar form is created on calling the incCount for the first time. All the bars that have at this moment total equal to zero are set invisible! And this is indeed what occurs in the class SysDataImportDefBase, the totals for the second bar set only after the incCount for the first bar is called. Therefore the workaround is to set for all the bars the total greater then zero (or alt. change the code in class SysOperationProgressForm to not set bars invisible).

Have fun with AX!

Petr Sehnal

Reply
Suggested Answer
UMESH PANDIT responded on 19 Feb 2014 9:53 PM

Hi Pabath,

Open AOT and compile the class SysDataImportExcel Class also check correct version of MS Excel has been installed.

--

Thank you
Note - This forum post is my own opinion and does not necessarily reflect the opinion or view of Microsoft.
Reply