Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Help in enabling and disabling double quotes in csv export

Answered
Nisshanthni 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.

7 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Nisshanthni 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

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Nisshanthni June 1, 2020

Hello,
Any updates on the flex monster update for the double quotes issue?
Thanks
 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Public
Nisshanthni 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?

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Please login or Register to Submit Answer