Export CGridView to CSV

Yii 1.1 General Discussion
1

I’m new to Yii framework.

How to export filtered data from CGridView (admin view) to csv?

thanks

2

Check this topic - http://www.yiiframework.com/forum/index.php?/topic/13715-

3

Yes, I read it. But the problem is, how do I get the filters applied to the grid in the controller (in ExportAction)?.

Thanks

4

$model->search() returns the dataprovider with the filters provided…

5

It does not work for me. $model->search() Select all.

In the admin view I have this code:

$this->widget(‘zii.widgets.jui.CJuiButton’, array(

        'buttonType'=>'link',


        'name'=>'btnGoExportar',


        'caption'=>'Exportar Compras',


        'options'=>array('icons'=>'js:{secondary:"ui-icon-extlink"}'),


        'url'=>array('exportar'),


    ));

And in the controller:

public function actionExportar()

{


   


    $model = new Ventas('search');


	$model->unsetAttributes();


    


    if (isset($_GET['Ventas']))


		$model->setAttributes($_GET['Ventas']);


    


            


    header( "Content-Type: application/vnd.ms-excel; charset=utf-8" );


    header( "Content-Disposition: inline; filename=\"ventas.csv\"" );


   


    $dataProvider = $model->search();


    $dataProvider->pagination = False;


    


    foreach( $dataProvider->data as $data )


         echo $data->idVenta, ";", $data->ApodoCliente, "\n";


            


    Yii::app()->end();


           


    


$this->render('admin', array(


	'model' => $model,


    ));


}

Any help?. Thanks.

6

Are you getting the filter values in $_GET[‘Ventas’] ?

7

No, that’s the problem. Do you know why?

Thanks.

8

Because you are not sending them :)

9

Ok. How I send it?

Thanks.

10

try this article http://www.yiiframework.com/wiki/306/exporting-cgridview-results-to-csv-file/