Grid produces empty CSV files

[brianhd71]

I converted an app to profound UI and it works well, but when I add csv export to the grid, I get an empty file. To get around it I created a new grid, moved all of the fields to it and got it to work that way.

[Scott Klement]

Hi Brian,

The subfile grid in your example has only one column. (You have multiple fields in that column.) Load the display file in the designer, select the subfile widget, and look at the "number of columns" property, and you'll see that there's only one.

The CSV export tool will export the first field that's in a given grid column. In your case, that is the checkbox -- so, since you have only one column, all that's ever exported is that checkbox. Since the checkbox is unchecked in your example, it comes out as blank in the CSV export. So you get only one field, and it's always blank.

I'm guessing that when you moved this data to a different grid to solve the problem, you put each field in a separate column, and probably also eliminated the fold/drop feature. So that would've made this work quite a bit differently, but would've solved the problem with CSV export. Is that true?

[brianhd71]

Yes, that's exactly what I did. That makes sense. The original grid was created on the enhanced theme conversion option.