Looking for Advice on Importing Users

[nikvon]

The guys at the vBulletin Forums suggested I try this post here:

Does anyone have a comprehensive set of directions on how to Import Users using phpmyadmin?

I would very much appreciate any experienced users' do's, dont's and dont forget to's tips.

I have MySQL v3.23.32 and phpmyadmin v2.2.3.

This is the first time for me trying this. I want to append about 400 users to a user database that already contains about 110 users.

I'm no stranger to importing data into databases, but have never done it with these tools into this type of database engine.

I have the csv file ready to go and I know to back up the mysql tables before I proceed.

Do I leave the UserID field empty (I see it is an auto-increment field), or do I need to assign a userid to each new record?

Do I also need to Import/append the new users to the UserField too, even if the field1 through field5 will be empty? How about into the UserActivation table? I notice both have the UserID field in them.

How to I create that 10 digit date/time number for JoinDate for June 1 2002 at 6am?

After sucessfully importing/appending these records, what do I need to update from the admin panel?

Any helpful hint would be greatly appreciated.

Thank you.