How to import users from CSV file with extra fields

[zhlousek]

Hi,
Please kindly describe the steps to import users from CSV file. I don’t seem to be able to figure out how to do that.
Thank you.

[Khaled]

Hello,

Please follow those steps to import users from csv file:

1. CSV File format:
First row of CSV file will treat as Field Name.
Field will separate with comma (,) and Enclosed with the double quotation (” “).

e.g:
“username”, “email”, “first_name”, “country”
“Jack”, “jack@domain.com”, “Jack”, “USA”

2. Upload CSV:
Upload your csv from User Meta >> User Import.

3.
After uploaded csv file, there will be a new screen, you can see all of your csv file header fields at left of the screen. Merge csv file’s field with WordPress fields. In case of extra field (e.g. country), select “Custom Field” from Assigning Field. Configure other settings as you need and hit Import button.

Thanks.

[zhlousek]

OK, Thank you.
However, the While I have version Version 1.1.1 Pro, there is no option you described in step 2.

2. Upload CSV:
Upload your csv from User Meta >> User Import.

I can send you a screenshot if necessary.

I something wrong with my installation?
Thank you for truly quick reply.

[Khaled]

With version 1.1.1, user import feature is not available. Please use version 1.1.2rc3 to import users.

Thanks.

[zhlousek]

Thank you again on a very quick reply.

I’ve realized that version 1.1.1 does not have the import feature.
I tired version 1.1.2rc3 but that generated an error when I tried to view the site page. BTW, the plugin appears to installs fine but the site afterwards has an error.

Here is an error message:
Warning: Missing argument 2 for umPreloadsProController::loginPageExtraExecutionTitle() in /wp-content/plugins/user-meta/controllers/pro/umPreloadsProController.php on line 74

I tried using version 1.1.2rc2 and that version does not display the error message but I cannot import users.
I used the csv file generated by excel and I even tried making one up by hand per your instructions in an earlier message.

Thank you.

[Khaled]

With version 1.1.2rc2/1.1.2rc3, what was occurring when you tried to import?

Thanks.

[zhlousek]

I have used version 1.1.2rc2 as 1.1.2rc3 does not work.

Here is a CSV file I tried. BTW, excel export does not put quotes around field values and I had to do that manually. You should consider overcoming that step is that would be a problem if I was trying to import large number of users.

“user_login”,”number”,”user_pass”,”email”,”last_name”,”first_name”
“joe”,”11111112″,”joejoejoe”,”joe@ix.com”,”Smith”,”Joe””
“jan”,”11111113″,”janjanjan”,”jan@ix.com”,”Smith”,”Jan””

THen I get my data listed in a column with select menu next to each value.
When I identify email fields or any combination for that matter, and the select import

the process completes with message

Import completed.
Read: 0, Created: 0, Updated: 0, Skipped: 0
I find no new users on the site.

THanks

[Khaled]

Hello,

Could you please send your site url and csv file to support@user-meta.com

Thanks.

[creattico]

Hi, I can’t import users, I receive a failure message. I’ve also tried to import your example:

“username”, “email”, “first_name”, “country”
“Jack”, “jack@domain.com”, “Jack”, “USA”

but it doesn’t work.

Thank you

[Khaled]

Hello,
Which failure message is showing for you?

[creattico]

Hi,
thank you for your response, but I’ve solved the problem repairing site permissions.

While we are, I want know if is possible change the date format from YYYY-MM-DD to DD-MM-YYYY in custom fields.

Thanks

[bluantinoo]

I have one question about CSV import: what happens if a user is already registered?
I mean, what if an email or a username that I try to import from csv is already present in wp users?

[Khaled]

@bluantinoo,
There is a checkbox at User Meta Import page “Overwrite existing users”. If you check that checkbox then, user data will be overwritten (username and email won’t overwrite if newly imported one already exists). And if checkbox remain uncheck then existing users will skipped.

Thanks.

[Author]

Posts