Extended_Data_Relationships_*.csv - Relationship Files for Collaboration and Sharing

File Summary

Relationship Files provide you with the ability to connect your students to their advisors, coaches, RAs, RDs, etc. Relationship files allow us to map person-to-person connections within your site. These relationship files will enhance user experience and help with collaboration.

Filename Format: Extended_Data_Relationships_*.csv

Simply replace * with a description of the data being sent.

Output Example

Extended_Data_Relationships_Advising.csv:

"Heading"|"Category"|"Member ID"|"Role"|"Owner ID"|"Owner Role"
"Advising"|"Math - Computer Science"|"0001010"|"Advisee"|"0002234"|"Primary Advisor"
"Advising"|"Math - Computer Science"|"0001011"|"Advisee"|"0002234"|"Primary Advisor"
"Advising"|"Math - Computer Science"|"0001012"|"Advisee"|"0002234"|"Primary Advisor"
"Advising"|"Math - Computer Science"|"0001015"|"Advisee"|"0002234"|"Primary Advisor" 
"Advising"|"Math - Computer Science"|"0001010"|"Advisee"|"0002237"|"Secondary Advisor" 
"Advising"|"Math - Computer Science"|"0001011"|"Advisee"|"0002237"|"Secondary Advisor"
...

We expect that these files contain a single one-to-one relationship per row. A Student ID can be found more than once throughout the file.

There are a couple of things to note about the format of these files:

1. The header row should always be included. Because you send us a header row, the order of the columns does not matter. If it is more convenient to swap the order, please feel free to do so.
   
   
2. The Heading and Category are used to display groups of students to the owner (see "Groups" screenshot to the right for an example). In the example to the right, "Advising" is the Heading and "Math - Computer Science" is the Category.
   
   
3. Member ID is always the "Student ID" and Role is the student's role (e.g. Advisee, Athlete, etc.).
   
   
4. The Owner ID should be populated with the relationship owner's ID ("Employee ID" or "Student ID").
   
   
5. Owner Role is the title that will display to your users (e.g. Advisor, Primary Advisor, Secondary Advisor, RA or Resident Assistant, Baseball Head Coach, Mentor, etc.). See screenshot to the right for an example.
   
   
6. You may define relationships in one file or in multiple files. Notice in the spreadsheet example above, both Primary and Secondary Advisors are listed, but on separate rows for individual Student IDs. 

As always, if you have any questions regarding the format of these files, please contact [e-mail].

(This is an extended and customizable file.)