MealTime Export

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

MealTime Export

Overview

This export creates a file for MealTime. The file is created as a tab-delmited text file 'mealtime.txt'. Each row contains information on a single student.

Options

The file can be saved to a path on the local machine, sent to an email address, or sent out via FTP (active, passive, or secure FTP).
Headers can be included or excluded.
The file layout can be one of the following:
- Variation 1
- Variation 2
- Variation 3
- mPower

Output

Variation 1
Column	Notes
Household Id
Household Name
Address
City
State
Zip
School Name
School Number
Student Id
Alternate Id
Last Name
First Name
Student DOB
Student Grade
Current School Name
Email
Variation 2
Column		Notes
HouseholdId
HouseholdName
Address
City
State
Zip
SchoolName
StudentId
LastName
FirstName
StudentDOB
StudentGrade
Homeroom
CurrentSchoolName
PrimaryContactFirstName
PrimaryContactLastName
PrimaryContactPhoneNumber
PrimaryContactEmail
AlternateId

Variation 3
Column	Notes
Household Name
Guardian 1 First Name
Guardian 2 First Name
Guardian 2 Last Name
Address
Apt Number
City
State
Zip Code
Day Phone
Evening Phone
School Name
School Number
Student Id
Student Last Name
Student First Name
Legal First Name
Legal Last Name
Student SSN
Student DOB
Student Grade
Student Homeroom
Student Status
mPower
Column		Notes
Customer ID		StudentID
Customer Last Name
Customer First Name
Customer Middle Name
Customer Birthdate
School Name
Customer PIN		StudentID
Customer Alt ID		StateID
Customer Grade
Customer Active Status
Customer Homeroom Name
Suffix
Household Number		FamilyCode
Primary Contact First Name
Primary Contact Last Name
Primary Contact Phone
Primary Contact Email
Primary Contact Address Line 1
Primary Contact Address Line 2
Primary Contact City
Primary Contact State
Primary Contact Zip code