Difference between revisions of "Student Email Import"
| (11 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. | ||
| Line 52: | Line 49: | ||
'''Student Email''' - Student e-mail address that was imported into the '''Student Master'''. | '''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]]. | To find definitions of commonly used column headers, follow this link: [[Common Column Headers]]. | ||
Latest revision as of 08: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.
