CSV string empty - Export All Customers

sampathkumara · November 2, 2008

I am using contribution to export all customer details to CSV file.

so i am geting this error , CSV string empty

below is the my code, can anyone tell where is wrong.

<?php

/*

$Id: all_customers.php, v1.0 March 21, 2005 18:45:00

adapted by Robert Goth June 24, 2005

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

written by Jared Call at client' suggestion

some code nicked and modified from /catalog/admin/customers.php

Released under the GNU General Public License

*/

//

// entry for bouncing csv string back as file

if (isset($_POST['csv'])) {

if ($HTTP_POST_VARS['saveas']) { // rebound posted csv as save file

$savename= $HTTP_POST_VARS['saveas'] . ".csv";

}

else $savename='unknown.csv';

#$csv_string = '';

if ($HTTP_POST_VARS['csv']) $csv_string=$HTTP_POST_VARS['csv'];

if (strlen($csv_string)>0)

{

header("Expires: Mon, 26 Nov 1962 00:00:00 GMT");

header("Last-Modified: " . gmdate('D,d M Y H:i:s') . ' GMT');

header("Cache-Control: no-cache, must-revalidate");

//header("Pragma: no-cache");

header("Pragma: public");

//header("Content-Type: Application/octet-stream");

header("Content-Type: application/force-download\n");

header("Content-Disposition: attachment; filename=$savename");

echo 'First Name , Last Name , Email , Street Address , City , Province , Postal Code, Country , Telephone No.';

echo $csv_string;

}

else echo "CSV string empty";

exit;

};

?>

<?php require('includes/application_top.php'); ?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<?php

// Used to determine sorting order by field

switch ($orderby) {

case "email" :

$db_orderby = "c.customers_email_address";

break;

case "address":

$db_orderby = "a.entry_street_address";

break;

case "city":

$db_orderby = "a.entry_city";

break;

case "state":

$db_orderby = "z.zone_code";

break;

case "country":

$db_orderby = "co.countries_name";

break;

case "telephone":

$db_orderby = "c.customers_telephone";

break;

case "pcode":

$db_orderby = "a.entry_postcode";

break;

default :

$db_orderby = "a.entry_lastname";;

break;

}

// $customers_query_raw = "SELECT c.customers_id , c.customers_default_address_id, c.customers_email_address, c.customers_fax, c.customers_telephone, a.entry_company, a.address_book_id, a.customers_id, a.entry_firstname, a.entry_lastname, a.entry_street_address, a.entry_suburb, a.entry_city, a.entry_state, a.entry_postcode, a.entry_country_id, a.entry_zone_id, z.zone_code, co.countries_name FROM " . TABLE_CUSTOMERS . " c JOIN " . TABLE_ZONES . " z ON a.entry_zone_id = z.zone_id JOIN " . TABLE_COUNTRIES . " co ON a.entry_country_id = co.countries_id LEFT JOIN " . TABLE_ADDRESS_BOOK . " a ON c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id ORDER BY $db_orderby $sorted";

// $customers_query_raw = "SELECT c.customers_id , c.customers_default_address_id, c.customers_email_address, c.customers_fax, c.customers_telephone, a.entry_company, a.address_book_id, a.customers_id, a.entry_firstname, a.entry_lastname, a.entry_street_address, a.entry_suburb, a.entry_city, a.entry_state, a.entry_postcode, a.entry_country_id, a.entry_zone_id, z.zone_code, co.countries_name FROM " . TABLE_CUSTOMERS . " c, ". TABLE_ZONES ." z, " . TABLE_ADDRESS_BOOK . " a, " . TABLE_COUNTRIES . " co WHERE a.entry_zone_id = z.zone_id AND a.entry_country_id = co.countries_id AND c.customers_id = a.customers_id AND c.customers_default_address_id = a.address_book_id ORDER BY $db_orderby $sorted";

$customers_query_raw = "SELECT c.customers_id , c.customers_default_address_id, c.customers_email_address, c.customers_dob, c.customers_telephone, c.customers_gender, a.entry_company, a.address_book_id, a.customers_id, a.entry_firstname, a.entry_lastname, a.entry_street_address, a.entry_suburb, a.entry_city, a.entry_state, a.entry_postcode, a.entry_country_id, a.entry_zone_id, z.zone_code, co.countries_name FROM " . TABLE_CUSTOMERS . " c LEFT JOIN " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id JOIN " . TABLE_COUNTRIES . " co ON a.entry_country_id = co.countries_id LEFT JOIN " . TABLE_ZONES . " z ON a.entry_zone_id = z.zone_id ORDER BY $db_orderby $sorted";

$customers_query = tep_db_query($customers_query_raw);

//BOF HEADER ?>

<? /*<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NUMBER; ?></td> */ ?>

<td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, TELEPHONE_NUMBER, 'telephone');

//EOF HEADER

?></td>

</tr>

<?php

$num_rows = tep_db_num_rows($customers_query);

while ($customers = tep_db_fetch_array($customers_query)) {

if ( tep_not_null($customers['customers_id']) ) {

$rows++;

if (strlen($rows) < 2) {

$rows = '0' . $rows;

}

$csv_accum .= "\n";

$email = '<a href="mailto:' . $customers['customers_email_address'] . '">'

. $customers['customers_email_address'] . '</a>';

$full_name = '<a href="customers.php?cID=' . $customers['customers_id'] . '&action=edit"> ' . $customers['entry_lastname'] . ", " . $customers['entry_firstname'] . '</a>';

?>

<? /* <td align="left" class="dataTableContent"><?php echo $rows; ?>.</td> */ ?>

</tr>

<?php

} else { }

}

?>

</tr>

<?php

if ($num_rows>0 && !$print) {

?>

<td class="smallText" colspan="4" style="padding-top:15px;"><form action="<?php echo $_SERVER['PHP_SELF']; ?>" method=post><input type='hidden' name='csv' value='<?php echo $csv_accum; ?>'><input type='hidden' name='saveas' value='Customer_list <?php

//suggested file name for csv, include year and month

echo date("Y" . "-" . "m" . "-" . "d" . "-" . "Hi");

?>'><input type="submit" value="<?php echo TEXT_BUTTON_REPORT_SAVE ;?>"></form>

</td>

</tr>

<?php }; // end button for Save CSV ?>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

</body>

</html>

CSV string empty - Export All Customers

Recommended Posts

sampathkumara

Archived

Browse

Activity