Page 24 of 28

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Wed Feb 19, 2014 8:20 am
by butte
kyolic, you can also read the present thread in a mere several minutes -- starting from either end.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Sun Mar 02, 2014 3:41 am
by saltsalty
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

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Sun Mar 02, 2014 4:45 am
by JNeuhoff
Increase your PHP memory_limit setting, see e.g.
http://www.opencartnews.com/tutorials/c ... olve-them/ on how to do it.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Sat Apr 26, 2014 8:03 pm
by zerofirefox
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

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Wed Jun 11, 2014 9:29 pm
by misscaprice
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

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Thu Jun 12, 2014 4:19 am
by qbtadmin
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.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Thu Jun 12, 2014 10:58 pm
by JNeuhoff
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

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Tue Jun 17, 2014 6:04 pm
by qbtadmin
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)

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Mon Aug 25, 2014 5:46 am
by barnone
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

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Mon Aug 25, 2014 7:22 pm
by JNeuhoff
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.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Tue Aug 26, 2014 12:20 am
by barnone
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

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Tue Aug 26, 2014 1:23 am
by JNeuhoff
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!

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Tue Aug 26, 2014 2:04 am
by barnone
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.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Tue Aug 26, 2014 8:04 pm
by Meeker
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...

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Tue Aug 26, 2014 9:05 pm
by JNeuhoff
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.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Tue Aug 26, 2014 10:11 pm
by Meeker
That worked. Thanks for your help.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Wed Aug 27, 2014 7:25 pm
by faca5
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)?

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Thu Aug 28, 2014 6:06 pm
by JNeuhoff
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.

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Thu Sep 04, 2014 12:37 am
by faca5
Multilanguage as:
category title, description
article title, description, meta

Re: [RELEASED] Export/Import tool for OpenCart 1.5.0.x

Posted: Wed Sep 10, 2014 5:57 am
by SamirAria
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