Hi Betty,
I created my grids a few years ago and there wasn’t away to dump everything to excel.
All of my pages use a Cold Fusion cfc function on the server end. Before I return the data I set a session variable to the value of the query data.
here’s and example: I have a function that returns different types of sales orders (phone orders, shipped, not shipped)
 Â
   Â
     Â
     Â
     Â
   Â
Then on my gridpage above my grid I have links  [To PDF]  and [To Excell] options (these icons and words)
When the user clicks one of these links it sends them to a page that recreates the data in the the chosen format.
Because these are links I can pass url parameters using jquery to gather filter data.
Jim
 Â
Oleg,
The code is way to big to post everything.
here's the css links which are in the heading section:
I already
Tony,
I want to thank you immensely for your grid.
Tony,
The grid started working!
Thank you for responding so quickly to my questions.
And thank you for the grid.
Jim
I counted 15:
I'll check again.
Tony,
The number of fields are correct.
Tony,
I cut the grid fields in half (removing my date fields) and now I get this error:
cm is undefined
../PTI/Parview/js3-5/jquery.jqGrid.min.js
Line 10
It acts like I'm missing some files but I've double checked.
Jim
This is my json data:
|
1 |
{"ROWS":<a href="/?page=3609385.0%2C%22Y300006%22%2C%22PW_junior10_DT_pos_UPS_is_not_holding_power%22%2C%22per_yums_hd_issued_PR840795%22_%2Fcode_code_%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22Y300006%22%2C%2210%5C%5C%2F25%5C%5C%2F2009_13%3A32%3A29%22%2C2.0091025133229E13%2C%2210%5C%5C%2F25%5C%5C%2F2009_13%3A34%3A08%22_%2Fcode_code_%2C2.0091025133408E13%2C%22Y300006%22%2C4.3039414E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3603770.0%2C%22X527045%22_%2Fcode_code_%2C%22PW_junior10_BOH_UPS_700_is_not_holding_a_charge%2C_please_send_replacement.%22%2C%22per_yuyms_%5C%5Cnissued_pr839396%22_%2Fcode_code_%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22X527045%22%2C%2210%5C%5C%2F19%5C%5C%2F2009_17%3A14%3A23%22%2C2.0091019171423E13%2C%2210%5C%5C%2F19%5C%5C%2F2009_17%3A16%3A37%22_%2Fcode_code_%2C2.0091019171637E13%2C%22X527045%22%2C4.3038506E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3613454.0%2C%22X527045%22_%2Fcode_code_%2C%22PW_junior10_The_new_BOH_UPS_that_was_sent_last_week_will_not_longer_turn_on_wh%22%2C%22issued_pr842522%5C%5Cn%22_%2Fcode_code_%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22X527045%22%2C%2210%5C%5C%2F29%5C%5C%2F2009_15%3A02%3A36%22%2C2.0091029150236E13%2C%2210%5C%5C%2F29%5C%5C%2F2009_15%3A10%3A05%22_%2Fcode_code_%2C2.0091029151005E13%2C%22X527045%22%2C4.3040058E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3587266.0%2C%22X527089%22_%2Fcode_code_%2C%22PW_junior10_Printer_keeps_jamming_up_papers._Please_send_replacement%22%2C%22issued_pr835264%22%2C%22Closed%22_%2Fcode_code_%2C%22Closed%22%2C%22PR%22%2C%22X527089%22%2C%2210%5C%5C%2F02%5C%5C%2F2009_17%3A36%3A00%22%2C2.00910021736E13%2C%2210%5C%5C%2F02%5C%5C%2F2009_17%3A37%3A22%22%2C2.0091002173722E13_%2Fcode_code_%2C%22X527089%22%2C4.3036005E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3601068.0%2C%22X527089%22%2C%22PW_junior10_%2Fcode_code_Lexmark_has_service_error%2C_replaced_the_PC_kit_and_reset_the_count%22%2C%22per_yums%5C%5C%2Ftbhd%5C%5Cnissued_pr838834%22_%2Fcode_code_%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22X527089%22%2C%2210%5C%5C%2F16%5C%5C%2F2009_13%3A54%3A17%22%2C2.0091016135417E13%2C%2210%5C%5C%2F16%5C%5C%2F2009_13%3A55%3A16%22_%2Fcode_code_%2C2.0091016135516E13%2C%22X527089%22%2C4.3038095E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3601322.0%2C%22X527089%22_%2Fcode_code_%2C%22PW_junior10_FC_POS_3_having_calibration_issues%22%2C%22per_yum%2C%5C%5Cnissued_pr838954%22%2C%22Closed%22%2C%22Closed%22%2C%22PR%22_%2Fcode_code_%2C%22X527089%22%2C%2210%5C%5C%2F16%5C%5C%2F2009_17%3A08%3A17%22%2C2.0091016170817E13%2C%2210%5C%5C%2F16%5C%5C%2F2009_17%3A10%3A06%22%2C2.0091016171006E13%2C%22X527089%22_%2Fcode_code_%2C4.3038164E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3602835.0%2C%22X527089%22%2C%22PW_junior10_Bump_bar_%2Fcode_code_5_has_a_damaged_button_and_they_can_39_t_bump_orders_with_it%22%2C%22per_yums%5C%5Cnissued_pr839091%22%2C%22Closed%22%2C%22Closed%22_%2Fcode_code_%2C%22PR%22%2C%22X527089%22%2C%2210%5C%5C%2F18%5C%5C%2F2009_21%3A10%3A32%22%2C2.0091018211032E13%2C%2210%5C%5C%2F18%5C%5C%2F2009_21%3A16%3A18%22%2C2.0091018211618E13_%2Fcode_code_%2C%22X527089%22%2C4.303839E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3596440.0%2C%22Y314014%22%2C%22PW_junior10_%2Fcode_code_FC_POS3%2C_drawer_won_39_t_close.%22%2C%22per_yums_hd_issued_PR837234%22%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22Y314014%22%2C%2210%5C%5C%2F12_%2Fcode_code_%5C%5C%2F2009_12%3A00%3A12%22%2C2.0091012120012E13%2C%2210%5C%5C%2F12%5C%5C%2F2009_12%3A01%3A30%22%2C2.009101212013E13%2C%22Y314014%22%2C4.3037394E7%2C%22KFC_%2Fcode_code_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3595115.0%2C%22Y300009%22%2C%22PW_junior10_DT_creditcard_swip_fell_%2Fcode_code_off%22%2C%22per_yums%5C%5C%2Ftbhd%5C%5Cnissued_pr837034%22%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22Y300009%22%2C%2210%5C%5C%2F10%5C%5C%2F2009_16%3A58%3A09%22%2C2.0091010165809E13_%2Fcode_code_%2C%2210%5C%5C%2F10%5C%5C%2F2009_16%3A58%3A50%22%2C2.009101016585E13%2C%22Y300009%22%2C4.3037221E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_%2Fcode_code_yum.com%22%5D%2C%5B3601012.0%2C%22Y052042%22%2C%22PW_junior10_DT_POS_UPS_not_passing_power%22%2C%22per_yums%5C%5C%2Ftbhd%5C%5Cnissued_pr838823%22_%2Fcode_code_%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22Y052042%22%2C%2210%5C%5C%2F16%5C%5C%2F2009_13%3A12%3A18%22%2C2.0091016131218E13%2C%2210%5C%5C%2F16%5C%5C%2F2009_13%3A13%3A41%22_%2Fcode_code_%2C2.0091016131341E13%2C%22Y052042%22%2C4.3038086E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3592774.0%2C%22W710101%22_%2Fcode_code_%2C%22PW_junior10_MWS_ptr._keeps_jamming_in_back%2C_just_replaced_pc_kit%2C_confirmed_it%22%2C%22per_yums_hd_issued_%2Fcode_code_PR836458_%22%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22W710101%22%2C%2210%5C%5C%2F08%5C%5C%2F2009_11%3A58%3A06%22%2C2.0091008115806E13%2C%2210%5C%5C%2F08%5C%5C%2F2009_%2Fcode_code_11%3A59%3A21%22%2C2.0091008115921E13%2C%22W710101%22%2C4.3036853E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3593289_%2Fcode_code_.0%2C%22X610036%22%2C%22PW_junior10_UPS_is_beeping_and_won_39_t_reset.%22%2C%22per_yum%2C%5C%5Cnissued_pr836691%22%2C%22Closed%22%2C%22Closed%22_%2Fcode_code_%2C%22PR%22%2C%22X610036%22%2C%2210%5C%5C%2F08%5C%5C%2F2009_20%3A54%3A07%22%2C2.0091008205407E13%2C%2210%5C%5C%2F08%5C%5C%2F2009_20%3A57%3A42%22%2C2.0091008205742E13_%2Fcode_code_%2C%22X610036%22%2C4.3036963E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3607078.0%2C%22W710264%22%2C%22PW_junior10_%2Fcode_code_DT_POS2_will_not_hold_calibration%2C_troubleshot%2C_please_replace.%22%2C%22per_yum%2C%5C%5Cnissued_pr840370%22%2C%22Closed%22_%2Fcode_code_%2C%22Closed%22%2C%22PR%22%2C%22W710264%22%2C%2210%5C%5C%2F22%5C%5C%2F2009_17%3A20%3A26%22%2C2.0091022172026E13%2C%2210%5C%5C%2F22%5C%5C%2F2009_17%3A34%3A16%22%2C2.0091022173416E13_%2Fcode_code_%2C%22W710264%22%2C4.303908E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3611330.0%2C%22W710264%22%2C%22PW_junior10_%2Fcode_code_dt_term_2_card_swipe_not_working%22%2C%22issued_pr841391%22%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22W710264%22%2C%2210%5C%5C%2F27%5C%5C%2F2009_14_%2Fcode_code_%3A16%3A35%22%2C2.0091027141635E13%2C%2210%5C%5C%2F27%5C%5C%2F2009_14%3A19%3A24%22%2C2.0091027141924E13%2C%22W710264%22%2C4.303971E7%2C%22KFC_%28YUM_%2Fcode_code_BRANDS%29%22%2C%22Melissa.Johnson_yum.com%22%5D%2C%5B3590795.0%2C%22Y343115%22%2C%22PW_junior10_DT_POS_2_will_not_power_on%22_%2Fcode_code_%2C%22per_yum%2C%5C%5Cnissued_pr835900%22%2C%22Closed%22%2C%22Closed%22%2C%22PR%22%2C%22Y343115%22%2C%2210%5C%5C%2F06%5C%5C%2F2009_16%3A32%3A05%22%2C2.0091006163205E13_%2Fcode_code_%2C%2210%5C%5C%2F06%5C%5C%2F2009_16%3A32%3A51%22%2C2.0091006163251E13%2C%22Y343115%22%2C4.3036557E7%2C%22KFC_%28YUM_BRANDS%29%22%2C%22Melissa.Johnson_%2Fcode_code_yum.com%22" class="bbcode_wiki" rel="nofollow">3609385.0,"Y300006","PW =junior10 DT pos UPS is not holding power","per yums hd issued PR840795"</a></code><code>,"Closed","Closed","PR","Y300006","10\/25\/2009 13:32:29",2.0091025133229E13,"10\/25\/2009 13:34:08"</code><code>,2.0091025133408E13,"Y300006",4.3039414E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3603770.0,"X527045"</code><code>,"PW =junior10 BOH UPS 700 is not holding a charge, please send replacement.","per yuyms \nissued pr839396"</code><code>,"Closed","Closed","PR","X527045","10\/19\/2009 17:14:23",2.0091019171423E13,"10\/19\/2009 17:16:37"</code><code>,2.0091019171637E13,"X527045",4.3038506E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3613454.0,"X527045"</code><code>,"PW =junior10 The new BOH UPS that was sent last week will not longer turn on wh","issued pr842522\n"</code><code>,"Closed","Closed","PR","X527045","10\/29\/2009 15:02:36",2.0091029150236E13,"10\/29\/2009 15:10:05"</code><code>,2.0091029151005E13,"X527045",4.3040058E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3587266.0,"X527089"</code><code>,"PW =junior10 Printer keeps jamming up papers. Please send replacement","issued pr835264","Closed"</code><code>,"Closed","PR","X527089","10\/02\/2009 17:36:00",2.00910021736E13,"10\/02\/2009 17:37:22",2.0091002173722E13</code><code>,"X527089",4.3036005E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3601068.0,"X527089","PW =junior10</code><code> Lexmark has service error, replaced the PC kit and reset the count","per yums\/tbhd\nissued pr838834"</code><code>,"Closed","Closed","PR","X527089","10\/16\/2009 13:54:17",2.0091016135417E13,"10\/16\/2009 13:55:16"</code><code>,2.0091016135516E13,"X527089",4.3038095E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3601322.0,"X527089"</code><code>,"PW =junior10 FC POS 3 having calibration issues","per yum,\nissued pr838954","Closed","Closed","PR"</code><code>,"X527089","10\/16\/2009 17:08:17",2.0091016170817E13,"10\/16\/2009 17:10:06",2.0091016171006E13,"X527089"</code><code>,4.3038164E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3602835.0,"X527089","PW =junior10 Bump bar</code><code> 5 has a damaged button and they can't bump orders with it","per yums\nissued pr839091","Closed","Closed"</code><code>,"PR","X527089","10\/18\/2009 21:10:32",2.0091018211032E13,"10\/18\/2009 21:16:18",2.0091018211618E13</code><code>,"X527089",4.303839E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3596440.0,"Y314014","PW =junior10</code><code> FC POS3, drawer won't close.","per yums hd issued PR837234","Closed","Closed","PR","Y314014","10\/12</code><code>\/2009 12:00:12",2.0091012120012E13,"10\/12\/2009 12:01:30",2.009101212013E13,"Y314014",4.3037394E7,"KFC</code><code> (YUM BRANDS)","Melissa.Johnson@yum.com"],[3595115.0,"Y300009","PW =junior10 DT creditcard swip fell</code><code> off","per yums\/tbhd\nissued pr837034","Closed","Closed","PR","Y300009","10\/10\/2009 16:58:09",2.0091010165809E13</code><code>,"10\/10\/2009 16:58:50",2.009101016585E13,"Y300009",4.3037221E7,"KFC (YUM BRANDS)","Melissa.Johnson</code><code>@yum.com"],[3601012.0,"Y052042","PW =junior10 DT POS UPS not passing power","per yums\/tbhd\nissued pr838823"</code><code>,"Closed","Closed","PR","Y052042","10\/16\/2009 13:12:18",2.0091016131218E13,"10\/16\/2009 13:13:41"</code><code>,2.0091016131341E13,"Y052042",4.3038086E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3592774.0,"W710101"</code><code>,"PW =junior10 MWS ptr. keeps jamming in back, just replaced pc kit, confirmed it","per yums hd issued</code><code> PR836458-","Closed","Closed","PR","W710101","10\/08\/2009 11:58:06",2.0091008115806E13,"10\/08\/2009</code><code> 11:59:21",2.0091008115921E13,"W710101",4.3036853E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3593289</code><code>.0,"X610036","PW =junior10 UPS is beeping and won't reset.","per yum,\nissued pr836691","Closed","Closed"</code><code>,"PR","X610036","10\/08\/2009 20:54:07",2.0091008205407E13,"10\/08\/2009 20:57:42",2.0091008205742E13</code><code>,"X610036",4.3036963E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3607078.0,"W710264","PW =junior10</code><code> DT POS2 will not hold calibration, troubleshot, please replace.","per yum,\nissued pr840370","Closed"</code><code>,"Closed","PR","W710264","10\/22\/2009 17:20:26",2.0091022172026E13,"10\/22\/2009 17:34:16",2.0091022173416E13</code><code>,"W710264",4.303908E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3611330.0,"W710264","PW =junior10</code><code> dt term 2 card swipe not working","issued pr841391","Closed","Closed","PR","W710264","10\/27\/2009 14</code><code>:16:35",2.0091027141635E13,"10\/27\/2009 14:19:24",2.0091027141924E13,"W710264",4.303971E7,"KFC (YUM</code><code> BRANDS)","Melissa.Johnson@yum.com"],[3590795.0,"Y343115","PW =junior10 DT POS #2 will not power on"</code><code>,"per yum,\nissued pr835900","Closed","Closed","PR","Y343115","10\/06\/2009 16:32:05",2.0091006163205E13</code><code>,"10\/06\/2009 16:32:51",2.0091006163251E13,"Y343115",4.3036557E7,"KFC (YUM BRANDS)","Melissa.Johnson</code><code>@yum.com","PAGE":1.0,"TOTAL":23.0,"USERDATA":{"MSG":"Retreived 331 Records.","TYPE":"Success"},"RECORDS"</code><code>:331} |
Thanks Tony,
Tony,
FYI:
I noticed that examples on your site still have class=scroll and other depreciated options in them.
Thanks,
Jim
Thanks Tony,
That fixed the problem.
Tony,
After I posted
Tony,
I'm running 3.5.1 and my pager bar is not showing up on one of my grids.
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top