Difference between revisions of "Student Email Import"

From EDgearWiki
Jump to navigationJump to search
 
(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-mails from a .csv file.'''
 
  
 
'''<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 ==
  
[[File:Student_Email_Import_Menu.png]]
+
'''Student > Loaders > Student Email Import'''
  
 +
== Setup Options ==
  
On the left navigation panel select '''Student Master > Loaders > Student Email Import.'''
+
[[File:mb908.png]]
  
== 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.
  
[[File:Student_Email_Import_Setup.png]]
+
'''Select Email Case'''
  
'''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.
+
*'''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.
  
'''District''' - Default value is based on your security settings. You will be limited to your district only.
+
'''OK''' - Click to continue.
  
'''File''' - Click '''Choose File''' to select the file to import student e-mail addresses.
+
To find definitions for standard setup values, follow this link: [[Standard Setup Options]].
  
:: *As noted in the top section, '''the file to be imported must be a .csv file, and be in sidno, e-mail format'''.
+
*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:Student_Email_Import_Main.png]]
+
[[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: '''<span style="background:yellow">[[Common Column Headers]]</span>'''.
+
'''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''' - Returns you to the Setup Box; see instructions above.
+
'''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.
  
'''Print''' - To find the print instructions, follow this link: '''<span style="background:yellow">[[Standard Print Options]]</span>'''.
 
  
'''Help''' - Written instructions and instructional 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

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

Studemailpassword.png

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

Student Email Import Bottom.png

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.



Student Master Main Page


JCampus Main Page

Retrieved from EDgear Wiki