csvout Follow @yiiframework

Hi,

Its not working fine when i have pagination. I like to export full table

Hello,

I added the changes suggested by seb and luoshiben into the package.

Also, I noticed that once the results were filtered through an Ajax call, the changes were not reflected in the CSV export. For this, the existing form (id=csvExportForm) has to removed.

\$(\"#csvExportForm\").remove();

This line goes before the formCsv initialisation. With this, there is also no need for the firstTime variable and its check. Thus, we get correct CSV export after each search operation.

Tested in IE8, Firefox 3.6 and Chrome 10.

Thanks for the extension. I had two issues and will give my solutions for both:

1. In IE8 (didn't test other versions of IE) when I clicked on the export button I got the error "formCSV is null or is not an object" and the file was not downloaded. I solved this problem by replacing line 92 of csvWidget.php with:

   
   formCsv = \$('<form>').attr({id: 'csvExportForm', method: 'POST', action: '".Yii::app()->urlManager->createUrl('csv/index')."'});
   $('body').append(formCsv);
   

2. I noticed that no escaping or enclosing of characters was being done when lines were added to the export. I borrowed an example from comments on the php man page for the fputcsv function and added the following to CsvController.php: A. At the very top of the actionIndex method I added:

   
   $delimiter = ',';
   $enclosure = '"';
   $delimiter_esc = preg_quote($delimiter, '/');
   $enclosure_esc = preg_quote($enclosure, '/');
   

   B. Then, inside of the "foreach($table as $row)" section I replaced the code to look like this:

   
   foreach($row as $indice=>$field)
   {
       if(preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field))
           $row[$indice] = $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field) . $enclosure;
   }
   $outputTable[] = join($delimiter, $row);
   

   Hope that helps someone.

see

http://www.yiiframework.com/forum/index.php?/topic/4213-csvout-install-problem/

greetings

var dato=cells|k|.innerHTML;

var index_a2= dato.lastIndexOf("< / a >");

if (index_a2!=-1) {

var index_a1= dato.substring(0,index_a2).lastIndexOf(">")+1;

var dato_link= dato.substring(index_a1,index_a2);

input.setAttribute('value', dato_link); } else input.setAttribute('value', cells|k|.innerHTML);

hi seb your solution not work for me

mi solution :

var dato=cells[k].innerHTML;

var index_a2= dato.lastIndexOf(\"\");

if (index_a2!=-1) {

var index_a1= dato.substring(0,index_a2).lastIndexOf(\">\")+1;

var dato_link= dato.substring(index_a1,index_a2);

input.setAttribute('value', dato_link); } else input.setAttribute('value', cells[k].innerHTML);

i'm using PHPExcel if you are interested, ask me

greetings

Column headers often contains links for sorting. Now this links exported as < a href ... >Text< /a>.

To fix this we need to change exportToCsv() JS function in csvWidget.php:

function exportToCsv()
{
...
if (cells[k].className.indexOf('{$this->ignoredCol}') === -1) {
    var input = document.createElement('input');
    input.setAttribute('type', 'hidden');
    input.setAttribute('name', 'tCells['+i+']['+j+']['+k+']');
    //check if cell contains a link
    if(cells[k].firstChild.nodeName.toLowerCase()!=='a'){
        input.setAttribute('value', cells[k].innerHTML);
    } else {

        input.setAttribute('value', cells[k].firstChild.innerHTML);
    }
    formCsv.appendChild(input);
}
...
}