Technical Support KnowledgeBase
Supporting KnowledgeBox, Longman, Pearson Education and Edexcel CD-ROMs

Glossary    Contact Us
 
   
Knowledge Base
Knowledge Base CD-ROMS Longman Digitexts Bulk upload of users from Excel

Bulk upload of users from Excel

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

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).

    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.


How helpful was this article to you?
Related Articles
article Bulk upload of users from Excel
Problem:Manually adding pupils is time...

(No rating)  19-Oct-2006    Views: 811   
article How do I log in to the administration pages of my KnowledgeBox?
There are two ways of getting into the...

  21-Aug-2004    Views: 3053   
article Printing problems with restricted users
Problem: Although the 'Administrator' can...

(No rating)  23-Mar-2005    Views: 1292   


.: Powered by Lore 1.3.0
[ Admin Login ]


(C) 2008 Pearson Education Ltd.