Add and delete (department) coaches by CSV import

Modified on Tue, 19 Dec, 2023 at 1:21 PM

Summary
Department coaches and coaches can be added to StudyCoach with a CSV import consisting of SIS IDs. Coach relationships can also be deleted. In this way, many department coaches and coaches can be added to StudyCoach at the same time. The department coaches are thus directly linked to the correct sub-account and the coaches related to the corresponding students or unrelated.

Value
Due to privacy reasons, it is important to add department coaches directly to the correct sub-account and link coaches to only the correct students. In addition, it is efficient to use the CSV import to be able to link large groups of students directly to the right coach or to be able to add many department coaches in bulk to the right sub-account instead of doing manual work one by one.

Roles

Student	Teacher	Coach	Department coach	Manager
				✓*

* Not available to managers on a sub-account level.

Table of contents

➤ Creating a CSV file

➤ Import a CSV file with (department) coaches

Creating a CSV file

A CSV file is a comma-separated file that makes it easy to import or delete larger amounts of information in StudyCoach.

Use the following CSV format to create or delete the relationship between coaches and students. A student can be associated with one or more coaches.

coach_sis_id,student_sis_id,status

COACH_SIS_1,SIS_STUDENT_1,active
COACH_SIS_1,SIS_STUDENT_2,active
COACH_SIS_2,SIS_STUDENT_1,active
COACH_SIS_2,SIS_STUDENT_3,active
COACH_SIS_2,SIS_STUDENT_4,deleted

⚠ When preparing the CSV file for coaches, note the following two things:

Make sure the CSV file contains a header.
Ensure that the IDs in the CSV file are the SIS IDs.

Use the following CSV format to create the relationship between department coaches and sub-accounts.

example_department_coach_import.csv

canvas_account_id,sis_user_id
1,SIS_COACH_1
1,SIS_COACH_2
2,SIS_COACH_3
2,SIS_COACH_4

⚠ When preparing the CSV file for department coaches, note the following two things:

Make sure the CSV file contains a header.
Use Canvas account IDs in combination with SIS IDs to import department coaches.

✨ Tip: Not looking for a CSV import but want to add a user and/or individual role (in bulk) in StudyCoach? Then check out the article 'User management'.

Import a CSV file with (department) coaches

A manager can import a CSV file into StudyCoach in the following manner:

Navigate to the settings.
Go to the tab Import.
Go to Coaches or to Department coaches, depending on the role you would like to import users for.
Go to Browse files and select the correct CSV file.
Consequently, you will see the progress of the import in 'Your last imports'.

⚠ Note: A successful import of CSV data cannot be undone.

✨ Tip: 'Download the current (department) coaches' in this menu generates a CSV file that can be used as a template to change the existing relationships.

Questions? Feedback? Need help?

Feel free to contact us.