cacaobeans

I was getting the same problem on WordPress 3.1, but this plugin seemed the best option for the one-off import I needed to do.

So I did some debugging, and the following fixes sorted it out:

Line 60: Insert each user – WordPress doesn’t seem to like a string in the table argument – first defining $table_name works. Also my Installatron automatic installed WordPress with NO table prefix! So of course ‘wp-users’ was wrong – I needed ‘users’.

The following code fixes these two issues:

$table_name = $wpdb->prefix . 'users';
$wpdb->insert( $table_name, $arr_user );

Line 81: Same problem with the user meta insert, code to fix it is:

$table_name = $wpdb->prefix . 'usermeta';
$wpdb->insert( $table_name, $arr_meta );

Line 48: my Excel generated csv file worked with the above fixed, but the email addresses had line feeds after them, hence didn’t work correctly when identifying users or sending emails. A simple trim does the job:

// firstname, lastname, username, password
$firstname 		= $arr_values[0];
$lastname 		= $arr_values[1];
$username 		= trim($arr_values[2]);
$password 		= trim($arr_values[3]);
$user_email 	= trim($arr_values[4]);

Line 70: the name of the meta value wp_capabilities also seems to be dependent on the table prefix, which as standard is wp_. Mine was actually just ‘capabilities’ though, so the subscriber role was not getting picked up. Here’s the fix:

// add default meta values
$arr_meta_values = array(
					'nickname' => $username,
					'rich_editing' => "true",
					'comment_shortcuts' => "false",
					'admin_color' => "fresh",
					$wpdb->prefix . 'capabilities' => 'a:1:{s:10:"subscriber";b:1;}',
					'first_name' => $firstname,
					'last_name' => $lastname,
					'default_password_nag' => "1"
					);

As mentioned elsewhere, I also change the php open tag to be the proper <?php tag.

I hope that helps, I can share my version if anyone wants it, or if Andy would like to integrate them back into the plugin.