Can I mass import student email addresses into iPASS?

  Yes.  There is a Student Email Import feature in Mass Update Students.

• Create a TXT or CSV data file with the Student ID or LASID and the corresponding student email address
• Go to Biographical System > Mass Update Students > Import Student Emails
• Upload student email data file
  • Click on Upload
  • Browse for the file and select (Hint: copy the exact file name including .txt or .csv)
  • Click >> Upload
  • Upload Complete – click OK
• Proceed to Student Email Import Set Up
  • Academic Year = make sure this is set to the year you desire
  • Delimiter = Space, | , or , (depends upon the file type you uploaded) (ie. CSV = , )
  • Encapsulator = “ or None (depends upon the file you uploaded)
  • File Name = exact file name of the file you uploaded (Hint: paste the file name you copied above).
  • Data Record Layout
    • Lasid/Student ID = 1 or 2 (indicate column position in uploaded file)
    • Email Address = 1 or 2 (indicate column position in uploaded fie)
• Submit
• Check your Reports to see the results of the import

Example Files:

TXT File, Delimiter = Space, Encapsulator = None

CSV File, Delimiter = , (comma), Encapsulator = None

CSV File, Delimiter = , (comma), Encapsulator = “ (quote)