InMotion Hosting Support Center

User data can be imported into Moodle 2.3 using the Upload Users feature in the Moodle Site administrator section. This option is good and can save time when creating users. For example, the teacher can edit a .csv file with Microsoft Excel, add the user information through Excel and then import or upload them into the Moodle site. This article will walk through the steps to import and upload users. For more information on exporting existing users, please see Exporting users in Moodle.

Importing User data with the Upload Users option in the Site administrator

  1. Log into the Moodle Dashboard
  2. upload-users-1-select-moodleGo to the Settings section on the left and navigate to Site administration > Users > Accounts > Upload users.

    Important! Keep in mind that Editing must be turned on in the Settings > Front Page Settings section in order to edit any of these options.


  3. upload-users-2-drag-moodleDrag the file into the Upload "Drop files here to upload"block.

    Note! The only supported file format for this is a .csv, .xls, or .ods. These file types are for storing tabulated data. If any other type of file is uploaded an "Error occur during loading CSV file!" will occur.


  4. upload-users-3-upload-moodleOnce uploaded the file name should show in the File block. In this case the file name is Users.csv. Click Upload Users.
  5. upload-users-4-status-moodleIf there are any issues with the .csv file, the Upload users preview will show the problem in the Status column. In the following snapshot, the Status shows "Invalid user field: campus". If this occurs, the .csv file will need to be edited to fix the field with the problem. In this example, the campus column was removed in order to process the import. After fixing the .csv, go back through steps 1 to 4 to restart the import.
  6. upload-users-5-import-moodleWhen the .csv file finally shows no Status errors, a page will load with values for importing. Set the Settings, Default Values, and Other Fields for the import and click Upload Users.
  7. upload-users-6-continue-moodleFinally the Upload users results page will load showing the users that were imported successfully.

This concludes the article for Importing users in Moodle. Please check the next article on Configuring the User Permission policies in Moodle. For more information on this Education Channel please visit Managing users and roles in Moodle

Continued Education in Course 105: User Accounts and Permissions in Moodle
You are viewing Section 7: Importing or Uploading users in Moodle
Section 6: Exporting or Downloading users in Moodle
Section 8: Removing the Guest login button from the Moodle login page
2013-05-22 10:20 am
Hello
I'm having the same problem. If I do want to upload the CSV file with the column of the profile_field. what do I do?
5,889 Points
2013-05-22 12:02 pm
To fix that error you will need to create the custom field for the user. Please see the following article on this.

<a href="http://www.inmotionhosting.com/support/edu/moodle/user-roles-moodle/user-profile-fields" target="_blank">Editing User profile fields in Moodle</a>

Make sure the field name profile_field matches your CSV information.

Best Regards,
James R
2013-05-22 1:19 pm
Hey thanks for the answer
I did doubled checked it and it's the same field name I did that but still when uploading the CSV file I'm getting "Invalid user field:" and I can't continue. I do want to continue with this column
5,889 Points
2013-05-22 1:25 pm
Sorry for all the trouble on this. You may need to remove that field from your CSV. Make a backup of the original first of course. It appears you will have to recreate the field through your Moodle Dashboard.
2013-05-23 4:05 am
without this column it works. but the idea is to upload mass of users with some other profile_fields that we want to add to the user profile in moodle. it used to work great on moodle 1.9 and now in moodle 2.4+I did the exact same procedure but it just not working. :-(
2013-05-23 4:19 am
I'v found out that I had extra space in the field of the rows and that's why it didn't work.
sorry for that , thanks for trying to help
n/a Points
2016-02-09 4:22 am

I have added role1 field in CSV, the id of role student is 5 so i filled role1 fields with value 5, upload was successful but the users were not assigned with the role. Tried other roles too but failed. Can you tell me what i am doing wrong?Regards

Staff
7,901 Points
2016-02-09 11:26 am
It would be difficult to know what exactly went wrong without being able to replicate the error, see your actual .csv file, or view a copy of a specific error message. I advise checking your work and trying again to see if the behavior repeats itself.
n/a Points
2017-02-01 10:35 am

Hi

I did everything you said

and i can really see all my users but how do I send them the UserName and there Pass?

Its not supposed to send an Email in the sec I uploaded you users?

Staff
37,299 Points
2017-02-02 5:53 am
Hello Sharon,

Per their documentation,documentation, you can add an option to send a message which requires messaging. You can also set the option to force password change, then use your CSV file to create an email list so that you can notify everyone of their username and the required password change.

I hope that helps to answer your question! If you require further assistance, please let us know!

Regards,
Arnel C.

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

10 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!