PDA

View Full Version : Problem in json loading in grid - help needed



kthiru72
24 Jan 2008, 7:27 PM
Hi all,

I have pasted the json string to be loaded into the grid. iam loading 600 tables.599 are working properly.only one table data pasted below is not loading properly, can anyone help me out to sort out?


{"results":[

{"id":"1","colid":"1","colname":"SZDEALCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"Y","cmt":"Scheme

Code"},

{"id":"2","colid":"2","colname":"SZTYPEOFLOAN","dflt":"null","dType":"VARCHAR2(10)","PKEY":"Y","cmt"

:"Portfolio Code / Loan Type"},

{"id":"3","colid":"3","colname":"SZDEALTYPECODE","dflt":"null","dType":"VARCHAR2(5)","PKEY":"Y","cmt"

:"Deal Type code"},

{"id":"4","colid":"4","colname":"SZDESC","dflt":"null","dType":"VARCHAR2(75)","PKEY":"N","cmt":"Deal

Description"},

{"id":"5","colid":"5","colname":"DTSTARTDATE","dflt":"null","dType":"DATE","PKEY":"Y","cmt":"Scheme Start

Date"},

{"id":"6","colid":"6","colname":"DTENDDATE","dflt":"null","dType":"DATE","PKEY":"Y","cmt":"Scheme Start

End"},

{"id":"7","colid":"7","colname":"SZINDEXCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"Y","cmt":"Index

Code - From Index Master"},

{"id":"8","colid":"8","colname":"SZSPREADCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"Y","cmt"

:"Spread Code - From Spread Master"},

{"id":"9","colid":"9","colname":"SZOFFSETCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"N","cmt"

:"Offset Code"},

{"id":"10","colid":"10","colname":"CREPYMTFREQ","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y","cmt"

:"Re Payment Frequency (Viz. - M- Monthly, Q- Quarterly, H-Half yearly and Y-Yearly)"},

{"id":"11","colid":"11","colname":"CFLATORREDUCING","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y","cmt"

:"F - Flat Or R - Reducing."},

{"id":"12","colid":"12","colname":"SZSECDEPINTTYPE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"N","cmt"

:"Security Deposit Type"},

{"id":"13","colid":"13","colname":"FSECDEPFLAT","dflt":"null","dType":"NUMBER(15,2)","PKEY":"N","cmt"

:"Security Deposit Flat"},

{"id":"14","colid":"14","colname":"FSECDEPPERC","dflt":"null","dType":"NUMBER(8,5)","PKEY":"N","cmt"

:"Security Deposit Perc"},

{"id":"15","colid":"15","colname":"CSECDEPINTFREQ","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt"

:"Security Deposit Interest Frequency (Viz. - M- Monthly, Q- Quarterly, H-Half yearly and Y-Yearly)"

},

{"id":"16","colid":"16","colname":"IEMIADV","dflt":"null","dType":"NUMBER(3)","PKEY":"Y","cmt":"No. Of

Advance EMI"},

{"id":"17","colid":"17","colname":"SZPRODUCTCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"N","cmt"

:"Product Code"},

{"id":"18","colid":"18","colname":"SZFILTERCARDCODE","dflt":"null","dType":"VARCHAR2(8)","PKEY":"N","cmt"

:"Filter Code. This is used only for the purpose of Selecting the scheme at Prospects Entry."},

{"id":"19","colid":"19","colname":"CMAINTAINCONSTANT","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y"

,"cmt":"Maintain Constant (Tenor or EMI)"},

{"id":"20","colid":"20","colname":"CLIABILITYLINKED","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt"

:"Liablity linked scheme (Y/N)"},

{"id":"21","colid":"21","colname":"CREVIEWPERIOD","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y","cmt"

:"Review Period (Ex - M- Monthly, Q- Quarterly, H-Half yearly and Y-Yearly)"},

{"id":"22","colid":"22","colname":"IFIRSTREVIEWPERIOD","dflt":"null","dType":"NUMBER(3)","PKEY":"N","cmt"

:"First Review Period. This is no. of days after disbursement period."},

{"id":"23","colid":"23","colname":"IPASSSCORE","dflt":"null","dType":"NUMBER(3)","PKEY":"N","cmt":"Passing

score"},

{"id":"24","colid":"24","colname":"FCASESCOREWEIGHTAGE","dflt":"null","dType":"NUMBER(5,2)","PKEY":"N"

,"cmt":"Case Score Weightage"},

{"id":"25","colid":"25","colname":"FCUSTOMERSCOREWEIGHTAGE","dflt":"null","dType":"NUMBER(5,2)","PKEY"

:"N","cmt":"Customer Score Weightage"},

{"id":"26","colid":"26","colname":"FASSETSCOREWEIGHTAGE","dflt":"null","dType":"NUMBER(5,2)","PKEY":"N"

,"cmt":"Asset Score Weightage"},

{"id":"27","colid":"27","colname":"CCOLLATERALREQUIRED","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N"

,"cmt":"Collateral Required (Y/N)"},

{"id":"28","colid":"28","colname":"CODUECALNFREQ","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y","cmt"

:"OD Calculation Frequency"},

{"id":"29","colid":"29","colname":"FODUECALNFPERC","dflt":"null","dType":"NUMBER(8,5)","PKEY":"Y","cmt"

:"OD Calculation Percentage"},

{"id":"30","colid":"30","colname":"FLOANCOSTRATIO","dflt":"null","dType":"NUMBER(8,5)","PKEY":"N","cmt"

:"Loan to Cost Ratio"},

{"id":"31","colid":"31","colname":"FVALIDITYPERIOD","dflt":"null","dType":"NUMBER(3)","PKEY":"N","cmt"

:"Scheme Validity Period

(In Days)"},

{"id":"32","colid":"32","colname":"CINTERESTTYPE","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y","cmt"

:"F - Fixed or V- variable"},

{"id":"33","colid":"33","colname":"CASSETREQUIRED","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt"

:"Asset Required Y/N ?"},

{"id":"34","colid":"34","colname":"SZCONVCHGCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"N","cmt"

:"Conversion Charges code"},

{"id":"35","colid":"35","colname":"SZCASEWORKFLOWCODE","dflt":"null","dType":"VARCHAR2(8)","PKEY":"Y"

,"cmt":"Case Workflow Code"},

{"id":"36","colid":"36","colname":"SZCASEDOCSETCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"Y"

,"cmt":"Case Document Set Code"},

{"id":"37","colid":"37","colname":"SZCASECARDCODE","dflt":"null","dType":"VARCHAR2(8)","PKEY":"N","cmt"

:"Case Card Code"},

{"id":"38","colid":"38","colname":"SZASSETWORKFLOWCODE","dflt":"null","dType":"VARCHAR2(8)","PKEY":"N"

,"cmt":"Asset WorkFlow Code"},

{"id":"39","colid":"39","colname":"SZASSETCARDCODE","dflt":"null","dType":"VARCHAR2(8)","PKEY":"N","cmt"

:"Asset Card Code"},

{"id":"40","colid":"40","colname":"SZASSETDOCSETCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"N"

,"cmt":"Asset Document Set Code"},

{"id":"41","colid":"41","colname":"CPREPAYCHARGESAPPLICABLE","dflt":"null","dType":"VARCHAR2(1)","PKEY"

:"Y","cmt":"Pre Payment Charges Applicable Y/N ?"},

{"id":"42","colid":"42","colname":"SZPREPAYCHARGESPERC","dflt":"null","dType":"NUMBER(8,5)","PKEY":"N"

,"cmt":"Pre Payment Charges Percentage on Net"},

{"id":"43","colid":"43","colname":"SZPREPAYCHARGESFLAT","dflt":"null","dType":"NUMBER(15,2)","PKEY":"N"

,"cmt":"Pre Payment Charges Flat on Net"},

{"id":"44","colid":"44","colname":"FPREPAYFREQPERYR","dflt":"null","dType":"NUMBER(2)","PKEY":"N","cmt"

:"Pre Payment Frequency Per annum"},

{"id":"45","colid":"45","colname":"FPREPAYMINNONPAYPERIOD","dflt":"null","dType":"NUMBER(2)","PKEY":"N"

,"cmt":"Minimum period for non-prepayment"},

{"id":"46","colid":"46","colname":"FPREPAYMAXAMT","dflt":"null","dType":"NUMBER(15,2)","PKEY":"N","cmt"

:"Maximum Prepayment amount (Multiples of EMI)"},

{"id":"47","colid":"47","colname":"FFCCHARGESPERC","dflt":"null","dType":"NUMBER(8,5)","PKEY":"N","cmt"

:"Foreclosure Charges Percentage. Before Six Months"},

{"id":"48","colid":"48","colname":"FFCCHARGESFLAT","dflt":"null","dType":"NUMBER(15,2)","PKEY":"N","cmt"

:"For closure Charges Flat Before Six Months"},

{"id":"49","colid":"49","colname":"FFCMINPERIOD","dflt":"null","dType":"NUMBER(3)","PKEY":"N","cmt":"Minimum

period for non-forclosure"},

{"id":"50","colid":"50","colname":"FFCCHARGESUNPAIDINT","dflt":"null","dType":"NUMBER(15,2)","PKEY":"N"

,"cmt":"Forclose charges on Unpaid Interest"},

{"id":"51","colid":"51","colname":"CVALUESCHANGEABLE","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N"

,"cmt":"Value Changeable Y/N"},

{"id":"52","colid":"52","colname":"CACTIVE","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y","cmt":"Active

Y/N ?"},

{"id":"53","colid":"53","colname":"SZUSERID","dflt":"null","dType":"VARCHAR2(15)","PKEY":"Y","cmt":"Record

Created / Updated by User"},

{"id":"54","colid":"54","colname":"DTUSERDATETIME","dflt":"null","dType":"DATE","PKEY":"Y","cmt":"Record

Creation Date"},

{"id":"55","colid":"55","colname":"DTLASTUPDATED","dflt":"null","dType":"DATE","PKEY":"Y","cmt":"Record

Updation Date"},

{"id":"56","colid":"56","colname":"CINTFREEDEAL","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt"

:"Interest Free deal"},

{"id":"57","colid":"57","colname":"CSCHEDULE","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y","cmt":"Schedule

Full or Partial"},

{"id":"58","colid":"58","colname":"CSIMANDATORY","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt"

:"Site Investigation Mandatory Y/N"},

{"id":"59","colid":"59","colname":"CINTERESTREST","dflt":"null","dType":"VARCHAR2(1)","PKEY":"Y","cmt"

:"Interest Rest"},

{"id":"60","colid":"60","colname":"SZPROPCARDCODE","dflt":"null","dType":"VARCHAR2(8)","PKEY":"N","cmt"

:"Property CRS Card Code"},

{"id":"61","colid":"61","colname":"SZAGGREGATIONCODE","dflt":"null","dType":"VARCHAR2(3)","PKEY":"N"

,"cmt":"Case Level Aggregation Code"},

{"id":"62","colid":"62","colname":"SZPROPDOCSETCODE","dflt":"null","dType":"VARCHAR2(10)","PKEY":"N"

,"cmt":"null"},

{"id":"63","colid":"63","colname":"SZPROPWORKFLOWCODE","dflt":"null","dType":"VARCHAR2(8)","PKEY":"N"

,"cmt":"null"},

{"id":"64","colid":"64","colname":"SZSCHEMEFOR","dflt":"null","dType":"VARCHAR2(10)","PKEY":"N","cmt"

:"For New or Used Asset"},

{"id":"65","colid":"65","colname":"CAMORTTYPE","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt":"null"

},

{"id":"66","colid":"66","colname":"FFCCHARGESPERCAFSIX","dflt":"null","dType":"NUMBER(8,5)","PKEY":"N"

,"cmt":"Foreclosure Charges Percentage. After six months"},

{"id":"67","colid":"67","colname":"FFCCHARGESFLATAFSIX","dflt":"null","dType":"NUMBER(15,2)","PKEY":"N"

,"cmt":"For closure Charges Flat After Six Months"},

{"id":"68","colid":"68","colname":"CMFGSUBV","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt":"null"

},

{"id":"69","colid":"69","colname":"CDEALERCOMM","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt"

:"null"},

{"id":"70","colid":"70","colname":"CMFRBUYDOWN","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt"

:"Manufacturer Subvention in Per Lac for CD Buydown"},

{"id":"71","colid":"71","colname":"CTVSFSDISC","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt":"null"

},

{"id":"72","colid":"72","colname":"CTVSFSPAYOUT","dflt":"null","dType":"VARCHAR2(1)","PKEY":"N","cmt"

:"null"}

]

,"total":"72"}


thanks

thiru

Condor
25 Jan 2008, 4:41 AM
Add a loadexception handler to the store to see what is wrong, e.g.


listeners: {
loadexception: function(proxy, store, response, e) {
alert(e.message);
}
}