problem with commas in columns of MySQL tables

posted on October 16th, 2019

Closed

Eric Malalel asked on October 16, 2019

I have multiple text columns in my MySQL tables and some of them can contain values with commas.
I use the FLexMonster compressor to load the ocsv file from these MySQL Tables into the FlexMonster component.
The displayed result is wrong, because it sounds like the ocsv file is considered by the FlexMonster component to have columns separated by commas.
I think you should be able to test with the attached files:

report.json: the report file used
data report json user.txt : the data I get using this report file
data report json user.xlsx : same data in excel, with lines 130, 131 and 132 highlighted, since they have commas in the "Séquence" column and Excel has also problems with it

I use latest version of FlexMonster.
Please advise quickly, the end user is waiting for these statistics.

Attachments:
data report json user.txt
data report json user.xlsx
report.json

7 answers

Public

Eric Malalel ⋅ October 17, 2019

Also, my end user says it was working before, so it may be related to a regression in latest version of FLexmonster I installed recently, and since then, there is this bug.

Public

Ian Sadovy ⋅ Flexmonster ⋅ October 17, 2019

Hello Eric,

Thank you for the details and giving us some time to investigate the issue.
We have found a bug in the latest updates we made for the Data Compressor.
I am attaching the "hot-fixed" version of the PHP Data Compressor.
The official version will be released in the next minor release (ETA Oct 21).

Please test and let us know if it works well.

Regards,
Ian

Attachments:
flexmonster-compressor.zip

Public

Eric Malalel ⋅ October 17, 2019

Hello Ian,
I updated the compressor.
The problem with commas is fixed, but calculations are wrong.
I attach the same files as previously:

report.json: the report file used
data report json user.txt : the data I get using this report file
data report json user.xlsx : same data in excel, with a cross tab report which is correct, total time is 69:12:01

With FlexMonster crosstab report, I get a total of 0:00:34.

Attachments:
data report json user.txt
data report json user.xlsx
report.json

Public

Ian Sadovy ⋅ Flexmonster ⋅ October 17, 2019

Eric,

Thank you for testing.
We see the issue and made one more ad-hoc fix.
Please download it from the attachments.

Hope it will work well now.

Regards,
Ian

Attachments:
flexmonster-compressor.zip

Public

Eric Malalel ⋅ October 17, 2019

Yes, it works perfectly now, thanks for quick feedback.

Public

Vera Didenko ⋅ Flexmonster ⋅ October 23, 2019

Hello, Eric,

We are happy to let you know that the issues with commas in the columns and with converting date/time are fixed.

This is provided in the 2.7.17 version of Flexmonster: https://www.flexmonster.com/release-notes/

You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
A kind reminder is to update Flexmonster Data Compressor also: https://www.flexmonster.com/doc/updating-to-the-latest-version/#!compressor

You are welcome to write to us in case of questions.

Best Regards,
Vera

Public

Eric Malalel ⋅ January 24, 2020

I confirm the issue is fixed.

This question is now closed