How do I constrct the CSV?
| Project: | User Import |
| Version: | 6.x-1.2 |
| Component: | Documentation |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Sorry, but I have never worked with excel or CSV files before.
The documentation appears not to say anything at all about how to construct one.
1)
For instance, I don't understand this (from the user imports page):
"Username: The Username will be built from CSV columns in the order selected"
What does that mean exactly? And why isn't 'name' listed in the 'drupal fields' dropdown menu?
Only 'password' and 'email address' are listed.
2)
Assuming I haven't added any custom profile fields, what columns should my excel file have?
For instance, should I include a UID number? Should I include the super user?
3)
Will the import append users from the CSV onto existing users, or overwrite them?
How easy is it to 'undo' an import in phpmyadmin?
4)
Is there a step-by-step tutorial anywhere?
It seems like everyone in the issue queues knows exactly what they're doing, and
how to use this module, but I don't know where they're getting their information from?
Thanks!
#1
On the User Import project page, under resources click "Read documentation".
The only required column in your csv file is email.
#2
thanks for your reply.
I already read the documentation... it didn't help. None of the above questions are answered by the documentation. At least, I didn't see one single thing about the CSV file there, only the steps involved in using the module.
> The only required column in your csv file is email
That doesn't make sense to me at all... why isn't the login name included?
Surely the imported users need a unique login name?
This is what i don't understand; the sample text has first and second name.
As I intimated originally, why isn't the login name included in all this?
Thanks for any further clarification!
#3
Usernames can either be randomly generated or you can use a combination of fields to generate a username (see Username column in Fieldmatch).
#4
OK, thanks. I worked it out eventually. It was simpler than I thought once I actually had a CSV of my own to work from.
And after a few practise runs. Very nice module!! Thanks for making it available.
Would you suggest any particular method for exporting users, that is compatible with the import module?
#5
Automatically closed -- issue fixed for 2 weeks with no activity.
#6
Hi,
I tried to read all the related messages but couldn't find how to easily make a .CSV file.
I have a list of email separated by a comma, I would like to find the easiest way to create users based on these emails addresses.
Can I make a CSV file in notepad++ or Google docs ? How should it look like.
Thanks a lot.
#7
A comma separated list *is* basically a 'one column' CSV file.
Personally, I'd import the list of emails into Excel or other spreadsheet.
This will get all the emails in one column - I'd give it the title of 'email' at the top.
Then I'd write this formula in the next column: =LEFT(A1,FIND("@",A1)-1)
This will parse just the name from the email and print it in the next column.
I'd give this column 'name' as a title at the top.
So now you have the information you need to create accounts: a username and email.
You'd export these two columns (including titles) as CSV, and use the resulting file with this module.
You can set the module to assign a random password and email the users with the login information
after the accounts are created.
However, you don't need to use the spreadsheet. Using the file you already have, you can get the
module to assign a random username as well as a random password. The user can then change their
name and password after logging in for the first time.