Automate CSV through schedule

[bb19]

Dears,

I'm trying to automate the csv import through schedule,
for this reason i created two schedule:
1- to truncate the table created for the list X
2- To import data through a csv file located on the hosting server.

I appreciate if someone can help me to create both php code in order to add them to the schedule.

For step number 1 i already chose the plugin php from schedule and added into "PHP Code" the following querry
mysql_query( "DELETE FROM fidelity" );
however it's not working (0 record deleted)

Your help is much appreciated.

Regards

 

[troester]

You should use the Joomla API to access your DB
http://fabrikar.com/forums/index.php?wiki/common-php-tasks/

 

[bb19]

thank you @troester, What about the csv import? any idea?

 

[cheesegrits]

Have you looked at the CSV import cron plugin?

http://fabrikar.com/forums/index.php?wiki/import-csv-scheduled-task/

-- hugh