2. PHPRunner General questions
  3. [SOLVED]  Import by cron job
This topic is locked
[SOLVED]

 Import by cron job

 		1/31/2011 3:20:25 AM
PHPRunner General questions
U
 uli author

I'm looking for a way to import customer data daily from another system to the phprunner application. The customer list is available as MS Excel. Can the import job be triggered automaticly by a cron job?
Thanks for help.
P
 		pvdemael 2/1/2011

As far as I understand, this has nothing to do with PHPRunner. the PHPRunner application is just the frontend to the database for human clients.

Automatic importing is a machine task and the machine can not interact with the application.

You can use the the mysql command line in cron jobs to do these task.

You will probably have to convert them to txt files and they need to be structured.

Just have a look at the mysql forums
U
 		uli author 2/2/2011



As far as I understand, this has nothing to do with PHPRunner. the PHPRunner application is just the frontend to the database for human clients.

Automatic importing is a machine task and the machine can not interact with the application.

You can use the the mysql command line in cron jobs to do these task.

You will probably have to convert them to txt files and they need to be structured.

Just have a look at the mysql forums



Thanks Pieter for sharing my task.

But there is some work to do, going the way from Excel to mysql. Most of that is solved in phprunner (converting of data formats, allocation of data fields etc.) The question is, is there a way to trigger the import job and passing the path / filename of the xml file. This could be saved in a folder at the server where the application is located.
P
 		procheck 2/2/2011

There are a lot of programs that will convert XLS to MySQL.
romaldus 2/2/2011

this link may helps:

http://www.htmlcente...ipts-with-cron/
or

try to googling with this keyword "php cron job"