ARCHIVED: Enter attendance in a Student Performance/FLAGs roster from a prepared file

To enter student performance rosters/FLAGs attendance values from a prepared file, use the Load from File tool.

• Prepare the file
• Use Load from File to enter a prepared file

Prepare the file

Important: Before loading, prepare your attendance file as follows:

• The file must be comma delimited (CSV); if you use a Mac, save your CSV file in Windows comma-separated format.
  Notes:

  • Every University ID in the comma-delimited file must match a University ID in the student performance roster; grades without matching University IDs will be ignored. Only students in the enrolled portion of the roster can be updated via this process; students listed as "attending but not enrolled" cannot be updated via this process. On the first line, enter FLAG to indicate that this is a FLAGs roster.
  • You do not need to enter attendance for students for whom attendance has already been assigned (for example, a value of "not attending" for withdrawn or dropped students). Attempts to replace the existing grade with a different one will result in an error similar to the following:

    "Attendance not loaded for emplid 0012345678 Invalid Attendance Value AT."

• All additional lines must be formatted with a University ID and attendance value. Valid attendance values include the following (case sensitive):
  • AT (Attending)
  • HSA (Has started attending)
  • IRA (Irregular Attendance)
  • NT (Not Attending)
  • NV (Never Attended)
  • AWNA (Withdraw - No Attendance) Administrative Withdrawal classes only
  • AWSA (Withdraw - Some Attendance) Administrative Withdrawal classes only
  Note:

  If an invalid attendance value ("XX" in this example) is specified, the following error will be returned:

  Attendance not loaded for emplid 0000011111. Invalid Attendance value XX.

• The University ID must contain all 10 digits in order to match the student performance roster. Student University IDs created before June 28, 2015, will begin with leading zeros, while student University IDs created after this date will begin with the number two. Following is an example of a load file:

    FLAG
  
    0000011111,AT
  
    0000022222,NV
  
    2000033333,NT
  
    2000044444,AT
  
    2000055555,IRA

  Note:

  Do not enter a Last Date of Attendance when applying an attendance value of NT (Not attending) or AWSA (Withdraw - Some Attendance). Enter the date after the upload, when validating the values. If you try to add a date before the upload, the record will not be loaded.
• If the file does not contain FLAG on the first line, or if the value does not match the roster type, the following error message will appear:

  Invalid File. First Line of File must be FLAG for FLAG Rosters.

Use Load from File to enter a prepared file

To use Load from File to enter your prepared attendance file:

1. ARCHIVED: Navigate to your Student Performance/FLAG roster.
2. On the roster, click Load from File.
3. Click Browse to locate your grade file.
4. Once the filename displays in the text box, click Upload. The system will attempt to load the file. The following message, where "Y" is the number of records in the file and "X" is the number of records loaded, should appear:

   Loading X Records out of Y Read. Would you like to continue?

   Click OK or Cancel.

   Note:

   If the message reads "Loading 0 Records out of Y Read. Would you like to continue?", check to see if you have any University IDs that begin with leading zeros and verify that the leading zeros are in your file. Saving it as a CSV file will strip out the leading zeros, but they must be present when you save the file for it to upload properly.
5. Click Save. Verify that all attendance values are loaded, edit as necessary, and then click Save; or, if you are ready for these values to be displayed to students in the Student Center, click Submit.