CodeIgniter Forums
Export database data into different columns of a csv file - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Export database data into different columns of a csv file (/thread-50808.html)



Export database data into different columns of a csv file - El Forum - 04-09-2012

[eluser]ethereal1m[/eluser]
Dear all,
I want to export data from database into a csv file using the following code:
Code:
function export()
  {
  
  $this->load->dbutil();
  $this->db->order_by('id','asc');
  $query = $this->db->get('some_table');
  $enclosure = '';
  $delimiter = ",";
  $newline = "\r\n";
  $data = $this->dbutil->csv_from_result($query,$delimiter,$newline,$enclosure);
  
   if ( ! write_file('my_directory\data.csv', $data))
   {
    echo 'Unable to write the file';
   }
   else
   {
    echo 'File written!';
   }
  }
Basically it uses csv_from_result to create the layout and later it is written to a file using write_file. I delimit each column with comma (,) and each row with carriage return. However when I open the file from Excel, each column is separated by comma and placed into one cell of Excel instead of different cells. Like this:

How can I make so that they are in different cells? What should I used for the arguments?

regards,
ethereal1m


Export database data into different columns of a csv file - El Forum - 04-09-2012

[eluser]ethereal1m[/eluser]
I got it, I put
Code:
/t
as delimiter instead of comma....


Export database data into different columns of a csv file - El Forum - 08-02-2012

[eluser]jpganz[/eluser]
Hi, any other way to do this? I tried with /t but still no work.. any idea?


Export database data into different columns of a csv file - El Forum - 08-03-2012

[eluser]Hampti[/eluser]
Hi there,

1) use
Code:
$enclosure = '"';
  $delimiter = ";";

2) set MS Excel CSV-Import Options accordingly

3) use openOffice or libreOffice

If i am right the latter ones let you choose delimiter, enclosure and character set on csv import. In Microsoft Excel it has to be set somewhere in options i believe, you wont get asked on importing the file.

Best Regards,
Constantin