sinobi 13 years ago

Hai i am using OC 1.5.5.1 and i was added one extension for my book store ,in that extension there are some extra fields like Book Name,Author,Publisher,Pages etc. how could i export and import these data with excel import export. i am new in OC

bhamu14 13 years ago

Hi,

I am using 1.5.5.1. Installed your extension and after importing excel file I found this error when opening website.

Fatal error: Class 'ControllerCommonHome' not found in /home/multiwa1/public_html/catalog/controller/common/home.php on line 2

Please help to solve the error.
Thanks

kec 13 years ago

Works like a charm on 1.5.5.1 on 2 different, non-standard OC shops. Thnx!

TFM 13 years ago

Has anyone made this extension to work with xlsx files? My attributes are over 65000 rows and I need more. I've tried changing the $maxrow and a few other variables but I keep receiving errors.
I'll soon need the products to be more than 65000 too.

Would love to get an answer on this - I see there are a few other people in the same boat as me.
Is there another solution out there besides this extension?

gruntstyle 13 years ago

Please help!

I've been using this extension for a year now, which has been awesome, but today when I try to export I get a quick download (unusual) and it only has this information in it:

Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay Error No: 1104 SELECT p.product_id, pd.name, .....

It goes on for a bit more as well.

pcbob 13 years ago

If you have database issues, a few tips here,
Export from the site, do not attempt to write your own.
Create a copy of the original for a backup - use the copy to work on
Do not remove any sheets or columns, if not used just shrink the size down, removing will give an error.
Never add any formulas, it will confuse the import.
Words like TRUE and FALSE are key words and therefore must be in lowercase. if when you type it, it goes to upppercase, try writing it in notepad copy it and paste it in.
There are many excel tutorials out there, so if you are stuck try googling "excel tutorial (add what you want to do)"
Save as an xlsx file - if you can't you could try an online converter, but it may work.
Hope this helps a few people out.

pcbob 13 years ago

There are actually TWO php.ini files in opencart, - one is in the main root other is in ADMIN. Change both to match
How much memory? error shows eg 67108864 bytes - divide this by 1024 and then 1024 again this will give the MB memory, in this case 64MB. If it matches what you have put in the ini files then it needs to be increased more, if not then it could be your hosting locking it, in which case you need to speak to them.

sunandglasses 13 years ago

Hello, I want to install this module but I get the following error and do not know how to fix it thanks and greetings

Cannot redeclare class ControllerToolExport in /furanet/sites/sunandglasses.com/web/htdocs/admin/language/english/tool/export.php on line 2

spirobg 13 years ago

I have import/export script by JNeuhoff it is working with 67,000 categories with .xlsx but when i try to upload file with 120.000 categories it throws errors like

Fatal error: Out of memory (allocated 732430336) (tried to allocate 43 bytes) in C:\xampp\htdocs\servizao\system\PHPExcel\Classes\PHPExcel\CachedObjectStorage\Memory.php on line 47
Fatal Error: Out of memory (allocated 732430336) (tried to allocate 43 bytes) in C:\xampp\htdocs\servizao\system\PHPExcel\Classes\PHPExcel\CachedObjectStorage\Memory.php on line 47

I usually upload the .xml file to the localhost then via phpmyadmin export the database and import it to the real store. I've bumped up the memory limits... the phpinfo is showing memory limit is 5000MB now... i dont know what to do please help me. Tell me what to change,,,, i am not programmer.

Dunald 13 years ago

This extension does not work for me in Opencart Version 1.4.9.3.
Any idea why I get this error in the file?

Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay Error No: 1104 SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.location, p.quantity etc etc

Destrifer 13 years ago

May you make export xlsx fles format?
Xls have limitation a 65000 lines.
The exported file is truncated to 65,000 lines.

bossdat 13 years ago

Really great tool! thank you so much for helping us with this great tool! :)

ameemaster 13 years ago

@devingttrois:

were you able to solve it as i have the same problem kindly help

alicealice 13 years ago

My version is 1.5.5.1, and when I finished to upload this, the admin-Export/Import show Permission Denied. You do not have permission to access this page, please refer to your system administrator. I am sure that all things seleted in User Group. This is really strange. What I should do? Thanks.

KS 13 years ago

Is it possbile to add the field "Custom title"?

Project_Brooklyn 13 years ago

Hi I installed this but because I use the Black ops admin skin nothins seems to come up. Has anyone got a fix for this?

Cheers Peter

theprojectbrooklyn@gmail.com

adamngai 13 years ago

I am using 1.5.5.1 with latest vqmod too. After following the installation step, I found our there are 2 same function which display at System tab which named Export/Import, I have opened both of them in different windows and found both url are same. How can I disable or remove 1 of them away? Seek for your kind advise and thanks in advance!

Adam

webconsultic 13 years ago

Hi!

I have an installation of newly installed Opencart 1.5.5.1. The component works well in export but to import fails (Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!) Only when overtaking the 200 lines in the table "products" xlsx file. Any idea?

Thank you very much!

mikispace 13 years ago

Great add on !
Adds huge functionality . . . Thank you soooo much.
Installed on 1.5.5.1 & working smoothly
5 stars

e-slap 13 years ago

Hello,
I am using the module EXPORT AND IMPORT TOOL
but in Portuguese language, the "Export / Import" in the main menu is accepted by the language (text_export).

In version 1.5.2.1 and English language works in both cases.

Thank you!