Difference between revisions of "Student Email Import"
(26 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 | + | :*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 == | ||
− | + | [[File:mb908.png]] | |
− | + | '''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 == | == Main Screen == | ||
− | [[File: | + | [[File:studemailpassword.png]] |
=== Column Headers on Screen === | === Column Headers on Screen === | ||
Line 44: | Line 50: | ||
'''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'''. | ||
− | To find definitions of commonly used column headers, follow this link: | + | '''Student Email Password''' - Student email password. |
+ | |||
+ | To find definitions of commonly used column headers, follow this link: [[Common Column Headers]]. | ||
== Bottom Buttons == | == Bottom Buttons == | ||
Line 50: | Line 58: | ||
[[File:Student_Email_Import_Bottom.png]] | [[File:Student_Email_Import_Bottom.png]] | ||
− | '''Setup''' - | + | '''Setup''' - Click to go back to the Setup box. |
+ | |||
+ | [[Standard Print Options | '''Print''']] - This will allow the user to print the report. | ||
+ | |||
+ | '''Help''' - Click to view written instructions and/or videos. | ||
− | |||
− | |||
---- | ---- |
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.