This is the header of the CSV file so that the app interprets the data correctly:
Name;Surname;Surname2;Code;Email;DOB;Phone;Contact1_Name;Contact1_Email;Contact1_Phone1;Contact1_Phone2;Contact2_Name;Contact2_Email;Contact2_Phone1;Contact2_Phone2;Notes
Only the fields «Name" Y "Surname«, the rest are optional. The order of the columns does not matter.
The format of the date of birth (DOB column) can be in one of the following formats:
- YYYY-MM-DD. Example: 1993-10-25
- YYYY/MM/DD.
- DD-MM-YYYY. Example: 12-04-2001
- DD / MM / YYYY
Steps to import students:
IMPORTANT: Steps 1 to 7 are done on a PC. From 8 to the end in the application.
- Download the empty template to fill in here: CSV Template
- You also have examples of CSV files:
- Open the downloaded template with LibreOffice:
- Add students:
- You see File -> Save as and save as CSV file. Activate the option «Edit filter settings«:
- Select save as CSV:
- Select the following options (you can also choose "Unicode UTF-16" or "Western Europe ISO-8859-1"):
- Copy or download the generated CSV file from PC to device. In the app, import students into the app: Menu -> Import. IMPORTANT: If the CSV file is in the cloud, you must first download it to the device.
- You must choose in the application the same character set and the field separator that you put in step 6
Use the button «preview» to view the CSV file before importing. If it doesn't look right change the «CSV separator" or the "Set of characters«. If it still doesn't look right, check the CSV headers as explained above.
Import Photos
To import photos, the following requirements must be met:
- Student photos should be named as the student code. For example, if a student has the code "A12345", the photo should be named A12345.jpg, A12345.png, etc.
- The photos are all copied to a single folder on the device.
- In the application, select the directory where the photos are: