Registering Bulk Pupil-Lists
From Gemin-Wiki
| Table of contents |
Registering Bulk Pupil Lists
What is it?
When a new school signs up to play in Project Gemini, they fill in an example spread-sheet and pass it to the facilitaotors. The spreadsheet contains people's Firstname, Lastname, Username, LastInitial etc. and we have to register a new user for each of 'em.
Stage One: Adding the School Group
You'll need to create a group to represet the school that the people in the list are joning up through. This SQL query does that, type it into the SQL Client attached to the server:
insert into obj_objects values (null,200,now(),"SCHOOLNAME","<page />","");
Obviously SCHOOLNAME should be the name of the school. You can check it's worked by listing all the groups in the database:
select * from obj_objects where type=200;
This will show you which NUMBER is associated with the GROUP too. Usefu
Stage Two: Check the xls
You'll need to check that the XL spreadsheet is in the right format. There should be no headers, no special formatting, just a simple grid with the columns containing *In This Order*, the FirstName, LastnameInitial, Username, Password and Group into. The GROUPINFO is of course the number you gained at the end of step one, the rest should be obvious. Save the spreadsheet as a .csv (Comma-Seperated-Values). You don't want any quotes to enclose each field or anything like that. An example line:
Alexander,R,leckkalexanderr,aPASfa,5850
How you sort out that sheet is up to you, but DO CHECK IT.
Stage Three: Uploading
In the apache-root directory there's a file called bulkUsersUpload.php - put the URL to that into your browser, select the file you just saved and click submit.
It's a VERY good idea to backup the database before you do this, and to turn off the Jelly Server for a while too.
State Four: Returning info
You'll want to send back a list of the passwords you made to the facilitators. Basically just email the file you just uploaded to 'em.
![[Main Page]](/wiki/stylesheets/images/wiki.png)