Post by JNeuhoff » Tue Jun 05, 2012 3:10 am

The Export/Import tool is now available for OpenCart 1.5.3.x.

It includes some bugfixes, as follows:
  • The DB tables option, option_description, option_value, and option_value_description are now preserved during an Import.
  • Option Value Image now correctly supported
  • The sort_order for additional product images is now supported.
  • The DB tables attribute, attribute_description, attribute_group, and attribute_group_description are now preserved during an Import.
Still on our to-do-list for the next release:
  • Improved validation and error/exception handler
  • Multi-lingual support
  • Incremental Import

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 wrangster » Tue Jun 05, 2012 11:40 am

Hi, I downloaded this today, and I think I did everything like I'm supposed to, but I get this message when opening the exported file in exxel:
<b>Notice</b>: Error: Table 'netzoo.netzoo_customer_group_description' doesn't exist<br />Error No: 1146<br />SELECT ps.*, cgd.name FROM `netzoo_product_special` ps LEFT JOIN `netzoo_customer_group_description` cgd ON cgd.customer_group_id=ps.customer_group_id AND cgd.language_id=1 ORDER BY ps.product_id, cgd.name in <b>/var/www/side17/system/database/mysql.php</b> on line <b>49</b>

New member

Posts

Joined
Mon Jun 04, 2012 5:27 pm

Post by JNeuhoff » Tue Jun 05, 2012 5:30 pm

wrangster wrote:Hi, I downloaded this today, and I think I did everything like I'm supposed to, but I get this message when opening the exported file in exxel:
<b>Notice</b>: Error: Table 'netzoo.netzoo_customer_group_description' doesn't exist<br />Error No: 1146<br />SELECT ps.*, cgd.name FROM `netzoo_product_special` ps LEFT JOIN `netzoo_customer_group_description` cgd ON cgd.customer_group_id=ps.customer_group_id AND cgd.language_id=1 ORDER BY ps.product_id, cgd.name in <b>/var/www/side17/system/database/mysql.php</b> on line <b>49</b>
You are using the wrong OpenCart version, this is for 1.5.3.1!

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 arrjaytea » Tue Jun 05, 2012 11:55 pm

Lovely work, J. Thank you for your diligence, looking forward to not relying on Sergio's mod anymore (though it should be noted that his mod was a very, very workable solution for me in the meantime).

Cheers.

Edit: For sure just did a trail run on some multi-store corrections and it worked flawlessly. Stock OC 1.5.3.1 w/ Sellegance theme.

New member

Posts

Joined
Thu May 31, 2012 11:58 pm

Post by wrangster » Wed Jun 06, 2012 6:34 am

Thanks a huge bunch! You were right, it was my wrong version that made it not work right. Seems to work great now, very nice extension!

New member

Posts

Joined
Mon Jun 04, 2012 5:27 pm

Post by tropnevad » Thu Jun 07, 2012 10:46 pm

Hi all

Thanks for the great extension. I am having problems with it working however as I cannot access my admin page after installing it.

I have recently installed the extension and now I cannot access my admin page as it says The page you requested cannot be found!

I then tried to install another version with same problems for both 1.5.2 and 1.5.3

I am running opencart 1.5.2.1 with Vqmod

Any help would be appreciated

New member

Posts

Joined
Wed Jun 01, 2011 4:40 pm

Post by JNeuhoff » Fri Jun 08, 2012 12:13 am

tropnevad wrote: I am running opencart 1.5.2.1 with Vqmod

Any help would be appreciated
This release of the Export/Import tool is for OpenCart 1.5.3.x only, not for 1.5.2.x.
Please do not post problems caused by using wrong releases of 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 tropnevad » Fri Jun 08, 2012 1:01 am

I was using the correct version for opencart 1.5.2.1 and still get the same problem
JNeuhoff wrote:
tropnevad wrote: I am running opencart 1.5.2.1 with Vqmod

Any help would be appreciated
This release of the Export/Import tool is for OpenCart 1.5.3.x only, not for 1.5.2.x.
Please do not post problems caused by using wrong releases of the Export/Import tool.

New member

Posts

Joined
Wed Jun 01, 2011 4:40 pm

Post by arrjaytea » Fri Jun 08, 2012 1:50 am

JNeuhoff wrote: Still on our to-do-list for the next release:
  • Incremental Import
Just to clarify, by "incremental support", do you mean I'll be able to import only the data I want to?

i.e. I can remove columns and/or only upload partial catalogs for price/option updates?

Really love the tool, works very reliably, just wish I didn't have to upload the entire sheet, every time - but for sure understand we've got no expectations with a free extension.

Just curious. :)

New member

Posts

Joined
Thu May 31, 2012 11:58 pm

