unchanged
Title
simple CSV export
Difference between #4 and #3 of simple CSV export
unchanged
Category
How-tos
unchanged
Tags
csv, excel, export
changed
Content
<html>
<div style='padding: 3px; background-color: #fe9; border: #aaa;
border-radius: 3px;'>
Por: <b><a href='https://plus.google.com/107716720815385421516'
rel='author' title='author profile'><span itemprop='name'>Christian
Salazar</span></a></b>
<a href="https://twitter.com/salazarchris74"
class="twitter-follow-button" data-show-count="false"
data-lang="es">Follow @salazarchris74</a>
</div>
<script>!function(d,s,id){var
js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>
<script type="text/javascript"><!--
google_ad_client = "ca-pub-5791317089514247";
/* firma */
google_ad_slot = "6843698352";
google_ad_width = 234;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</html>
Hello everyone, this simple component extract data to CSV. The main difference
with others is the ability to format each column using Yii::app()->format
functions in a very similar way as CGridView does.
1. **This component can output the result directly to your browser as a
downloadble CSV**, so use the input arguments to provide a filename, if not, the
output will be returned as a string.
2. **The input argument to be converted to CSV must be any array of CModel
objects**, or any indexed array like $ar['key1'],$ar['key2']. You can pass an
CActiveRecord array to this component too.
3. example usage:
~~~
[php]
public function actionExport(){
CsvExport::export(
People::model()->findAll(), // a CActiveRecord array OR any CModel array
array('idpeople'=>array('number'),'birthofdate'=>array('date')),
true, // boolPrintRows
'registers-upto--'.date('d-m-Y H-i').".csv"
);
}
in a view put a link:
echo CHtml::link('Download CSV',array('site/export'));
~~~
4. **please note the input**: People::model()->findAll(), this component is
not limited to CActiveRecord, you could pass any array or any CModel objects
array to it.
5. **for each column definition you can concatenate formats**:
array('idpeople'=>array('number','fixed8'),'birthofdate'=>array('date')),
please note 'fixed8' this will invoke Yii::app()->format->formatFiexed8,
this method must exist in your CFormatter implementation in order to work, you
can extend CFormatter and implement the required methods.
6. copy this class into your protected/components/CsvExport.php:
~~~
[php]
<?php
/**
CsvExport
helper class to output an CSV from a CActiveRecord array.
example usage:
CsvExport::export(
People::model()->findAll(), // a CActiveRecord array OR any
CModel array
array(
'idpeople'=>array('number'), 'number' and 'date' are
strings used by CFormatter
'birthofdate'=>array('date'),
)
,true,'registros-hasta--'.date('d-m-Y H-i').".csv");
Please refer to CFormatter about column definitions, this class will use
CFormatter.
@author Christian Salazar <christiansalazarh@gmail.com> @bluyell
@yiienespanol (twitter)
@licence Protected under MIT Licence.
@date 07 october 2012.
*/
class CsvExport {
/*
export a data set to CSV output.
Please refer to CFormatter about column definitions, this class will use
CFormatter.
@rows CModel array. (you can use a CActiveRecord array because it
extends from CModel)
@coldefs example: 'colname'=>array('number') (See also CFormatter
about this string)
@boolPrintRows boolean, true print col headers taken from coldefs
array key
@csvFileName if set (defaults null) it echoes the output to browser
using binary transfer headers
@separator if set (defaults to ';') specifies the separator for each CSV
field
*/
public static function export($rows, $coldefs, $boolPrintRows=true,
$csvFileName=null, $separator=';')
{
$endLine = '\r\n';
$returnVal = '';
if($csvFileName != null)
{
header("Cache-Control: public");
header("Content-Description: File Transfer");
header("Content-Disposition: attachment;
filename=".$csvFileName);
header("Content-Type: application/octet-stream");
header("Content-Transfer-Encoding: binary");
}
if($boolPrintRows == true){
$names = '';
foreach($coldefs as $col=>$config){
$names .= $col.$separator;
}
$names = rtrim($names,$separator);
if($csvFileName != null){
echo $names.$endLine;
}else
$returnVal .= $names.$endLine;
}
foreach($rows as $row){
$r = '';
foreach($coldefs as $col=>$config){
if(isset($row[$col])){
$val = $row[$col];
foreach($config as $conf)
if(!empty($conf))
$val = Yii::app()->format->format($val,$conf);
$r .= $val.$separator;
}
}
$item = trim(rtrim($r,$separator)).$endLine;
if($csvFileName != null){
echo $item;
}else{
$returnVal .= $item;
}
}
return $returnVal;
}
}
~~~
- personal blog:
[http://trucosdeprogramacionmovil.blogspot.com/](http://trucosdeprogramacionmovil.blogspot.com/)
"http://trucosdeprogramacionmovil.blogspot.com/"
- yii en español:
[http://www.yiiframeworkenespanol.org](http://www.yiiframeworkenespanol.org)"http://www.yiiframeworkenespanol.org"
twitter: @yiienespanol
Need advanced RBAC UI functionality in Yii ? use
Cruge...[https://bitbucket.org/christiansalazarh/cruge](https://bitbucket.org/christiansalazarh/cruge
"https://bitbucket.org/christiansalazarh/cruge")