CRELOADED Database automate Import script/solution

Script needed for automate import from excel/ .xls file to creloaded online store. 1. The source file .xls is stored on a ftp server, and will be updated everyday. 2. I need you write a script to import certain column from .xls file to creloaded online store. 3. we have to test the script until it's working perfectly. 4. some clue: use easy populate? some tips from google search, but it's for zen cart, which has been proof working ok: You can save an excel spreadsheet in CSV format and use, the Easy Populate CSV add on, available here: [login to view URL] Ftp the file to /tempEP (the default import directory). Let's say the file is called [login to view URL] You might be able to automate the above with a batch script. Then create a script to be called by cron every five minutes say. The script must first authenticate itself. see: [login to view URL] The script then sets the filename variable to import and runs the easypopulate code. To authenticate we need to override init_admin_auth.php. So copy admin/includes/init_includes/[login to view URL] to admin/includes/init_includes/overrides/[login to view URL] and add """ // to allow cron jobs set CRON_ADMIN_USER_ID if ($_SERVER['REMOTE_ADDR'] == $_SERVER['SERVER_ADDR']) { if (!isset($_SESSION['admin_id']) && defined('CRON_ADMIN_USER_ID') && CRON_ADMIN_USER_ID != '') { $_SESSION['admin_id'] = CRON_ADMIN_USER_ID; } } """ to just after """ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } """ Then we write the script for cron. Create a file /admin/[login to view URL]: Then set up the cron job to call the script eg: /usr/bin/lynx -accept_all_cookies -dump http://localhost/PathTo/admin/[login to view URL]