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:

[url removed, login to view]

Ftp the file to /tempEP (the default import directory).

Let's say the file is called [url removed, login to view]

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:

[url removed, login to view]

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/[url removed, login to view]

to

admin/includes/init_includes/overrides/[url removed, login to view]

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/[url removed, login to view]:

Then set up the cron job to call the script eg:

/usr/bin/lynx -accept_all_cookies -dump http://localhost/PathTo/admin/[url removed, login to view]

华润创业加载 MySQL PHP

项目ID： #4132844

关于项目