Lunchbox Export

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

Lunchbox Export Features

The Lunchbox Export can be found on the Core.Scheduler page. The Lunchbox export performs the following tasks:

Create a CSV file of students for the Lunchbox application and places it at a specified path on the server.
Optionally send that file to an FTP Server

Student Selection

Students (active and inactive) from any School in Genesis. Students from schools with the following flags are not included:

These flags are found on the Setup.Schools.Modify screen.

The file that is created is a ~ (Tilde) delimited file. This specification was set by the vendor; not Genesis.

Column	Data
SiteImportKey	School.schoolCode
HomeRoom	Student.homeroom
LastName	Student.lastName
MiddleName	Student.middleName
FirstName	Student.firstName
GradeLevel	Student.gradeLevel
BirthDate	Student.dateOfBirth	mm/dd/yyyy
Status	Student.lunchCode	See notes
DistrictID	Student.studentID
ContactFirstName	LR/Home/First Name or Guardian1/FirstName
ContactLastName	LR/Home/Last Name or Guardian1/LastName
Relationship	LR/RelationshipCode or Guardian1/Relationship Description
Street	Address for LR or Guardian1/Address
City
State
Zip
ActiveParticipant	Student.enrollment 1 if ACTIVE; 0 if INACTIVE
Phone	LR/Home phonenumber or Guardian1/PrimaryPhone

3 (Paid) is the default value.

2 is used instead when student's lunch code has the Reduced flag set.

1 is used instead when student's lunch code has the Free flag set.

Lunch code flags are configurable on this screen: Student Data.Lunch.Setup.Codes.