tony on Searching problem + Saving to xml

Tue, 27 Oct 2009 03:25:39 +0200

Hello,

I think you misunderstud how jqGrid works.

To be a clear you use a xml file. In princip this is a static file and it is not generated from any server side language dynamically.

Short : if you load data this way you can not.

1. Perform search

2. Add/update or delete to this file (or you can do this, but you should use again server side language like PHP, ASP...)

Best Regards

Tony

HFried on Searching problem + Saving to xml

Fri, 23 Oct 2009 10:23:28 +0300

Hi,

For several days i have been reading the documentation, demonstration examples and the forum to find the solution to my problems. I'm Using jqgrid 3.5 with an xml file.

First One: Searching records does nothing;

Second: Data isn't saved to the xml file.

First case:

I use the search box from navgrid menu.

Searching for data in the grid does nothing, it just stays where it is withought filtering the record nor focusing it.

Second case:

Whenever i edit, add or delete records in the grid, it only saves localy and not on the xml file.

Could anyone help me?

Thanks in advance.

Here is my html:

…
<link rel=”stylesheet” type=”text/css” media=”screen” href=”css/redmond/jquery-ui-1.7.1.custom.css” />
<link rel=”stylesheet” type=”text/css” media=”screen” href=”css/ui.jqgrid.css” />

jQuery(document).ready(function(){
jQuery(”#list”).jqGrid({
url:'contacts.xml',
datatype: 'xml',
mtype: 'GET',

    colNames:['nome','Login', 'Ext','Tel','PC','Printer', 'Local', 'E-mail'],
   colModel :[
      {name:'nome', index:'nome', xmlmap:"nome", editable:true, search:true, stype:'text',},
      {name:'login', index:'login', width:50, xmlmap:"login", editable:true},
      {name:'ext', index:'ext', width:50, align:'right', xmlmap:"ext", editable:true},
      {name:'tel', index:'tel', width:50, align:'right', xmlmap:"tel", editable:true},
      {name:'pc', index:'pc', width:70, align:'right', xmlmap:"pc", editable:true},
      {name:'printer', index:'printer', align:'right', width:80, sortable:false, xmlmap:"printer", editable:true},
   {name:'local', index:'local', align:'right', width:80, xmlmap:"local", editable:true},
      {name:'email', index:'email', align:'right', width:170, sortable:false, xmlmap:"email", editable:true}
   ],
   xmlReader: {
      root:”result”,
      row:”invoice”,
      page:”invoices>currentpage”,
      //total:”invoices>totalpages”,
      //records:”invoices>totalrecords”,
      repeatitems:false,

},
    pager: jQuery('#pager'),
    rowNum:500,
    rowList:[10,20,30],
    sortname: 'nome',
    sortorder: 'asc',

id: 'id',
viewrecords: true,
loadonce: true,
caption: 'Lista Contactos',
editurl: 'contacts.xml',

}).navGrid('#pager',{view:true, del:true},

{reloadAfterSubmit:false, }, // edit options
{reloadAfterSubmit:false,}, // add options
{reloadAfterSubmit:false}, // del options
{Find: “Go”, multipleSearch:true,} // search options
);
//{edit:true,add:true,del:true});
jQuery(”#list”).editRow(rowid, keys, oneditfunc, succesfunc, url, extraparam, aftersavefunc,errorfunc, afterrestorefunc);
jQuery(”#list”).saveRow(rowid, succesfunc, url, extraparam, aftersavefunc,errorfunc, afterrestorefunc);

});

</script>

</head>
<body>

…

…

</body>
</html>

Example of my xml file:

<?xml version =”1.0″ encoding=”utf-8″?>
<invoices>
   <request>true</request>
   …
   <currentpage>1</currentpage>
   <totalpages>10</totalpages>
   <totalrecords>20</totalrecords>
   <result>
      <invoice>
         <nome>John Doe</nome>
         <login>U119468</login>
         <ext></ext>
         <tel>5417</tel>
         <pc>PC01</pc>
         <printer></printer>
   <local>GF</local>
   <email>john.doe@contoso.com</email>
      </invoice>

……….

</result>
</invoices>

jQuery Grid Plugin - jqGrid - Topic: Searching problem + Saving to xml

tony on Searching problem + Saving to xml

HFried on Searching problem + Saving to xml