CRELOADED Database automate Import script/solution
$85-260 USD
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]
ID projekta: #4132844
Več o projektu
Dodeljeno:
5 freelancerjev ponuja v povprečju za $162 na tem delu
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,
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č