Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro
Author Message
cmcraft
New Member
New Member


Joined: Dec 05, 2005
Posts: 24

PostPosted: Mon Oct 16, 2006 11:45 am Reply with quote

I have a list of my students in a CSV file that I would like to import. I am not too familiar with MySQL command lines, is there any way I can do this?

It sure would beat typing in hundreds of entries, and that takes forever!

Thanks!

Chris Craft Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Mon Oct 16, 2006 3:41 pm Reply with quote

There are various tools at various price points out there. Try googling "mysql import cvs" and you will see some of them.

I am assuming you want to import this data into the users table? If so, you'll need to "map" between what's in the csv file and the users table. Getting familiar with what's in the users table would be a good start. For instance, the users name in the users table is not subdivided into last name and first name and if you have your data that way you will need to do some manipulation before trying to load it. You'll also need a password for each user and that is stored as an encrypted value (MD5).

Honestly, the more I think about it, the more I think that you might be better off to give one of them the assignment to sit there and type them in thru the Nuke administrative interface. But maybe someone here has a better idea.
 
View user's profile Send private message Visit poster's website
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Tue Oct 17, 2006 5:18 am Reply with quote

i did that some time ago...
had the help of a commercial script... Laughing
 
View user's profile Send private message
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©