Post by JNeuhoff » Fri Jun 08, 2012 7:20 pm

arrjaytea wrote: Just to clarify, by "incremental support", do you mean I'll be able to import only the data I want to?

i.e. I can remove columns and/or only upload partial catalogs for price/option updates?
By Incremental Import we mean the ability to import categories and products without first deleting all the existing entries from the database. It will just do an update, and only add an item to the database if it wasn't there before.

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 JNeuhoff » Fri Jun 08, 2012 8:11 pm

tropnevad wrote:I was using the correct version for opencart 1.5.2.1 and still get the same problem
JNeuhoff wrote:
tropnevad wrote: I am running opencart 1.5.2.1 with Vqmod

Any help would be appreciated
This release of the Export/Import tool is for OpenCart 1.5.3.x only, not for 1.5.2.x.
Please do not post problems caused by using wrong releases of the Export/Import tool.
Looks to me there is an issue with VQmod. Check all your relevant log files, e.g. server's error_log, OpenCart's system/logs/error.txt and VQmod's vqmod/vqmod.log for any hints as what the problem could be.

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 wonderland » Mon Jun 11, 2012 4:51 pm

I'm really sorry for this off topic post but I don't understand 1 thing about import/export mod.

Some time ago I found 3 import/export tools
first was (still is) out of development which looks like your mod
second I think was yours
third was very much like yours, but It supported multi language export/import

So I went with third.

It works good, but I wanted to ask some questions to developer.

But now all I can find is your extension and the what that is out of development.

Are all these 3 tools based on same extension ?
were there some copyright issues with the extension I got ?

New member

Posts

Joined
Wed Jun 15, 2011 8:25 pm

Post by JNeuhoff » Mon Jun 11, 2012 10:17 pm

wonderland wrote:I'm really sorry for this off topic post but I don't understand 1 thing about import/export mod.

Some time ago I found 3 import/export tools
first was (still is) out of development which looks like your mod
second I think was yours
third was very much like yours, but It supported multi language export/import

So I went with third.

It works good, but I wanted to ask some questions to developer.

But now all I can find is your extension and the what that is out of development.

Are all these 3 tools based on same extension ?
were there some copyright issues with the extension I got ?
Our Export/Import tool is the original one and has been available since OpenCart 0.7.9. It is released under the GPL3 license. Any derived work of it needs to be available under GPL3, too, so if somebody else charges for it, they still have to make the source code available for free under the terms of this GPL3 license.

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 estateP » Fri Jun 15, 2012 8:31 am

I have installed this mod v1.5.3.1 and was able to export an xls file with all the details included in the separate tabs. When I try to import the file back into the store, when I choose the file and click import in the dashboard, it redirects to a blank page.

When I check the store, the import has only added the details from the first tab of the xls file. There are no attributes or additional images displayed. In fact it deleted the additional images of the first 2 products I entered in the catalogue manually and now only shows the first image. Any help?

Thanks

New member

Posts

Joined
Wed Jun 13, 2012 2:41 am

Post by JNeuhoff » Fri Jun 15, 2012 11:36 pm

estateP wrote:I have installed this mod v1.5.3.1 and was able to export an xls file with all the details included in the separate tabs. When I try to import the file back into the store, when I choose the file and click import in the dashboard, it redirects to a blank page.

When I check the store, the import has only added the details from the first tab of the xls file. There are no attributes or additional images displayed. In fact it deleted the additional images of the first 2 products I entered in the catalogue manually and now only shows the first image. Any help?

Thanks
Chances are that you will some error message in your OpenCart's system/log/error.txt, or in your server's 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 estateP » Sat Jun 16, 2012 12:38 am


Chances are that you will some error message in your OpenCart's system/log/error.txt, or in your server's error_log.
Hi

I know nothing about coding. There seems to be a lot of errors in the store, but I don't know how to fix them. I can';t upload the log to here because the upload is being rejected. Here are a few of the recurring errors:

