Destiny Follett Export

Modified on Thu, Dec 14, 2023 at 10:40 AM

Destiny Follett Export

Export information for Destiny Follett Library System

The file created by this task is a CSV (Comma Separated Values) file in which the first row contains the headers. The file contains rows for students and teachers.

The file can either be stored on the Local Server Hard Disk or it can be sent to an FTP or an SFTP Server.

Configuring

The Destiny Follett Export task is configured on the Core.Scheduler screen in Genesis.

The File Format (CSV with Headers)

Column	Configurable?	Description
Barcode	Yes	Student id or Lunch Pin
SiteShortName	Yes	School Code or Alternate School Code
DistrictID	Yes	Student id or Lunch Pin
LastName
FirstName
MiddleName
Nickname
Gender
PatronType		Student or Teacher
AccessLevel		Patron or Teacher
Status		For Students: A for Active / I for Inactive (Enrollment Status). For Teachers: Always A
CardExpires		Always blank (Data not available in Genesis)
GradeLevel
Homeroom
GraduationYear
BirthDate		mm/dd/yy format
UserName	Yes	Data is optionally taken from a user text field.
Password	Yes	Data is optionallytaken from a user text field.
EmailPrimary		Old Contacts: LR/Home Email New Contacts: Guardian 1's Email
EmailSecondary		Old Contacts: OP/Home Email New Contacts: Guardian 2's Email
AddressPrimaryLine1		Old Contacts: LR Address Record New Contacts: Guardian 1
AddressPrimaryLine2
AddressPrimaryCity
AddressPrimaryState
AddressPrimaryZipCode
AddressPrimaryPhoneNumberPrimary		Old Contacts: LR/Home Phone Number New Contacts: Guardian 1's Phone Number
AddressPrimaryPhoneNumberSecondary		Always blank
AddressSecondaryLine1		Old Contacts: OP Address Record New Contacts: Guardian 1
AddressSecondaryLine2
AddressSecondaryCity
AddressSecondaryState
AddressSecondaryZipCode
AddressSecondaryPhoneNumberPrimary		Always blank
AddressSecondaryPhoneNumberSecondary		Always blank

Export Options

Schools to include
(Comma separated list of school codes or blank for all active in-district schools):
Source of USERNAME:
Code of User Text Field for USERNAME (trumps above option):
Source of TEACHER USERNAME:
Pull BARCODE from students:
Pull DISTRICTID from students:
Pull SITESHORTNAME from:
Pull HOMEROOM from:
Pull UserDefined1 from:
Pull UserDefined2 from:
Pull UserDefined3 from:
Use following User Text value for EmailSecondary column:
English Course Codes (For English Teacher Option): (Example: ENG001,ENG002,ENG003)
Include Teachers in file (if teacher in multiple schools will pull teachers Primary School Location):

Use m/d/yyyy instead of mm/dd/yyyy for Date of Birth fields.
Use State ID (rather than local) for Staff.
Use Other ID (rather than local) for Staff.
Use State ID (rather than local) for Students.
Exclude inactive students.
Exclude inactive staff.
Include Student Email Column.
Only have teaching staff in the file
Include student and teacher image export (includes additional "images.zip" file)
Use student nickname for first name when available