Messages

1

Help for ParamQuery Pro / Excel/CSV Export Button Callback

« on: September 30, 2015, 02:01:20 pm »

Greetings,
I'd like to know if the Excel/CSV button has any sort of callback after the download has started or it has been complete.
I need it because sometimes the time for download the excel (or CSV) are long due to long data processing and I'd like to prompt a waiting dialog.

So basically:

Code: [Select]

           
items:  [{
                        type:       'button',
                        label:      'Export to CSV',
                        icon:       'ui-icon-document',
                        listeners: [{
                            click: function (evt) {
                                $("#grid_json").pqGrid("exportCsv", {
                                    url: "script/mypage.php?id="+id,
                                    sheetName: "My Sheet Name",
                                    [b]complete: function(data) {} or success: function(data){} something like that[/b]
                                });
                            }
                        }]
            }]
     

Thanks in advance.
Best, Pardgroup.

2

Help for ParamQuery Pro / Group Column are not export in excel and csv?

« on: July 31, 2015, 05:28:41 pm »

Greetings,
We have a problem with the MAIN column header not being exported in excel when there are SUB-columns.
So in case there are 3 SUB-columns equal for different MAIN columns the result is an excel or csv with no indication for which MAIN column are the SUB-columns.

Example let's say we have MAIN columns as clusters and they are named: Cluster Paris, Cluster Italy, Cluster Spain
under each MAIN columns we have 3 sub columns: Quantity-A, Quantity-B, Quantity-C

In Param query everything is okay, I can identify the 3 SUB columns for each cluster but in excel, csv I don't have the 3 MAIN columns: Cluster Paris, Cluster Italy, Cluster Spain. So image that in an excel with 20 MAIN columns.

Any hints for fix that?
thanks, Best Alberto.