Totara Learn Open Discussions

Upload Users - errors importing

Für dieses Forum ist eine Höchstzahl von Beiträgen innerhalb eines bestimmten Zeitraums festgelegt worden. Dies gilt nach 3 Beiträgen innerhalb von 1 Tag

Hello!

https://totara.help/docs/available-fields-for-uploading-a-user

I've followed the above to put together a spreadsheet to upload users, and have tried using just one user but continue to get the following 3 errors:

Not enough columns, please verify the delimiter setting

Debug info:
Error code: csvfewcolumns

Stack trace:

line 500 of /lib/setuplib.php: moodle_exception thrown
line 192 of /admin/tool/uploaduser/locallib.php: call to print_error()
line 135 of /admin/tool/uploaduser/index.php: call to uu_validate_user_upload_columns()

The first I am trying to fix is the 'Not enough columns'. The only columns I listed were the required columns of username, firstname, lastname, and email, as well as the columns 'course1' and 'enrolstatus1' because my end goal is to use the upload to unenroll a group of people from a particular course.

Would you have any ideas on what I'm missing or should do to use the ''upload users' feature?

Thank you!

User Upload Test.csv (112 Bytes)

Dauerlink | Antwort

Typically the CSV file would have commas between fields - this one does not. The source package for the csv should be configured to use comma as delimiter. ie "Comma Separated Values".

cheers, Andrew

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

Thank you Andrew - I've rebuilt to the attached but receiving the same errors.

Apologies, I use the upload CSV feature to upload course completion but I've never had to manually enter the commas. Odd.

User Upload Test 1.csv

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

That new file had quotations around each line which may be causing issues. Here's a template I know works. Whichever report or tool generating your list may require reconfiguring. Be careful with using Excvel for CSV's in some situations - in particular, Excel automatically strips leading zeroes, which maims any data with leading zeros.

The free app Notepad++ is excellent for transparently manipulating text files, with useful search and replace if required.

username,firstname,lastname,email,password

leofin,Leo,Finley,leo.finley@mainfreight.com,XYZZY

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

Hi Andrew!

I've fixed the CSV file and am no longer getting the error importing, and if I change user profile fields they change, but after testing the following options I am still unable to unenroll a team member from the course. I've documented the tests. Would you mind letting me know if there is something I'm doing to keep the upload file from unenrolling the user from the course?

Thank you!

Upload user to unenroll test notes.docx
User Upload Test 2.6.2024d.csv

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

If you want to suspend a user, the value of the column enrollstatus = 1.

1= suspended

0 = active

The enrolstatus only applies to manual enrollment.

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

Thanks Servando. Re your comment: The enrolstatus only applies to manual enrollment.

Does this mean that if the user was enrolled via audience sync, self enrolment, or program enrolment that we cannot use the upload file to unenroll them?

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

I'm not sure if it works or not. I think it will not work with audience sync, self-enrollment, or program enrollment because those types of enrollments have specific ways of adding users to the course.

If I need to unenroll a user who was enrolled by audience or program, I have to change the audience. The problem is when the audience it's syncronizade whit other courses. So I have to manually enrol in the other courses where I don't need to unrol or create a new audience whitoout the specific user and then syncronize that audience in the course... I do not know if anyone has a better way to resolve this enrollment conflict.

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

My primary issue is still that using this spreadsheet is not un-enrolling the team member. I've tried using '0' as enrol status, using ''1' as enrol status, I've tried with 5 different team members, some added manually and some with audience sync. This works to enrol a team member, but not to unenrol them. Any other ideas?

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

If you delete the manual or sync enrol method, just take care with the grades of existing users, you may need to restore them.

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

We want to do the same - unenrol by a file. The video above seems to be only making the user inactive on the course not unenrol them altogether which we are wanting. I wonder how / if this can be done? Does anyone know?

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

Suspending a user has the same effect as deleting the registration method. So I ask myself, what effect are you looking for?

One prblem/benefit on Totara is that when you enroll a user in a course, it creates a row in the grade and completion table, so it can't be deleted (on Totara).

Maybe you need to explain the result you are looking for.

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

Hi Servando

It is giving us inaccurate course completion reporting due to the number of users enrolled that are either inactive or suspended.

I tested one of our courses as an example. Course completion before inactive users were unenrolled was 52.9% and after unenrol was 55.6%.

Keeping the users enrolled in the course negatively affects the course completion data as it's not reporting on the amount of people actively still enrolled / employed.

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

Hi Raechel,

I had the same issue and Mandatory Course reporting integrity was a mess. I was advised to include the Is enrolled filter=Yes in reporting. I also include Number of job assignments filter is greater or equal to 1 (b/c suspended users will have zero, it's just a 2nd cautionary filter). I wish we could filter by roles, b/c we're still having inaccuracies due to 'support' staff being enrolled but not required, showing up in report but that is supposed to be addressed at a later time.

Report without filter Is Enrolled (58,834 records)

Report with filter Is Enrolled = Yes (42,470 records)

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

Yes, I know... but the basic filters for the report are:

Is enrolled
User status

You may want to save the search filters and set as default view.

Dauerlink | Ursprungsbeitrag anzeigen | Antwort

Hi there everyone - we received the same answer a while ago and went back and added the active filter to all of the reports, made it mandatory for everyone but admin, and changed the title of the filter to 'Active Status - Choose Active'. Quite an ugly work-a-round, but it's there.

Dauerlink | Ursprungsbeitrag anzeigen | Antwort