2012-06-15 0:58:23 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=Products!$A$6,'data/pipes/091/091-1.jpg',1),
(39,=Products!$A$6,'data/pipes/091' at line 39<br />Error No: 1064<br />INSERT INTO `pipes_product_image` (`product_image_id`,`product_id`,`image`,`sort_order` ) VALUES
(1,50,'data/pipes/119/119-2.jpg',2),
(2,50,'data/pipes/119/119-3.jpg',3),
(3,50,'data/pipes/119/119-4.jpg',4),
(4,50,'data/pipes/119/119-5.jpg',5),
(5,50,'data/pipes/119/119-6.jpg',6),
(6,50,'data/pipes/119/119-7.jpg',7),
(7,50,'data/pipes/119/119-8.jpg',8),
(8,50,'data/pipes/119/119-9.jpg',9),
(9,50,'data/pipes/119/119-10.jpg',10),
(10,51,'data/pipes/096/096-2.jpg',2),
(11,51,'data/pipes/096/096-3.jpg',3),
(12,51,'data/pipes/096/096-4.jpg',4),
(13,51,'data/pipes/096/096-5.jpg',5),
(14,51,'data/pipes/096/096-7.jpg',6),
(15,51,'data/pipes/096/096-8.jpg',7),
(16,51,'data/pipes/096/096-9.jpg',8),
(17,51,'data/pipes/096/096-10.jpg',9),
(18,51,'data/pipes/096/096-11.jpg',10),
(19,52,'data/pipes/074/074-2.jpg',2),
(20,52,'data/pipes/074/074-3.jpg',3),
(21,52,'data/pipes/074/074-4.jpg',4),
(22,52,'data/pipes/074/074-5.jpg',5),
(23,52,'data/pipes/074/074-6.jpg',6),
(24,52,'data/pipes/074/074-7.jpg',7),
(25,52,'data/pipes/074/074-8.jpg',8),
(26,52,'data/pipes/074/074-9.jpg',9),
(27,52,'data/pipes/074/074-10.jpg',10),
(28,53,'data/pipes/085/085-1.jpg',1),
(29,53,'data/pipes/085/085-2.jpg',2),
(30,53,'data/pipes/085/085-3.jpg',3),
(31,53,'data/pipes/085/085-4.jpg',4),
(32,53,'data/pipes/085/085-5.jpg',5),
(33,53,'data/pipes/085/085-6.jpg',6),
(34,53,'data/pipes/085/085-7.jpg',7),
(35,53,'data/pipes/085/085-8.jpg',8),
(36,53,'data/pipes/085/085-9.jpg',9),
(37,53,'data/pipes/085/085-10.jpg',10),
(38,=Products!$A$6,'data/pipes/091/091-1.jpg',1),
(39,=Products!$A$6,'data/pipes/091/091-2.jpg',2),
(40,=Products!$A$6,'data/pipes/091/091-3.jpg',3),
(41,=Products!$A$6,'data/pipes/091/091-4.jpg',4),
(42,=Products!$A$6,'data/pipes/091/091-5.jpg',5),
(43,=Products!$A$6,'data/pipes/091/091-6.jpg',6),
(44,=Products!$A$6,'data/pipes/091/091-7.jpg',7),
(45,=Products!$A$6,'data/pipes/091/091-8.jpg',8),
(46,=Products!$A$6,'data/pipes/091/091-9.jpg',9),
(47,=Products!$A$6,'data/pipes/091/091-10.jpg',10) in /home/estate/public_html/ocart/system/database/mysql.php on line 49
2012-06-15 0:58:40 - PHP Notice: Undefined variable: report_product_profited in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 181
2012-06-15 0:59:06 - PHP Notice: Undefined variable: report_product_profited in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 181
2012-06-15 1:42:27 - PHP Notice: Undefined variable: news in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 87
2012-06-15 1:42:27 - PHP Notice: Undefined variable: homepage in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 90
2012-06-15 1:42:27 - PHP Notice: Undefined variable: report_product_profited in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 187
2012-06-15 1:42:54 - PHP Notice: Undefined variable: news in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 87
Any help would be appreciated. Many thanks

New member

Posts

Joined
Wed Jun 13, 2012 2:41 am

Post by JNeuhoff » Sat Jun 16, 2012 4:36 am

estateP wrote:

Chances are that you will some error message in your OpenCart's system/log/error.txt, or in your server's error_log.
Hi

I know nothing about coding. There seems to be a lot of errors in the store, but I don't know how to fix them. I can';t upload the log to here because the upload is being rejected. Here are a few of the recurring errors:

2012-06-15 0:58:23 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=Products!$A$6,'data/pipes/091/091-1.jpg',1),
(39,=Products!$A$6,'data/pipes/091' at line 39<br />Error No: 1064<br />INSERT INTO `pipes_product_image` (`product_image_id`,`product_id`,`image`,`sort_order` ) VALUES
(1,50,'data/pipes/119/119-2.jpg',2),
(2,50,'data/pipes/119/119-3.jpg',3),
(3,50,'data/pipes/119/119-4.jpg',4),
(4,50,'data/pipes/119/119-5.jpg',5),
(5,50,'data/pipes/119/119-6.jpg',6),
(6,50,'data/pipes/119/119-7.jpg',7),
(7,50,'data/pipes/119/119-8.jpg',8),
(8,50,'data/pipes/119/119-9.jpg',9),
(9,50,'data/pipes/119/119-10.jpg',10),
(10,51,'data/pipes/096/096-2.jpg',2),
(11,51,'data/pipes/096/096-3.jpg',3),
(12,51,'data/pipes/096/096-4.jpg',4),
(13,51,'data/pipes/096/096-5.jpg',5),
(14,51,'data/pipes/096/096-7.jpg',6),
(15,51,'data/pipes/096/096-8.jpg',7),
(16,51,'data/pipes/096/096-9.jpg',8),
(17,51,'data/pipes/096/096-10.jpg',9),
(18,51,'data/pipes/096/096-11.jpg',10),
(19,52,'data/pipes/074/074-2.jpg',2),
(20,52,'data/pipes/074/074-3.jpg',3),
(21,52,'data/pipes/074/074-4.jpg',4),
(22,52,'data/pipes/074/074-5.jpg',5),
(23,52,'data/pipes/074/074-6.jpg',6),
(24,52,'data/pipes/074/074-7.jpg',7),
(25,52,'data/pipes/074/074-8.jpg',8),
(26,52,'data/pipes/074/074-9.jpg',9),
(27,52,'data/pipes/074/074-10.jpg',10),
(28,53,'data/pipes/085/085-1.jpg',1),
(29,53,'data/pipes/085/085-2.jpg',2),
(30,53,'data/pipes/085/085-3.jpg',3),
(31,53,'data/pipes/085/085-4.jpg',4),
(32,53,'data/pipes/085/085-5.jpg',5),
(33,53,'data/pipes/085/085-6.jpg',6),
(34,53,'data/pipes/085/085-7.jpg',7),
(35,53,'data/pipes/085/085-8.jpg',8),
(36,53,'data/pipes/085/085-9.jpg',9),
(37,53,'data/pipes/085/085-10.jpg',10),
(38,=Products!$A$6,'data/pipes/091/091-1.jpg',1),
(39,=Products!$A$6,'data/pipes/091/091-2.jpg',2),
(40,=Products!$A$6,'data/pipes/091/091-3.jpg',3),
(41,=Products!$A$6,'data/pipes/091/091-4.jpg',4),
(42,=Products!$A$6,'data/pipes/091/091-5.jpg',5),
(43,=Products!$A$6,'data/pipes/091/091-6.jpg',6),
(44,=Products!$A$6,'data/pipes/091/091-7.jpg',7),
(45,=Products!$A$6,'data/pipes/091/091-8.jpg',8),
(46,=Products!$A$6,'data/pipes/091/091-9.jpg',9),
(47,=Products!$A$6,'data/pipes/091/091-10.jpg',10) in /home/estate/public_html/ocart/system/database/mysql.php on line 49
2012-06-15 0:58:40 - PHP Notice: Undefined variable: report_product_profited in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 181
2012-06-15 0:59:06 - PHP Notice: Undefined variable: report_product_profited in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 181
2012-06-15 1:42:27 - PHP Notice: Undefined variable: news in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 87
2012-06-15 1:42:27 - PHP Notice: Undefined variable: homepage in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 90
2012-06-15 1:42:27 - PHP Notice: Undefined variable: report_product_profited in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 187
2012-06-15 1:42:54 - PHP Notice: Undefined variable: news in /home/estate/public_html/ocart/vqmod/vqcache/vq2-admin_view_template_common_header.tpl on line 87
Any help would be appreciated. Many thanks
You have quite a few errors indeed, but the one relevant to the Export/Import module is the fact that you use spreadsheet formulas instead of numbers in the product_id column of your 'Additional Images' worksheet.

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 estateP » Sat Jun 16, 2012 7:17 am

JNeuhoff wrote: You have quite a few errors indeed, but the one relevant to the Export/Import module is the fact that you use spreadsheet formulas instead of numbers in the product_id column of your 'Additional Images' worksheet.
Fixed!! Thank you so much for your help :)

Now I need to figure out what is causing the other errors ???

Cheers

New member

Posts

Joined
Wed Jun 13, 2012 2:41 am

Post by jewellerstore » Fri Jun 22, 2012 5:02 pm

I have updated both opencart and the Import/Export ext.
When I go to export it comes up with the following screen:

Image

If I open it this comes up:

Image

I can't see where the problem is, have I not updated something properly?

New member

Posts

Joined
Fri Dec 30, 2011 6:28 pm

Post by JNeuhoff » Sat Jun 23, 2012 10:40 pm

Try this:

In file admin/model/tool/export.php, in method
populateProductsWorksheet, after the

$layouts = $this->getLayoutsForProducts( $database );

add this line:

$database->query( "SET OPTION SQL_BIG_SELECTS = 1" );


Juergen

User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 5 guests