even if i do what the mesage tells me to do i dot get any export file, any idea how to make this tool work , i have oc 1.5.6.1 whit vqmod wokingOption value 'Mic 12 mg/ml' is defined multiple times within its option!
In the Settings-tab please activate the following:
Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'
Either tick the settings
Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'
Or, even better, sort out your option definitions: Why do you need to have the option value 'Mic 12 mg/ml' defined twice for the same option?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I downoaded your extension through the extensionpage, version for 1.5.6.4, for use with my opencart version 1.5.6.4.
vqmod version 2.01 installed.
made xlsx file according to the exported file.
uploaded no errors
but also no products imported, old product also not deleted.
no errors in logs.
What am I doing wrong?
Marcel
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Send me a PM, I can certainly customize the Export/Import tool for a small charge.accialex wrote:Hi, i'm using the multilingual 2.10 on 1.5.3.1.
Everything works fine, except the column seo_keyword.
In OC i've "Url SEO" in 2 languages.
1) When i do export: only one language is exported.
2) When i import ( filling the single available column) no data are imported.
I'm using multilingual_links.xml extension in vqmod
Is there anything i can do? ...I like that extension...
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
The question is when export the data ,the xlsx file just has 186 bytes,and it cant open after it has been downloaded.
I find the error logs has follow recode.
Code: Select all
2014-10-12 11:44:00 - PHP Fatal Error: Class 'ZipArchive' not found in /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 227
2014-10-12 11:44:00 - PHP Warning: Cannot modify header information - headers already sent by (output started at /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:227) in /www/web/bsignr_com/public_html/opencart/admin/model/tool/export.php on line 49
2014-10-12 11:44:00 - PHP Warning: Cannot modify header information - headers already sent by (output started at /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:227) in /www/web/bsignr_com/public_html/opencart/admin/model/tool/export.php on line 50
Sorry for noob question, what is the trigger code to add permission for access or modify? Usually I made it from install function like:
$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'tool/export_import'); but i can see it in your code, perhaps opencart has another way?
I am unable to reproduce your error. Most likely you haven't uploaded all the files, or uploaded them to the wrong place.xemox wrote:@JNeuhoff Vqmod is installed and fine. But why I cannot see check box for tool/export_import in user groups?
Sorry for noob question, what is the trigger code to add permission for access or modify? Usually I made it from install function like:
$this->model_user_user_group->addPermission($this->user->getId(), 'access', 'tool/export_import'); but i can see it in your code, perhaps opencart has another way?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Ask you webhost to install the missing PHP ZIP-library.heabee wrote:Hello ,I haved download the Export/Import Tool ver. 1-18, the OC ver. is 1.5.6.4.Installion is correct.
The question is when export the data ,the xlsx file just has 186 bytes,and it cant open after it has been downloaded.
I find the error logs has follow recode.How to solve it ?Code: Select all
2014-10-12 11:44:00 - PHP Fatal Error: Class 'ZipArchive' not found in /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 227 2014-10-12 11:44:00 - PHP Warning: Cannot modify header information - headers already sent by (output started at /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:227) in /www/web/bsignr_com/public_html/opencart/admin/model/tool/export.php on line 49 2014-10-12 11:44:00 - PHP Warning: Cannot modify header information - headers already sent by (output started at /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:227) in /www/web/bsignr_com/public_html/opencart/admin/model/tool/export.php on line 50
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
JNeuhoff wrote:Ask you webhost to install the missing PHP ZIP-library.heabee wrote:Hello ,I haved download the Export/Import Tool ver. 1-18, the OC ver. is 1.5.6.4.Installion is correct.
The question is when export the data ,the xlsx file just has 186 bytes,and it cant open after it has been downloaded.
I find the error logs has follow recode.How to solve it ?Code: Select all
2014-10-12 11:44:00 - PHP Fatal Error: Class 'ZipArchive' not found in /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 227 2014-10-12 11:44:00 - PHP Warning: Cannot modify header information - headers already sent by (output started at /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:227) in /www/web/bsignr_com/public_html/opencart/admin/model/tool/export.php on line 49 2014-10-12 11:44:00 - PHP Warning: Cannot modify header information - headers already sent by (output started at /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:227) in /www/web/bsignr_com/public_html/opencart/admin/model/tool/export.php on line 50
Thanks , but this question is needed solve by myself,my webhost do not help ,,
Google quickly reveals the answer to this.Thanks , but this question is needed solve by myself,my webhost do not help ,,
See e.g. http://stackoverflow.com/questions/2517 ... -not-found
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
i found that every time i tried to import When ' Use incremental Import : Yes '
It uploaded successfully , but when i tried to browse catalog page ,
It shows up like below while the admin page is still working
Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/mydomains/domains/mydomains/public_html/system/database/mysqli.php on line 17
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_ in /home/mydomains/domains/mydomains.com /public_html/system/database/mysqli.php on line 41
i tried much times and i found when i imported by ' Use incremental Import : No '
It's worked , and no error comes out on the catalog page ...
Thank you for your great extension
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
It's working now !!
Thank you very much
By the way, the double 'default' excel form is exported by the module ,
is that because of my SQL database errors or any others ?
Anyway , this extension is really really helpful ^_^
I have problem with multilingual version.
OC is 1.5.6.4
I/E Tool is 2.17
I have English and Bulgarian languages.
Bulgarian is Cyrillic language and when i try to import information, nothing happen. The tool import only lat letters, but not Cyrillic.
Can you help me with this?
Also, I assume you use UTF-8 throughout your server and spreadsheet file?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for your tips!
I found my mistake after your post. The problem was in language shortcode - in the first site is bg, but in the second (where i try to import) was BG - with capital letters. That was the problem. When i changed BG to bg, everything goes fine!
Thanks a lot for your help and for this excellent extension!
Hi I'm having the same issue. After trying to do an incremental import, the screen goes blank and after checking, the products weren't updated. I cleared the VQmod Cache, tried again and it doesn't work. Is this an issue with the file I'm using? I only have 750 products listed.JNeuhoff wrote:TAC: I don't know what you did to your server again. I cleared the VQmod caches, and after that it worked fine on your server. I also upgraded the Export/Import tool to the new version 2.4.
Also, try importing in smaller batches. It might be a timeout issue.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Ask your hosting comapny to install the ZipArchive module for cPanel or what hosting platform they use.heabee wrote:Hello ,I haved download the Export/Import Tool ver. 1-18, the OC ver. is 1.5.6.4.Installion is correct.
The question is when export the data ,the xlsx file just has 186 bytes,and it cant open after it has been downloaded.
I find the error logs has follow recode.How to solve it ?Code: Select all
2014-10-12 11:44:00 - PHP Fatal Error: Class 'ZipArchive' not found in /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php on line 227 2014-10-12 11:44:00 - PHP Warning: Cannot modify header information - headers already sent by (output started at /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:227) in /www/web/bsignr_com/public_html/opencart/admin/model/tool/export.php on line 49 2014-10-12 11:44:00 - PHP Warning: Cannot modify header information - headers already sent by (output started at /www/web/bsignr_com/public_html/opencart/system/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:227) in /www/web/bsignr_com/public_html/opencart/admin/model/tool/export.php on line 50
Users browsing this forum: No registered users and 3 guests