CRELOADED Database automate Import script/solution

In Progress

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]

Skills: CRE Loaded, MySQL, PHP

See more: use script in google spreadsheet, spreadsheet script google, script google spreadsheet, online test jobs, online store jobs, online jobs with google, online jobs on google, online jobs in google, online jobs forum, online jobs database, online jobs by google, online database jobs, ma jobs, ma code, lynx test, jobs with google online, jobs ma, jobs in ma, job search ma, google job cart, ftp batch job, database jobs online, cron jobs online, column jobs, write a script online

Project ID: #4132844

Awarded to:

toinnisfree

pls chk pmb

$220 USD in 3 days
(524 Reviews)
7.8

5 freelancers are bidding on average $162 for this job

SunrisePHP

Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Best Regards,

$90 USD in 9 days
(387 Reviews)
7.0
yanotcook

I am ready to start. Please check PM for details.

$86 USD in 3 days
(25 Reviews)
4.7
angelsofttech

I can start work now.

$150 USD in 4 days
(11 Reviews)
4.5
benideas

Hi, REady to start. Waiting for hear from you. Thanks Benideas

$200 USD in 5 days
(1 Review)
3.0
designeserive

Greetings, Let's start..... We are one of the India's highly skilled web technology experts. We specialize in giving an App idea a concrete shape with a Guarantee of Excellence, Quick turnaround and Cost-effectiven More

$150 USD in 7 days
(0 Reviews)
0.0