asked on May 7, 2020
I recently updated the flexmonster version to 2.8. I am having issues with csv export as the previous flexmonster version used to add double quotes to all the values in csv export. Now, it is exporting without the quotes. I read that this feature is added in the latest version. Please help me in enabling double quotes.
⋅ May 8, 2020
Hello,
Thank you for reaching out to us.
Our team would like to kindly explain that the usage of quotes in CSV export was optimized with a minor update v.2.7.23.
The value will be wrapped with quotes only in case it contains the separator (so it needs to be enclosed).
As for now, the described behavior can not be changed.
We would like to ask you what is a use case when quotes are needed for each value.
Our team is looking forward to hearing from you.
Best regards,
Illia
⋅ May 8, 2020
Hello,
We have been using quotes in our reports by default. So is there a way where get them back in the report? Like a setting where I can set "showQuotes" = true / false? We have clients who are expecting double quotes.
Thanks
⋅ May 11, 2020
Hello,
Thank you for writing to us.
Our team would like to kindly inform you that the desired option is going to be added with a minor update ETA June 01.
Our team will notify you as soon as the version is available to download.
Please contact us in case additional questions on this point arise.
Best regards,
Illia
⋅ June 1, 2020
Hello,
Any updates on the flex monster update for the double quotes issue?
Thanks
⋅ June 2, 2020
Hello,
We are glad to inform you that for CSV export, the new option alwaysEnclose was added to enclose all fields in quotes.
This is provided in the 2.8.8 version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if it works for you.
Feel free to write to us in case of questions.
Best regards,
Illia
⋅ June 9, 2020
I am still not able to enable csv with double quotes. I am not able to export csv now. Can you please help me resolve this and also show the right usage of alwaysEnclose for csv export?
⋅ June 10, 2020
Hello,
Thank you for your question.
The alwaysEnclose property should be set to true in the second parameter of the exportTo API call. Please refer to the following code snippet:
function exportTo() {
pivot.exportTo("csv", {
alwaysEnclose: true
})
}
Please see an example we have prepared for you.
Detailed information about the exportTo method and its properties (including alwaysEnclose) can be found in our documentation.
You are welcome to contact us in case any additional questions arise.
Regards,
Illia