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:
I use latest version of FlexMonster.
Please advise quickly, the end user is waiting for these statistics.
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.
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.
I updated the compressor.
The problem with commas is fixed, but calculations are wrong.
I attach the same files as previously:
With FlexMonster crosstab report, I get a total of 0:00:34.
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.
Yes, it works perfectly now, thanks for quick feedback.
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.