CRELOADED Database automate Import script/solution

IN PROGRESS
Bids
6
Avg Bid (USD)
$149
Project Budget (USD)
$85 - $260

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:
http://www.zen-cart.com/index.php?ma...oducts_id=1240

Ftp the file to /tempEP (the default import directory).
Let's say the file is called import_me.csv

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:
http://www.zen-cart.com/forum/showthread.php?t=114279

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/init_admin_auth.php
to
admin/includes/init_includes/overrides/init_admin_auth.php
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/cron1.php:


Then set up the cron job to call the script eg:
/usr/bin/lynx -accept_all_cookies -dump http://localhost/PathTo/admin/cron1.php

Skills required:
CRE Loaded, MySQL, PHP
Hire appletreesl
Project posted by:
appletreesl
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 220
in 3 days
$ 90
in 9 days
$ 86
in 3 days
$ 150
in 4 days
$ 200
in 5 days
$ 150
in 7 days