CSV export problem

phpcoder101 · November 1st, 2009, 07:07 AM

When I export csv file for products and categories, a row of each data in csv is in one cell.

e.g.
id,"name","shortdesc","longdesc","thumbnail","imag e","grouping","status","category_id","featured" ,

is in one cell.

Could anyone tell me how to fix this problem?

I open csv with MS Exel.

Regards.

phpcoder101 · November 1st, 2009, 07:45 AM

I forgot to select comma when I import to excel.

http://www.brighthub.com/computing/w...les/10782.aspx

plavalle · September 4th, 2012, 06:08 PM

I'm getting this error when I click on the Category link:

Code:

( ! ) Fatal error: Cannot redeclare MCats::exportCsv() in C:\wamp\www\ci_fullsite_professional\application\models\mcats.php on line 183

Model - MCats:

Code:

function exportCsv(){
	$this->load->dbutil();
	$Q = $this->db->query("select * from categories");
	return $this->dbutil->csv_from_result($Q,",","\n");
}

Admin Controller - Categories:

Code:

function export(){
	$this->load->helper('download');
	$csv = $this->MCats->exportCsv();
	$name = "category_export.csv";
	force_download($name,$csv);
}

CI version 2.1.2