I've noticed that GridView.export(DataToExport.ALL, ExportFormat.CSV) is cutting my data output at halfway through the 95th row (the full dataset is 347 records) with the 2009 v.1 libraries.
When I set my page size to 0 and then use GridView.export(DataToExport.CURRENT, ExportFormat.CSV) (which I used in 2008 v.1) this outputs my whole result set.
Any ideas?
Karl
Perfect! After adding the responseComplete() method call everything is working correctly! Thank you for your help.
Hello Karlgrz,
I did create 400 rows in WebGrid with 'pagesize=0' and applied export functionality with 'DataToExport.ALL' and was able to export all 400 data rows in CSV format. This scenario works fine in both 20091.1000 and 20091.1019 build. Code snippet given below. If this is still an issue we appreciate if you could provide us an isolated sample application.
Thank you!
// Backing bean
public void exportAll(ActionEvent event) {
FacesContext context = FacesContext.getCurrentInstance();
grid.export(DataToExport.ALL, ExportFormat.CSV);
context.responseComplete();
}
// Jsp code
<ig:gridView
dataSource="#{gridSelectedRowsForums.dataList}"
binding="#{gridSelectedRowsForums.grid}"
style="height: 300px;width: 600px;"
pageSize="0"
>
Hello Karl,
I am in doubt. Are you getting the DataToExport.ALL with the NetAdvantage version 9.1?
I tried but I am not getting DataToExport.ALL option on the grid object. However I tried the page size setting to 0 and export the 1000 records, using :grid.export(DataToExport.CURRENT , ExportFormat.CSV);I am able to get all records exported to excel.
Roshan