Nutrikids Export

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

NutriKids Export

This task will export student data to a file format compatible with the NutriKids application.
The file is exported as a CSV file; and can be either stored on the server or sent to another server via the FTP or SFTP protocol.

The file that is created is a industry standard CSV text file.
The first row contains headers.
If a cell contains a comma; the cell will wrapped in quotes. If a cell contains a quote; the quote is escaped by using two quotes.

Column	Sample Data	Report Writer Object / Notes
School Year	2011-12	Current System School Year
Student ID	12345	Student.studentID
Last Name	Zinn	Student.lastName
First Name	Christopher	Student.firstName
Middle Initial	M	Student.middleInitial
Date Of Birth	6/3/1999	Student.dateOfBirth (m/d/yyyy)
StreetAddress	1313 Mockingbird Lane	Address/LR Mailling Line 1 or Guardian1 - Mailing Line 1
City
State
Zip
School Number	GHS	Student.currentSchoolCode
Grade	09	Student.gradeLevel
Homeroom	101	Student.homeroom
Guardian		Address/LR Mailing Name or Guardian 1 - Mailing Name
Lunch Code	FT	Student.lunchCode
Lunch Pin	1234	Student.lunchPin
Enrollment Status	ACTIVE	Student.enrollmentStatus
NK Lunch Code	P	P, F or R (See below)
Phone Number*	(555) 555-1212	LR/Home or Guardian1 Primary Phone Number. Only exported if option is chosen.

The flags on the Genesis lunch code are used to determine the NK Lunch Code.

The Genesis Lunch code flags are configured on the Student Data.Lunch.Setup.Codes screen.

The code is a F if the code has the Free flag checked.

The code is a R if the code has the Reduced flag checked.

The code is a P for all other cases.

The Store on Genesis server (Full path + filename) field can optionally be set to a filename.

The path and filename is for a location on the server.

If your server is a Linux server; an example output filename might something like /home/oracle/nutrikids.csv.

On a Windows server; an exmaple output filename might be something like c:\nutrikids\nutrikids.csv.

Using the configuration fields on the screen; you can specify an FTP or SFTP server to send the file to.