Post by alexismertens » Fri May 11, 2012 9:34 am

Hello,

I need to make a simple interface with FTP with my logistics.

Everyday at same time a php script must connect to my DB, generate a CSV file with a few specific columns of the order and order_product tables for all order in status=x, connect to the FTP of my logistic and put the CSV there.

Also everyday but at another time, the php script must connect to the FTP, read the updated CSV file (in another folder) and updating the order status ids and adding the tracking code as comment.

That's it.

Please make your offer,

Newbie

Posts

Joined
Sat Mar 03, 2012 1:30 am

Post by Avvici » Thu May 24, 2012 5:51 am

Yup, you would want to do this with a CRON JOB function. I have the script that will put the file in the directory of your choice but you will have to set up the CRON JOB. You can set these up from within your cpanel and read about them here:
http://net.tutsplus.com/tutorials/php/m ... ith-php-2/

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC
Who is online

Users browsing this forum: No registered users and 9 guests