jQuery Grid Plugin - jqGrid

And what about export to Excel? It was the most popular user request in your poll. Will it be realised in 3.7 final release?

OK. Export to CSV is also very good

Voila!  Exporting to CSV done.

First I added a separator and custom button to the navigation bar as shown:

// A separator.
//
.jqGrid ('navSeparatorAdd','#' + treePagerId)
//
// A button for exporting the grid data.
//
.jqGrid ('navButtonAdd', '#' + treePagerId, {
	id:         "export_grid",
	caption:    "",
	title:      "Export the grid",
	buttonicon: "ui-icon-disk",
	onClickButton:  function () {
		window.location.href = 'exportTasks.php?projectId=' + projectId;
	}
})

Then, I created a PHP file called "exportTasks.php" and passed in a parameter called projectId (obviously this will be different for you).
Then, my exportTasks.php file looks like this:

  require_once "config.php";
  require_once "dbConfig.php";
  require_once "HTMLUtils.php";


  header ('Content-Type: text/csv');
  header ("Cache-Control: no-cache");
  header ("Content-Disposition: attachment; filename="sample.csv"");

  //
  // Project ID is the project we're interested in.
  //
  $projectId = (integer)$_REQUEST["projectId"];

  //
  // Get all of the tasks for this project.
  //
  $conditions = array ("conditions" =>
                  array ("project_id = ?", array ($projectId)));
  $tasks = Task::all ($conditions);
  
  foreach ($tasks as $task) {
    echo $task->id.",";
    echo $task->title.",";
    echo $task->description.",";
    echo $task->user->username;
    echo "n";
  }

I tested it in Chrome, Firefox, and Internet Exploder v8 and all three of them worked as expected.  Granted, for your situation you will likely want to customize which columns come back, and "perhaps" how they are sorted or filtered but this is simple.  It took me longer to remember how to put a SEPARATOR in the navigation bar than it did for me to write the export PHP.  Btw, I'm using ActiveRecord for fetching data.

Regards,

Squid

Btw, Tony, I "HATE" the editor for this forum :P.

Thank you squid! I'll try to implement this functionality

Any date or preview available for Groupping row based on a column as descibed here: http://www.trirand.com/blog/?p.....-breaking/

Same question for grouping headers as requested here : http://www.trirand.com/blog/?p.....8;search=1

Bug in MSIE 7:

"Multiple Search" does not work when using IE7 as the browser.  Test it against the 3.7 Beta demo site and see.  You get multiple search options, but if you use more than 1 it fails.

I realize the correct solution is "don't use IE7", when I'm at work there's no other choice. 

I hope identifying this issue helps debug, thank you.

We're trying out the beta and love the new local load once features! We are however experiencing one new behavior that I don't think was intended.

When you have a horizontal scrollbar on the grid and you are scrolled to the right if you sort on a column depending on the browser you experience different things.   With Firefox it scrolls you to the very left of the grid.  If you use IE(forced to here) it seems to only scroll the grid but the table header row stays in the same spot.  Once you move the horizontal scrollbar then the header row catches up to where its suppose to be with the grid.

You can see examples of this on the demo page with firefox.  The demo sites stylesheet seems to be broken in IE so I'm currently getting horizontal scrollbars in the headers themselves (I don't see this on my testing site).  The way I was able to cause horizontal scrollbars was to stretch the columns widths out. 

Let me know if you need any more info or if this is an issue I should be able to fix myself.

Thanks,

Warren

I'm still having the same original issue but now you can see the issue with IE on the demo site too. Here is how to reproduce.

1) Pull up any grid without a toolbar (toolbar search demo works correctly)

2) Stretch width of columns to cause a horizontal scrollbar.

3) Scroll horizontally to the right

[Image Can Not Be Found]

4) Sort on a column

[Image Can Not Be Found]

So it tries to move the grid to the very left horizontally but the header stays in the same spot. This is with IE6 and IE7.

If you try with FF it scrolls both the header and the regular rows to the very left when sorting which I don't think is the desired behavior either. Thanks! Warren

Sorry I was wrong saying any grids without a toolbar.  It needs to be one with virtual scrolling enabled.  I also went to the normal demo site in the 3.6 section and there is a grid there with virtual scrolling enabled and the issue happens there to.  I also just tested with IE8 and it does the same thing as 6 and 7 like I posed in screenshot earlier.  Firefox just scrolls you back all the way to the left and chrome seems to move you as much space as the sorting icon.

Sorry for earlier confusion.