School Fusion

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

School Fusion

Core Scheduler

School Fusion integration can be found on the Core.Scheduler tab.

Options

Option	Sample	Description
SFTP Server Host Name or IP	sftp.myvendor.com
Port: (Blank = 22)	9001
SFTP Username	user
SFTP Password	password
SFTP Directory	incoming	This is normally left blank.
Store on Local Server Directory (Path)	c:/schoolFusion	The path where these files can be created. Useful for testing or if not using the Secure FTP protocol to transfer them to the vendor.
Only export courses that are currently meeting
Include Teachers in StudentFaculty file
Comma Separated list of course codes and/or course sections to exclude	100,200,300 100.1,200.2,300.5	May include school code with course code formatted schoolcode@coursecode. The second set of numbers exclude course 100 section 1 etc...
Comma Separated list of Schools with no scheduled courses to include in extracts	EHS,SES
Use lunchpin as password instead of SFPASS User Text field
Export Parent Module users		If this is checked; enabled Parent Users will be exported to a file called parents.txt (see below)
School ID #:		The parents.txt file contains a school id # column. The text you place in this field will appear in that column.

Files Created

The School Fusion task creates 3 TAB Delimited Files. The first line of each file contains the headers.

Schools Included in the output file

Data is collected from schools with the following criteria (as set on the Setup.Schools.Modify School screen).

School code is not OOD
Include students in state reporting set to YES
School Year is the current system school year

studentFaculty.txt
This file contains students and optionally teachers.

Column	Teachers	Students
School ID #	School Code	Student.currentCchoolCode
User ID #	DistrictTeacher.teacherID	Student.studentID
Last Name	DistrictTeacher.lastName	Student.lastName
First Name	DistrictTeacher.firstName	Student.firstName
Username	First letter of firstname + lastname	StudentUserText where code = SFUSER
Password	'new'	StudentUserText where code = SFPASS
Email Address	DistrictTeacher.emailAddress	StudentUserText where code = EMAIL
Status	'Faculty'	'Student'
Website Administrator	Always Blank	Always blank
DOB	Always Blank	mm/dd/yyyy

groupImport.txt

Data for this file comes from the following report writer tables: CurriculumCourse, CourseSection, CourseSubsection, DistrictTeacher and Department.

Normally, only schools that have schedules are included; and the file is generated by iterating through the Courses in the school.

However; If a list of schools that do not have schedules (ELEMENTARY SCHOOLS) are also include; then all Teachers in that school are included (The teachers are iterated); see "No Sched Desciption" column.

Column	Description	No Sched. Description
School ID #	CourseSubsection.schoolCode	SchoolTeacher.schoolCode
Group Type	'Classroom'	Same as Description
Teacher/User ID #	DistrictTeacher.voiceMail (Franklin Lakes only: DistrictTeacher.teacherID)	Same as Description
Teacher First Name	DistrictTeacher.firstName	Same as Description
Teacher Last Name	DistrictTeacher.lastName	Same as Description
External Section ID	CourseSubsection.courseCode . .courseSection (For example: MATH101.1)	schoolTeacher.schoolCode . currentHomeroom (For example: FPES.101)
Class Name	CurriculumCourse.courseDescription	'Homeroom'
Period Name	CourseSubsection.printPeriod	Always Blank
Instructor Name	DistrictTeacher.name (Usually comes out last, first)	Same as Description
Department	Department.name (Department is looked up from CurriculumCourse.departmentCode	Always Blank

membershipImport.txt

This file is generated from the Student and StudentScheduleCourse table. Normally only students with schedules are added to this file. If a list of schools is specified where there is no schedules; then all students from that school will be exported to this file as well (See No Sched. Description)

Column	Description	No Sched. Description
School ID #	StudentScheduleCourse.schoolCode	School Code
User ID #	StudentScheduleCourse.studentID	Student.studentID
External Section ID	Course Code . Section (For example: MATH101.1)	Student.homeroom

parents.txt

This file is generated from the ParentStudent and ParentUser table. All enabled Parent Users are included.

The password field could either be the password,MD5 or Salted SHA-512 Hash of the password depending on how the

password security is setup in Genesis.

Column	Description
Last Name	ParentUser.lastName
First Name	ParentUser.firstName
Username	ParentUser.logonid
Password	ParentUser.password
Email Address	ParentUser.logonid
Student #1 User ID	ParentStudent[1].studentid
Student #2 User ID	ParentStudent[2].studentid
Student #3 User ID	ParentStudent[3].studentid
Student #4 User ID	ParentStudent[4].studentid
Student #5 User ID	ParentStudent[5].studentid
School ID #	Text from the School ID # field on the task setup screen.