User Tools

Site Tools


student:fitnessgram_export

FitnessGram Export

The extract file name is FG_Extract_SchoolYear_CampusID+.csv (e.g., FG_Extract_2019_001.csv).

If the district is submitting a district-wide FitnessGram file, copy each campus extract into one file, and remove the campus ID from the name (e.g., FG_Extract_2019.csv). Save the exported document as a .csv file.

ColumnTypeMax LengthValid ValuesDescription
ASchoolID *Alphanumeric50 CountyDistrictID-CountyDistrictID + Campus ID (e.g., 1010912-10109122001)
BStudentID *Alphanumeric50 Must be unique in the district. Ensure student IDs remain consistent year to tear to avoid duplication.
CStudentFirstName *Alphanumeric35
DStudentLastName *Alphanumeric35
EStudentMiddleInitialAlphanumeric35
FStudentNickNameAlphanumeric35 Student’s Nickname from Registration.
GStudentBirthdate *Date10MM/DD/YYYYInclude forward slash marks.
HStudentGrade *Alphanumeric10K-13Single, alphanumeric characters for grade levels K-9, or two digits for grade levels 10-12. Any PK or early development grades must be reported as K only. Adult or post-high school levels must be reported as 13.
IStudentGender *Alphanumeric1m, f, M, F
JStudentEthnicityCodeNumeric100 Must correspond to an EthnicityID in FitnessGram (three-digit federal code).
KStudentUserName *Alphanumeric60 Must be unique in district. StudentID is often used.
LStudent Password*Alphanumeric100 If not available, use student’s FirstInitial + MiddleInitial + LastInitial + Birthday (e.g., ABC010203).
MStudentReportEmailAlphanumeric128 The student’s E-mail from Registration. If email address is not included, those student and parent reports cannot be sent.
NStudent SSO IDAlphanumeric35 Only used for districts using single sign on.
OStudentPrintBodyCompAlphanumeric1y, n, Y, N
PParentReportEmail1Alphanumeric128 The E-mail of the student’s priority 1 contact from Registration. If email address is not included, those student and parent reports cannot be sent.
QParentReportEmail2Alphanumeric128
RStudentPrintReportInSpanishAlphanumeric1y, n, Y, NIf student’s priority 1 contact has Spanish selected for Language in Registration, this column is Y.
SStudentPermanentExemptionCodeAlphanumeric1 Must correspond to an ExemptionID in FitnessGram.
TStudentIsActiveAlphanumeric1Y, NDefault is Y. You can change it within the application or file.
UClassName *Alphanumeric100 Add physical education classes. Must be unique by teacher and easily identified by teachers (e.g., CourseTitle + SectionNumber + SemesterIdentifier + YY (last two digits of the school year)
VClassID *Alphanumeric100 Must be unique in district (e.g., DistrictID + CampusID + ServiceID + CourseNumber + SectionNumber + BeginPeriod + CourseSemester + YY (last two digits of the school year).
WClassDescriptionAlphanumeric255
XClassStartDate *Date10MM/DD/YYYYStart date for the course. Include forward slash marks.
YClassEndDate *Date10MM/DD/YYYYThe last day of the semester. Include forward slash marks.
ZTeacherID *Alphanumeric50 Unique number assigned to instructor by TEA (TX Unique Staff ID).
AATeacherFirstName *Alphanumeric35
ABTeacherLastName *Alphanumeric35
ACTeacherMiddleInitialAlphanumeric35
ADTeacherNickNameAlphanumeric35
AETeacherUserName*Alphanumeric60 Must be unique in district. Teacher’s email address is recommended. For security purposes this is the official school email address.
AFTeacherPassword *Alphanumeric100 If password is not available, recommend combining instructor’s birthdate and initials (2-DigitBirthMonth + 4-DigitBirthYear + FirstInitial + LastInitial (e.g., 041987AB))
AGTeacherEmail *Alphanumeric128 Instructor’s work email address.
AHTeacherIsActiveAlphanumeric1Y, NDefault is Y. You can change it within the application or file.
AITeacher SSO IDAlphanumeric35 Only used for districts using single sign on.

*Required

Notes:

  • Staff data is from Human Resources > Maintenance > Staff Demo. If the district does not use TxEIS Business, columns for staff information are blank.
  • Do not use commas in the data fields; commas will cause the import to fail. If there is a comma in an email field, the email field will be blank when it is exported.
  • Do not enter blank spaces in fields that will be empty.
  • Do not insert blank rows into the file.
student/fitnessgram_export.txt · Last modified: 2018/10/09 14:48 by jstanford

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.