Closed

CRELOADED Database automate Import script/solution

This project was awarded to toinnisfree for $220 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$85 - $260 USD
Total Bids
6
Project Description

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]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online