Page 37 of 53

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

Posted: Thu Aug 17, 2017 4:01 am
by sirajpatel
hi, tried to export from 2.2 and import it in 3.0.2, it gives an error the following error

2017-08-16 19:39:51 - Export/Import: Invalid header in the Categories worksheet
2017-08-16 19:39:51 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 12
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: The Twig_Function_Function class is deprecated since version 1.12 and will be removed in 2.0. Use Twig_SimpleFunction instead. in /home/f9/public_html/system/library/template/Twig/Function/Function.php on line 13
2017-08-16 19:39:51 - PHP Unknown: The Twig_Function class is deprecated since version 1.12 and will be removed in 2.0. Use Twig_SimpleFunction instead. in /home/f9/public_html/system/library/template/Twig/Function.php on line 12
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100

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

Posted: Thu Aug 17, 2017 4:09 am
by sirajpatel
hi, tried to export from 2.2 and import it in 3.0.2, it gives an error the following error

2017-08-16 19:39:51 - Export/Import: Invalid header in the Categories worksheet
2017-08-16 19:39:51 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 12
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: The Twig_Function_Function class is deprecated since version 1.12 and will be removed in 2.0. Use Twig_SimpleFunction instead. in /home/f9/public_html/system/library/template/Twig/Function/Function.php on line 13
2017-08-16 19:39:51 - PHP Unknown: The Twig_Function class is deprecated since version 1.12 and will be removed in 2.0. Use Twig_SimpleFunction instead. in /home/f9/public_html/system/library/template/Twig/Function.php on line 12
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100
2017-08-16 19:39:51 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/f9/public_html/system/library/template/Twig/Autoloader.php on line 30
2017-08-16 19:39:51 - PHP Unknown: Passing a name as a first argument to the Twig_Environment::addFunction method is deprecated since version 1.21. Pass an instance of "Twig_SimpleFunction" instead when defining function "staticCall". in /home/f9/public_html/system/library/template/Twig/Environment.php on line 1100

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

Posted: Fri Aug 18, 2017 3:57 pm
by sonique7
I am facing the same issue as above. I tried to move products from 2.3 to 3.0.2 and i got this error --

Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed.

i went to the logs to confirm and i saw this

2017-08-18 7:55:32 - Export/Import: Invalid header in the Products worksheet
2017-08-18 7:55:32 - PHP Unknown: The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/z9ord/public_html/shop/system/library/template/Twig/Autoloader.php on line 12
2017-08-18 7:55:32 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/z9ord/public_html/shop/system/library/template/Twig/Autoloader.php on line 30
2017-08-18 7:55:32 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/z9ord/public_html/shop/system/library/template/Twig/Autoloader.php on line 30
2017-08-18 7:55:32 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/z9ord/public_html/shop/system/library/template/Twig/Autoloader.php on line 30

please help out

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

Posted: Mon Aug 21, 2017 6:39 pm
by JNeuhoff
In case you get the 'Invalid header' error message, please do the obvious: Use the correct header for the 'Products' or 'Categories' worksheet. You can get the correct header for these worksheets by doing an Export first off the new website. And then copy/paste the old data to the new worksheet before an import.

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

Posted: Sun Aug 27, 2017 11:11 pm
by NDS
Hello! I just installed this plugin in OpenCart 2.3.0.2, but I can not find the documentation... Although the page of this plugin says "Documentation Included". Where can I find the documentation for this plugin, in particular, the contents of the fields of the Excel file for import?
Sorry for my English :)

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

Posted: Mon Aug 28, 2017 3:18 am
by oc_ms
Dear JNeuhoff!

Is it possible to import with only one Excel file? I tried one file with the tables "AttributeGroups", "Attributes", "Categories", "Products", "ProductAttributes" and "AdditionalImages" but received the error "undefined attribute_group_id". Then I splitted the file in three single files (Attributes*/ Categories and Products*) and everything works fine.

Thanks for your short reply!

Best regards,

Holger

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

Posted: Tue Sep 05, 2017 12:33 am
by firstuser
Hi. The installed module indicates that the page is not found. what's wrong?

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

Posted: Fri Sep 08, 2017 4:58 pm
by MVV
Hi. This tool is amazing, thank you for it!
I updated it from v3.16 to v3.17 on OC 2.3.0.2 and everything is fine, but I only can't export Products. It shows me a message File now found and http://mywebsite/admin/index.php?route= ... YST99A2SZ2
Do you have any idea where is the problem? I can export categories, options, customers, etc. normaly. Only when I try to export product, I got this message.

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

Posted: Tue Sep 19, 2017 1:46 pm
by ginsar
Hi. I installed the module, but it does not work. Exporting of goods results in an error.

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

Posted: Tue Sep 19, 2017 9:17 pm
by JNeuhoff
ginsar wrote:
Tue Sep 19, 2017 1:46 pm
Hi. I installed the module, but it does not work. Exporting of goods results in an error.
Missing standard PHP ZIP-library here, ask your webhost to install it.

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

