| Info |
|---|
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
