Reports
Backup & Restore
Keep your data safe
The whole school in one JSON file. The same file can be restored on another installation.
Total rows10,122
Filled tables4266 tables total
Backup file
This file holds all of this school's data, including password hashes. Keep it somewhere safe.
Nightly copies
Saved automatically every night at 12: the last seven nights, and the first night of each month.
The first copy is saved tonight at 12.
Restore
Rows are matched by ID, so restoring the same file twice never duplicates anything.
What is inside
Row counts — an empty table means that feature has no data yet.
| Table | Internal name | Rows |
|---|---|---|
| School profile | schools | 1 |
| Logins | users | 260 |
| Staff | staff | 7 |
| Teacher permissions | teacher_permissions | 1 |
| role_permissions | role_permissions | 0 |
| user_permissions | user_permissions | 4 |
| password_reset_tokens | password_reset_tokens | 0 |
| Extra form fields | custom_form_fields | 2 |
| Classes | classes | 6 |
| Books / subjects | books | 30 |
| Students | students | 130 |
| Attendance | attendance | 5,568 |
| Holidays | school_holidays | 3 |
| Grading | grading_systems | 7 |
| Datesheets | exam_datesheets | 30 |
| Question papers | papers | 2 |
| Exams | exams | 2 |
| Assessments (tests & exams) | assessments | 60 |
| Assessment marks | assessment_marks | 1,300 |
| Notices | notices | 3 |
| Fee structures | fee_structures | 3 |
| Fee discounts | fee_discounts | 0 |
| Fee vouchers | fee_vouchers | 260 |
| Fee concessions | fee_concessions | 3 |
| Student-specific fees | student_fees | 0 |
| Fee payments | fee_payments | 227 |
| Receipt numbers | receipt_counters | 2 |
| Student wallet | student_wallet_entries | 0 |
| Bank accounts | bank_accounts | 1 |
| Online transactions | payment_transactions | 0 |
| Bank statement lines | bank_statement_lines | 0 |
| Salary runs | salary_runs | 2 |
| Salary slips | salary_slips | 14 |
| expense_categories | expense_categories | 5 |
| expenses | expenses | 6 |
| Lesson Diary | class_book_entries | 72 |
| Message log | message_log | 12 |
| Message templates | message_templates | 0 |
| File records | media_files | 0 |
| Promotions | promotions | 60 |
| danger_actions | danger_actions | 0 |
| danger_grants | danger_grants | 0 |
| Settings | school_settings | 1 |
| Result cards | result_cards | 130 |
| Books issued | student_books | 0 |
| Stock items | inventory_items | 5 |
| Stock sales | inventory_sales | 6 |
| Timetable | timetable_slots | 216 |
| Class access (mode) | user_class_scope | 0 |
| Class access | user_class_access | 0 |
| Class access (features) | user_class_features | 0 |
| Teacher defaults | teacher_feature_defaults | 0 |
| Discord links | discord_hooks | 0 |
| Alert kinds | notification_categories | 0 |
| Alert settings | notification_prefs | 0 |
| Personal alert settings | user_notification_pins | 0 |
| Activity history | audit_log | 6 |
| Staff attendance | staff_attendance | 301 |
| Leave requests | leave_requests | 2 |
| Salary advances | salary_advances | 1 |
| Recycle Bin | recycle_bin | 0 |
| inout_settings | inout_settings | 1 |
| inout_class_times | inout_class_times | 0 |
| inout_marks | inout_marks | 1,370 |
| id_cards | id_cards | 0 |
| card_access | card_access | 0 |