Export Module

[Guest]

Hello Everyone,

 

Does anyone know if any of the modules available (ie.MYOB etc) can automatically generate a csv file or a excel type file at a given time everyday or every time when an order is placed? Basically, we need a way for it to send a report or file to the store owner showing them the orders for that day.

 

Thanks in advance,

 

Shawn

[yeahyeahyeah]

Hello Everyone,

 

Does anyone know if any of the modules available (ie.MYOB etc) can automatically generate a csv file or a excel type file at a given time everyday or every time when an order is placed? Basically, we need a way for it to send a report or file to the store owner showing them the orders for that day.

 

Thanks in advance,

 

Shawn

a great class for this is called cbmysql. i think you can find it on sourceforge. i've used it in the past to make quick and dirty CSVs. just put the class in your php lib path.

 

<?
include ('/usr/lib/php/cbmysql.class.php');
include ('includes/application_top.php');
$m=new MySQL;

$m->init(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE);
$m->select2csv("SELECT * from customers;");
$m->close();
?>

[cannuck1964]

You can also extract the export logic and make it as it's own stand alone file, then set this file up as a CRON job, this will allow you to automate the file export....

 

cheers,

Peter M.

[peabbles]

You can also extract the export logic and make it as it's own stand alone file, then set this file up as a CRON job, this will allow you to automate the file export....

 

cheers,

Peter M.

 

 

How would you setup the CRON job? Does anyone have the cbMySql class. I can't find it online

Edited December 5, 2005 by peabbles