Ingest accelerated reader data
- Tim Peterson
The products-renlearn template is a subset of the products template. It can only be used to update product records, not create product records.
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 that can save data as CSV (comma-separated values).
Open Excel data file from RenLearn.
Create a new Google Doc spreadsheet using the products-renlearn template file (See menu item: File > Make a Copy…). The required columns are: alquiznr, alsinterestlevel, alsreadlevel, alspoints, isbn.
Copy/paste data from Excel to the new Google Doc file.
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: products-renlearn-YYYYMMDD.csv (where YYYYMMDD represents today's date)
Ingest the local file through the web admin UI of the titleleaf site:
a. Admin > Ingestion > New
b. Type = Products
c. Attachment = products-renlearn-YYYYMMDD.csv