Transeo Export

Modified on Thu, Jun 29, 2023 at 10:03 AM

Transeo Export

Courses.csv

Option to exclude certain course codes

Column	Description	Required
Name	Name of Course	Y
Description	Course Description	N
Sourced ID	Unique Identifier	Y
Course ID	Course ID, same as Sourced ID	Y
NCAA	If course counts towards NCAA eligibility	Y
Credits	Number of course credits	Y
Schools	List of school codes course belongs to	Y
Level	regular, advanced, honors, remedial, specialEd, ap, ib	Y
Grades	List of grades	Y
Subjects	Subjects this course belongs to	N

TestsUpload.csv

Select assessment to include
Select score column from assessment to pull the grade from

Column	Description	Required
User	Email of user	Y
Test	Name of academic test	Y
Result	Result of test	Y
Date	Date or iteration test was taken	Y

StudentUpload.csv

Set password via usertext or other options
Include only staff/students with emails
Select what staff roles you wish to include. All non teachers/students will be set as 'administrator'
Add 't' to end of teacher id for id column
Include elementary homerooms

Note: this file does include teachers

Column	Description	Required
First Name		Y
Last Name		Y
Email	Must be unique	Y
Default User password	This will be changed by the user on their first login. NOTE: If you use LDAP or Google as your authentication method you should leave this blank, otherwise this field MUST be included	N
ID	Users identifier	N
Grade
Role	This column should be one of the following values (please copy exactly): "student", "administrator", or "teacher". If left blank this will default to "student"	N
Counselor Email		N
School		Y
Gender	0 for Male, 1 for Female	N
Cluster		N
ELL	Describes if student belongs to ELL population	N
IEP	Describes if a student belongs to the IEP special population	N
LI	Describes if a student belongs to the Low Income special population	N
Homeless	Describes if a student belongs to the homeless special population	N
Attendance	Number representing current attendance rate. Formatted as decimal #.## with a rate of 1 being 100% attendance	N
GPA	Students GPA. Value is grabbed from students weighted cumulative GPA record. Formatted as #.##	N
Status	(currently not sent)

Classes.csv

Column	Description	Required
Sourced ID	Unique ID for class	Y
Name	Name of this class	Y
Course ID	Course's sourced id value	Y
Time Description	Description of timing for this course	N

Enrollments.csv

Column	Description	Required
User	Email of user, if the user is a non student then they will be marked as a teacher	Y
Class	Sourced id of class user belongs to	Y
Grade	Value of grade student receive for class	N
Completed	Whether or not course is completed	N
Status	(currently not sent)	N