Set Account Expiration Dates for Multiple Students at Once

Admin Area > Student Management > Students > Import Student Data

The following details how to use Excel to batch set account expiration dates for multiple students, improving operational efficiency and simplifying the batch management process. This is ideal for administrators who frequently need to update student information.

Step 1: Export Student Data

1. Log in to the system using your staff account, then enter the Admin Area backend page.
2. Click the [Students] tab at the top or side menu to access the student management interface.
3. In the student management interface, click the [Export] [All] Student Data button.
4. The system will automatically generate and download an Excel file containing all student information. Once downloaded, open the Excel file locally to proceed with editing.

Step 2: Set Account Expiration Dates

1. After opening the exported Excel file, first check that the content is complete. Once verified, proceed to the next step.
2. Locate the column titled [Expiration Date], usually on the right side of the table.
3. For student accounts that need batch expiration date updates, uniformly enter the account validity date in the [Expiration Date] column. The date format must be entered as "yyyy-mm-dd" (for example: 2025-12-31) to prevent import errors caused by inconsistent formats.

Step 3: Import the Updated Excel Data

1. After completing the setting of expiration dates for multiple student accounts, be sure to verify all information is correct. Then, save the file in Office Excel 2003 format (.xls).
2. Log in to the system again, return to the Admin Area backend, and click the [Students] tab to enter the student management page.
3. In the student management interface, click the [Import Student Data] button to start the import process.
4. The system will pop up the import data interface. Click [Choose File], then select the recently updated Excel file from your local folder.
5. In the import data interface, confirm and choose the method for handling duplicate accounts: you may select [Overwrite Original Data if Account Duplicates] or [Skip Duplicate Data]. Choose appropriately according to your actual needs.
6. After confirming all options, click the [Click Here to Upload XLS File] button. The system will then start uploading and updating the data.

Step 4: Confirm the Import Results

1. After completing the import process, it is recommended to immediately return to the student management page and randomly check several student records to ensure that the account expiration dates have been correctly updated.
2. If errors are found, please repeat the above steps and pay special attention to file format and correct date input.

Notes

• The imported Excel file must strictly conform to the Office Excel 2003 format (.xls).
• Before importing, confirm the handling method for duplicate accounts to avoid accidental overwrites or data loss.
• It is recommended to keep a backup of the original exported data file in case of errors during import.
• After completing the operation, be sure to review the data to ensure all updates are correct.
• For assistance, you may refer to or download the sample Excel file template provided by the system to ensure a smooth import process.

---

Batch Increase/Decrease Student Points

Admin Area > Student Management > Students > Adjust Points

Batch operations allow you to quickly and efficiently increase or decrease points for multiple students, saving administrator time and ensuring data accuracy. The following explains each step and relevant notes in detail.

Step 1: Select Students

1. After logging in to the system, enter the Admin Area and select the "Students" option from the left menu.

2. In the student list, check the students for whom you want to modify points.

   • You can quickly find the required students using search, filtering, or paging through the list.
   • To process all students at once, you may click the select-all checkbox at the top of the list.

3. After selection, click the "❤️ Adjust Points" button on the toolbar at the top of the page.

Step 2: Set Points Adjustment

1. The system will automatically pop up a confirmation window for modifying student points. Please carefully verify the list of students shown to ensure accuracy.

2. In the input box at the bottom of the window, enter the number of points to be increased or decreased.

   • The input range must be a positive integer; the system does not accept negative values.

3. According to your actual needs, click the "➕ Increase" or "➖ Decrease" button.

4. The "Description" field is optional but recommended for a clear and concise explanation, such as "Event Reward," "Monthly Deduction," etc.

   • If you provide a description, it will be clearly visible in the student's points record as the reason for the adjustment.

5. Click the confirm button at the bottom of the window to complete the batch modification of points.

Notes

• If the number of points deducted exceeds the student’s current points, the system will set the student’s points to zero; negative or abnormal values will not appear.
• If a student is suspended, point adjustments will not affect their points.
• The number of students that can be modified per batch depends on the page display setting. For example, if 30 records are shown per page, you may modify points for up to 30 students at a time.
• After adjusting points, it is recommended to immediately check the points records of relevant students to ensure correctness and avoid future disputes or problems.
• To maintain data security and accuracy, it is recommended to authorize only dedicated personnel to perform batch points modifications and keep records for reference.

---

Frequently Asked Questions

Q1: Can students be batch deleted?

A: For data security reasons, the system currently only provides single deletion. For mass removal, please back up data first.

Q2: Can points be recharged for students directly from the backend?

A: Yes. Enter the student's edit page, enter the recharge points, and save.

---

---

This manual strives for accuracy and completeness, but we do not assume any liability for errors, omissions, or updates. The content may be modified at any time without prior notice. We are not responsible for any damages arising from the use of this manual or downloading its contents, including but not limited to system failures, data loss, or infringement of rights. Users assume full responsibility and risk.