Welcome to WebmasterWorld Guest from 18.207.136.184

Forum Moderators: open

Message Too Old, No Replies

PHPMyAdmin & CSV File: automatic numbering not sequential

     
6:31 pm on Sep 25, 2006 (gmt 0)

New User

10+ Year Member

joined:Sept 7, 2006
posts:7
votes: 0


I have managed to upload an Excel exported CSV file to MySQL via phpmyadmin, but the automatic numbering of my id field is a little wonkey. It starts out find, going from 1 and to about 600, then jumps to ~77000. I a) don't know why it would do this and b)don't know if this matters anyway. I tried uploading the file a couple times and besides a change in the number where it "jumps," it continues to do so.

There are currently about 1600 records in the CSV. I read somewhere that if you have a lot of records, you might want to break them up into several uploads; what exactly is "a lot"?

TIA.

4:09 pm on Sept 26, 2006 (gmt 0)

New User

10+ Year Member

joined:Sept 7, 2006
posts:7
votes: 0


I think I've "resloved" the issue (as it turns out, I think I may have created it, too).

I added a column at the begining for the autonumbered field and put a 1 in the first entry (all the others I left blank). Then, I checked the tab delimited file Excel created before uploading. It had added a lot of empty lines to the end (I'm not particularly good with Excel either and seem to have added lots of blank lines to the end of the spreadsheet which deleting doesn't actually seem to remove).

After fixing these two things, I uploaded the file and everything worked fine. My autonumbered fields are now appropriately numbered, if it matters. Any other insight or advice is still greatly appreciated. Thanks.

9:36 pm on Sept 26, 2006 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12555
votes: 3


What more could we offer? Seems you've briged the gap!
Welcome to WebmasterWorld, erb5 :)
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members