Post by seme1 » Mon May 20, 2019 4:52 am

Hello JNeuhoff,

Another question I have is regarding custom fields added to the products. How can they be exported in the excel file and re-imported? I only have one custom field that needs to be exported/imported.

Newbie

Posts

Joined
Wed Mar 20, 2019 5:49 am

Post by JNeuhoff » Mon May 20, 2019 4:39 pm

Your admin backend language must be also one of the supported frontend languages as you correctly stated. You could modify the frontend language selector in the 'common/language.tpl' file to exclude the admin language from the selector.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by seme1 » Tue May 21, 2019 8:21 pm

Thank you for your response.
I have a custom field added in the table oc_product and I wish to export/import that custom field when exporting the products. Can you please guide me on how this can be achieved ? Perhaps point me to the right sections that I need to modify the code to include that custom field ?

Newbie

Posts

Joined
Wed Mar 20, 2019 5:49 am

Post by Laoyumi » Sun Jun 16, 2019 9:37 am

The following error at import in OC 3.0.3.2:
2019-06-15 8:27:41 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /www/htdocs/........../...................../system/library/template/Twig/Autoloader.php on line 30
Export to Excel works. Nice extension! Easy to use. Only that one issue it seems.

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by JNeuhoff » Sun Jun 16, 2019 8:43 pm

Laoyumi wrote:
Sun Jun 16, 2019 9:37 am
The following error at import in OC 3.0.3.2:
2019-06-15 8:27:41 - PHP Unknown: Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /www/htdocs/........../...................../system/library/template/Twig/Autoloader.php on line 30
Export to Excel works. Nice extension! Easy to use. Only that one issue it seems.
Ignore this message. The Export/Import real error message will be above that one in your OpenCart error.log.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Laoyumi » Mon Jun 17, 2019 12:04 pm

The error has gone - I do not know why but am unable to reproduce the error.
Have reinstalled the extension today and noticed a new version for 3.0.3.2. Or I fiddled something else, might even have made an error in the spreadsheet.
Important - its working with 3.0.3.2 and makes live so much easier. Thank you

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by Laoyumi » Tue Jun 25, 2019 1:03 pm

Maybe a small issue discovered: When I import products from .xlsx additional related items get stripped. In the field "related_ids" I have the value of "197,198". But only 197 is shown in OC. I have to manually add 198 through the admin interface.
Opencart 3.0.3.2, Import/Export Tool vers. 3.2
Generally the tool drives me crazy but when I look at the error log is is always my fault in the spreadsheet.

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by JNeuhoff » Tue Jun 25, 2019 3:10 pm

Laoyumi wrote:
Tue Jun 25, 2019 1:03 pm
Maybe a small issue discovered: When I import products from .xlsx additional related items get stripped. In the field "related_ids" I have the value of "197,198". But only 197 is shown in OC. I have to manually add 198 through the admin interface.
Opencart 3.0.3.2, Import/Export Tool vers. 3.2
Generally the tool drives me crazy but when I look at the error log is is always my fault in the spreadsheet.
This is an issue with the local settings of of operating system or spreadsheet software used. Make sure that '197,198' isn't treated as a decimal number, it has to be a string entry in your spreadsheet software. I recommend using LibreOffice Calc rather than MS Excel.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Laoyumi » Tue Jun 25, 2019 3:38 pm

Thank you, issue solved. Setting the column to "Text" and it imports all the product_ids.
I am on Linux Mint using LibreOffice exclusively. Am very happy with Linux, as easy to use as Windows. But calc can not always replace the shortcomings of the user (me).

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by borko471 » Tue Jul 02, 2019 12:05 am

Hi guys. I'm running OC 1.5.3. My issue is with the 'Limit products export by category:' text field (filtering by Category before exporting). No suggestions show up while I'm typing and even if I type the correct name and press enter, it's no good. I checked a previous answer which said to check for duplicate SEO keywords, which I did and there were none. I'm pretty sure this text box was working when I first installed the module. Could it be because of duplicate Category Names in either language?

Newbie

Posts

Joined
Fri Apr 05, 2019 6:42 pm

Post by borko471 » Thu Jul 04, 2019 8:00 pm

borko471 wrote:
Tue Jul 02, 2019 12:05 am
Hi guys. I'm running OC 1.5.3. My issue is with the 'Limit products export by category:' text field (filtering by Category before exporting). No suggestions show up while I'm typing and even if I type the correct name and press enter, it's no good. I checked a previous answer which said to check for duplicate SEO keywords, which I did and there were none. I'm pretty sure this text box was working when I first installed the module. Could it be because of duplicate Category Names in either language?
Bump.
I eliminated all duplicate names of the categories in both my languages. I made sure there are no duplicate SEO keywords, either. The filter by category text box is still not working. I'll be glad if someone has any ideas about this so I can at least try something. I'll try removing caches now.

Newbie

Posts

Joined
Fri Apr 05, 2019 6:42 pm

Post by ndryomov » Thu Jul 18, 2019 2:15 am

Hi, guys

I installed Export/Import Tool on OpenCart v3.0.3.2 and try to import xls with products. During import I'm getting error:

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

In error log I got error - 2019-07-17 16:33:59 - Export/Import: Invalid worksheet names

What right structure of products file should be for importing?

Thanks in advance for your answers

With best regards

Newbie

Posts

Joined
Sat Jul 13, 2019 4:15 am

Post by robineero » Fri Jul 19, 2019 4:01 am

I installed this extension but under System > Maintenance (as said in instructions) there really is no Export / Import. Where does this extension appear on OpenCart 3.0.3.2?

Newbie

Posts

Joined
Fri Jul 19, 2019 3:45 am

