πŸ“š Lisa's Book Catalogue

For use in Class - sortable on Topics and Song Types

Show Users:
Loading books…
Select a suitability level above.

Bulk Import from CSV

⬇ Download CSV template
πŸ“‚

Click to browse or drag and drop a CSV file here

Columns: title, author, illustrator, year_published, publisher, topics (semicolon-separated), notes, song_type, song_difficulty, bilingual, australiana, approved, year_levels, special_occasions, links (format: Title|URL;Title|URL)


Bulk Link Import

⬇ Download link template

Download the template to get a CSV pre-filled with every book. Add your links in the link_title and link_url columns β€” one link per row, duplicate the book row if a book needs multiple links. Upload when done; invalid rows are reported and skipped.


Upload Backup

Upload a backup_…zip file created by the ⬇ Backup button. All books, system lists, and cover images will be restored from the ZIP into the data/ directory. Existing files are overwritten; the books cache is rebuilt automatically.

πŸ—ƒοΈ

Click to browse or drag and drop a backup ZIP here

No file selected

πŸ“ Restore from a file already on the server

For very large backups that exceed browser upload limits, upload the ZIP directly to /tmp on the server via SFTP, then click Scan /tmp to find and restore it.

πŸ”‘

Admin authentication

Enter the ADMIN_PASSWORD from php/passwd.php to continue.

πŸ“š

Empty catalogue

The data directory is set up but contains no books. You can restore from a backup ZIP to reload a previous catalogue, or continue with an empty catalogue and add books manually.

β›”

Startup error

Fix the issue above, then reload the page.

πŸ“

First-time setup

The data directory has not been initialised yet. Would you like to start with a fresh empty catalogue, or restore from a backup ZIP?

A fresh install creates the data/ directory structure. You can import books afterwards via the Import view.
Working…
πŸ—ƒοΈ

Restore from backup

Choose a backup_….zip file created by the ⬇ Backup button. All books, system lists, and cover images will be restored.

Uploading…
βœ…

Setup complete!

Your book catalogue is ready. Click the button below to open the app.

πŸ“‹ Generate Lesson Plan