I am having issues with this mod i have checked all php settings but still nothing i contacted my webhosts and they replied with this.
When i try to export my info (6mb) of database once i download the excel file it says its corrupted and only downloads 221 bytes and with an error in A2 "<b>Fatal error</b>: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 523800 bytes) in <b>/home/adulttoy/public_html/system/pear/Spreadsheet/Excel/Writer/Parser.php</b> on line <b>1132</b><br />"
"It seems the php memory limit set in file "admin/controller/tool/export.php" [ini_set] due to which its conflicting and throwing allowed memory size error.
I've also tried to set the memory limit from 8MB to 1024MB in this file and also in all the php.ini files present under your account but its still giving the same error for the ini_set memory limit.
I'd suggest you to please contact the support community of opencart application vendor and ask them to provide any work around for this memory problem/issue and update us if in case they suggest any server side changes in php configuration so that we will try to do it for you to overcome this issue.
Please let us know if I/we can be of any further assistance. Standing by to assist you.
"
Can anyone help with this at all please.
Regards
Stuart
http://www.opencartnews.com/tutorials/c ... olve-them/ on how to do it.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Export / Import для ocStore 1.5.5.x (HTML-тег H1 + HTML-тег Title) 1
# # # # # # # # # # # # # # # # # # # # # # # # #
description
# # # # # # # # # # # # # # # # # # # # # # # # #
Export / Import XLS- file
Version : 1.0 Beta
The module allows you to export / import products and categories with options attributes Reviews
and other additional information . information ( including SEO TITLE and SEO H1). The exported file can be edited
and then imported back into the database.
From other similar modules differs solve memory when working with large files.
Usually takes the following error : Fatal Error: Allowed memory size of
In this module, export / import , stepwise processing xls- file, so such errors will occur !
Tested on OcStore: 1.5.5.1.2, 1.5.4.1
If you have any questions while working with the module , please contact :
havisaid@gmail.com
skype: havisaid
# # # # # # # # # # # # # # # # # # # # # # # # #
INSTALLATION
# # # # # # # # # # # # # # # # # # # # # # # # #
To operate the module is VQMod!
1) Load the contents of the directory upload to the root of the site. This updates the library PHPExcel to version 1.8 .
So I recommend to check all modules that use this library .
2) Make sure that the directory admin / uploads set write permissions ( 777 ) .
3) Before using the newly installed module , first install to add the Administrators group.
In the admin interface, select System > Users> User Groups > Chief Administrator .
Click on " Select all " in windows "Access " and " Change ." Must put down a tick. Save.
Module is installed !
Original module page here
https://opencartforum.com/files/file/17 ... %BE%D0%B2/
Download from Dropbox here
https://www.dropbox.com/s/be97threx74d9 ... .1beta.zip
I am posting it as it was posted by the Russian co-author including his donation build-in form.
Works for me on OCstore 1.5.5.1.2 with 64mb memory_limit
Module has been updated to v1.1 - download links have been updated
The exactly the same database worked just fine on 1.5.1.3. I've increased the memory limit to the max (128mb) but error persists. Any other suggestions how to fix the error?
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 59 bytes) in D:\xampp\htdocs\opencart\system\PHPExcel\Classes\PHPExcel\Style\Supervisor.php on line 123
When I try to import the modified spreadsheet I get the following message:
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
The error log shows:
2014-06-12 6:12:28 - PHP Notice: Undefined variable: text_export in /home/troycoma/public_html/airdirect/acdconf/view/template/common/header.tpl on line 206
2014-06-12 6:14:11 - PHP Notice: Undefined variable: text_export in /home/troycoma/public_html/airdirect/acdconf/view/template/common/header.tpl on line 206
2014-06-12 6:14:50 - PHP Unknown: Only variables should be assigned by reference in /home/troycoma/public_html/airdirect/acdconf/model/tool/export.php on line 1570
2014-06-12 6:14:50 - PHP Unknown: Only variables should be assigned by reference in /home/troycoma/public_html/airdirect/acdconf/model/tool/export.php on line 1583
2014-06-12 06:14:50 - Export/Import: Invalid header in the Products worksheet
2014-06-12 6:14:50 - PHP Notice: Undefined variable: text_export in /home/troycoma/public_html/airdirect/acdconf/view/template/common/header.tpl on line 206
I've gone through the spreadsheet and cannot find anything wrong? Any ideas please.
As regards your error message
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
Your system/logs/error.txt clearly shows why:
2014-06-12 06:14:50 - Export/Import: Invalid header in the Products worksheet
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I modified the spreadsheet cells to ensure they were all ok and it uploaded. However not all of the products were imported.
If I export the data it only shows some of the products and none of the new ones?
We exported the original spreadsheet from the site which had products in it. We have updated this sheet with new categories and many new products.
Any ideas would be appreciated )
It also only uploaded 293/600 new products that I had on csv sheet.
Error Log:
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1570
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1583
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1609
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1622
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1635
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1648
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1661
Your error messages have nothing to do with your blank screen, there should be another entry in your log. The most likely reason is a timeout issue.barnone wrote:Having some trouble with import/export tool. It goes to white screen after showing upload %. Displays no success message.
It also only uploaded 293/600 new products that I had on csv sheet.
Error Log:
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1570
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1583
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1609
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1622
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1635
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1648
2014-08-23 1:11:28 - PHP Unknown: Only variables should be assigned by reference in /home/barnon5/public_html/admin/model/tool/export.php on line 1661
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
2014-08-25 16:18:12 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,'2014-07-20 21:37:25','0000-00-00 00:00:00','2014-07-20',0,5,1,0,0,0,0,0,'3','' at line 1<br />Error No: 1064<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (294,1,'','','','','','','', in /home/user/public_html/system/database/mysql.php on line 50
Please copy and paste the whole error message here, otherwise I can't help!barnone wrote:The last line of code I see in there is:
2014-08-25 16:18:12 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,'2014-07-20 21:37:25','0000-00-00 00:00:00','2014-07-20',0,5,1,0,0,0,0,0,'3','' at line 1<br />Error No: 1064<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (294,1,'','','','','','','', in /home/user/public_html/system/database/mysql.php on line 50
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Combined with the above info it was full error message.JNeuhoff wrote:Please copy and paste the whole error message here, otherwise I can't help!barnone wrote:The last line of code I see in there is:
2014-08-25 16:18:12 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,'2014-07-20 21:37:25','0000-00-00 00:00:00','2014-07-20',0,5,1,0,0,0,0,0,'3','' at line 1<br />Error No: 1064<br />INSERT INTO `oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (294,1,'','','','','','','', in /home/user/public_html/system/database/mysql.php on line 50
Anyway I manged to figure out the issue. I was missing price and date available on a product in the import. Missed it on first inspection, but anyway import went through fine.
Many thanks for creating this tool. I have a problem going from 1.4.9.2 to 1.5.6.4. The Export seems to work fine. I get the error message "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!". Looking at error.log of 1.5.6.4, I get:
"2014-08-26 10:54:10 - PHP Notice: Undefined index: import in /var/www/vhost/example.com/httpsdocs/admin/controller/tool/backup.php on line 13
2014-08-26 11:52:52 - Export/Import: Invalid number of worksheets, 8 worksheets expected
2014-08-26 11:58:15 - Export/Import: Invalid number of worksheets, 8 worksheets expected"
This is a new install with VQMOD installed, but the database prefix is different to that of the old one. I also have testimonials and promotional tags modules installed.
Any ideas? Regards...
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I try your extension which is very good!
http://www.opencart.com/index.php?route ... sion_id=17
Now I like to know how to import/export all translations (category/articles)?
Izdelava spletne trgovine | Najem spletne trgovine | PHP programiranje
What translations exactly are you talking about? Categgory names and descriptions?
Bear in mind that the Export/Import tool only support one language.
We are currently working on a multilingual version of the Export/Import tool which we expect to have released soon.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
category title, description
article title, description, meta
Izdelava spletne trgovine | Najem spletne trgovine | PHP programiranje
PHP Notice: Undefined variable: footer_top in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/footer.tpl on line 7
Notice: Undefined variable: templatecolor in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/header.tpl on line 67
Notice: Undefined variable: header_top in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/header.tpl on line 98
Notice: Undefined variable: boss_megamenu in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/header.tpl on line 108
Notice: Undefined variable: header_bottom in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/header.tpl on line 115
Notice: Undefined variable: footer_top in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/footer.tpl on line 7
Notice: Undefined variable: footer_bottom in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/footer.tpl on line 39
Notice: Undefined variable: currency in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/footer.tpl on line 48
Notice: Undefined variable: language in /customers/9/b/0/bilnavi.se/httpd.www/catalog/view/theme/bt_extroic/template/common/footer.tpl on line 49
Users browsing this forum: No registered users and 61 guests