Follett Export
Follett is the library and textbook management system. Follett needs to files, students and schedules. Schedules contain teacher information as well. The Follett uses a feature in SQL 2008 that allows to SQL to run programs and create the exports needed. It also uses an export from PowerSchool to fill in the password information.
Students
Export all students that are not marked as graduated and in High School.
{groups:Super User,Administrators,Technicans}Source Server:glenbardlibrary.org
Destination Server: glenbardlibrary.org
Protocol: SQL Server Integration Services (SSIS)
Process: Run by the SQL Server Agent (PowerSchool Export.dtsx)
Package Password:e0s1911
{/groups}
File:StudentCombined.csv
Schedule: Daily 12:00 AM
Fields exported:
- Student_number
- Schoolid
- Last_name
- First_name
- Middle_name
- Gender
- Grade_level
- Counselor
- Dob
- Student_web_id
- Student_web_password
- fc_email
- mailing_street
- mailing_city
- mailing_state
- mailing_zip
- home_phone
- emerg_phone_1
- Second_mail_address
- second_mail_city
- second_mail_state
- second_mail_zip
- second_mail_phone
- Sched_yearofgraduation
- 3/4 teacher last name
- 3/4 classroom
- 5/6 teacher last name
- 5/6 classroom
- Statue (active=A, inactive/graduated/transfer=I)
Staff
Export all staff members that have not been marked fake.
{groups:Super User,Administrators,Technicans}Source Server:glenbardlibrary.org
Destination Server: glenbardlibrary.org
Protocol: SQL Server Integration Services (SSIS)
Process: Run by the SQL Server Agent (PowerSchool Export.dtsx)
Package Password:e0s1911
{/groups}
File:staff.csv
Schedule: Daily 12:00 AM
Fields exported:
- Teachernumber
- first_name
- last_name
- middle_name
- gender
- email_addr
- street
- city
- state
- zip
- home_phone
- LoginID
- schoolid
- status (active=A, inactive=I)
- dob
Schedules
Export student schedules for book check out. This export does not attach books to class or courses. Attaching books to courses is done in the Follett System outside of this export. The schedules exported are for the hard coded termid.
{groups:Super User,Administrators,Technicans}Source Server:glenbardlibrary.org
Destination Server: glenbardlibrary.org
Protocol: SQL Server Integration Services (SSIS)
Process: Run by the SQL Server Agent (Course Export.dtsx)
Package Password:e0s1911
{/groups}
File:StudentCourses.csv
Schedule: Sunday 11:30 PM
Fields exported:
- Schoolid on the cc record
- course_name
- section_number
- teachernumber
- the first period of the cc expression
- student_number
- creditType
- (blank)
- firstday
- lastday
