How to Bulk Import Staff into openSIS
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 administrators to import multiple staff records simultaneously. This guide will walk you through the steps to successfully bulk import staff data into openSIS.
To begin the process:
- Log in to your openSIS account with administrative privileges.
- Navigate to the "Tools" section from the main dashboard.
- Click on "Staff Bulk Data Import" to start the bulk import process.
Step 2: Download the Data Import Template
Before importing staff data:
- In the first step of the import process, you will be prompted to download the data import template. This template is a spreadsheet designed to ensure that the data you input is correctly formatted for openSIS.
- Click on the download link to obtain the template file.
- Open the template in your preferred spreadsheet software (such as Microsoft Excel, Google Sheets, etc.)
Step 3: Fill in the Data Import Template
With the template ready:
- Following the format and guidelines provided in the template, fill in the necessary staff information. The template will typically include columns for staff names, roles, contact information, and any other required fields.
- Ensure that all mandatory fields are completed accurately, as missing or incorrect data can lead to errors during the import process.
- Once all staff data has been entered, save the file in the format specified by openSIS.
Step 4: Upload the Data Sheet
Now that your data sheet is prepared:
- Return to the "Staff Bulk Data Import" tool in openSIS.
- In the second step, you’ll be prompted to upload your completed data sheet.
- Click on the upload button and select the file from your computer.
- After uploading, the system will begin processing the data.
Step 5: Confirm Field Mapping
Once the data sheet is uploaded:
- In the third step, the system will automatically recognize and map the fields from your data sheet to the corresponding fields in openSIS.
- Review the field mapping to ensure that each column from your data sheet is correctly matched to the appropriate field in the system.
- If the mapping is incorrect, you may have the option to manually adjust the field mappings.
- After confirming that everything is correct, proceed to the next step.
Step 6: Start the Import Process
With the field mapping confirmed:
- In the final step, click on the "Start Import" button to begin importing the staff data into openSIS.
- The system will process the import and add the staff records to your database.
Step 7: Handle Import Errors
If any errors occur during the import process:
- The system will generate a report detailing the issues that caused the data to be rejected.
- You can access this report by clicking on "View Report" in the Staff Bulk Data Import tool.
- The report will list the specific staff records that encountered errors, allowing you to identify and correct the problems.
- Additionally, you can download this list of staff records for further review and troubleshooting.
Related Articles
How to Bulk Import Students into openSIS
Bulk importing student data into openSIS is a straightforward process that allows school administrators to efficiently manage large numbers of students. This guide walks you through the steps to add or update student records in the openSIS system ...
How to Export Data from openSIS
openSIS allows a Superadministrator to download data in Excel format for portability. In the event you want to keep a backup of the data for yourself, or you have decided to move to a different platform, you can download the following data categories ...
How to use openSIS API
openSIS is built with APIs. The system allows Superadministrators to access this feature to retrieve data from the system via JSON payload. To access the API, navigate to Main Menu >> Tools >> API To start using the API, you have to generate an API ...
End of School Year Processing - Rollover
Rollover is the functionality to move the school data from current school year to the next school year. Once a school year is rolled over, students can be promoted to the next grade and failed students can be retained to the same grade level. Also ...