Understanding Tools & Utilities

Overview

The Tools & Utilities section in openSIS provides administrative tools for managing system-level tasks. These tools help authorized users import data, export records, perform end-of-year rollover, and review system activity.

This section is mainly used by administrators who manage school data, academic year changes, and system monitoring.

Navigation Path

Menu > Tools

What You Can Do from Tools & Utilities

From the Tools section, users can access options such as:

Tool	Purpose
Student Data Import/Update	Add or update student records in bulk.
Staff Data Import	Add staff records in bulk.
Historical Grades Import	Import previously earned grades into openSIS.
Data Export	Export selected data from openSIS to Excel.
Rollover	Move school data from one academic year to the next.
System Access Log	Review user access information.
Activity Log	Track user activity performed inside the system.

Steps to Access Tools & Utilities

1. Log in to openSIS with an authorized user account.
2. Go to the left menu.
3. Click Tools.
4. Select the tool or utility you want to use.
5. Follow the page-specific instructions for that tool.

Important Notes

• Tools & Utilities options may vary based on user role and permissions.
• Bulk actions should be performed carefully because they can affect many records at once.
• Before importing or rolling over data, review the file format and required fields.
• Rollover should be performed only after the current academic year setup and records are reviewed.

• Related Articles

• Bulk Import or Update Student Data

  Overview The Bulk Import or Update Student Data tool allows administrators to add multiple student records or update existing student information using an import file. This is useful when a school needs to create student records in bulk or maintain ...

• Export Data from openSIS to Excel

  Overview The Export Data from openSIS to Excel tool allows authorized users to download important openSIS data in Excel format. This is useful when administrators need to review records offline, maintain a backup, share selected information with ...

• Bulk Import Staff Data

  Managing staff data for an educational institution can be a time-consuming task, especially when dealing with large numbers of personnel. Fortunately, openSIS offers a "Staff Bulk Data Import" feature that simplifies this process, allowing ...

• View System Access Log

  Overview The System Access Log allows authorized users to review login activity in openSIS. It shows who accessed the system, when the login happened, whether the login was successful or failed, the failure count, and the IP address used for access. ...

• How to Import Historical Grades Data in openSIS

  The Historical Grades Import feature in openSIS allows users to import historical grade data for students. This is particularly useful when you need to import grades from previous years or academic periods. The process involves mapping fields, ...