Post by butte » Wed Feb 19, 2014 8:20 am

kyolic, you can also read the present thread in a mere several minutes -- starting from either end.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by saltsalty » Sun Mar 02, 2014 3:41 am

Hi,

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

New member

Posts

Joined
Fri Mar 16, 2012 5:32 pm

Post by zerofirefox » Sat Apr 26, 2014 8:03 pm

This is a fork of your mod from the Russian forum

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

Newbie

Posts

Joined
Sat Apr 26, 2014 7:53 pm

Post by misscaprice » Wed Jun 11, 2014 9:29 pm

I'm experiencing the same error with this mod on OC 1.5.6.4 running on localhost.
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

New member

Posts

Joined
Sat Jan 22, 2011 6:47 pm

Post by qbtadmin » Thu Jun 12, 2014 4:19 am

HI,

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.

Newbie

Posts

Joined
Thu Jun 12, 2014 4:17 am

Post by JNeuhoff » Thu Jun 12, 2014 10:58 pm

You are using a non-standard configuration which we never tested. E.g. there is no admin/view/template/common/header.tpl on your server, so the VQmod XML script couldn't modify it.

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

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by qbtadmin » Tue Jun 17, 2014 6:04 pm

I do have a standard configuration. The admin/view/template/common/header.tpl is there.

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 :o)

Newbie

Posts

Joined
Thu Jun 12, 2014 4:17 am

Post by barnone » Mon Aug 25, 2014 5:46 am

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

Active Member

Posts

Joined
Wed Dec 26, 2012 11:49 am

Post by JNeuhoff » Mon Aug 25, 2014 7:22 pm

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
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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by barnone » Tue Aug 26, 2014 12:20 am

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

Active Member

Posts

Joined
Wed Dec 26, 2012 11:49 am

Post by JNeuhoff » Tue Aug 26, 2014 1:23 am

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
Please copy and paste the whole error message here, otherwise I can't help!

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by barnone » Tue Aug 26, 2014 2:04 am

JNeuhoff wrote:
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
Please copy and paste the whole error message here, otherwise I can't help!
Combined with the above info it was full error message.

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.

Active Member

Posts

Joined
Wed Dec 26, 2012 11:49 am

Post by Meeker » Tue Aug 26, 2014 8:04 pm

Hi Jeff,
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...
Last edited by Meeker on Tue Aug 26, 2014 10:10 pm, edited 1 time in total.

User avatar
Active Member

Posts

Joined
Thu Sep 16, 2010 5:45 am

Post by JNeuhoff » Tue Aug 26, 2014 9:05 pm

Do an Export first to see the new formats of the worksheets which are different from your previous OpenCart version. Then copy and paste the relevant columns to your new worksheets before Import.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Meeker » Tue Aug 26, 2014 10:11 pm

That worked. Thanks for your help.

User avatar
Active Member

Posts

Joined
Thu Sep 16, 2010 5:45 am

Post by faca5 » Wed Aug 27, 2014 7:25 pm

Hello.

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)?

New member

Posts

Joined
Wed Aug 27, 2014 7:23 pm

Post by JNeuhoff » Thu Aug 28, 2014 6:06 pm

faca5 :

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.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by faca5 » Thu Sep 04, 2014 12:37 am

Multilanguage as:
category title, description
article title, description, meta

New member

Posts

Joined
Wed Aug 27, 2014 7:23 pm

Post by SamirAria » Wed Sep 10, 2014 5:57 am

Hello, I have upload boss extronic theme today and these error comes up. what should i do to fix this....

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

Newbie

Posts

Joined
Wed Sep 10, 2014 5:28 am
Who is online

Users browsing this forum: No registered users and 7 guests