scot 14 years ago

I love this one!!... I find my self dependent on this mod. Is there any chance you will make it work for 1.5.3.1 ? I hope so. 5+ Stars +++++++++++++++++++++

zor 14 years ago

This extension is Very Good

But

- Not multilingual
- when you update, delete the order of the images of their products

I could donate 250 usd if you add those features

menorcarob 14 years ago

used this extension and i had problems "my own doing" the author was more than helpful, and got the whole thing working a treat, one of the best help i have had in all my years working on the web, if i could rate this as ten stars i would, thanks for all your help Jeugen *************

Chris

zor 14 years ago

I would like to give you this suggestion,
this extension is quite important for a lot of users, including me; you should sell it and keep improving it.

I paid $50 USD happy to add Multilanguage to it, it worked great!
But the user that sold me that was banned for it, and can't keep improving it.

this extention is free and there is no urgency to continue developing it
no hurry to update

You should sell it, or sell the rights the license to someone else that can sell it and improve it

wbaileynzl 14 years ago

Can we have version for 1.5.3 please? Thank you Just love this script has saved me hours of work. Thank you :-)

TCDAMAESTRO 14 years ago

Hello...

I get the following error when I click Export:

Fatal error: Class 'Spreadsheet_Excel_Writer_BIFFwriter' not found in public_html/domainname/system/pear/Spreadsheet/Excel/Writer/Worksheet.php on line 46

Can anybody help me out?

grupok2 14 years ago

HI
Works when export, but xls file returns with 0 bytes,

OpenCart 1.5.1.3
mod = OpenCart-1-5-1-x-6-import-export

Any way around this?

Thanks

BarbieH2 14 years ago

Is there a way to make the export/import tool compatible with the Dependent Options module from Ryan. I installed the dependent options model which allows me to associate certain colors only with certain sizes (clothing store) and it works great. Now I need to use the export tool so that I can incorporate the options more quickly via a spreadsheet and then import them back into my store.

When I set up a test product with the correct options and export it - the spreadsheet shows the options but not any differently than it did before I installed the options mod. Instead of showing my chosen option combinations in some way it still shows single lines of color-red, color-black, size-large, size-small. I need it to show in some way that the color red goes only with size small and the color black goes only with size large.

Does anyone know how to accomplish this task?

Thanks

ninJo 14 years ago

it just doesn't appear at admin panel :(

opencart 2.1

Domenico 14 years ago

Hi,

that´s one of the best extension for Opencart, and that´s for free!!!! Thank you!!!

liamcaff 14 years ago

More info on problem:

I have 4806 unique products and 10,132 product options in total...
Does this exceed the possible size of a shops database?
My Excel filesize is 7.5MB

liamcaff 14 years ago

I'm getting this error when trying to import my database now (after adding a few thousand more products)....

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 93 bytes) in /home/mikroweb/public_html/opm/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 93 bytes) in /home/mikroweb/public_html/opm/system/PHPExcel/Classes/PHPExcel/Worksheet.php on line 961

Any way around this?

romit 14 years ago

I am getting this error:-
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!

I uploaded the exported excel only with some text changes.

strglove 14 years ago

XLS file not opening and giving error.

When opening on Excell or other spreadsheets program I get:

"Warning: set_time_limit() [<a href='function.set-time-limit'>function.set-time-limit</a>]: Cannot set time limit in safe mode in /var/www/vhosts/baudastshirts.com/httpdocs/store/admin/controller/tool/export.php on line 76ÐÏà¡±á"

Also when Opening the file it says something like "Wrong format specified by extension."

Please help, i'm uploading files for my store, and getting really delayed on this.

Thanks

strglove 14 years ago

Having the same problem and can't find a way out, please help.

Regards

viviclothes 14 years ago

@JNeuhoff

You can use our module for multi language support it works GREAT and its verified and tested by many freelancers. Also it will handle bad characters like japanese languages etc it works perfect!

The only problem is some error handlings like export feature sinds it is using your codes and we didnt touch it. I think if you use our module as default, then you can save time and make your customers happy with multi language support :) please test our module your self and let us know your result. You can copy our code and use it! I think your customers will be very happy.

digital.retoucher 14 years ago

hi used this today for 5.2.1 it as killed my options menu all together now i need to re-install it again anyway of doing it without reinstalling ??

JonathanR 14 years ago

A life-save module. However, when the db grows this error can appear: Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if t etc etc....

I think I have found a fix (use with caustion & back-up!). Open admin>model>tool>export.php

Around about line 1723 on this file, you will see the following line:
$query = "SELECT c.* , cd.*, ua.keyword FROM `".DB_PREFIX."category` c ";

*BEFORE* this add:
mysql_query("SET OPTION SQL_BIG_SELECTS=1");

I tested the module before making this change and I got the error. I applied the change and uploaded the file and the error went away - the entire db was downloaded as a csv file. Just to make sure, I uploaded the unchanged export.php file and the error came back. It certainly seems to be a reliable fix. I really hope that helps somebody.

JNeuhoff 14 years ago

@viviclothes: I am working on an Export/Import tool with improved error handling, multi-lingual support, and incremental Import support. Meanwhile, please post any support requests on the regular OpenCart Community Forum, not here.

viviclothes 14 years ago

Our upgrade version of this extention have a new update!

Please check the Multi Language module here:

www.opencart.com/index.php?route=extension/extension/info&extension_id=5217&filter_search=export&sort=e.date_modified&order=DESC

We are still hoping JNeuhoff will use our module as the default module and improve it!