Posted: Wed Sep 20, 2017 2:05 pm
by ginsar
JNeuhoff wrote:
Tue Sep 19, 2017 9:17 pm
Missing standard PHP ZIP-library here, ask your webhost to install it.
What kind of library?
I have VDS and I can install it myself.

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

Posted: Wed Sep 20, 2017 6:02 pm
by JNeuhoff
ginsar wrote:
Wed Sep 20, 2017 2:05 pm
JNeuhoff wrote:
Tue Sep 19, 2017 9:17 pm
Missing standard PHP ZIP-library here, ask your webhost to install it.
What kind of library?
I have VDS and I can install it myself.
It could also be this:
https://stackoverflow.com/questions/214 ... php-output

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

Posted: Fri Sep 22, 2017 8:28 pm
by ginsar
JNeuhoff wrote:
Wed Sep 20, 2017 6:02 pm
It could also be this:
https://stackoverflow.com/questions/214 ... php-output
Where is here talk about Standard Library ?

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

Posted: Fri Sep 22, 2017 8:58 pm
by JNeuhoff
As the link explains, the most common cause of this error when saving to php://output is an open_basedir restriction that doesn't include a valid system's temp folder (e.g. /tmp), or permissions for the system's temp folder. If shows some possible solutions to this issue. The Export/Import tool uses the PHPExcel library which is located in the system/PHPExcel folder, or in the system/library/export_import folder, depending on the OpenCart version used.

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

Posted: Wed Sep 27, 2017 8:36 pm
by salwa123
The catalog gives a code of 20.40, so how do I know the code of the main and sub sections
Is it possible to display the name of the main section in particular and sub-branch other

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

Posted: Thu Sep 28, 2017 3:07 am
by JNeuhoff
salwa123 wrote:
Wed Sep 27, 2017 8:36 pm
The catalog gives a code of 20.40, so how do I know the code of the main and sub sections
Is it possible to display the name of the main section in particular and sub-branch other
Your post is confusing, there is no catalog code. There is a categories column whose values are comma-separated lists of category__ids. You can find the latter via exporting the Categories first.

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

Posted: Fri Sep 29, 2017 10:35 pm
by salwa123
Usually when a clean product we have to define its catalog. How do we know the catalog number?
Or in other words, what is the relationship between the product id and the main catalogs id and branch catalogs and the branch thereof

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

Posted: Tue Oct 03, 2017 2:58 pm
by Wonderwoman
Hi, i've exported the files and didn't edit anything, i just import it to see how it goes but i get this error message

2017-10-03 6:21:37 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '412' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Worksheet 'AdditionalImages' cannot use product_id '670' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Worksheet 'Specials' cannot use product_id '412' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Worksheet 'Specials' cannot use product_id '670' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Worksheet 'Discounts' cannot use product_id '412' because it is not listed in worksheet 'Products'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Orange Polkadots' for option_name 'Expandable Shopping Bag Design' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Dramatize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Energize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Fantasize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Glamorize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Harmonize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Hypnotize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Optimize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Polarize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Privatize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Sensualize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Sociolize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Tranquilize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Tropicalize' for option_name 'LA Girl Eye Lux Eyeshadow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '900B Pink Suga' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '901B Think Pink' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '903C Just Peachy' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '904B Rose Bud' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '905D Smokin Hot Pink' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '907C Mauve Outta Here' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '909D Coral-Line' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '910D Red Velvet' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '912C In The Flesh' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '913C Sand Storm' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '914C Mocha-Licious' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '915B Spiked W/Rum' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '918D Cherry Bomb' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '919B Vamp It Up' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '965 Cherry Picking' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '966 Dont Blink Pink' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name '968 Pinkerbell 970' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Purty Persimmon' for option_name 'WET N WILD Megalast Lip Color' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'No 1 Earth Brown' for option_name 'Clio Tinted Tattoo Kill Brow' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Baby Girl - 9m' for option_name 'Baby Size' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Baby Girls - 12m' for option_name 'Baby Size' used in worksheet 'ProductOptionValues'!
2017-10-03 6:21:37 - Export/Import: Undefined option_value_name 'Baby Girls - 18m' for option_name 'Baby Size' used in worksheet 'ProductOptionValues'!


I'm not sure what to do with Undefined option_value_name error message. Do I delete the the option? And what to do next?

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

Posted: Tue Oct 03, 2017 10:46 pm
by JNeuhoff
About the option_value_names: Do an Export of the option definitions and then check to make sure their names don't contain leading or trailing blank characters.

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

Posted: Fri Oct 06, 2017 12:34 am
by nortski
Hi,
There appears to be a slight bug concerning the 'description(en)' field when I download my product catalogue. On some of my items it will repeat what's in the description multiple times underneath each other. Rather annoying as this means I have to check out every item to see if it has been affected.

EDIT: This seems to have something to do with Open Office. If I open the file in Excel it appears fine.