Difference between revisions of "Student Email Import"
(10 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
− | + | '''This program will import student e-mail addresses/email passwords. The format of the file needs to be a csv file with the sidno, email, password. So, the file only needs the sidno, email and password. ''' | |
− | '''This program will import student e- | ||
'''<span style="background:yellow">[[Prior to running this import, create a file as follows:]]</span>''' | '''<span style="background:yellow">[[Prior to running this import, create a file as follows:]]</span>''' | ||
:*"csv" file type | :*"csv" file type | ||
− | :*Layout: sidno (jcampus student ID number), student email address. The header record is required for this format to import. | + | :*Layout: sidno (jcampus student ID number), student email address, student email password. The header record is required for this format to import. |
== Menu Location == | == Menu Location == | ||
− | + | '''Student > Loaders > Student Email Import''' | |
− | |||
− | |||
== Setup Options == | == Setup Options == | ||
Line 25: | Line 22: | ||
'''Select Email Case''' | '''Select Email Case''' | ||
− | *'''No Change''' - | + | *'''No Change''' - Select to keep the email address the way it was typed in. |
− | *'''Upper Case''' - | + | *'''Upper Case''' - Select to change all characters to uppercase for the email addresses. |
− | *'''Lower Case''' - | + | *'''Lower Case''' - Select to change all characters to lowercase for the email addresses. |
'''OK''' - Click to continue. | '''OK''' - Click to continue. |
Latest revision as of 07:26, 20 July 2023
This program will import student e-mail addresses/email passwords. The format of the file needs to be a csv file with the sidno, email, password. So, the file only needs the sidno, email and password.
Prior to running this import, create a file as follows:
- "csv" file type
- Layout: sidno (jcampus student ID number), student email address, student email password. The header record is required for this format to import.
Menu Location
Student > Loaders > Student Email Import
Setup Options
Year - Defaults to the current year. A prior year may be accessed by clicking in the field and making the appropriate selection from the drop down list.
District - Default value is based on the user’s security settings. The user will be limited to their district only.
File - Click Choose File to select the file to import student e-mail addresses.
Select Email Case
- No Change - Select to keep the email address the way it was typed in.
- Upper Case - Select to change all characters to uppercase for the email addresses.
- Lower Case - Select to change all characters to lowercase for the email addresses.
OK - Click to continue.
To find definitions for standard setup values, follow this link: Standard Setup Options.
- As noted in the top section, the file must be saved in a .csv file format to import correctly. Format to include sidno, e-mail address with a record header.
Main Screen
Column Headers on Screen
District - Student`s school district code.
School - Student`s school of enrollment
First Name - Student`s first name.
Last Name - Student`s last name.
SIDNO - Student`s identification number.
Student Email - Student e-mail address that was imported into the Student Master.
Student Email Password - Student email password.
To find definitions of commonly used column headers, follow this link: Common Column Headers.
Bottom Buttons
Setup - Click to go back to the Setup box.
Print - This will allow the user to print the report.
Help - Click to view written instructions and/or videos.