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)
importing csv into phpmyadmin #1062 - Duplicate entry '5000'
Moderator: General Moderators
-
jonnyfortis
- Forum Contributor
- Posts: 462
- Joined: Tue Jan 10, 2012 6:05 am
Re: importing csv into phpmyadmin #1062 - Duplicate entry '5
Have you checked that the row isn't duplicated in your CSV?jonnyfortis wrote:but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there
-
jonnyfortis
- Forum Contributor
- Posts: 462
- Joined: Tue Jan 10, 2012 6:05 am
Re: importing csv into phpmyadmin #1062 - Duplicate entry '5
yes sorry one had sneaked in there. sorry about thatCelauran wrote:Have you checked that the row isn't duplicated in your CSV?jonnyfortis wrote:but it is giving me an error Duplicate entry '5000' even though the 5000 isnt in there