Skip to content

Account Data

File: accounts_data.csv · Where: Admin Tasks → End-of-Year Reports → year → Account Data

Every account that existed in myblueboard when the year was closed — directors, students and parents — with the profile details attached to each one.

This is the report to reach for when someone who has left the program needs to be contacted, or when you need last year's roster with contact details intact.

What's in it

One row per account. Because the file is written before graduates and non-returning students are removed, it includes people who are no longer in myblueboard.

Column What it holds
id The account's myblueboard ID. Other end-of-year reports point back to accounts using this number
type Director, Student or Parent
email The email address used to sign in
firstname, lastname, shortname Name, and the preferred/short name if one was set
address, address_city, address_state, address_zipcode Home address
grade Grade level — students only
phone1, phone2 Phone numbers
section The student's section or ensemble
student_groups Groups the student belonged to
student_id Your school's own student ID, if you record one
allergies, food_allergies, otc_medicines Health information recorded on the student's profile
gender As recorded on the profile
bus_number Bus assignment
student_connection_number The 4-digit code a parent uses to connect to the student
title, prefix Director title, and name prefix
parent_groups Groups the parent belonged to
child_relation How a parent is related to their student

Platform administrator accounts belonging to myblueboard are not included, and neither is any account with no profile attached to it.

It matches the import template

The columns are the same, in the same order, as the file Importing accounts expects. So a downloaded Account Data file can be edited and imported back in — useful when a student who left returns, or when setting up a related program.

Check the current import template before relying on this: if the import format has changed since the year was closed, an older export may need columns adjusted.

This file contains health and contact information

Home addresses, phone numbers, allergies and medication notes for every family are in this one file. Download it only when you need it, keep it off shared drives, and delete your copy afterwards.