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 !
⋅ 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
⋅ 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.
⋅ 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
⋅ 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
⋅ December 17, 2019
Hello, Hugues,
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.
Best regards,
Illia