When uploading data files for new rosters, perform the uploads in the exact order of the numbered filenames below (1_users.csv, 2_students.csv, 3_teacher_students.csv). You can then rename the .csv files with the current date appended (1_users_08162016.csv) to allow for unique data files in your district's database.
To create a data file:
Create a new file in Microsoft Excel.
Type the required header row as shown in these examples, being sure to include the following fields in the exact order:
Column |
1_users.csv |
2_students.csv |
3_teacher_students.csv |
A |
Employee_ID |
StudentID |
EmployeeID |
B |
Username |
Date_of_Birth |
StudentID |
C |
Password |
Last |
|
D |
First |
||
E |
Last_Name |
Grade |
|
F |
First_Name |
Building_Name |
|
G |
Building_Names |
Gender |
|
H |
User-Type |
SPED |
|
I |
|
Ethnicity |
|
J |
Race |
||
K |
Ell |
||
L |
District_Data_1 |
||
M |
District_Data_2 |
||
N |
District_Data_3 |
||
O |
District_Data_4 |
||
P |
District_Data_5 |
||
Q |
Password (optional) |
Type data into the empty cells below the field names, following the accepted data formats exactly. See Acceptable Data Formats for a list of accepted formats.
When you have finished adding data to the template, click File, and then click Save As.
Select a location to save the file.
In the File name box, type a name for the file using the following conventions: 1_users.csv, 2_students.csv, 3_teacher_students.csv.
In the Save as Type drop-down box, select CSV (Comma delimited).
Click Save. A warning message appears asking if you want to keep the workbook in .csv format.
Click Yes to save the file as a comma delimited (CSV) file.
Click No to return to the file without saving.
Tip: You can save the completed data file and reuse it to add or update user data.