senthilkumar Posted January 7, 2008 Share Posted January 7, 2008 hi, I am new to OsCommerce. I have installed Easy Populate 2.76f-MS2. The Products export to excel (from database to csv file) is woking fine. Then i do some modification in that csv file. Then i upload that file to database i had following error "1366 - Incorrect decimal value: 'v_attribute_values_name_13_17_2' for column 'products_price' at row 1 INSERT INTO products ( products_image, products_model, products_price, products_status, new_arrivals, homepage_products, featured_items, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id ) VALUES ( 'v_attribute_values_name_13_17_1', 'values_name_13_14_3', 'v_attribute_values_name_13_17_2', '1', 'No', 'No', 'No', '2008-01-07 05:00:02', '1970-01-01 00:00:00', '1970-01-01 00:00:00', '', 'v_attribute_values_price_13_17', 'v_attribute_values_name_13_17_3', NULL) " Note : I had many product attributes, so the CSV file has many column from A, B, C... ENU. I think that, due to many columns in the CSV file the it take header as the value. Actually 'v_attribute_values_name_13_17_1' is a header not a value but pls see the error message it coe under values. I think that EP has some limitations for coloumn count after it over the limitation it take the header as a value. I am not sure about these.. Please any one help me i would like to solve this issue as soon as possible. Please help me. Quote Senthil Kumar R Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 7, 2008 Share Posted January 7, 2008 How are you uploading the file? Using phpmyadmin and an sql window or via EP? The sql is trying to insert the column headings into the table as field values. If you are using EP to import the data please post the first 2 lines of your import file. Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.