Page 3 of 8

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Thu Oct 09, 2014 12:06 am
by m1t
i allway get
Option 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'
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 woking

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Thu Oct 09, 2014 12:34 am
by JNeuhoff
I am unable to reproduce your error, so unless you give us some more details, I can't help you.

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?

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Thu Oct 09, 2014 12:44 am
by plutosoft
Hello,
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

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Thu Oct 09, 2014 1:02 am
by JNeuhoff
plutosoft: Send me a PM with your FTP and OpenCart login details, and I can take a look at it.

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Thu Oct 09, 2014 5:59 pm
by JNeuhoff
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...
Send me a PM, I can certainly customize the Export/Import tool for a small charge.

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Sun Oct 12, 2014 8:44 pm
by heabee
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.

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
How to solve it ?

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Mon Oct 13, 2014 8:23 am
by xemox
@JNeuhoff Vqmod is installed and fine. But why I cannot see check box for tool/export_import in user groups? :choke:

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?

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Mon Oct 13, 2014 6:01 pm
by JNeuhoff
xemox wrote:@JNeuhoff Vqmod is installed and fine. But why I cannot see check box for tool/export_import in user groups? :choke:

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.

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Mon Oct 13, 2014 8:58 pm
by JNeuhoff
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.

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
How to solve it ?
Ask you webhost to install the missing PHP ZIP-library.

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Mon Oct 13, 2014 10:48 pm
by heabee
JNeuhoff wrote:
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.

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
How to solve it ?
Ask you webhost to install the missing PHP ZIP-library.

Thanks , but this question is needed solve by myself,my webhost do not help ,, :(

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Mon Oct 13, 2014 11:06 pm
by JNeuhoff
Thanks , but this question is needed solve by myself,my webhost do not help ,, :(
Google quickly reveals the answer to this.

See e.g. http://stackoverflow.com/questions/2517 ... -not-found

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Thu Oct 16, 2014 1:53 am
by jamywong
Hello , I am using the export / import tools on Open Cart v.1.5.6.4

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 :)

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Thu Oct 16, 2014 2:16 am
by JNeuhoff
jamywong: Check your specials, rewards or discounts to make sure that for each product they have only exactly one entry for the 'default' customer group.

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Sat Oct 18, 2014 2:34 am
by jamywong
Dear JNeuhoff,

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 ^_^

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Fri Oct 24, 2014 8:20 pm
by Ma57eR
Hi JNeuhoff! You created a wonderful extension.

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?

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Sun Oct 26, 2014 6:10 am
by JNeuhoff
Ma57eR Have you tried setting your admin language to Bulgarian? It won't list imported products in the admin backend when using other admin languages (e.g. English in your case) because of a bug in OpenCart, see https://github.com/opencart/opencart/issues/2085

Also, I assume you use UTF-8 throughout your server and spreadsheet file?

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Tue Oct 28, 2014 6:26 pm
by Ma57eR
Hi again JNeuhoff!


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!

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Fri Oct 31, 2014 12:53 am
by mab213
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.
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.

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Fri Oct 31, 2014 1:16 am
by JNeuhoff
Check your server's error_log (ask webhost for it), and OpenCart's system/log/error.txt.

Also, try importing in smaller batches. It might be a timeout issue.

Re: [RELEASED] Multilingual Export/Import for OpenCart 1.5.x

Posted: Fri Oct 31, 2014 7:36 am
by laur
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.

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
How to solve it ?
Ask your hosting comapny to install the ZipArchive module for cPanel or what hosting platform they use.