Post by Laoyumi » Sat Jul 20, 2019 9:16 am

I had all the same problems, but since it is working flawless.

1. After the installation you have to go to "Extensions - Modifications!". Here you can enable the extension.
2. I exported one manually created article to the spreadsheet. That gave me the ideal template including formatting and column headings. And it shows you which fields need an input, example a 0 despite not really used.

New member

Posts

Joined
Thu Jun 13, 2019 9:59 am

Post by gerstavros » Mon Oct 07, 2019 2:29 am

thileep91@gmail.com wrote:
Wed Jan 09, 2019 5:29 pm
I installed module success fully. i have some error export tools work perfect. import tools some error
please find error
Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed.
Cane you check that
I have the same problem.
Error log is:

Code: Select all

2019-10-06 18:04:12 - Export/Import: Invalid header in the Products worksheet
2019-10-06 18:04:12 - PHP Unknown:  The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 12
2019-10-06 18:04:12 - PHP Unknown:  Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 30
2019-10-06 18:04:12 - PHP Unknown:  Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 30
2019-10-06 18:04:12 - PHP Unknown:  Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 30
2019-10-06 18:04:12 - PHP Unknown:  Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 30
2019-10-06 18:22:54 - Export/Import: Invalid header in the Products worksheet
2019-10-06 18:22:54 - PHP Unknown:  The Twig_Autoloader class is deprecated since version 1.21 and will be removed in 2.0. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 12
2019-10-06 18:22:54 - PHP Unknown:  Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 30
2019-10-06 18:22:54 - PHP Unknown:  Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 30
2019-10-06 18:22:54 - PHP Unknown:  Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 30
2019-10-06 18:22:54 - PHP Unknown:  Using Twig_Autoloader is deprecated since version 1.21. Use Composer instead. in /home/drfixgr/public_html/mpw/system/library/template/Twig/Autoloader.php on line 30

New member

Posts

Joined
Mon Apr 04, 2016 12:44 am

Post by JNeuhoff » Mon Oct 07, 2019 3:50 pm

I have the same problem.
Is there any reason why you won't sort out the header line in your Products worksheet? The error is quite clear on that. Do an Export first, to see the exact format of the Products worksheet, and then use it.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by kurdogluugur » Thu Nov 14, 2019 12:14 pm

Version 3.0.0.0
installed extension.
try to import product from excel file.
" Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed. "

I think it's about Database access.

and error Log

Code: Select all

2019-05-30 14:22:08 - PHP Warning:  mysqli::__construct(): (HY000/1045): Access denied for user 'motoradmin'@'localhost' (using password: YES) in /home/motorsto/public_html/store/system/library/db/mysqli.php on line 7
2019-05-30 14:22:08 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/motorsto/public_html/store/system/library/db/mysqli.php on line 10
2019-05-30 14:22:08 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/motorsto/public_html/store/system/library/db/mysqli.php on line 10
2019-05-30 14:22:08 - PHP Notice:  Undefined variable: mysql in /home/motorsto/public_html/store/install/controller/install/step_3.php on line 276
2019-05-30 14:22:08 - PHP Notice:  Trying to get property of non-object in /home/motorsto/public_html/store/install/controller/install/step_3.php on line 276
2019-05-30 14:26:01 - PHP Warning:  mysqli::__construct(): (HY000/1044): Access denied for user 'motorsto_admin'@'localhost' to database QLi::__construct(): 
2019-05-31 19:53:28 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/motorsto/public_html/system/library/db/mysqli.php on line 10
2019-05-31 19:53:28 - PHP Warning:  DB\MySQLi::__construct(): Couldn't fetch mysqli in /home/motorsto/public_html/system/library/db/mysqli.php on line 10
2019-05-31 19:53:32 - PHP Warning:  mysqli::mysqli(): (HY000/2002): No such file or directory in /home/motorsto/public_html/system/library/db/mysqli.php on line 7    ...
if someone faced same problem please share me some solution.

thanks for your helps.

Newbie

Posts

Joined
Wed Nov 13, 2019 5:29 pm

Post by JNeuhoff » Thu Nov 14, 2019 10:57 pm

These error message are from May this year, several months ago. There should be some newer entries in your OpenCart error.log which are more specific to the
Export/Import tool.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by ZEROS-RRC » Wed Nov 20, 2019 1:08 am

Hi JNeuhoff

Thanks for the great module, I have had no problems using it with various OC versions, however I do want to know if its possible to simply add an extra output column in the exported file? Ideally I need the data shown in the screenshot which is going to be separate stock codes for product options, such as XL Red, XL Blue etc, I need this code to be outputted on the exported CSV so I can easily cross check stock codes to stock levels etc. Hope this is a easy one for you :)

Thanks in advance

Newbie

Posts

Joined
Tue Nov 19, 2019 12:11 am

Post by JNeuhoff » Wed Nov 20, 2019 1:17 am

ZEROS-RRC wrote:
Wed Nov 20, 2019 1:08 am
Hi JNeuhoff

Thanks for the great module, I have had no problems using it with various OC versions, however I do want to know if its possible to simply add an extra output column in the exported file? Ideally I need the data shown in the screenshot which is going to be separate stock codes for product options, such as XL Red, XL Blue etc, I need this code to be outputted on the exported CSV so I can easily cross check stock codes to stock levels etc. Hope this is a easy one for you :)

Thanks in advance
If you send an enquiry via our contact us page then I can work out a quick quote for the necessary modification for adding support of extra field columns to the Export/Import tool. We'd need to know the exact names and types of the extra DB fields to be supported.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * Template Switcher PHP/Twig


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: OSWorX and 2 guests