How do I export data to csv file?

[cstreet]

We want to export Welcome to BeSeenOnAbike products to a csv file.

Product Info Export File

Can someone describe how to do this?

[jpf]

You host's phpMyAdmin panel does have a export to CVS.

Supports:
CSV
CSV for MS Excel
Microsoft Excel 2000
Microsoft Word 2000
LaTeX
Open Document Spreadsheet
Open Document Text
PDF
SQL
XML

However only support IMPORTING as
SQL compatibility mode:
NONE
ANSI
DB2
MAXDB
MYSQL323


Chose your a specific table or the whole database - for a one time thing great.

If your looking at "Product Info Export Files" this is not included as a default but can be added easily - this is for export only.

As well as there is Easy Populate - already included in osCMax - support export and importing as well.

[cstreet]

Thanks very much. I'm going to try to use Easy Populate first.

Chris Street
Welcome to BeSeenOnAbike
DataMind Home page

[trochia]

This will export to csv your products into the file you would like. But if you have any NULL (emptydata) in the fields, you'll get misplacement...but it also calls attention to any input, that was missed...that you may correct. Either via osCMax, or faster using phpMyAdmin as Michael mentioned.

Once corrected (missing entries), you may then select individual fields, instead of *

PHP Code:

<?php
$host = 'localhost'; // use URL if external server
$user = 'dbUserName'; // Change me
$pass = 'dbPassword; //Change me
$db = 'dbName'; // Change me
$table = 'products';
$file = 'export';
$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");
$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field]."; ";
$i++;
}
}
$csv_output .= "n";
$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j]."; ";
}
$csv_output .= "n";
}
$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>

Hope this helps