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:
jqGrid('getGridParam', 'data') to get all row datajqGrid('getGridParam', 'colNames') to get colnames
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/questions/26105629/jqgrid-exporting-formatted-data)Â Sorry for being repetitive.)
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top