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

Gastón Pablo Pérez wrote:

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) Hi. I have code I used to create users from osCommerce users in a CSV file. The 'from' columns will be different, but you if it will be useful at all e-mail me and I'll send it to you. The password is simply md5($the-original-password).

Jeff

Hi, yet another option is the excellent module pair - Migrate and Table Wizard http://drupal.org/project/migrate http://drupal.org/project/tw Many thanks, John Oakley On 03/12/2009, at 8:08 AM, 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)

thanks in advance

Gastón Pablo Perez Email: gpperez@gmail.com Web: http://cv.gpperez.com.ar