Get Free Trial
Get Free Trial

Analyzing data… remain at 0%

Answered
Hugues Audoux asked on November 13, 2019

Hello,
I use Flexmonster to make a pivot table from a database, so I used the project “Pivot Table for Databases / server / .net” in the Flexmonster directory. I changed the « query » and « connectionString », start the project and go to,« /api/Flexmonster/get », perfect I have the data. Then I use the file « index.html » to load the Pivot Table but the problem is that when I load all the data from the database, I have a « TypeError:v7a is undefined // flexmonster.js:9:131840 » and the analysis data remain at 0%.
If I load a small amount of data like 10 lines, it works and this error does not appear.
Why is this happening ?
 
Thank you !
 
 

4 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 14, 2019

Hello, Hugues,
 
Thank you for reaching out to us.
 
We would like to kindly ask you to provide more details about the problem. Does the issue appear when using the specific data set, or it’s typical for all data sets with a similar size?
 
Could you please create an example that would demonstrate the problem so we could reproduce it on our side?
 
Also, it would be great to see an expanded error in your console, so we could understand its reason better. You can expand it by clicking the arrow symbol on the left side of the error.
 
You are welcome to write to us in case of any questions.
 
Kind Regards,
Illia

Public
Hugues Audoux November 14, 2019

Hello,
I have added a screen capture of the screen with the error.
I tried it with a 59000 line CSV and I didn’t have any problems. I continued the tests and identified 6 lines that produce the bug.
 
 

Attachments:
flexmonster3.png
data.csv

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 15, 2019

Hello, Hugues,
 
Thank you for providing more details.
 
The exception you see in your console seems like an issue.
It is going to be fixed with the next minor update (ETA Dec 02).
 
Also, we would like to emphasize that the data you have provided does not correspond to the CSV standard.
The following lines have double-quotes between two other double-quotes:

"Eng1/2 Chêne r Excl 6 1/2" Bros Grey Drizzle Dura"
"Cla3/4 Chêne r Excl 2 1/2" Bros Knowlton Cash"
"Lock7/16 Érable Excl 4 5/16" Grey Drizzle LB"
"Classic - Noyer caractère 3 1/4" Charcoal Cashmere"
"Eng1/2 Chêne b R&Q Excl 5" Bros Snowdrift Cash"

 
If you want to use double-quotes inside the value, you have to put it twice. Check out an example below:

"Cla3/4 Chêne r Excl 2 1/2"" Bros Knowlton Cash"

 
Such an approach will eliminate an exception and allow your data to display correctly.
We hope it helps.
Feel free to contact us in case any additional questions occur.
 
Kind Regards,
Illia

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 15, 2019

Hello, Hugues,
 
The ETA was indicated incorrect in the previous message. An actual ETA is Dec 16.
 
We are sorry about that mistake.
 
Kind Regards,
Illia

Please login or Register to Submit Answer