Bulk Import using V2 format helps District administrators to import a large number of schools, classes, staff, students, contacts, and their membership connections. Currently, this option is available at the District level only.
TABLE OF CONTENTS
- Bloomz CSV V2 format using 6 files
- V2 Format Bulk Import flow: Manual upload
- 3. Bloomz V2 format Bulk Import Using SFTP:
- Additional Scenarios for Data Import
Bloomz CSV V2 format using 6 files
Schools File
The schools.csv file provides the information necessary to generate the school structure as it relates to a district in Bloomz.
Fields:
-- id or sis_id: Unique to each school and referenced by all other files. 0 or a NULL value is commonly used for the district building ID.
-- name: School Name
Ex:
sis_id, name
Classes/Groups File
The classes.csv file provides the classroom and group information necessary to generate a classroom/group roster in Bloomz.
Fields:
-- school_id: Id of the school where the class/group is located. Must match an ID in the school.csv file.
-- id or sis_id: Unique for each class/group. Will be referenced in the memberships.csv file.
-- name: Name of the class/group.
-- grade: PK, KG, K, PS, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, Other
-- type: [optional] Group Type (class, room, group, sports team, club, etc.) The Default is 'class'.
Ex:
school_id, id, name, grade, type
Staff File
The staff.csv file provides the information necessary to generate staff accounts and relates them to the school(s) they belong to. List all staff members in this file, including faculty, teachers, office staff, admins, etc.
Fields:
-- school_id: Id of the school where the staff member is assigned. Must match an ID in the school.csv file.
-- id or sis_id: Unique to each staff member. Will be referenced in the memberships.csv file.
-- first_name: [optional]
-- last_name: [optional]
-- email: Format must be [email protected]
-- mobile_phone: [optional] 10 digits only. No dashes or spaces included.
-- preferred_language: Default language is English, unless another value is given. (See the list of supported languages for reference)
-- role: [optional] See the list of supported roles for reference. Default is 'teacher'
Ex:
school_id, sis_id, first_name, last_name, email, mobile_phone, preferred_language, role
Students File
The students.csv file provides the necessary information to generate student accounts and relates them to the school(s) they belong to.
Fields:
-- school_id: Id of the school where the student is assigned. Must match an ID in the school.csv file.
-- id or sis_id: Unique for each student. Will be referenced in the memberships.csv and contacts.csv files.
-- first_name: [required]
-- last_name: [required]
-- email: [optional] Format must be [email protected]
-- mobile_phone: [optional] 10 digits only. No dashes or spaces included.
-- preferred_language: Default language is English, unless another value is given. (See the list of supported languages for reference)
-- grade: [optional] PK, KG, K, PS, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, Other
-- gender: [optional] (Male/Female/Other)
-- dob: [optional] MM/DD/YYYY
Ex:
school_id, sis_id, first_name, last_name, email, mobile_phone, preferred_language, grade, gender, dob
Contacts File
The contacts.csv file provides the necessary information to generate specific contact (parent/guardian) accounts and relates them to students within the district.
Fields:
-- school_id: Id of the school where the student is located. Must match an ID from the school.csv
-- id or sis_id: Unique for each contact. For multiple students, the ID must match across all of them.
-- child_id: The ID of a related student found in the students.csv file.
-- first_name: [optional]
-- last_name: [optional]
-- email: Format must be [email protected]
-- mobile_phone: [optional] 10 digits only. No dashes or spaces included.
-- preferred_language: Default language is English, unless another value is given. (See the list of supported languages for reference)
Additional Contact Notes:
Email and mobile phone number are recommended.
Ex:
school_id, sis_id, child_id, first_name, last_name, email, mobile_phone, preferred_language
Memberships File
The memberships.csv file provides the necessary information to associate staff, students, and contacts to specific classes/groups that they belong to.
Fields:
-- school_id: Must match an ID in the schools.csv file.
-- class_id: Must match an ID in the classes.csv file. (Use this column for Class ONLY)
-- group_id: Must match an ID in the classes.csv file. (Use this column for ALL other group types- i.e sports team, club, etc...)
-- staff_id: Must match an ID in the staff.csv file.
-- student_id: Must match an ID in the students.csv file.
-- contact_id: Must match an ID in the contacts.csv file. (Only used if assigning "parent" account to a staff role- i.e. parent is "coach" of a sports team)
-- role: admin/office/teacher/staff/parent/student/member
Additional Membership Notes:
A school_id and class_id/group_id must be provided for each membership. Exception: 0 or a NULL value is commonly used for the district building id.
A staff_id or student_id must be provided for each individual membership.
Staff members who are school or district admins, and should have complete access to the school or district, should be assigned the admin role at the appropriate level. Example: For a district administrator, enter a '0' or NULL value for the school_id, plus their staff_id and their role (admin).
Staff members who are teachers should be assigned the teacher role at the school(s) they are assigned to.
Staff members who are NOT teachers should be made staff at the school they belong to. If they work at the district level, they should be assigned the staff role in the district.
Ex:
school_id, class_id, group_id, staff_id, student_id, contact_id, role
V2 Format Bulk Import flow: Manual upload
1. Go to District Settings
2. Open to “Edit Settings” option
3. Go to “Bulk Import” section
4. Expand the “Advanced Bulk import” section
5. You will find the “Import by manually uploading files” option. Click on it.
6. You can see the “Advanced Bulk Import” screen with a list of options.
7. There you can find the 6 CSV files: “School”, “Classes”, “Staff”, “Students”, “Contacts” and “Membership”.
8. You can download the appropriate CSV Template using the “Download Template” option.
9. Or you can use the existing District data by using the “Use Existing” option. It is used to get the data from the district.
10. Once the appropriate CSV file is completed, you will upload the CSV files using the “Upload Spreadsheet” option.
Schools CSV Upload:
Data or details of the schools are added to “Schools.csv” as shown below
id or sis_id - School sis ids – user provided
name - School names
Screen 1
Upload the CSV file into the “Schools” section
Screen 2
After successful upload click on “Done” to complete the File upload
Screen 3
Reopen the “Advanced Bulk Import” option to check the upload status.
Success or failure status is shown below
Screen 4
After the file is processed, Schools get added to the district (If they do not exist in the District, if not it will ignore that row).
Screen 5
b. Classes File upload:-
After downloading the classes.csv file. Add the details of the classes/groups/troops and other group details,
school_id - to which school we need to add the Group/class
id or sis_id- unique identify for each class/group being created
name - name of the Class/Group type
grade - grade of the class/group type
type - group type (see all available options below)
Bloomz supports different group types:
class
group
sports team
club
bus route
childcare room
department
troop - boy scouts
troop - girl scouts
summer camps
afterschool care
religious group
EXAMPLE: classes CSV as shown below.
Upload the above-formatted CSV using the “Upload Spreadsheet” option in the classes section of the “Advanced Bulk Import” screen.
Screen 19
Click on “Done” to complete the file upload.
4. Success or failure status is shown below
5. All the classes/groups that are there in the CSV file get added to the appropriate schools. Verify them by going to those particular schools
c. Staff CSV Upload:
Data or details of the staff members are added to “staff.csv” as shown below.
school_id – schools ids to which you are willing to add staff members (mandatory)
id or sis_id – unique to each staff member. Will be referenced in the memberships.csv file(mandatory)
first_name - the first name of the staff (optional)
last_name - last name of the staff (optional)
email - email address of the user (mandatory if phone is not provided)
mobile_phone – phone number of the user (Mandatory if email is not provided)
preferred_language - Default language is English, unless another value is given (optional)
role- default is "teacher" (optional)
District Level supported staff roles:
School Level supported staff roles:
Upload the above-formatted csv using the “Upload Spreadsheet” option in the staff section of the “Advanced Bulk Import” screen.
Click on “Done” to complete the file upload.
It will open “Invite Staff” screen where we can personal invitation message and send the invitation to staff members.
PLEASE NOTE: If the invitations are toggled off you will still proceed with pressing send on this screen, but invitations WILL NOT be sent out.
Success or failure status is shown below
We can see the staff members in the respective schools as shown below.
d. Student CSV Upload:-
Data or details of the students are added to “students.csv” as shown below.
school_id – schools ids to which you are willing to add staff members (mandatory)
id or sis_id – unique for each student. Will be referenced in the memberships.csv and contacts.csv files (mandatory)
first_name - the first name of the student (Mandatory)
last_name - last name of the student (Mandatory)
email - email address of the student (optional)
mobile_phone – phone number of the student (optional)
preferred_language - Default language is English, unless another value is given (optional)
grade - PK, KG, K, PS, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, Other (mandatory)
gender- male/female/other (optional)
dob - Date of Birth of the student MM/DD/YYYY (optional)
Upload the above-formatted csv using the “Upload Spreadsheet” option in the staff section of the “Advanced Bulk Import” screen.
Click on “Done” to complete the file upload.
It will open the “Invitation Message” screen where we can personal invitation message and send the invitation to students.
PLEASE NOTE: If the invitations are toggled off you will still proceed with pressing send on this screen, but invitations WILL NOT be sent out.
5. Success or failure status is shown below
6. We can see the students in the respective schools as shown below.
e. Parents/Contacts CSV
Data or details of the parents are added to “contacts.csv” as shown below.
school_id – schools ids to which you are willing to add parents (mandatory)
id or sis_id – unique for each contact. For multiple students, the ID must match across all fo them (mandatory)
child_id - child sis id, to which you are adding parent profile
first_name - the first name of the parent (optional)
last_name - last name of the parent (optional)
email - email address of the parent (mandatory if the phone is not provided)
mobile_phone – phone number of the parent (Mandatory if the email is not provided)
preferred_language - Default language is English, unless another value is given (optional)
Upload the above-formatted csv using the “Upload Spreadsheet” option in the contacts section of the “Advanced Bulk Import” screen.
Click on “Done” to complete the file upload.
It will open the “Invitation Message ” screen where we can personal invitation message and send the invitation to parents.
PLEASE NOTE: If the invitations are toggled off you will still proceed with pressing send on this screen, but invitations WILL NOT be sent out.
5. Success or failure status is shown below
6. We can see the student in the respective parents as per the csv file we uploaded. In School > Students section
7. We can see parent profiles and their child profiles as per the data in csv we uploaded, In the School > Parents tab.
f. Membership CSV upload:
This Upload is very important as it defines the members and group relation and their roles.
Download the Membership CSV template
Create the CSV file as shown below. Each row is specified for each member
school_id – schools ids.
class_id – class to which we need to add the user. (Use this column for class ONLY)
group_id – group Id of any group type (Use this column for ALL other group types- i.e. sports team, club, etc...)
Please note: You will not have BOTH class_ id and group_id filled for each line, it will be one or the other
student_id - id of the student (must match ID in students.csv file)
staff_id - id of the staff (must match ID in staff.csv file)
contact_id - Id of the parent (must match ID in contacts.csv file)
Please note: "Contacts"/parents will automatically follow the membership given to their child, you DO NOT need to list each contact ID in this file, unless you are assigning them to a staff role- i.e. parent is a "coach" of a sports team
role - any role from the list of roles... please refer to article- What roles are supported in the different class/group types?
Upload the above-formatted csv using the “Upload Spreadsheet” option in the Membership section of the “Advanced Bulk Import” screen.
Click on “Done” to complete the file upload.
5. Success or failure status is shown below
6. We can see all the members to respective groups and classes with in the specified schools as shown below.
3. Bloomz V2 format Bulk Import Using SFTP:
Advanced Bulk Import option is available for Districts only. You can upload these CSV files to your District SFTP location.
For SFTP connection details are available on the Settings page
Each district has an SFTP option
You must contact our Bloomz service team to enable it for your District/ School.
Once it is enabled from the Bloomz admin side, SFTP details will be open for schools and districts
If the “Advanced Bulk Import” option is not active for your district, please reach out to Bloomz support team.
Once, the “Advanced Bulk Import” option is active, you can access this feature.
For Advanced Bulk Import SFTP Import we have to follow the following steps
Getting SFTP Connection Details
Setting up SFTP Connection
Uploading Files to SFTP Location
Running the Import/ Scheduling the Import
a. Getting SFTP Connection Details:-
Open the Bloomz application.
Go to the District/ School where you want to set up SFTP Connection
Screen 1
Go to Settings
Screen 2
Open to “Edit Settings” option
Screen 3
Go to “Bulk Import” section
Screen 4
You can find SFTP Import/ Advanced Bulk Import options. If they are not active please contact bloomz service team.
Screen 5
After it gets active, expand the “Advanced Bulk Import” option
You can find the required information for Advanced Bulk import SFTP Setup
Screen 7
b. Setting up SFTP Connection:-
FileZilla connection
1. You need the Filezila application on your machine
2. Install it -https://filezilla-project.org/
3. Open the app
Screen 1
4. Open New Connection
Screen 2
5. Create “New Site”
Screen 3
6. You can rename the Site name.
Screen 4
7. Select the “Protocol” option to “SFTP”
Screen 5
8. Get the HostName from SFTP details provided in District > Settings > Bulk Import Section
Screen 6
Paste the “SFTP Location using key” to the “User” field in FileZilla.
Screen 7
Get the “SFTP Username” from the SFTP Import details screen.
Screen 8
Paste the Copied Host value to “User” filed
Screen 9
Get the Password/ Password using the key by downloading the Private key.
Screen 10
Select “Login type” to “Key file” in FileZilla
Screen 11
Browse the downloaded key file using the “Browse..” value
Screen 12
Screen 13
Click on the “Connect” button to establish the SFTP Connection
Screen 14
Click on “OK” to complete the setup.
Screen 15
After the successful completion of the SFTP Connection setup. You can see a list of folders in the District’s/School’s SFTP location as shown below.
1. BulkImport V1
2. BulkImport V2
3. AutoNotification
Screen 16
c. Uploading V2 Files to SFTP Location
After the successful establishment of the District’s/ School’s SFTP connection,
You have to open the “Bulkimport-v2” folder.
Screen 1
Upload the files to “BulkImport-v2” folder
Screen 2
Browse the file from your computer.
Upload files to “BulkImport-v2” SFTP location
Screen 3
d. Running the Import/ Scheduling the Import
Open the Bloomz application, District/School settings page > “Bulk Import” section
Open “Advanced Bulk Import” and click on “Import” or “Schedule the Import”
Screen 1
There is another option to schedule our import process by clicking on the “Scheduled import from SFTP” toggle button.
Screen 2
You can select “Invite from” to choose a school administrator or his equivalent role to send invitations on your behalf. and the “Notify to” option sends the import status to the list of roles in the school.
Screen 3
Click on the “Import Now” button
Screen 4
On Clicking “Import Now” a dialogue will be displayed. Turn On/OFF those options as per your requirement.
Screen 5
On click on “Save” import action start
Screen 6
The “Import Now” button will be disabled state until import is complete
You can check the Import status by clicking the “Last Import Status” option.
Screen 7
After setting up the SFTP Import, you can dismiss from this screen by clicking on “Save”
Screen 9
Screen 10
Additional Scenarios for Data Import
3. I have imported students using Clever or other sources but need to import parents using CSV and these parents should be attached to all classes. How do I do that using CSV?
4. I have imported students manually in the past but I want to bulk add SIS IDs. How can I achieve this?
5. If I just want to import only parents with no students, how do I prepare my file?
6. Can I create classes or groups using the import? How do I do that?
7. How do I update Staff data with phone numbers if my staff was already imported using Clever?