Before you submit your graduates file, follow these guidelines to avoid common errors and ensure that StudentTracker can process your file and track your graduates accurately and efficiently. For detailed information and instructions, see Formatting and Submitting a Graduates File.

Formatting the File

• Header row:
  • Ensure that the header row information is in row A and remove any column headers that you have added
  • Ensure that cell A1 contains the letters PH3 in all capital letters
  • Ensure that the letters ED are not in column AB. The letters ED are only required in the student detail rows
    

• Student detail rows
  • Ensure that all required student data fields are included and formatted correctly
  • Ensure that every student row has the letters PD3 in column A
  • Ensure that the letters ED are in column AB for each of your student detail rows
    
• Trailer row
  • Ensure that this is the last row of your file and that it contains the letters PT3 in column A
  • Ensure that the letters ED are not in column AB of the trailer row
    

Formatting the Fields

• Format non-date fields as text: Format all non-date fields as text before you add any data to ensure that the file retains any leading zeroes in Social Security numbers, student IDs, and/or the high school ACT code.
  
• Correctly format date fields: Format all date fields as YYYYMMDD (year-month-day).
  
• Populate all Social Security number fields: Do not leave Social Security number fields blank. If your organization does not collect Social Security numbers, or you do not want to submit a Social Security number, enter NO SSN in the field.
  
• Review the file submission guidelines: Make sure you follow the instructions in our file submission guidelines, include all required fields, and format each field correctly.

Using Optional Fields

• Correctly format optional fields: Double-check any values entered in the optional demographic and academic fields. If you export data from your student information system (SIS), it may not be formatted in a way that StudentTracker can accept. Review our file submission guidelines and make sure the values are valid and do not exceed character limits.
• Remove N/A from optional fields: Do not enter N/A in any optional academic or demographic fields. StudentTracker interprets N/A as an error, which will delay the processing of your file. If you do not want to populate any optional fields, leave them blank.

Saving the File

• Use the right file type: Save your file as Text (Tab delimited) (*.txt). StudentTracker CANNOT process other file types, such as comma delimited (*.csv) or Excel files (*.xls or *.xlsx).
  
• Remove invalid characters from the filename: You can use numbers, letters, hyphens and underscores in your filename. StudentTracker will reject your file if you use any other characters in the filename.