I have nearly finished a new bulk import/export of categories from/to an Excel XML spreadsheet file. I am planning to do something similar for products, too.
If anybody is interested, I can upload it to the OpenCart extensions site under a GPL license sometime next week. It would be based upon OpenCart 0.7.7 and be bundled with my other XHTML-compliancy extension which I already uploaded last week.
Let me know if anybody is interested in it.
3806 wrote: It is export of the list of the goods in the form of price-lists?
The export feature for the products will include all of the database fields from the 'product', 'product_description' and 'product_discount' tables. The 'price' field is included in that, too.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Well I finished the Export/Import to/from Spreadsheet feature, see http://forum.opencart.com/index.php/topic,853.0.html . I am still struggling with the 255 character limitation when reading an uploaded XLS-file in PHP, once that problem is sorted out, I'll upload this addon as a free contribution.
If anybody has a solution to reading large text fields (> 255 characters) from a XLS-file in PHP, that would help. Currently I am using the Excel Reader script from http://sourceforge.net/projects/phpexcelreader, if anybody knows a better one let me know!
If anybody has a solution to reading large text fields (> 255 characters) from a XLS-file in PHP, that would help. Currently I am using the Excel Reader script from http://sourceforge.net/projects/phpexcelreader, if anybody knows a better one let me know!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have now uploaded the bulk import/export module, you can download it from http://www.opencart.com/contribution/in ... tion_id/34 .
The Import/Export module is a new administrative feature which allows the admin user to do a bulk export
of all the categories, products, and product options to an Excel spreadsheet file. The spreadsheet file can be edited offline and then be re-imported to the OpenCart database.
Enjoy.
The Import/Export module is a new administrative feature which allows the admin user to do a bulk export
of all the categories, products, and product options to an Excel spreadsheet file. The spreadsheet file can be edited offline and then be re-imported to the OpenCart database.
Enjoy.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Does not work... 
By pressing of the button "export" - opens a blank page..
Version PHP: 5.2.5
Version DB: MySQL 5.0.51-log
*****Russian*******
Не работает...
При нажатии кнопки экспорт открывается белая страница
Версия PHP: 5.2.5
Версия базы данных: MySQL 5.0.51-log
By pressing of the button "export" - opens a blank page..
Version PHP: 5.2.5
Version DB: MySQL 5.0.51-log
*****Russian*******
Не работает...
При нажатии кнопки экспорт открывается белая страница
Версия PHP: 5.2.5
Версия базы данных: MySQL 5.0.51-log
Have you exactly added or overridden the following files in your admin directory of OpenCart 0.7.7 ?Does not work...
By pressing of the button "export" - opens a blank page..
Version PHP: 5.2.5
Version DB: MySQL 5.0.51-log
admin/controller/export.php
admin/extension/module/menu.php
admin/language/english/controller/export.php
admin/language/english/extension/module/menu.php
admin/language/german/controller/export.php
admin/language/german/extension/module/menu.php
admin/OLE/OLE.php
admin/OLE/PPS.php
admin/OLE/PPS/File.php
admin/OLE/PPS/Root.php
admin/Spreadsheet/Excel/Reader.php
admin/Spreadsheet/Excel/Writer.php
admin/Spreadsheet/Excel/Reader/OLERead.php
admin/Spreadsheet/Excel/Writer/BIFFwriter.php
admin/Spreadsheet/Excel/Writer/Format.php
admin/Spreadsheet/Excel/Writer/Parser.php
admin/Spreadsheet/Excel/Writer/Validator.php
admin/Spreadsheet/Excel/Writer/Workbook.php
admin/Spreadsheet/Excel/Writer/Worksheet.php
admin/template/default/module/menu.tpl
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
In the admin interface, chooseWhen I go to Admin - Configuration - Export / Import, it doesn't work. It says:
"Permission Denied!
You do not have permission to access this page, please refer to your system administrator."
What should I do?
Admin > Configuration > Users > User Group
From there, select 'Top Adminstrator', then click on the Update-icon to the right. This will open up an edit window with multichoice dropdown lists for 'Access' and 'Modify' rights. In both of them, you'll see a new entry for 'Export' which you can select via a Ctrl-Click.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for your help. Now I can import and export but there is another problem:
When I try to open the "backup_categories_products.xls" it doesn't work. I've tried with OpenOffice and Microsoft Excel. It says: "backup_categories_products.xls: format file is not valid".
When I try to open the "backup_categories_products.xls" it doesn't work. I've tried with OpenOffice and Microsoft Excel. It says: "backup_categories_products.xls: format file is not valid".
I just uploaded an updated package with a bugfix, please try the new package from http://www.opencart.com/contribution/in ... tion_id/34 . I tested it with a freshly installed OpenCart 0.7.7 on a Linux system using PHP 5.1.6 and MySQL 5.0.22 and on a Linux live server using PHP PHP 5.2.4 and MySQL 5.0.45-community, and it works fine. I also tested the resulting spreadsheet with both OpenOffice 2.0.4 and MS Excel 2003.When I try to open the "backup_categories_products.xls" it doesn't work. I've tried with OpenOffice and Microsoft Excel. It says: "backup_categories_products.xls: format file is not valid".
Last edited by JNeuhoff on Tue Feb 12, 2008 1:31 am, edited 1 time in total.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I just tried the updated package but it's the same. I've tried to open the xls file in 2 ways: linux + openoffice and secondly windows + microsoft excel. To see what result I get when I try to open the xls file ( first two snapshots - oppenoffice, the 3rd - microsoft excel): http://kazo.110mb.com/
I'm using PHP 5.2.1 and MySQL 5.0.37, but I don't think that's the problem.
I'm using PHP 5.2.1 and MySQL 5.0.37, but I don't think that's the problem.
Last edited by kazo on Tue Feb 12, 2008 11:50 pm, edited 1 time in total.
To get to the ground of this can you do the the following: Create a complete backup of the database (Admin > Configuration > Backup / Restore) and e-mail it to me (opencart at mhccorp.com)? Then I can load it on my own test server and see whether I can replicate this error. Or I can do the same if you give me access to our OpenCart server.I just tried the updated package but it's the same. I've tried to open the xls file in 2 ways: linux + openoffice and secondly windows + microsoft excel. To see what result I get when I try to open the xls file ( first two snapshots - oppenoffice, the 3rd - microsoft excel): http://kazo.110mb.com/
Last edited by JNeuhoff on Wed Feb 13, 2008 2:08 am, edited 1 time in total.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I don't have a database yet. Just the sample products from opencart. I want to populate my database using import/export feature. I will have a database with 1000+ products and I want a easy import/export feature. That's why it's absolutely necesarry for me that import/export feature should work.
Download backup file and xls file from kazo.110mb.com
Download backup file and xls file from kazo.110mb.com
That beats me at the moment.
Can you do the following:
- Do a fresh install of OpenCart 0.7.7
- Then install the Export/Import module by overriding/adding the appropriate files
- Add the permission via Admin > Configuration > Users > User Group > Top Adminstrator for the export.php script
That's what I did, and it works fine.
Are you using Linux or Windows?
Can you do the following:
- Do a fresh install of OpenCart 0.7.7
- Then install the Export/Import module by overriding/adding the appropriate files
- Add the permission via Admin > Configuration > Users > User Group > Top Adminstrator for the export.php script
That's what I did, and it works fine.
Are you using Linux or Windows?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Who is online
Users browsing this forum: No registered users and 3 guests
