Ingest accelerated reader data

When you've received quiz data from Renaissance Learning, you should update the website database. This page explains that process using a Google Doc template. Google Doc is not mandatory; you can follow the same procedure using any modern spreadsheet application (e.g. Excel) that can save data as CSV (comma-separated values).

  1. Open Excel data file from RenLearn.

  2. Create a new Google Doc spreadsheet using the renlearn template file (See menu item: File > Make a Copy…). The required columns are: alquiznr, alsinterestlevel, alsreadlevel, alspoints, isbn.

    Google Doc: renlearn template

    Google Doc: File menu, Make a copy

  3. Copy/paste data from Excel to the new Google Doc file.

  4. Once complete, download the new Google Doc file as CSV to your local computer (See menu item: File > Download as > Comma Separated Values). Name the local file without spaces. For example: renlearn-YYYYMMDD.csv (where YYYYMMDD represents today's date)

    Google Doc: File menu, Download as CSV

  5. Ingest the local file through the web admin UI of the titleleaf site:

    a. Admin > Ingestion > New

    Ingestion menu, new item

    b. Type = Products

    c. Attachment = renlearn-YYYYMMDD.csv

    New ingestion, renlearn data