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

Hide (blank) in csv export

Answered
Patrick Berens asked on February 22, 2021

Hi ya,
Our report data has empty fields which show as “(blank)” inside the Flexmonster flat view. When we export to a csv, it also shows “(blank)”.
 
Is it possible to make it so that empty cells in csv are exported as empty cell instead of as “(blank)”? Our customers end up having to do a find and replace every time they download a report which is a hassle when they are just trying to import the data into their databases.
 
Thanks,
Patrick

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster February 23, 2021

Hello, Patrick,
 
Thank you for contacting us.
 
We suggest considering two options to achieve this behavior.
The first one implies replacing the caption of the blank values with an empty string. It results in empty cells both on the grid and in the exported file:

global: {
  localization: {
    grid: {
      blankMember: ""
    }
  }
}

Please see the JSFiddle for the reference: https://jsfiddle.net/flexmonster/e751c92g/.
 
The second approach allows preserving blank caption on the grid but export empty cells instead.
Please use the customizeCell API hook to manage this behavior.
We have also prepared the JSFiddle for the demonstration: https://jsfiddle.net/flexmonster/v0L4hjmn/.
 
Please let us know if it works for you.
Our team is looking forward to hearing your feedback.
 
Regards,
Illia

Please login or Register to Submit Answer