Skip to main content

I am trying to enrol a “test” user onto a course, using the .CSV template but it hasn’t worked and I can’t work out if I have entered the incorrect information onto the file.

Here are my steps:

  1. Went onto Course Management, and selected Management Enrolment from CSV
  2. Dropped the file, clicked on Advanced Settings, and enabled the toggle to “consider the first row as header”
  3. The next steps I’m sure what the purpose of dragging and dropping the header onto the preview screen is. However I did this and I clicked on “import”.

However, when I went into the course enrolments tab, the user isn’t on there. I’ve done a few variations but none are accepted.

Username - I have tried username, full name, email address and employee number. None worked.

Course Code - I have entered this as RP-51, as per below screenshot

Session ID - the field is left blank as when I created the session the session ID field wasn’t mandatory

Active until - (I entered this as a past date) 01/01/2024  00:00:00

 

If someone can help me that’ll be great. Thanks in advance :-)

The UserName is going to be what ever is in the UserName column when you look at someone under Admin>Users.  I do think most people use an e-mail, but it can be anything, so I’d start there to see if that’s your issue.

 

The Active Until probably should be blank or a future date.  I’ve never done it with a past date, it may be possible but I’m not sure if that’s causing issue.

When you do an import you are provided, at least in my experiences, an audit log/error log.  Did you check that?

Did you also include the enrollment level on the CSV file you are using?  Either Student or Instructor.  If you didn’t include that column, that could be the cause of the enrollment not happening.

Please check your background jobs for an error log. They are usually pretty explicit.

Hi Susan,

I just ran a test file with the following fields for an e-Learning course, not ILT, but I think this may help.

  • username
  • course code
  • level = Student
  • active until = 2024-12-10 (I changed the time format to this setting which resulted in a successful upload.)

I hope this helps.

Desiree Leslie

As ​@Dez mentioned, I find one of the main issues is the date format.  This should always be set as yyyy-mm-dd otherwise the file will not load.

Also make sure none of your cell entries contain additional spaces, as this can also cause issues.

In my experience, upload failures are nearly always due to an incompatible date format. However, the error log from the Background Job should tell you the reason for the rejections.

Thanks @joanne.gerard and @JGildea. I typed “time format” when I meant “date format”. Thanks for clarifying. 😊

Dez

Thanks all! I really appreciate your responses.

No, nothing appeared in Background Jobs (under System Admin). I forgot to mention on the CSV file there is a “Level” column which has “student” under it. The course is also ILT and not eLearning. Surely enrolment uploads should work for both?

I also tried changing the date format from UK to US, but it keeps reverting back. 

 

Anyway, I think the main reason why the upload isn’t working is because I am using the training environment and there isn’t my email address attached to the profile.

I’m waiting for someone to create a new profile for me and I will try the above process again.

 

Hi @Susan Hoang, 

When you changed the date format, did you do so within the cells (which will revert back), or did you right-click on the column, select Format Cells, select Date and select, for example, 2012-03-14? Doing it the second way should not revert the format.

Reply


Terms & ConditionsCookie settings