Import data, follow these steps:
1. Go to Settings > Import.
2. Select module to import
3. Download the import template or upload your own file.
4. Enter your data into the Excel file, either manually or by copying and pasting.
Please follow these guidelines:
The file must be in .csv or .xlsx format.
5. Upload the completed template to proceed with the import.
Note on holiday data :
| Field | Note | Format |
|---|---|---|
| *** Name (Required) | The name of the Holiday | Text |
| Date | No lessons will be created on the holiday date once the holiday is set. | YYYY-MM-DD |
* Importing holidays for past dates is not allowed.
1. Choose an Action
Add new records only: Only imports brand new items. Existing items are ignored.
Update existing records only: Only updates items already in the system. New items are ignored.
Add new and update existing records: Updates existing items and adds new ones.
2. Match Records By
Example: Date: The system looks at the Date to check if an item already exists in your database. (Tip: Make sure the date is exactly the same to avoid duplicates).
Map columns
1. Fill in any unmapped columns.
2. Once completed, click Next to proceed.
Review & Import
1. Click Import to complete the process. If there are any rows with errors, you can still choose to proceed and import the correct rows.
2. Afterward, you can download the error log file, correct the data, and upload those remaining rows again.