Hide (blank) in csv export

posted on February 22nd, 2021

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 ⋅ 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

Hide (blank) in csv export

1 answer

Please login or Register to Submit Answer