Page 1 of 1

Save Grid to CSV and retain blank columns

Posted: Thu Nov 05, 2020 3:34 pm
by LoriAustin
I need to export some data to send to a third party. They have a specific number of columns required for the csv file, but we do not have data in all of those columns. I have created a grid that contains columns with headings for each column the third party desires, however when I export to CSV asking it to export with headings, any column that does not contain data is removed from the resulting csv. Is there a setting I can adjust to change this behavior?

Thank you.

Re: Save Grid to CSV and retain blank columns

Posted: Thu Nov 05, 2020 5:23 pm
by Scott Klement
Do you mean that you have a field that contains a widget bound to a blank variable, and the blanks aren't showing up in the export?

Or do you mean that you haven't put any widgets into the grid column, but you still want it to show up in the export?

Re: Save Grid to CSV and retain blank columns

Posted: Thu Nov 05, 2020 5:32 pm
by LoriAustin
There is nothing in the grid column except the heading and I still want it to show up. I did try putting a blank label there and that did not work.

Re: Save Grid to CSV and retain blank columns

Posted: Thu Nov 05, 2020 5:35 pm
by LoriAustin
I guess I could try a blank text variable.

Re: Save Grid to CSV and retain blank columns

Posted: Thu Nov 05, 2020 5:56 pm
by Scott Klement
Yeah, I would try putting an output field (or similar) there and binding it to a blank character variable.