EMS

Català Castellano English

Importing students from Esfera (SAGA)

This guide explains how to bulk-import or refresh student and family-contact data from an Esfera (SAGA) export file.


Contents

  1. Esfera vs. GEDAC — two different imports
  2. Running the import
  3. What gets created or updated
  4. Reading the result and the log
  5. Things to check afterwards

Esfera vs. GEDAC — two different imports

Don’t confuse this with Enrolling the preinscription students, which is a different import from a different system:

For a smaller, ad-hoc update from any other CSV file (not the official Esfera format, and unable to create new students), see Updating student data from a CSV file instead.

Running the import

From the Students list, open the actions menu (the gear icon ⚙️ next to the list) and choose Import from Esfera. Select the .xlsx file exported from Esfera/SAGA and click Import students. While the import runs, a message stays on screen until it finishes; a large file can take a few minutes.

Import from Esfera window, with the file upload and the overwrite option

If the students in the file already have a Google account created outside EMS, untick Create Google accounts before importing. EMS then doesn’t create any account for them: they are marked with Assign corporate email manually on their form. Fill in each one’s existing address in Corporate email, on the form itself or for all of them at once with Updating student data from a CSV file (column Student email). See Managing a student’s Google account.

What gets created or updated

Reading the result and the log

After the import, the wizard shows how many students were created/updated, and lists any rows that raised an error (one bad row never blocks the rest of the file — it’s just reported and skipped). A downloadable CSV log lists every student and family contact touched by that specific run, with what was linked to what — useful for spot-checking a large import.

Things to check afterwards


← Back to Secretariat index