Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I am facing issue with plugin, while export the products it gives the error..
Undefined offset: 0
×Getting messages - what is this ?
I tried to contact hosting provider they said this :
The error which you are seeing is due to the connectivity issue of MHCCORP.COM. When you press the EXPORT button, the script is trying to connect with MHCCORP.COM and fails, it cause the 504 Gateway Time-out error as per the server logs.
[20:55:02 srv12 root@xxx ~]cPs# curl -v http://MHCCORP.COM/
* About to connect() to MHCCORP.COM port 80 (#0)
* Trying 192.254.233.92... Connection timed out
* couldn't connect to host
* Closing connection #0
curl: (7) couldn't connect to host
Reason: Added quote tags.
Have problem with this mod:
then try to export I`ve got message
" Undefined offset: 3"
and in error log
(PHP Notice: Undefined offset: 3 in /var/www/instroysna/data/www/................./admin/model/tool/export_import.php on line 6920)
Reason: Added quote tags.
I have rebuild the cache by refreshing and checked the permission tab but it isn't showing up there either.
Just to repeat it (I get this kind of enquiry almost every day): This is an Opencart installer issue, not an Export/Import issue! The files were most likely uploaded to the wrong place because of a missing or invalid FTP Root in the System > Settings > edit Store > FTP setting.ActionHank wrote:Hey, I've installed this extension on a fresh 2.3.0.2 install of opencart, but it isn't showing up in the back end.
I have rebuild the cache by refreshing and checked the permission tab but it isn't showing up there either.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
That's all fine and dandy, but what if the install is in the root...? Or do i say somthing strange now?JNeuhoff wrote:Just to repeat it (I get this kind of enquiry almost every day): This is an Opencart installer issue, not an Export/Import issue! The files were most likely uploaded to the wrong place because of a missing or invalid FTP Root in the System > Settings > edit Store > FTP setting.ActionHank wrote:Hey, I've installed this extension on a fresh 2.3.0.2 install of opencart, but it isn't showing up in the back end.
I have rebuild the cache by refreshing and checked the permission tab but it isn't showing up there either.
And is there a fix for this? Even if its quick and dirty.
[edit]
Sorry, i misunderstood you, i have fixed it.
To fix Just add the last directory of your base url of the webserver in the ftp settings.
[/edit]
Undefined offset: 0
×Getting messages - what is this ?
I tried to contact hosting provider they said this :
The error which you are seeing is due to the connectivity issue of MHCCORP.COM. When you press the EXPORT button, the script is trying to connect with MHCCORP.COM and fails, it cause the 504 Gateway Time-out error as per the server logs.
[20:55:02 srv12 root@xxx ~]cPs# curl -v http://MHCCORP.COM/
* About to connect() to MHCCORP.COM port 80 (#0)
* Trying 192.254.233.92... Connection timed out
* couldn't connect to host
* Closing connection #0
curl: (7) couldn't connect to host
I export the spreadsheet and I have made amends to the sheet, when I go to import again, I get the following errors.
Could you offer me any advice please? Or where/how to get this working again?
Thanks,
I'm using opencart 2.0.1.1
2016-08-03 13:31:54 - Export/Import: Undefined option_value_name 'Leg Set Plinth Kit 1000 1700 Plinth – LEGC' for optiion_id '94' used in worksheet 'ProductOptionValues'!
But when I want to export, and I get this message:
Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/local/lib/php') in /home/hardcore/public_html/admin/model/tool/export_import.php on line 7954
Please help!
Are you sure you go the correct setting for DIR_SYSTEM in your admin/config.php? If so, then it might be also an access rights issue.ahetaton wrote:I installed the tool without error.
But when I want to export, and I get this message:
Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/local/lib/php') in /home/hardcore/public_html/admin/model/tool/export_import.php on line 7954
Please help!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have installed Export/Import on 2.0.3.1
When exporting "products" using default settings
I added one product change but when trying to import get error below.
Code: Select all
2016-08-17 9:25:41 - Export/Import: Undefined option_value_name '25.4 130mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:41 - Export/Import: Undefined option_value_name '31.8 - 110mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '48cm' for option_name 'Frame Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (80mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '26x1.75/1.95 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '26x2.1/2.6 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Schrader Valve' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '29x1.75/2.125 Schrader Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined option_value_name '700x35/43C Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 9:25:42 - Export/Import: Undefined attribute_name 'Suitable For' for attribute_group_name 'Child Trailer Spec' used in worksheet 'ProductAttributes'!
2016-08-17 10:03:15 - Export/Import: Duplicate product_id '1518' used in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Worksheet 'Specials' cannot use product_id '1519' because it is not listed in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Worksheet 'ProductOptions' cannot use product_id '1519' because it is not listed in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Worksheet 'ProductOptionValues' cannot use product_id '1519' because it is not listed in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Worksheet 'ProductAttributes' cannot use product_id '1519' because it is not listed in worksheet 'Products'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '25.4 130mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '31.8 - 110mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '48cm' for option_name 'Frame Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (80mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '26x1.75/1.95 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '26x2.1/2.6 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Schrader Valve' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '29x1.75/2.125 Schrader Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:15 - Export/Import: Undefined option_value_name '700x35/43C Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 10:03:16 - Export/Import: Undefined attribute_name 'Suitable For' for attribute_group_name 'Child Trailer Spec' used in worksheet 'ProductAttributes'!
You have to define the missing option values values first, before using them in your products import.snappyfish wrote:Hi,
I have installed Export/Import on 2.0.3.1
When exporting "products" using default settings
I added one product change but when trying to import get error below.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for for reply, could you explain more? Even when exporting the default products already in the store and trying to re-import with no changes I get this error?JNeuhoff wrote:You have to define the missing option values values first, before using them in your products import.snappyfish wrote:Hi,
I have installed Export/Import on 2.0.3.1
When exporting "products" using default settings
I added one product change but when trying to import get error below.
Code: Select all
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '25.4 130mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '31.8 - 110mm' for option_name 'Stem Options' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '48cm' for option_name 'Frame Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '700x18/25C Presta Valve (80mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '26x1.75/1.95 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '29x1.75/2.125 Presta Valve (60mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '26x1.75/1.95 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '26x2.1/2.6 Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '27.5x1.75/2.125 Schrader Valve' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '29x1.75/2.125 Schrader Valve (48mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined option_value_name '700x35/43C Schrader Valve (40mm)' for option_name 'Tube Size' used in worksheet 'ProductOptionValues'!
2016-08-17 12:28:17 - Export/Import: Undefined attribute_name 'Suitable For' for attribute_group_name 'Child Trailer Spec' used in worksheet 'ProductAttributes'!
If I tick these options and export and then re-import there is no errors? But un-ticked and causes errors as mentioned.JNeuhoff wrote:You have to define the missing option values values first, before using them in your products import.snappyfish wrote:Hi,
I have installed Export/Import on 2.0.3.1
When exporting "products" using default settings
I added one product change but when trying to import get error below.
Use option_id instead of option name in worksheets 'ProductOptions' and 'ProductOptionValues'
Use option_value_id instead of option_value name in worksheet 'ProductOptionValues'
Use attribute_group_id instead of attribute_group name in worksheet 'ProductAttributes'
Use attribute_id instead of attribute name in worksheet 'ProductAttributes'
Use filter_group_id instead of filter_group name in worksheets 'ProductFilters' and 'CategoryFilters'
Use filter_id instead of filter name in worksheets 'ProductFilters' and 'CategoryFilters'
I have been using your extension for a few years now and it is really great. I just wanted to know if you have added DOWNLOAD list import/export to it in recent versions.
Many thanks for your valuable work.
"SELECT a.*, c.name AS country, z.name AS zone, (cu.address_id=a.address_id) AS 'default' FROM 'address' a INNER JOIN 'country' c ON C.COUNTRY_ID=A.COUNTRY_ID LEFT JOIN 'zone' z ON z.country_id AND z.zone_id INNER JOIN 'customer' cu ON cu.customer_id WHERE a.customer_id BETWEEN 1 AND 760 ORDER BY a.customer_id ASC, a.address_id ASC;"
What can cause this error log?
Comment out the linesirszor wrote:I like this extension. I have been using it for 1 year. Today I installed the latest 3.5 to my OC2.0.3.1 system. It works almost fine. When I start Customers export it makes the xls file perfectly but I get an error message in error log:
"SELECT a.*, c.name AS country, z.name AS zone, (cu.address_id=a.address_id) AS 'default' FROM 'address' a INNER JOIN 'country' c ON C.COUNTRY_ID=A.COUNTRY_ID LEFT JOIN 'zone' z ON z.country_id AND z.zone_id INNER JOIN 'customer' cu ON cu.customer_id WHERE a.customer_id BETWEEN 1 AND 760 ORDER BY a.customer_id ASC, a.address_id ASC;"
What can cause this error log?
Code: Select all
$this->log->write( $sql );
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
But i have a little problem...(
How can I doing import without overwriting field "description"?
I have this problem, because description of products i'm writing manually in OC admin, but the rest of data - is automatically generated from my CRM (sku, prices, stocks and so on)...
So, when i'm doing import - my descriptions was overwrited with empty values(((
Users browsing this forum: No registered users and 73 guests