Problem:
Manually adding pupils is time consuming and prone to errors.

Affects:
Exploring Science 7, 8 and 9 Pupil Interactive

Cause:
The program lacks a bulk-upload feature

Solution:
You should prepare in advance a list of user first/last names, passwords (optional) and year group/class (optional - for sorting only).

PC users can then download this ZIP file:
CDMS_Upload.zip (43KB)

Once you have extracted the components, open the Excel Workbook and follow the instructions on the 'Instructions' sheet.

The process of upload is:

1. You add user details into Excel columns.
2. The worksheet creates code around the user name.
3. You copy the new code into an index XML file.
4. You copy additional code into a batch (BAT) file to create pupil directories.
5. You run the BAT file - which creates the required folder structures.
6. You copy additional code into a second BAT file which populates the pupil folders with the required data.
7. You run the second BAT file to complete the upload.
8. You must post-process the pupil xml files to strip out instances of "<pupil> (to replace with <pupil>) and </pupil>" (to replace with </pupil>. Tools for this may include Smultron (Mac) or EditPlus (PC). We recommend the use of a tool such as 'Replace in Files' (http://www.emurasoft.com/replall/index.htm)
   
   Alternatively, you may send us a password-protected Excel document for us to process for you - please contact us at schools.cd-romhelpdesk@pearson.com for details and CRB references if required.
   
9. Copy the files and folder structure to your shared location.

Note. This process does NOT check for pre-existing users, or merge with existing data. You should back-up any previous user data before proceeding.

Check for duplication by manually merging the pupil folders before adjusting and manually merging the old and new pupil index XML file.