Save Grid to CSV and retain blank columns

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
LoriAustin
New User
Posts: 13
Joined: Thu May 25, 2017 1:19 pm
First Name: Lori
Last Name: Austin
Company Name: NALC
Phone: 202-662-2853
Country: United States
Contact:

Save Grid to CSV and retain blank columns

Post 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.
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Save Grid to CSV and retain blank columns

Post 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?
LoriAustin
New User
Posts: 13
Joined: Thu May 25, 2017 1:19 pm
First Name: Lori
Last Name: Austin
Company Name: NALC
Phone: 202-662-2853
Country: United States
Contact:

Re: Save Grid to CSV and retain blank columns

Post 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.
LoriAustin
New User
Posts: 13
Joined: Thu May 25, 2017 1:19 pm
First Name: Lori
Last Name: Austin
Company Name: NALC
Phone: 202-662-2853
Country: United States
Contact:

Re: Save Grid to CSV and retain blank columns

Post by LoriAustin »

I guess I could try a blank text variable.
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Save Grid to CSV and retain blank columns

Post by Scott Klement »

Yeah, I would try putting an output field (or similar) there and binding it to a blank character variable.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests