eticaretci 15 years ago
ı have 30.000 product (22M) but ı dont make import ı make php.ini in my server but dont upload pls help me Notice: iconv_substr() [function.iconv-substr]: Unknown error (0) in /var/www/vhosts/xxxxxxxxxx.com/httpdocs/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 306
AdamM 15 years ago
I recently installed vqmod and this extension (opencart-1-5-1-x-2-export-import.zip) on a new test installation of OpenCart 1.5.1.3.1. After uploading the files and running the vqmod installer I went to the user groups page as instructed in the import/export instructions, and it was entirely blank. It looks like there's probably a fatal PHP error going on somewhere, but nothing's showing up in the OC error log.
Since then I've tried removing all the import/export extension files, including the vqmod export xml file, but the user groups page is still AWOL.
I hadn't used the user groups admin page previously, so I can't be completely certain that the extension is to blame, but it seems fairly likely.
Does anyone know what part of the extension modifies the user groups page, or how? Any ideas about what might be causing the problem?
Thanks very much!
Adam
Matras 15 years ago
I have following error: 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 the SELECT
Wishack 15 years ago
Any chance of making it able to export only certain manufacturers? I have roughly 30,000 products so these sheets are getting rather large
deejunit 15 years ago
Thanks for a great extension that's going to save me a lot of time! :) great work!
Amuro 15 years ago
I have v1.5.1.2 version and am using opencart-1-5-1-x-2 to download, I got error for the exported file.
"The file is in a different format. "
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 the SELECT is okay<br />Error No: 1104<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.location, ...
rukhairy 15 years ago
I keep on getting this error... been google for few days and still no solution for this error.. any help would be appreciated :)
Error: Incorrect key file for table '/tmp/#sql_3034_0.MYI'; try to repair it<br />Error No: 126<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, .......
rukhairy 15 years ago
Hi. I need to add 7 additional field into the module urgently. Will you quote me the price for it. Thank you :)
hanwei 15 years ago
Hi I have added cost into my store, but i am wondering how to put additional fields appear in the excel file?
zzzvic 15 years ago
i have the vq mod.
i put it in the xml folder, but it doesnt come up in user group permissions? and wont let me access it.
jmanx4092 15 years ago
I am trying to do an export after i download the tool. I am not able to do an export. I am using firefox and it takes for eaver loading, then shows me that the server has timed out? What does that mean? How do i fix that?
xciso 15 years ago
This works really good! (oc 1.5.1.1)
I have a extension installed to insert "spec" for my products.
How can i modify so i can edit this in the exported file?
Thanks for great extension!
JVP 15 years ago
I installed the module and it seems to work pretty well.
But when I export the product data to an excel file, I get all these weird looking caracters in the file
[quote]ÌAB°=¼%r8X"1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1ÈÿArial1È Arial ¤
[/quote]
any ideas on what went wrong? And where?
I have a installed version 1.5.1
mamatozay 15 years ago
i am tried at op 1.5.1
the export running smoothly.
when i tried to import, get a blank white screen. i do'not know whats happen?
any suggestion please?
pirate 15 years ago
how html tags converting to < > in DB product desciption
Sportartikelstore 15 years ago
Guys, any help would be great!
I exported products without any problem on OC 1.4.9 x
Now I want to import the file to OC 1.5.1 and I get to following error:
Fatal error: require_once() [function.require]: Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/lib/php') in /home/egal/public_html/OCnieuw/admin/model/tool/export.php on line 1577
Does anybody knows what kind of problem this could be?
vlada_v 15 years ago
sure the common/header.tpl must be edited ... it is just a hyperllink to this tool
jezfez 15 years ago
how have people managed to install this ?
the readme.txt says
In file admin/language/english/common find:
$_['text_backup'] = 'Backup / Restore';
common is a folder, not a file
shaunt27 15 years ago
I have installed the product on my openccart 1.5.1.1 default templete. when I try to export to the excel 2003 sheet I get a error.
Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\DOCUME~1\shaun\LOCALS~1\Temp\backup_categories_products-1.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.
I am running my opencart on localhost at the moment. not sure if this is going to be a problem. Also I need to know if this export tool take the image as well.It seems I have lost my product photos or it just lists the directory where the image is.
Many Thanks
shaun
madlime 15 years ago
cliclk export download file but inside this error ???? normaly together error but max 100 and send 2 message
