|
Basic Instructions
- Use the sample import documents below as a template to format your data files in the appropriate format.
sample student import file | sample teacher import file | sample group/class import file
- Open the appropriate sample spreadsheets.
- Paste in the data for the columns that you have.
- Re-save the document using your campus name. For example, MyHighSchool_Students.csv.
- Attach the spreadsheets to an email to import@MySatori.com with "MyCampus—MySchool District import" in the subject line.
IMPORTING INSTRUCTORS AND/OR STUDENTS
You can use one or two spreadsheets as long as all of the information is included. If you use two spreadsheets, please include the following information:
- Teachers: Required Fields: InstructorID, Password, First Name, MI, Last Name
- Students: Required Fields: UserID, Password, First Name, MI, Last Name, Grade, Birthday*
NOTE: If the ID is missing we will use FirstLast by default, i.e., JohnDoe.
IMPORTING GROUPS/CLASSES
If you would like to have the classes imported, the following spreadsheets are needed with the required information:
- Teachers: InstructorID, Password, First Name, MI, Last Name
- Classes: Class name, InstructorID, and optionally a list of titles used by that Class. (see Title_List.xls for title names)
- Students: UserID, Password, First, MI, Last Name, Grade,Birthday*, Groups (Classes)\
NOTE: The InstructorID in the Classes spreadsheet must match exactly with the InstructorID in the Teachers spreadsheet. Also class names in the Students spreadsheet must match exactly with those in the Class spreadsheet. Multiple classes can be put in the group column by delimiting with the pipe (|).
School|Class 1|Class 2
User Import Format
sample student import file | sample teacher import file
Your file should be an Excel file or tab-delimited file which includes the following data:
|
Column Name
|
|
Sample Input and/or details |
|
First Name
|
|
John |
|
Middle Initial
|
|
A (“-“ if none) |
|
Last Name
|
|
Doe |
|
Nick Name
|
|
(“-“ if none) |
|
User ID
|
|
5225522 |
|
Password
|
|
3rgH25 |
|
Birthday
|
|
05/01/1999
The birthday is important because in later versions of MySatori™, decisions will be made about the students study plan based in part on their age. |
|
A Security Question
|
|
Enter the word "none"
|
|
The Security Answer
|
|
Enter a dash ("-") |
|
Grade
|
|
4 |
|
Gender
|
|
M or F |
|
Active
|
|
The word “Active” |
|
A Comment
|
|
(“-“ if none) |
|
Groups
|
|
Groups/Classes to place the User in. This is a list of one or more groups separated by “|”. (This is typically called the “pipe” character and is above the return key.) The default group “school” must be included in this list. The names of the groups you include here must exactly match the names of existing groups names or the names of the groups in the group import file. If you do not have any groups created then only put the “school” group here. The “|” character is only between group names, not at the beginning or end.
Example:
school|Jones 3rd Period Math |
|
School Name
|
|
This should match the name of the school that appears in your subscription documentation. |
|
Roles
|
|
This is a list of one or more Roles separated by “|”. (This is typically called the “pipe” character and is ASCII code 124.) The default Role “Student” must be included in this list. Other possible values are Instructor or Guardian. |
|
False
|
|
The word “False”. |
The Group Import Format
sample group import file
Your file should be an Excel file or tab-delimited file which includes the following data:
|
Column Name
|
|
Sample Input and/or details |
|
Group Name
|
|
Jones Math 3rd Period |
|
Group type
|
|
class |
|
Group Leader
|
|
The User ID of the group leader (usually the teacher) |
|
Parent Group
|
|
Typically the parent
group would be "school" |
|
School
|
|
The School the Group Belongs to (This will always be your school name as it appears in MySatori. You can find this in the account information sheet.) |
|
False
|
|
The word “False” |
|
Syllabus
|
|
This is a list of one or more titles that your school owns and that will be used by the groups, separated by “|”. (This is typically called the “pipe” character and is ASCII code 124.)
Example: TAKS Grade 03 Math|TAKS Grade 03 Reading |
|
