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 !
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.
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.
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.
The ETA was indicated incorrect in the previous message. An actual ETA is Dec 16.
We are sorry about that mistake.
We are pleased to inform you that the issue with parsing CSV data with quotes was fixed.
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
An important remark is that Flexmonster Data Compressor needs to be updated as well: https://www.flexmonster.com/doc/updating-to-the-latest-version/#!compressor
Please let us know if everything works.