I have the same problem with some 250 user and 6 different cohorts. I will try and find a workaround nd post it here if i succeed.
Steinar
Did you ever get this sorted ?...
I worked this out this afternoon. With the following code modifications you can automatically register users to cohorts.
Edit admin/uploaduserlib.php at line 200:
} else if (preg_match('/^(course|group|type|role|enrolperiod)\d+$/', $lcfield)) {
to
} else if (preg_match('/^(course|group|type|role|enrolperiod|cohort)\d+$/', $lcfield)) {
Edit admin/uploaduser.php
After line 32 add:
require_once($CFG->dirroot.'/cohort/lib.php');
Edit admin/uploaduser.php at approximately line 700 add code below
// find cohort enrolments
foreach ($filecolumns as $column) {
if(!preg_match('/^cohort\d+$/', $column)) {
continue;
}
$i = substr($column, 6);
if(empty($user->{'cohort'.$i})) {
continue;
}
if (!empty($user->{'cohort'.$i})) {
$cShortname = $user->{'cohort'.$i};
// check if assigned to a cohort
if($DB->record_exists('cohort', array('idnumber'=>$cShortname))) {
// Get cohertId
$cohortData = $DB->get_record('cohort',array('idnumber'=>$cShortname));
cohort_add_member($cohortData->id, $user->id);
}
}
}
A sample CSV file would be:
firstname, lastname, username, cohort1, cohort2, cohort3
Joe, Bloggs, jbloggs, x, y, z
cohort1 etc must be the cohort id
This should definetely be integrated into the moodle code! Would a tracker need to be opened for this to happen, or what procedure should be followed?
I thought it was already integrated in 2.2? See http://tracker.moodle.org/browse/MDL-26965
But, I haven't found out how it works yet.
I get 'cohort1' is not a valid field name.
Thanks for your links. I skipped at least 1 step and that was creating the enrolment methods in the courses. But still I get the message: "cohort1" is not a valid field name when I try to upload the csv. I add the csv as an attachment and 2 screenshots of creating the cohorts and the enrollment methods. Maybe you can see where I go wrong.
What I've also done is:
What I hoped to create is a bulk upload file which would allow me to upload users, put them in the right cohort and enrol this cohort in a whole category of courses. But, maybe this is not possible?
Yes, I found where the error is. in your file . csv line 3
| username | password | firstname | lastname | cohort1 |
| 444168 | Chantal | Bor | van den | chades@hotmail.com | 2011-1A |
444168 Chantal Bor van den chades@hotmail.com 2011-1A
the collun cohort1= chades@hotmail.com and this cohort dont exist
see collun email= van den
enable debbuging and you will see the error messages
sucess
Mmm, yes it looks distorted in your post, but if I open it in Texteditor it looks like this:
username;password;firstname;lastname;email;cohort1 441193;;Brenda;van Hoogenvest;brendavh_1995@hotmail.com;2011-1A 444168;;Chantal;Bor, van den;chades@hotmail.com;2011-1A 448565;;Dijon;Rothuis;dylanvanbuuren6@hotmail.com;2011-1B 444539;;Dylan;van Buuren;evertjan_bogerd@hotmail.com;2011-1B
would that be right?
is it not a problem to leave out the password column?
| username | password | firstname | lastname | cohort1 | ||
| 441193 | Brenda | van Hoogenvest | brendavh_1995@hotmail.com | 2011-1A | ||
| 444168 | Chantal | Bor | van den | chades@hotmail.com | 2011-1A | |
| 448565 | Dijon | Rothuis | dylanvanbuuren6@hotmail.com | 2011-1B | ||
| 444539 | Dylan | van Buuren | evertjan_bogerd@hotmail.com | 2011-1B | ||
see.. line 3 is incorrect. collumn have a address mail
problem to leave out the password column? NO.. no problem..
Thank you. I'll improve the csv.
But, it might also help to upgrade tot 2.2! I found out I'm still on 2.1.2 (gggrrrr)
Dear Isabelle,
as I don't know wether your problem is solved I post my thoughts:
Line 3 has the following error: in the field "firstname" you put a comma to divide the real firstname " Bor" from "van den".
According to http://docs.moodle.org/22/en/Upload_users the comma is the problem:
"Commas within a field must be encoded as , - the script will decode these back to commas."
Using the comma in the way you did it will force the system do read your file as Gisele presented.
Hope this helps
Hartmut
Hi
Like Isabelle I am having problems uploading cohorts. I have done created my cohort etc however when uploading the csv file I get a
404 - File or directory not found. warning which I know I normally get if something is incorrect on the file.
Now if I don't include the cohort1columme it uploads OK, so really am at a loss as to what I am doing which is causing the problem.
I hope some-one can help.
Cheers Barbara
Can you confirm the cohort has been created beforehand on Moodle?
Hi Mary
Yes I created my cohort (cohort ID 2012-TLS) in advance.
Cheers
Barbara
