jQuery Grid Plugin - jqGrid

Thanks Tony,  - Jim

datatype: 'json', //We specify that the datatype we will be using will be JSON
    colNames:['Case ID','Site ID','Reported Problem','Closing Summary','Status','Priority','Contact','Created','Sort Date','Closed','Sort Closed','Alt Site ID','Cust Ref No','Acct Name','Email'], //Column Names
    //The Column Model to define the data. Note you can make columns non sortable, specify width, alignment, etc.
    colModel :[
        {name:'id_number',index:'id_number', align:"center", search:true, stype:"text", width: 70},
     {name:'site_id',index:'site_id',  align:"center",search:true,stype:"text", width: 60},
     {name:'title',index:'title',  align:"left", width: 100,search:true, stype:"text"},
     {name:'closing_summary',index:'closing_summary',  align:"left", width: 100,search:true, stype:"text"},     
       //{name:'condition',index:'condition', hidden:"false", search:false, stype:"text", width: 54},
     {name:'status',index:'status',  align:"center",search:true, stype:"text", width: 60},
     {name:'priority',index:'priority',  align:"center",search:true, stype:"text", width: 60},
     {name:'last_name',index:'last_name',  align:"center",search:true, stype:"text", width: 60},
        {name:'creation_time',index:'creation_time', align:"center",search:true, width: 90, formatter:'date', formatoptions:{srcformat: 'm/d/Y H:i:s',newformat: '<cfoutput>#session.myGridDateFormat#</cfoutput>'}
     }, // m/d/Y H:i:s
      {name:'sort_creation_time',index:'sort_creation_time', align:"center", hidden: true},
        {name:'case_close_date',index:'case_close_date', align:"center", width: 90, formatter:'date', formatoptions:{srcformat: 'm/d/Y H:i:s',newformat: '<cfoutput>#session.myGridDateFormat#</cfoutput>'}
     }, // m/d/Y H:i:s
      {name:'sort_case_close_date',index:'sort_case_close_date', align:"center", hidden: true},     
     {name:'alt_site_id',index:'alt_site_id',  align:"center", stype:"text", width: 60},
     {name:'x_cust_ref_no',index:'x_cust_ref_no', search:true, stype:"text", width: 60},
     {name:'name',index:'name', search:false, sortable:false, width:60},
     {name:'e_mail',index:'e_mail', search:false, sortable:false, width: 80, formatter:'email'}     ], 

This is my json data:

{"ROWS":[[3609385.0,"Y300006","PW =junior10 DT pos UPS is not holding power","per yums hd issued PR840795","Closed","Closed","PR","Y300006","10\\/25\\/2009 13:32:29",2.0091025133229E13,"10\\/25\\/2009 13:34:08",2.0091025133408E13,"Y300006",4.3039414E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3603770.0,"X527045","PW =junior10 BOH UPS 700 is not holding a charge, please send replacement.","per yuyms \\nissued pr839396","Closed","Closed","PR","X527045","10\\/19\\/2009 17:14:23",2.0091019171423E13,"10\\/19\\/2009 17:16:37",2.0091019171637E13,"X527045",4.3038506E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3613454.0,"X527045","PW =junior10 The new BOH UPS that was sent last week will not longer turn on wh","issued pr842522\\n","Closed","Closed","PR","X527045","10\\/29\\/2009 15:02:36",2.0091029150236E13,"10\\/29\\/2009 15:10:05",2.0091029151005E13,"X527045",4.3040058E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3587266.0,"X527089","PW =junior10 Printer keeps jamming up papers.  Please send replacement","issued pr835264","Closed","Closed","PR","X527089","10\\/02\\/2009 17:36:00",2.00910021736E13,"10\\/02\\/2009 17:37:22",2.0091002173722E13,"X527089",4.3036005E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3601068.0,"X527089","PW =junior10 Lexmark has service error, replaced the PC kit and reset the count","per yums\\/tbhd\\nissued pr838834","Closed","Closed","PR","X527089","10\\/16\\/2009 13:54:17",2.0091016135417E13,"10\\/16\\/2009 13:55:16",2.0091016135516E13,"X527089",4.3038095E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3601322.0,"X527089","PW =junior10 FC POS 3 having calibration issues","per yum,\\nissued pr838954","Closed","Closed","PR","X527089","10\\/16\\/2009 17:08:17",2.0091016170817E13,"10\\/16\\/2009 17:10:06",2.0091016171006E13,"X527089",4.3038164E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3602835.0,"X527089","PW =junior10 Bump bar 5 has a damaged button and they can't bump orders with it","per yums\\nissued pr839091","Closed","Closed","PR","X527089","10\\/18\\/2009 21:10:32",2.0091018211032E13,"10\\/18\\/2009 21:16:18",2.0091018211618E13,"X527089",4.303839E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3596440.0,"Y314014","PW =junior10 FC POS3, drawer won't close.","per yums hd issued PR837234","Closed","Closed","PR","Y314014","10\\/12\\/2009 12:00:12",2.0091012120012E13,"10\\/12\\/2009 12:01:30",2.009101212013E13,"Y314014",4.3037394E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3595115.0,"Y300009","PW =junior10 DT creditcard swip fell off","per yums\\/tbhd\\nissued pr837034","Closed","Closed","PR","Y300009","10\\/10\\/2009 16:58:09",2.0091010165809E13,"10\\/10\\/2009 16:58:50",2.009101016585E13,"Y300009",4.3037221E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3601012.0,"Y052042","PW =junior10 DT POS UPS not passing power","per yums\\/tbhd\\nissued pr838823","Closed","Closed","PR","Y052042","10\\/16\\/2009 13:12:18",2.0091016131218E13,"10\\/16\\/2009 13:13:41",2.0091016131341E13,"Y052042",4.3038086E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3592774.0,"W710101","PW =junior10 MWS ptr. keeps jamming in back, just replaced pc kit, confirmed it","per yums hd issued PR836458-","Closed","Closed","PR","W710101","10\\/08\\/2009 11:58:06",2.0091008115806E13,"10\\/08\\/2009 11:59:21",2.0091008115921E13,"W710101",4.3036853E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3593289.0,"X610036","PW =junior10 UPS is beeping and won't reset.","per yum,\\nissued pr836691","Closed","Closed","PR","X610036","10\\/08\\/2009 20:54:07",2.0091008205407E13,"10\\/08\\/2009 20:57:42",2.0091008205742E13,"X610036",4.3036963E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3607078.0,"W710264","PW =junior10 DT POS2 will not hold calibration, troubleshot, please replace.","per yum,\\nissued pr840370","Closed","Closed","PR","W710264","10\\/22\\/2009 17:20:26",2.0091022172026E13,"10\\/22\\/2009 17:34:16",2.0091022173416E13,"W710264",4.303908E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3611330.0,"W710264","PW =junior10 dt term 2 card swipe not working","issued pr841391","Closed","Closed","PR","W710264","10\\/27\\/2009 14:16:35",2.0091027141635E13,"10\\/27\\/2009 14:19:24",2.0091027141924E13,"W710264",4.303971E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"],[3590795.0,"Y343115","PW =junior10 DT POS #2 will not power on","per yum,\\nissued pr835900","Closed","Closed","PR","Y343115","10\\/06\\/2009 16:32:05",2.0091006163205E13,"10\\/06\\/2009 16:32:51",2.0091006163251E13,"Y343115",4.3036557E7,"KFC (YUM BRANDS)","Melissa.Johnson@yum.com"]],"PAGE":1.0,"TOTAL":23.0,"USERDATA":{"MSG":"Retreived 331 Records.","TYPE":"Success"},"RECORDS":331}

Tony,

The number of fields are correct.  The grid was working fine on my development machine, but when I moved everything to the production machine it starting getting the error.  That's why I thought that one of the js or css files was missing. 

Which files handle the formatter?  

Jim 

I'll check again.

Tony,

I want to thank you immensely for your grid.  We went live today on our new version of our Customer Portal which employs 20+ grids to present shipping, purchasing, invoicing and servicing data. 

The grid are working well.

Thanks again,

Jim