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

CSV guidelines for Academy

  • Updated

The instructions below show you how to complete a CSV template to add new CPD learners to Hachette Learning Academy or edit existing ones.. See Adding and Editing CPD learners in bulk for help finding and uploading the correct templates.

You must not use an email address for CPD learners. Always use a username and password instead. For more information, click here. 

 

Adding new CPD learners

Optional columns can be left blank, but you must not delete the column headers or edit them in any way.

  • Column A - Action: Type 'A' (for ‘add’).
  • Column B - User ID (optional): Leave this column blank. 
  • Column C - Type: Type 'S' (for ‘student’).
  • Column D - Username: Enter a username.
  • Column E - Email (optional): Leave this column blank. 
  • Column F - Password: Enter a password for the user. 
  • Column G - First name: Enter the user's first name. 
  • Column H - Middle name (optional): Enter the user's middle name. 
  • Column I - Last name: Enter the user's last name. 
  • Column J - Interface (optional): Leave this column blank. 
  • Column K - Class: Enter the user's class. You must create the class first, and the formatting of the name must be identical.
  • Column L - Access to application: Type ‘Y’ (for 'yes') to give immediate access to Academy. Type 'N' (for 'no') to create the user record but prevent them from logging in or appearing in the platform. 

When your CPD learners log in, they must enter the username and password you've created for them and your centre ID number. This can be found under your institution's name at the top of the Admin Hub. 

Below is an example of a completed CSV template to add new users: 

 

Editing existing CPD learners

Optional columns can be left blank, but you must not delete the column headers or edit them in any way.

  • Column A - Action: Type 'E' (for ‘edit’). 
  • Column B - User ID: This column will be populated when you export the template. Do not edit it. 
  • Column C - Type: Type 'S' (for ‘student’).
  • Column D - Username: Update the learner's username. 
  • Column E - Email (optional): Leave this column blank.
  • Column F - Password: Update the password. 
  • Column G - First name: Edit the user's first name. 
  • Column H - Middle name (optional): Add or edit the user's middle name. 
  • Column I - Last name: Your students' first and last names, respectively. Edit as desired. 
  • Column J - Interface (optional): Leave this column blank. 
  • Column K - Class: Update the user's class. You must create the class first, and the formatting of the name must be identical.
  • Column L - Access to application: Type ‘Y’ (for 'yes') to give immediate access to Academy. Type 'N' (for 'no') to create the user record but prevent them from logging in or appearing in the platform. 

Below is an example of a CSV template that has been exported from the Admin Hub and used to add users' middle names to the system where they were missing: