Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate Error on while uploading


senthilkumar

Recommended Posts

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.

Senthil Kumar R

Link to comment
Share on other sites

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.

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...