Chapter 20: System Maintenance, Backups & Support

This chapter covers institutional data security, performing automated and manual database backups, troubleshooting common operational issues, and raising support tickets with the Uttercode engineering team.

1. Database Backups & Data Protection

Uttercode School ERP stores student records, examination archives, and financial ledgers in an optimized relational MySQL database.

Recommended Backup Schedule:

Daily Automated Backups: Scheduled at midnight to capture daily fee collections, attendance, and exam marks.
Weekly Offsite Archive: Stored in a secure external storage location or cloud bucket.
Pre-Upgrade Snapshot: Always export a complete database backup before executing institutional roll-overs or major software updates.

Executing a Manual Database Backup:

Navigate to System Maintenance → Database Backup or access the database utility.
Click Generate Full Database Backup (.sql.gz).
The system locks tables temporarily and exports a compressed archive containing all tables, indexes, and constraints.
Download the backup file to an encrypted external storage drive.

2. In-App Support & Ticketing

When assistance, bug reporting, or custom module extensions are required:

Click on Support or visit support@uttercode.com.
Fill in the support ticket form:

Issue Category: _Academic Setup_, _Fee POS & Receipts_, _Report Cards_, _Transport_, _User Privileges_, _Custom Feature Request_.
Priority: _Critical (System Blocker)_, _High_, _Normal_, _General Inquiry_.
Detailed Description & Steps to Reproduce.
Screenshot / Error Log Attachment.

Click Submit Ticket.
The Uttercode support team assigns an engineer and provides continuous status updates via email.

3. Best Operational Practices

Role Separation: Avoid sharing the Super Admin credentials; assign individual accounts with appropriate roles (Teacher, Accountant, Librarian) to maintain an audit trail.
End-of-Day POS Reconciliation: Accountants should verify the Daily Collection Report against physical cash and UPI terminal settlement slips before closing the register.
Session Rollover Checklist: Complete final term marks entry, issue all pending certificates, and settle student fee dues before initiating the academic year batch promotion.