Page 1 of 1

importing csv into phpmyadmin #1062 - Duplicate entry '5000'

Posted: Wed Jan 27, 2016 1:42 pm
by jonnyfortis
i have an excel spreadsheets that i have converted into a csv file here is the first line of the exported file
[text]5000,"Sleeveless Suit, Inky Black, Heart Hands",Made from 100% quality Cotton fabric ... Clothes are Unisex which are made to be mixed and matched ,31,0,sleeveless romper black hands.jpg,,,58,0,0,0,SS16,0,0
[/text]
but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there.

the settings i am using are

import

select the csv file
Character set of the file:utf-8
Columns separated with:,
Columns enclosed with:"
Columns escaped with:"
Lines terminated with:auto
Do not abort on INSERT error (not ticked)

Re: importing csv into phpmyadmin #1062 - Duplicate entry '5

Posted: Wed Jan 27, 2016 2:14 pm
by Celauran
jonnyfortis wrote:but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there
Have you checked that the row isn't duplicated in your CSV?

Re: importing csv into phpmyadmin #1062 - Duplicate entry '5

Posted: Wed Jan 27, 2016 2:31 pm
by jonnyfortis
Celauran wrote:
jonnyfortis wrote:but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there
Have you checked that the row isn't duplicated in your CSV?
yes sorry one had sneaked in there. sorry about that