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.
Save Grid to CSV and retain blank columns
-
- 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:
-
- 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
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?
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?
-
- 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
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.
-
- 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
I guess I could try a blank text variable.
-
- 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
Yeah, I would try putting an output field (or similar) there and binding it to a blank character variable.
Who is online
Users browsing this forum: No registered users and 4 guests