jQuery Grid Plugin - jqGrid - Topic: jqGrid : exporting 'formatted' data http://www.trirand.com/blog/?page_id=393/help/jqgrid-exporting-formatted-data Simple:Press Version 5.7.5.3 tony on jqGrid : exporting 'formatted' data http://www.trirand.com/blog/?page_id=393/help/jqgrid-exporting-formatted-data#p31267 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-exporting-formatted-data#p31267 Hello,

 

The data in grid parameters is source data. The formated data come when a new page is loaded.

Sorry, this is very basic and it is difficult  to make additional function for this purpose.

 

Regards

]]> Tue, 21 Oct 2014 17:58:36 +0300 Rajesh on jqGrid : exporting 'formatted' data http://www.trirand.com/blog/?page_id=393/help/jqgrid-exporting-formatted-data#p31197 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-exporting-formatted-data#p31197 Objective: To export data displayed in jqGrid as CSV maintaining existing formatting. Make a generic utility to be used across multiple webpages using jqGrid for exporting data.

Currently I am able to create a csv formatted data from jqgrid and pass it to backend to be saved as .csv file.

Steps Taken:

  • Used

    jqGrid('getGridParam', 'data')

    to get all row data

  • Used

    jqGrid('getGridParam', 'colNames')

    to get colnames

  • Created a tab separated output- No issues.

Problem: Since I used

'data'

, the column values are the raw values and not the formatted values.
For eg, from backend the date comes as a long -

1411674947000

but using custom formatter in jqgrid it displays as

2014-09-25 19:55:47

.

Similarly there are error codes which come as numeric values but formatted to show some text.
The objective is to use the formatted value eg '2014-09-25 19:55:47' in the csv output instead of '1411674947000'.

(I posted the same question in another forum without any success.(http://stackoverflow.com/quest.....atted-data) Sorry for being repetitive.)

]]> Fri, 03 Oct 2014 19:19:26 +0300