How do I manually import teacher data from our school MIS into Pogo Progress?

1. Export Staff Data from Your MIS

• Log into your MIS (SIMS, Arbor, Bromcom, iSAMS, etc.).

  Run an export for staff list.

  Choose fields such as:

  • Full Name
  • Email Address (essential for login)
  • Role / Job Title
  • Subjects / Year Groups (if your MIS stores this)
  • Staff ID (optional but good for consistency).
• Save the export as CSV or Excel.

👉 Tip: Keep only active teaching staff — remove support/admin roles unless you want them in POGO.

2. Clean & Format the File

• Open the CSV/Excel in Excel or Google Sheets.

  Delete any unnecessary columns (phone numbers, payroll codes, etc.).

  Rename headers to match POGO’s template if required (often “First Name”, “Last Name”, “Email”, “Role”).

  Make sure:

  • Each teacher has a valid school email address.
  • No duplicates (one row per teacher).
  • Roles are clear (Teacher, Year Lead, Admin, etc.).

3. Import into POGO Progress

1. Log into POGO Progress as Admin.

   Go to Admin → Staff / Teachers → Import Staff.

   Download the POGO Import Template CSV (if available).

   • This shows the exact column names and order required.

1. Copy/paste your cleaned MIS export into the template.
2. Upload the completed CSV.
3. Preview results: POGO usually shows which accounts will be created, updated, or rejected.

4. Verify & Finalise

• After upload, check the staff list in POGO:
  • All teachers appear.
  • Emails are correct.
  • Roles and permissions are correct.
• Fix any errors by re-uploading the CSV or editing individuals manually.

5. Share Access

• POGO will send welcome/login emails automatically if set up.

  If emails don’t send (firewall issue), you may need to:

  • Reset passwords manually in POGO, OR
  • Share login instructions separately.

Best Practices

• Keep a master CSV of all staff that matches POGO’s format → reuse it each year.
• Check spelling of names — these appear on reports.
• Update regularly: if new staff join mid-year, either import them manually or add directly in POGO.
• Test with a small batch first (e.g. 2–3 teachers) before bulk import.