Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Issue with GridImport XML
13/05/2010
17:16
Avatar
Meng Hai
Member
Members
Forum Posts: 17
Member Since:
03/02/2010
sp_UserOfflineSmall Offline

Hi,

I am using jquery 1.4.2 min.js.  I tested this out in both jqgrid 3.6.4 and 3.6.5

I am trying to do a GridImport with a xml file. I used:

  $("#gridmain").jqGrid('GridUnload');
        $("#gridmain").jqGrid('jqGridImport',
            { impurl:"tt3.xml",
             imptype: "xml",
              mtype: "POST",
     importComplete:function(){

             }
           });

in the content of my tt3.xml file I noted that if I have 6 columns of info, it is working fine. But when I had 7 columns, it gives this error in firefox firebug and doesn't display the grid:

JSON.parse
The content of the tt3.xml is shown below.
If I remove the last column eg:  the <colModel> pair, <colNames> pair, and <cell> pair; there is no error and the grid display the result. I can't figure out why the 7th column is giving the error. Can someone help me please.
Thank you.

<?xml version='1.0' encoding='utf-8'?>
<roots>    <grid><url>loadcompmark.php.php?q=1</url><height>340</height><rowNum>50</rowNum>
<colModel>  <name>SNo</name>  <index>SNo</index>  <width>15</width>  <sortable>false</sortable><resizable>true</resizable></colModel>
<colModel>  <name>Name</name>  <index>Name</index>  <width>200</width> <sortable>false</sortable> <resizable>true</resizable></colModel>

<colModel>  <name>1</name>  <index>1</index>  <width>80</width> <editable>true</editable><sortable>false</sortable> <align>center</align> <resizable>true</resizable></colModel>
<colModel>  <name>2</name>  <index>2</index>  <width>80</width> <editable>true</editable><sortable>false</sortable> <align>center</align> <resizable>true</resizable></colModel>
<colModel>  <name>3</name>  <index>3</index>  <width>80</width> <editable>true</editable><sortable>false</sortable> <align>center</align> <resizable>true</resizable></colModel>
<colModel>  <name>4</name>  <index>4</index>  <width>80</width> <editable>true</editable><sortable>false</sortable> <align>center</align> <resizable>true</resizable></colModel>
<colModel>  <name>5</name>  <index>5</index>  <width>80</width> <editable>true</editable><sortable>false</sortable> <align>center</align> <resizable>true</resizable></colModel>

<colNames>SNo</colNames>
<colNames>Name</colNames>
<colNames>(1) Composition 1 [50]</colNames>
<colNames>(1) Composition 2 [50]</colNames>
<colNames>(1) Composition 3 [50]</colNames>
<colNames>(1) Composition 4 [50]</colNames>
<colNames>(1) Functional Writing 1 [20]</colNames>

<datatype>xml</datatype>
<mtype>GET</mtype>
<forceFit>true</forceFit>
<cellEdit>true</cellEdit>
<cellsubmit>clientArray</cellsubmit>
<shrinkToFit>true</shrinkToFit>
<xmlReader>    <root>rows</root>    <row>row</row>    <page>rows>page</page>    <total>rows>total</total>    <records>rows>records</records>    <repeatitems>true</repeatitems>    <cell>cell</cell>    <id>[id]</id>    <userdata>userdata</userdata></xmlReader>

<loadui>enable</loadui> <toolbar>false</toolbar><scroll>false</scroll><recordtext>Row(s)</recordtext><loadtext>Loading…</loadtext>
</grid>

<rows>
<row id='1030'>

<cell>01</cell>
<cell><![CDATA[TIFFANY THALIA GUNAWAN
<input type='hidden' id='noCols' value='5' />
<input type='hidden' id='hvala2' value='3150' /><input type='hidden' id='hvalb2' value='50' /><input type='hidden' id='hvalc2' value='1' /><input type='hidden' id='hvald2' value='' />
<input type='hidden' id='hvala3' value='6825' /><input type='hidden' id='hvalb3' value='50' /><input type='hidden' id='hvalc3' value='1' /><input type='hidden' id='hvald3' value='' />
<input type='hidden' id='hvala4' value='6826' /><input type='hidden' id='hvalb4' value='50' /><input type='hidden' id='hvalc4' value='1' /><input type='hidden' id='hvald4' value='' />
<input type='hidden' id='hvala5' value='6827' /><input type='hidden' id='hvalb5' value='50' /><input type='hidden' id='hvalc5' value='1' /><input type='hidden' id='hvald5' value='' />
<input type='hidden' id='hvala6' value='3151' /><input type='hidden' id='hvalb6' value='20' /><input type='hidden' id='hvalc6' value='1' /><input type='hidden' id='hvald6' value='' />
<input type='hidden' id='hvala7' value='6829' /><input type='hidden' id='hvalb7' value='20' /><input type='hidden' id='hvalc7' value='1' /><input type='hidden' id='hvald7' value='' />
<input type='hidden' id='hvala8' value='6830' /><input type='hidden' id='hvalb8' value='20' /><input type='hidden' id='hvalc8' value='1' /><input type='hidden' id='hvald8' value='' />
<input type='hidden' id='hvala9' value='3152' /><input type='hidden' id='hvalb9' value='38' /><input type='hidden' id='hvalc9' value='1' /><input type='hidden' id='hvald9' value='' />
<input type='hidden' id='hvala10' value='6832' /><input type='hidden' id='hvalb10' value='32' /><input type='hidden' id='hvalc10' value='1' /><input type='hidden' id='hvald10' value='' />
<input type='hidden' id='hvala11' value='6835' /><input type='hidden' id='hvalb11' value='38' /><input type='hidden' id='hvalc11' value='1' /><input type='hidden' id='hvald11' value='' />
<input type='hidden' id='hvala12' value='6841' /><input type='hidden' id='hvalb12' value='32' /><input type='hidden' id='hvalc12' value='1' /><input type='hidden' id='hvald12' value='' />
<input type='hidden' id='hvala13' value='7649' /><input type='hidden' id='hvalb13' value='20' /><input type='hidden' id='hvalc13' value='1' /><input type='hidden' id='hvald13' value='' />
<input type='hidden' id='hvala14' value='7650' /><input type='hidden' id='hvalb14' value='40' /><input type='hidden' id='hvalc14' value='1' /><input type='hidden' id='hvald14' value='' />
<input type='hidden' id='hvala15' value='7651' /><input type='hidden' id='hvalb15' value='40' /><input type='hidden' id='hvalc15' value='1' /><input type='hidden' id='hvald15' value='' />
<input type='hidden' id='hvala16' value='7648' /><input type='hidden' id='hvalb16' value='70' /><input type='hidden' id='hvalc16' value='1' /><input type='hidden' id='hvald16' value='' />]]></cell>

<cell>37</cell>
<cell>37</cell>
<cell>30</cell>
<cell>34</cell>
<cell>14</cell>

</row>
</rows>

</roots>

13/05/2010
17:41
Avatar
Meng Hai
Member
Members
Forum Posts: 17
Member Since:
03/02/2010
sp_UserOfflineSmall Offline

I just found out the problem.

It is the word "Function" in the 7th column for colNames

Apparently cant use the phrase "function" for colNames. Will this be rectified?

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
45 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information