Add and delete (department) coaches by CSV import

Modified on Tue, 19 Dec 2023 at 01: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

StudentTeacherCoachDepartment coachManager




✓*
* 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:

  1. Navigate to the settings
  2. Go to the tab Import.
  3. Go to Coaches or to Department coachesdepending on the role you would like to import users for.
  4. Go to Browse files and select the correct CSV file.
  5. 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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article