A sample Participants CSV file is available for download. Use this CSV file as a template, making sure to delete any sample data which is not wanted in the final group lists.
The same CSV file format applies to all imports of participants, teams / teamsets, and groups. The column headings used on the CSV file are critical, and must be identical to those shown below. Notice that case matters: "group_code" is not the same as "Group_Code", "Group_code", "group code" or "group-code". Use the headings shown, with exactly the same characters and case, and taking care not to add any other characters (such as spaces or punctuation) to them:
The order of the columns is not important. Columns containing non-compulsory and unwanted data may be ommitted from the import CSV file.
Some data is critical (id, first, last) and the import will not succeed without that data. Some data ('team') is dependant on other data ('group_code'), so if participants are to be organised into teams then they must be assigned to a group.
The following outline the "rules" associated with the organisation of participants into groups, and into teams within groups:
Where a participant is a member of multiple groups, or of multiple teams in different groups, this is represented in the Participants CSV file as multiple rows for this participant, with duplicate "id", "first" and "last" entries, one row for each group_code & team. Xorro will automatically neglect any duplicate entries, but add or edit any new group or team memberships.
Example: Consider the following list of ten participants as correctly loaded in a Participants CSV file::
In this example There are three groups (eg courses) indicated. Only one of these three groups (123.101) involves teams. Every participant who is in 123.101, is assigned to a team, and in each case must have an email address in the record.
Participant records assigned to the groups which will not run team activities do not need team or email information, but adding this will have no adverse effects. Note that Gretna Green is a member of 123.101 in team "Panda", and in another line she is also recorded for group 123.204 (no team specified, and no email is required in the second record). John Smith is also in 123.101 as well as another group without a team, but in this case his email has been added to the record for the other group (123.202).
Note that one of the teams in 123.101 (team "Bear") has only two participants in it and hence would be skipped in a Peer Assessment unless more participants are added later.