hi
as with russell mann's post above, i too am getting below error:
'Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!'
I'm trying to find how the spreadsheet needs to be layed out to import properly. I can't seem to find documentation on it. Any help?
You mention in post that there may be issues when using openoffice, if so, what do i need to do to fix? if 'products' data is corrupt could you poss let me know how to fix?
I have attached spreadsheet file.
all help appreciated.
matt
as with russell mann's post above, i too am getting below error:
'Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!'
I'm trying to find how the spreadsheet needs to be layed out to import properly. I can't seem to find documentation on it. Any help?
You mention in post that there may be issues when using openoffice, if so, what do i need to do to fix? if 'products' data is corrupt could you poss let me know how to fix?
I have attached spreadsheet file.
all help appreciated.
matt
Check your OpenCart's system/logs/error.txt for more details.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
thanks for that, for some reason i didn't think to check error logs, but, bingo...
it's saying 'Export/Import: Invalid header in the Products worksheet' - self-explanatory, however, i am not sure what is making the header invalid...?
I've attached spreadsheet again.
it's saying 'Export/Import: Invalid header in the Products worksheet' - self-explanatory, however, i am not sure what is making the header invalid...?
I've attached spreadsheet again.
Just do an export, and copy the product worksheet header from that resulting file to your new spreadsheet file.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have done all suggestions above, now, when i do an import, when timer on chrome gets to 100% the screen whites out, the error in logs is below:
2012-10-24 17:11:49 - 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 'SS F 19' RIM.JPG', 179, 0, 1, 50, '2012-09-14 11:28:28','2012-09-14 11:28:28', 1' at line 1<br />Error No: 1064<br />INSERT INTO `category` (`category_id`, `image`, `parent_id`, `top`, `column`, `sort_order`, `date_added`, `date_modified`, `status`) VALUES ( 444, 'data/Classic British/BSA/BSA 7' SS F 19' RIM.JPG', 179, 0, 1, 50, '2012-09-14 11:28:28','2012-09-14 11:28:28', 1); in /var/www/vhosts/sorcewebdesign.co.uk/httpdocs/devonrimcompany/system/database/mysql.php on line 49
I have tried to locate the image with apostrophes in the image name, above, but i cannot find it on the server, I am guessing that the error is possibly because of the apostrophes - do you think this might be the case?
2012-10-24 17:11:49 - 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 'SS F 19' RIM.JPG', 179, 0, 1, 50, '2012-09-14 11:28:28','2012-09-14 11:28:28', 1' at line 1<br />Error No: 1064<br />INSERT INTO `category` (`category_id`, `image`, `parent_id`, `top`, `column`, `sort_order`, `date_added`, `date_modified`, `status`) VALUES ( 444, 'data/Classic British/BSA/BSA 7' SS F 19' RIM.JPG', 179, 0, 1, 50, '2012-09-14 11:28:28','2012-09-14 11:28:28', 1); in /var/www/vhosts/sorcewebdesign.co.uk/httpdocs/devonrimcompany/system/database/mysql.php on line 49
I have tried to locate the image with apostrophes in the image name, above, but i cannot find it on the server, I am guessing that the error is possibly because of the apostrophes - do you think this might be the case?
You are using single quotes in your image file names, e.g. 'data/Classic British/BSA/BSA 7' SS F 19' RIM.JPG'.
Don't use special characters in image file names.
Don't use special characters in image file names.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Please help having issues.
This is the error that i am getting. I have zero programming experience so please be as direct as possible. Any help would be greatly appreciated
2013-04-03 18:13:36 - PHP Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.ean, p.jan, p.isbn, p.mpn, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, pd.tag, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in /home2/pricesin/public_html/store/system/database/ipsmysql.php on line 53
This is the error that i am getting. I have zero programming experience so please be as direct as possible. Any help would be greatly appreciated
2013-04-03 18:13:36 - PHP Notice: Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay<br />Error No: 1104<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.ean, p.jan, p.isbn, p.mpn, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, pd.tag, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in /home2/pricesin/public_html/store/system/database/ipsmysql.php on line 53
ok corrected my last problem. but now I get this error
Error: MySQL server has gone away
Error No: 2006
Error: MySQL server has gone away
Error No: 2006
So, um.
how did you solve the /ipsmysql.php error?
please share if you solve an issue
how did you solve the /ipsmysql.php error?
please share if you solve an issue
Self Taught Opencart User & Developer Since 2010.
Who is online
Users browsing this forum: No registered users and 61 guests