Skip to Content

Import students and cards from a file

How to load a list of students from a table and separately assign card numbers to students who are already in the list.

When you need this

You have a table with the list of students and entering them one by one takes too long. The Import page has two sections: Roster import creates students, and Cards only assigns card numbers to those who already exist.

An import by class names needs exactly one active academic year that covers today's date (Academic years). Otherwise the page says No current academic year.

Import students

  1. Prepare a CSV, TSV, TXT or XLSX file. The first row holds the column headers in English, in any order: lastName, firstName, class, category are required, middleName, card, status, photoRef are optional. The File columns table on the page shows all accepted headers.
  2. In the class column write the number and one letter (5-А or 5А). A class that does not exist in the current academic year is created. A category that does not exist is created too.
  3. Choose the file in the Import file block and check the Class enrollment date: one date for the whole file, the start of the current academic year by default.
  4. Press Preview file. The preview writes nothing.
  5. Look at the Classes to create and Categories to create blocks: a typo in a name creates an extra class or category. In the Rows of the file table each row has the result Will be created, Will be updated, Unchanged or Error.
  6. When there are no errors, press Commit import. The summary shows how many students were created, updated and how many cards were added.

A student who is already in the class is not duplicated: only an empty middle name and a card are added, and the category is replaced. Importing the same file again is safe. Any error in a row or in the file blocks the whole import: nothing is written until the preview has no errors.

Import cards

  1. In the Cards section prepare a CSV (UTF-8), TSV or XLSX with the columns Card number, Last name, First name and Class. The column Patronymic is optional. In XLSX store card numbers as text.
  2. Choose the file and press Preview file.
  3. If needed, tick Deactivate the earlier cards and QR codes of the pupils that receive a new card: then every student who gets a new card has their other active cards and QR codes made inactive. It is unticked every time the section opens.
  4. Look at the rows: To add, Already assigned or Error. Rows with errors are skipped, the reason is in the Reason and warnings column.
  5. Press Import cards. Rows with problems can be downloaded with Download rows with problems.

What you will see

After the student import - Import complete and the button View students. After the card import - Card import complete with the Card import report.

If something goes wrong

  • Choose a CSV, TSV, TXT, or XLSX roster file before preview. or Choose a file with card numbers.: choose a file first.
  • The Validation errors block: fix the rows in the file and preview it again. If the enrollment date is not within the academic year of a class, the rows are named: choose another date. If there is no current academic year, it says Class names need exactly one active academic year that contains today's date..
  • Card file errors: The file could not be read. CSV, TSV and XLSX are supported., The file is empty., The file has no required column (with the column name), A column is in the file more than once, The file has no card rows. and There is no current academic year, so the classes of the file cannot be found..
  • Reasons a card row is skipped: A required cell is empty, The card number is not valid. (with a detail: The card number is empty., The card number is too long. or The card number has characters that are not allowed.), The card number cannot be read exactly from a numeric cell. Store the cell as text., The class was not found in the current academic year., Several classes of the current academic year match the class name, The class is inactive., The class has no active pupil with this last name and first name., Several pupils of the class match the row. Add the patronymic., The card number is already used by another pupil or a meal group., The file gives this card number to several pupils., The card number was taken while the import was running. and The card could not be stored..
  • Warnings in a row do not block the import: The pupil already has this card, but it is inactive; the import does not change it. (activate the card in the QR codes dialog), The pupil already has another patronymic; it is kept., The patronymic of the row is not valid; it is not stored., The patronymic could not be stored. and An earlier row of the file gives the same card to this pupil..
  • Too many requests. Wait a minute and try again.: wait a minute.
  • Network offline or Check the connection and try again.: restore the connection and try again.

On this page