The only check you want to watch out for is if the email already exists (you don't want two users with the same email, that's a check Drupal does when you create a new user interactively). Forage for the code in the user.module. Victor Kane http://awebfactory.com.ar On Wed, Dec 2, 2009 at 8:08 PM, Matt West <mjw@our-hometown.com> wrote:
Gastón,
You can do this programmatically by creating a separate script that bootstraps Drupal. Something like:
if (($handle = fopen("file.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle)) !== FALSE) { // Set vars to the appropriate indexes from the .csv, you'll need to customize this list($user, $pass, $mail) = $data;
// Create the user array $new_user = array( 'name' => $user, 'pass' => $pass, 'mail' => $mail, 'status' => 1, 'init' => $mail, );
if(!user_load($new_user)) { // Make sure the user doesn't already exist // If you want to assign a role $roles = user_roles(); $new_user['roles'] = array(array_search('your_roll_name', $roles) => 1);
// Save the user $new_user = user_save(null, $new_user); } } fclose($handle);
}
On Dec 2, 2009, at 5:38 PM, Gastón Pablo Pérez wrote:
Hi all
I have data for several persons in an excel file and i would like to convert all of these people in users in my drupal 6. Somebody knows how can i do this? The idea is that not to have to create the users one by one, maybe i would have to make an sql script to include the users in one time, but i don't know in which tables I have to include the data and some other things for example, how have i to set the password? (this is encrypted in the database field)
-- Matt West Software Developer Our Hometown, Inc mjw@our-hometown.com