http://www.opencart.com/index.php?route ... n_id=26995
This contribution allows merchants to avoid to spend service fees while there doesn't need to be (unless having an excessive mount of data) for exporting Zen-Cart database over Excel files in order to re-import them in Opencart with this so well known contribution: http://www.opencart.com/index.php?route ... sion_id=17 .
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=27000
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
"- Go to your admin - > tools - > users - > user groups - > edit - > checkmark the module/Zencart_export and module/Zencart_settings if not checked already." Did not get these options displayed in user groups.
"- Go to your admin - > extensions - > modules - > Zencart Export. Install it." Installed. Tried Edit. Message displayed not enabled. Did not see where to enable. Did enable Zencart settings.
Previously installed PDO. Vague and ambiguous documentation.(Not your responsibility, I know...). May not have been totally correct. Could use your insight.
Thanks.
Perhaps you'd like to elaborate that a little? What seem to be the issue with your installation?Previously installed PDO. Vague and ambiguous documentation.(Not your responsibility, I know...). May not have been totally correct. Could use your insight.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Docs for PDO doesn't say how to verify database connection works.
I still can't enable zencart export.
Slightly confused as path is not "- Go to your admin - > tools - > users - > user groups - > edit - > checkmark the module/Zencart_export and module/Zencart_settings if not checked already." Rather "- Go to your admin - > system - > users - > user groups - > edit - > " and no zencart export options appear for me to check.
Thanks.
These instructions are nowhere to be found in my documentation. In both config.php and admin/config.php files, all you need to do is to make the changes for:dchaney wrote:I installed the PDO extension and made indicated changes to config.php, php.ini, in both root and admin. If I select PDO by commenting out "define('DB_DRIVER', 'mysqlidrv');" and add "define('DB_DRIVER', 'pdodriver');" (without quotes) to config.ini files, I get 505 server error on my storefront. If I remove comment marks from mysqldrv line, storefront displays.
Docs for PDO doesn't say how to verify database connection works.
I still can't enable zencart export.
Thanks.
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
The Zen-Cart extension is a free extension as it does not involve any sales fee on this one. The only lesson learned here pretty much is by not following the provided instructions.dchaney wrote:Thanks for the reply. It was my misunderstanding. I thought your documentation meant that the paid extension had to be installed.
I will uninstall the files and file modifications and chalk up the $15 to lessons learned.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
"- Go to your admin - > tools - > users - > user groups - > edit - > checkmark the module/Zencart_export and module/Zencart_settings if not checked already."
1. This path is different admin - > SYSYEM - > users - > user groups - > edit - > When I edit the user group, no zencart options are present,
2. - Go to your admin - > extensions - > modules - > Zencart Export. Install it. DO NOT RUN IT YET ! Did this.
When I try to edit iget message "text_error" The Zen-Cart export module is currently disabled!.
I enabled the Zen-Cart settings and still get the above message.
3."- Run the Zencart Export module." I don't know how to do this.
Thanks.
In your admin folder, create a new PHP file:dchaney wrote:OK thanks for the wrist slap. Now for my original questions for you:
"- Go to your admin - > tools - > users - > user groups - > edit - > checkmark the module/Zencart_export and module/Zencart_settings if not checked already."
1. This path is different admin - > SYSYEM - > users - > user groups - > edit - > When I edit the user group, no zencart options are present,
2. - Go to your admin - > extensions - > modules - > Zencart Export. Install it. DO NOT RUN IT YET ! Did this.
When I try to edit iget message "text_error" The Zen-Cart export module is currently disabled!.
I enabled the Zen-Cart settings and still get the above message.
3."- Run the Zencart Export module." I don't know how to do this.
Thanks.
Code: Select all
<?php
extension_loaded ('PDO' );
extension_loaded('pdo_mysql');
echo "<pre />\n";
print_r(get_loaded_extensions());
echo "</pre>\n";
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Ok, now remove the file. Did you activated the Zen-Cart settings module as well? This needs to be activated. Otherwise, you won't be able to use the module.dchaney wrote:Yes, I have several:
[34] => PDO
[35] => pdo_dblib
[36] => PDO_ODBC
[58] => pdo_mysql
[59] => pdo_sqlite
[60] => pdo_pgsql
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Do you notice any recent errors by date and time in your admin - > systems - > settings - > tools - > error logs page regarding the PDO class?dchaney wrote:As outlined in above posts, I set Zen-Cart Settings to enabled. Still having the problems I mentioned.
Note also ensure your logs are enabled from your admin - > systems - > settings - > edit store - > server tab.
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
Reason: Removed referral link of other party. Not acceptable !
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Im trying to use your usefull extension, following each step in the documentation. I've allready installed the Zencart Settings part in admin - > extensions - > modules - > Zencart Settings, but when I edit the database settings, I get a "Permision Denied: You do not have permission to access this page, please refer to your system administrator" messege.
I'm using the OC database settings. Am I wrong? Should I use the settings from the zencart database I'm trying to import instead? The username, database name and password are right.
Thank you for your help, and for your work in this extension.
I expect this tool to be able to export the zen cart data into format compatible with this tool; http://www.opencart.com/index.php?route ... sion_id=17
Sadly it is not.
I end up using the Easy Populate plugin in Zen Cart to export the data and copy and paste the data into the excel file required by the Export/Import tool before import it into OC.
Users browsing this forum: No registered users and 47 guests