News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

importing to sql dbase

Started by deepwaters, October 07, 2004, 10:18:41 PM

Previous topic - Next topic

deepwaters

can this be done? i have a bunch of users that need to be added. they are in a csv file. i've searched for documentation, but may not be using the correct keywords. i can't find anything about importing. help!

[Unknown]

Do you have a username, password, and email address for each person?  That's the minimum.....

-[Unknown]

deepwaters


[Unknown]

Well, if you can reformat it, what you want it to look like is this:

INSERT INTO prefix_members
  (memberName, passwd, emailAddress)
VALUES ('username', MD5('password'), '[email protected]');

Does that help at all?

-[Unknown]

Advertisement: