CRELOADED Database automate Import script/solution

V teku Objavljeno Jan 16, 2013 Plačilo ob prevzemu
V teku Plačilo ob prevzemu

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]

CRE Loaded MySQL PHP

ID projekta: #4132844

Več o projektu

5 predlogov Oddaljen projekt Aktiven Jan 17, 2013

Dodeljeno:

toinnisfree

pls chk pmb

$220 USD v 3 dneh
(524 mnenj)
7.8

5 freelancerjev ponuja v povprečju za $162 na tem delu

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 v 9 dneh
(387 ocen)
7.0
yanotcook

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

$86 USD v 3 dneh
(25 ocen)
4.7
angelsofttech

I can start work now.

$150 USD v 4 dneh
(11 ocen)
4.5
benideas

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

$200 USD v 5 dneh
(1 Ocena)
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 Več

$150 USD v 7 dneh
(0 ocen)
0.0