No core files, all new files developed by modules and a library. PHPExcel has been included in the package. If you have it and especially under the same folder already, you do not need to re-upload this folder particularly unless the version is pretty old. This version support Excel 2007 and may be above.
Please follow the documentation tab and post on the support forum for technical assistance.
The worksheet names are intentionally reduced due to the limitation of the maximum characters of 31. However, these limitations will NOT prevent users in any way to import these fields and values. The fields are included in the Excel sheets.
Requires PDO Extension!
Contribution: http://www.opencart.com/index.php?route ... n_id=27021
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
The oscommerce export module is currently disabled!
Attachments
ocCapture.PNG (11.84 KiB) Viewed 7722 times
Which OC version are you using and what are the exact step-by-step procedures you did to get this status message?Mabudigital wrote:Hi, Im getting this error:
The oscommerce export module is currently disabled!
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I manually upload all the files except PHPExcel and follow the module documentation on documentation tab. I have to add this to the admin/config:
define('DB_TYPE', 'mpdo');
[Simply upload all files to their proper folders as described in the ZIP package (except PHPExcel if you already have it installed and especially on the same folder). Notice that the admin/language/en-gb may need to be renamed to 'en' (without quotes) or simply take the files inside and upload the sub-folder to your destination language folder. Very simple.
- Go to your admin - > tools - > users - > user groups - > edit - > checkmark the module/oscommerce_export and module/oscommerce_settings if not checked already.
- Go to your admin - > extensions - > modules - > oscommerce Settings. Install it. Then, fill in the database form from the edit button.
- Go to your admin - > extensions - > modules - > oscommerce Export. Install it. DO NOT RUN IT YET !
- In your admin/config.php file, ensure that the DB_TYPE is set to: 'mpdo' . There is no need to configure your root config.php file for this.
In both config.php and admin/config.php files, make the changes for:
Code: Select all
define('DB_DRIVER', 'mpdo');
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Fatal error: Class 'PDO' not found in /home/*****/public_html/******/system/library/db/mpdo.php on line 9
Follow this step: http://forum.opencart.com/viewtopic.php ... 79#p630011 and see if you can notice prefixes starting with: pdo on the list.Mabudigital wrote:Ok aparently the server has a problem with PDO
Fatal error: Class 'PDO' not found in /home/*****/public_html/******/system/library/db/mpdo.php on line 9
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
(
[0] => Core
[1] => date
[2] => ereg
[3] => libxml
[4] => openssl
[5] => pcre
[6] => sqlite3
[7] => zlib
[8] => bcmath
[9] => calendar
[10] => ctype
[11] => curl
[12] => dom
[13] => hash
[14] => filter
[15] => ftp
[16] => gd
[17] => SPL
[18] => iconv
[19] => session
[20] => json
[21] => mbstring
[22] => mcrypt
[23] => mysql
[24] => mysqli
[25] => standard
[26] => Phar
[27] => posix
[28] => Reflection
[29] => imap
[30] => SimpleXML
[31] => sockets
[32] => exif
[33] => tokenizer
[34] => xml
[35] => xmlreader
[36] => xmlrpc
[37] => xmlwriter
[38] => zip
[39] => cgi-fcgi
)
Problem solved, pdo is not installed or is installed but not activated on your server. I would suggest to contact your host to have the PDO extension installed / activated.Mabudigital wrote:Array
(
[0] => Core
[1] => date
[2] => ereg
[3] => libxml
[4] => openssl
[5] => pcre
[6] => sqlite3
[7] => zlib
[8] => bcmath
[9] => calendar
[10] => ctype
[11] => curl
[12] => dom
[13] => hash
[14] => filter
[15] => ftp
[16] => gd
[17] => SPL
[18] => iconv
[19] => session
[20] => json
[21] => mbstring
[22] => mcrypt
[23] => mysql
[24] => mysqli
[25] => standard
[26] => Phar
[27] => posix
[28] => Reflection
[29] => imap
[30] => SimpleXML
[31] => sockets
[32] => exif
[33] => tokenizer
[34] => xml
[35] => xmlreader
[36] => xmlrpc
[37] => xmlwriter
[38] => zip
[39] => cgi-fcgi
)
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
How can I fix it?Fatal error: Uncaught exception 'Exception' with message 'SQLSTATE[HY000] [2002] Connection timed out' in /home/******/public_html/storesample/system/library/oscommerce.php:26 Stack trace: #0 /home/********/public_html/storesample/system/storage/modification/system/engine/loader.php(94): Oscommerce->__construct(Object(Registry)) #1 /home/*******/public_html/storesample/admin/model/tool/oscommerce_export.php(4): Loader->library('oscommerce') #2 /home/********/public_html/storesample/admin/model/tool/oscommerce_export.php(12): ModelToolOscommerceExport->getTablesList() #3 [internal function]: ModelToolOscommerceExport->getTablesListCount() #4 /home/********/public_html/storesample/system/storage/modification/system/engine/loader.php(150): call_user_func_array(Array, Array) #5 [internal function]: Loader->{closure}(Array) #6 /home/*********/public_html/storesample/system/engine/proxy.php(13): call_user_func(Object(Closure), Array) #7 /home/*********/public_html/storesample/admin/controller/module/oscommerce_export.php(48): in /home/*********/public_html/storesample/system/library/oscommerce.php on line 26
Reason: Added quotes.
As per the event message provides on the above, it is stating: Connection time out which means you are trying to access another domain from your current domain with the PDO extension which is restricted host-based by your host console. There is a way to unlock the target domain. Although, I definitely do NOT recommend this approach but rather to export your Opencart database from your target domain via PHPMyAdmin and import it as a new database into your current domain. Then, to modify the OsCommerce Export Settings form to point your server name towards the same location where your current store is being handled.Mabudigital wrote:Ok I run the script from a server with pdo enable but I get this error:
How can I fix it?Fatal error: Uncaught exception 'Exception' with message 'SQLSTATE[HY000] [2002] Connection timed out' in /home/******/public_html/storesample/system/library/oscommerce.php:26 Stack trace: #0 /home/********/public_html/storesample/system/storage/modification/system/engine/loader.php(94): Oscommerce->__construct(Object(Registry)) #1 /home/*******/public_html/storesample/admin/model/tool/oscommerce_export.php(4): Loader->library('oscommerce') #2 /home/********/public_html/storesample/admin/model/tool/oscommerce_export.php(12): ModelToolOscommerceExport->getTablesList() #3 [internal function]: ModelToolOscommerceExport->getTablesListCount() #4 /home/********/public_html/storesample/system/storage/modification/system/engine/loader.php(150): call_user_func_array(Array, Array) #5 [internal function]: Loader->{closure}(Array) #6 /home/*********/public_html/storesample/system/engine/proxy.php(13): call_user_func(Object(Closure), Array) #7 /home/*********/public_html/storesample/admin/controller/module/oscommerce_export.php(48): in /home/*********/public_html/storesample/system/library/oscommerce.php on line 26
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Hoping I can get this to work. I am trying to migrate my OsCommerce (2.3.4) into the latest OpenCart (2.3.0.2).
I am trying carefully to follow the installation instructions for this extension, BUT, after I install the extension, when I try to enter the database details and hit save, I get:
Permission Denied!
Home Permission Denied!
Permission Denied!
You do not have permission to access this page, please refer to your system administrator.
I am assuming that I am to put in the database information for my OsCommerce install, so that the exporter can access and generate the Excel, but I have tried and tried, and I keep getting permission denied.
Help would be much appreciated.
Thanks.
Rick
Buehler? Buehler? ...
Good Luck
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
So what??24hourcampfire wrote:Geez is it really this slow to get some help for OpenCart? I mean I'd love to try it but at this rate it will take me months to get set up.
Buehler? Buehler? ...
You are using an extension developed by someone.
And it is not working as expected.
Now instead of contacting this developer and ask for help, you expect that others here know this extension.
And are able to help.
As Ernie suggested, don't cry here around, instead post in the Commercial Forum Section and maybe someone may help you.
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Users browsing this forum: No registered users and 57 guests