Skip to main content
For live service updates and maintenance alerts, subscribe to the Hachette Learning Status Hub.

CSV Guidelines for Magazines

Ethan
  • Updated

Introduction

This article will show you how to complete a CSV template to add new learners to Hodder Education Magazines or edit existing ones. 

For instructions on how to download a blank template to add new learners and upload the completed version, see Adding Learners in Hodder Education Magazines.

For instructions on how to download a template with existing users and upload the edited version, see Editing Learners in Hodder Education Magazines.

Note that you do not have to add and edit learners on separate CSV files. If you export a template with existing learners, you can follow the instructions below to add new learners on the same file. 

 

Adding New Learners

Columns A (Action), C (User Type), D (Username/email), F (First Name), H (Last Name) and I (Access to application) are mandatory:

  • Column A: Type 'A' (for ‘add’).
  • Column C: Type 'S' (for ‘student’).
  • Column D: Enter an email address or create a username for each learner. Email users will receive a verification email asking them to create a password before they can log in. For those with usernames, you'll need to enter a password in Column E. Learners with usernames will need to log in with the username, password, and your institution's centre ID. This can be found under your institution's name at the top of the Admin Hub. 
  • Columns F and H: Enter the students' first and last names, respectively. 
  • Column I: Type ‘Y’ (for 'yes') to grant a student access to Boost when the CSV is uploaded, or type 'N' (for 'no') to put them in Students > Without Access.

Columns B (User ID), E (Password), and G (Middle Name) are optional: 

  • Column B: This column should be blank for new learners. 
  • Column E: If you have added a username instead of an email address in Column D, you will need to enter a password. The password should be at least six characters long with no spaces. 
  • Column G: Enter the learner's middle name if desired. 

The example below shows a completed CSV template. All four learners will be added to the Admin Hub as new users.

The first two will be registered with email addresses; they'll receive verification emails to finish their account set up once the upload is complete.

The second two will be registered with usernames and passwords. They'll need to log in with their username, password, and your institution's centre ID. This can be found under your institution's name at the top of the Admin Hub. 

 

 

Editing Existing Learners

Columns A (Action), B (User ID), C (User Type), D (User Name/Email), F (First Name), H (Last Name), and I (Access to application) are mandatory:

  • Column A: Type 'E' (for ‘edit’) in each row you update. 
  • Column B: This column will be populated with user ID numbers when you export the CSV of your existing students. Do not edit these numbers--it is how the system identifies your users when you reupload the CSV file. 
  • Column C: This column will be populated with an 'S' (for 'student') when you export the CSV of your existing students.  
  • Column D: Your students' current usernames or email addresses. These can be edited as desired. However, usernames must be at least six characters long and cannot contain any spaces; you will also need to enter a password at least six characters long and without spaces for these students in 
  • Columns F and H: Your students' first and last names, respectively. Edit as desired. 
  • Column I: Your students' current access status in Boost. Change to ‘Y’ (for 'yes') to grant a student access to Boost when the CSV is uploaded, or change to 'N' (for 'no') to move them to Students > Without Access.

Columns E (Password) and G (Middle Name) are optional: 

  • Column E: If you have added a username instead of an email address in Column D, you will need to enter a password. The password should be at least six characters long with no spaces. Ensure this column is completely blank (apart from the header) for learners with email addresses.  
  • Column G: Your learners' middle names. Edit as desired.

The example below shows an exported CSV file of existing students in its original and edited form. (Edited fields are highlighted for clarity.)

 

 

 

The first three learners will all be edited:

  • The first learner's middle name will be added.
  • The second learner's email address will be updated. However, the new email address will not come into effect or be visible in the Admin Hub until the learner accesses the verification link sent to the new address. 
  • The third learner's password will be changed.

The password column has been cleared for the first two learners as they are registered with email addresses. The final learner will not be edited as there is no 'E' in the 'Action' column. 

Related articles