Difference between revisions of "Photo File Creator"

From EDgearWiki
Jump to navigationJump to search
 
(26 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
'''This program will create a csv file for the photographer in advance of the picture taking sessions.  The file will help the photographer create photos that import into JCampus for students.'''
 
'''This program will create a csv file for the photographer in advance of the picture taking sessions.  The file will help the photographer create photos that import into JCampus for students.'''
  
'''Note:''' Please do not use Excel to open or save the file created from this utility.  Excel will trim off the leading zero on a student's ID and cause problems for the photographer.
+
'''Note''' - Do not use Excel to open or save the file created from this utility.  Excel will trim off the leading zero on a student's ID and cause problems for the photographer.
  
==Menu Location
+
==Menu Location==
  
[[File:photomenu.png]]
+
'''Student > Interfaces > Photo File Creator'''
 
 
 
 
On the left navigation panel, select '''Student Master''' > '''Interfaces''' > '''Photo File Creator'''.
 
  
 
==Setup Options==
 
==Setup Options==
  
[[File:photosetup.png]]
+
[[File:mb722.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.
 
'''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 your security settings. You will be limited to your district only.
+
'''District''' - Default value is based on the user’s security settings. The user will be limited to their district only.
 
 
'''School''' - Default value is based on your security settings. If you are assigned to a school, the school default value will be your school site code. You will not be able to change this
 
 
 
value. If you are a supervisor or other district office employee with access to the Student Information System, you will be able to run programs for one school, a small group of schools, or
 
 
 
all schools in your district.
 
  
'''Grade''' - Grade level of students whose records need to be edited or whose names are to be included on a report. Leave the field blank if all grade levels are to be included. Otherwise,
+
'''School''' - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.  
  
click in the field to the right of Grade(s) to select the desired grade level(s) to be included.
+
'''Grade''' - Leave blank or select all to include all grade levels. Otherwise, choose the desired grade level.
  
 
''' As of Date''' - This choice will list only those students who are actively enrolled as of the date selected in the date field.
 
''' As of Date''' - This choice will list only those students who are actively enrolled as of the date selected in the date field.
  
'''Special Codes''' - Special Codes must have been entered into the Student Master record for students. Leave blank if all special codes are to be included into the report. Otherwise click in
+
'''Special Codes''' - Leave blank if all special codes are to be included into the report. Otherwise, choose the desired special code.
 
 
the field to the right of Special Codes to select the desired special code(s) to view.
 
  
 
'''Semester''' - To select all semesters leave the field blank or click in the field and select the check box at the top of the list of semesters; to select one or more semesters click in the  
 
'''Semester''' - To select all semesters leave the field blank or click in the field and select the check box at the top of the list of semesters; to select one or more semesters click in the  
 
 
field and select the desired semester(s) from the popup list.
 
field and select the desired semester(s) from the popup list.
  
'''Transcript Group''' - Click in the box and make your selection
+
'''Transcript Group''' - Click in the box and make a selection.
  
'''OK''' - Click to continue
+
'''OK''' - Click to continue.
  
To find definitions for standard setup values, follow this link: '''<span style="background:yellow">[[Standard Setup Options]]</span>'''.
+
To find definitions for standard setup values, follow this link: [[Standard Setup Options]].
 
 
 
 
Note:  To create a file by Homeroom:''
 
 
 
Semester:  Set to desired semester.  Typically at the start of the year, this is “1”.
 
 
 
Transcript group:  Set to “blank” as shown above.
 
  
 
==Main==
 
==Main==
  
 
+
[[File:photofilecreatormain.png]]
 
 
[[File:photomain.png]]
 
  
 
===Column Headers===
 
===Column Headers===
  
'''Sch''' - School site number
+
'''Sch''' - School site number.
  
'''SIDNO''' - Student's identification number
+
'''SIDNO''' - Student's identification number.
  
'''Last Name''' - Student's last name
+
'''Last Name''' - Student's last name.
  
'''First Name''' - Student's first name
+
'''First Name''' - Student's first name.
  
'''Homeroom''' - Student's homeroom teacher's name
+
'''Homeroom''' - Student's homeroom teacher's name.
  
'''GD''' - Student's grade of enrollment
+
'''GD''' - Student's grade of enrollment.
  
'''Period''' - Student's class period based on the Transcript Group from the setup box or blank if no Transcript Group selected
+
'''Period''' - Student's class period based on the Transcript Group from the setup box or blank if no Transcript Group selected.
  
 
'''Teacher''' - Student's course teacher based on the Transcript Group from the setup box or the homeroom teacher if no Transcript Group was selected.
 
'''Teacher''' - Student's course teacher based on the Transcript Group from the setup box or the homeroom teacher if no Transcript Group was selected.
Line 78: Line 57:
 
'''Course''' - Course based on the Transcript Group from the setup box or blank if no Transcript Group is selected.
 
'''Course''' - Course based on the Transcript Group from the setup box or blank if no Transcript Group is selected.
  
To find definitions of commonly used column headers, follow this link: '''<span style="background:yellow">[[Common Column Headers]]</span>'''.
+
'''Gender''' - Gender of student.
 +
 
 +
'''Parent Name''' - Student's parent/guardian name.
 +
 
 +
'''Parent Email''' - Student's parent/guardian email.
  
 +
#If the guardian's last name is not blank, then show the guardian's '''name''' and '''email''' address.
 +
#If the guardian's last name is blank and the mother's last name is not blank, then show the mother's name and email address.
 +
#Lastly, if the guardian and mother's last name are both blank, then show the father's name and email address.
  
 +
To find definitions of commonly used column headers, follow this link: [[Common Column Headers]].
  
To create a file by Transcript group, such as “English” classes:''
+
==Bottom==
  
Semester: Select the desired semester.  Typically at the start of year, this is “1”.
+
[[File:mb718.png]]
  
Transcript group:  Select the desired group, such as “English” in the setup box.
+
'''[[Standard Print Options | Print]]''' - This will allow the user to print the report.
  
Note: The column headers are the same as the screen above.
+
[[File:mb719.png]]
  
[[File:photoenglish.png]]
+
'''Setup''' - Click to go back to the Setup box.
  
Click the '''OK''' button to continue.
+
'''Help''' - Click to view written instructions and/or videos.
  
Review the results, then click the '''Print''' button on the lower left of the screen.
+
[[File:mb724.png]]
  
At the '''Print''' options screen, click to select “'''CSV – Comma Separated file'''”.  You will see that the system has created a File Name for you. Click the '''Print''' button to create
+
'''Photo File''' - Export of Student Information for Photography Companies.
  
the file.
+
'''Note''' - Do not use Excel to open or save the file created from this utility.  Excel will trim off the leading zero on a student's ID and cause problems for the photographer.
  
[[File:photoprint.png]]
 
  
'''Google Chrome''' users:
 
  
A new window will open that will be mostly blank.  In the lower left will be a link to the file.  Click the arrow on the right of the file name.  A menu will open.  Choose Show in folder.
 
 
Browse the listing of files to locate the “photoFile….csv” file.  Send this file to your photographer.
 
  
'''Remember''': Please do not use Excel to open or save the file created from this utility.  Excel will trim off the leading zero on a student's ID.
+
----
 +
[[Student Master|'''Student Master''' Main Page]]
  
To find the print instructions, follow this link: '''<span style="background:yellow">[[Standard Print Options]]</span>'''.
+
----
 +
[[WebPams|'''JCampus''' Main Page]]

Latest revision as of 09:10, 20 July 2023

This program will create a csv file for the photographer in advance of the picture taking sessions. The file will help the photographer create photos that import into JCampus for students.

Note - Do not use Excel to open or save the file created from this utility. Excel will trim off the leading zero on a student's ID and cause problems for the photographer.

Menu Location

Student > Interfaces > Photo File Creator

Setup Options

Mb722.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.

School - Default value is based on the user's security settings. If the user is assigned to a school, the school default value will be their school site code.

Grade - Leave blank or select all to include all grade levels. Otherwise, choose the desired grade level.

As of Date - This choice will list only those students who are actively enrolled as of the date selected in the date field.

Special Codes - Leave blank if all special codes are to be included into the report. Otherwise, choose the desired special code.

Semester - To select all semesters leave the field blank or click in the field and select the check box at the top of the list of semesters; to select one or more semesters click in the field and select the desired semester(s) from the popup list.

Transcript Group - Click in the box and make a selection.

OK - Click to continue.

To find definitions for standard setup values, follow this link: Standard Setup Options.

Main

Photofilecreatormain.png

Column Headers

Sch - School site number.

SIDNO - Student's identification number.

Last Name - Student's last name.

First Name - Student's first name.

Homeroom - Student's homeroom teacher's name.

GD - Student's grade of enrollment.

Period - Student's class period based on the Transcript Group from the setup box or blank if no Transcript Group selected.

Teacher - Student's course teacher based on the Transcript Group from the setup box or the homeroom teacher if no Transcript Group was selected.

Course - Course based on the Transcript Group from the setup box or blank if no Transcript Group is selected.

Gender - Gender of student.

Parent Name - Student's parent/guardian name.

Parent Email - Student's parent/guardian email.

  1. If the guardian's last name is not blank, then show the guardian's name and email address.
  2. If the guardian's last name is blank and the mother's last name is not blank, then show the mother's name and email address.
  3. Lastly, if the guardian and mother's last name are both blank, then show the father's name and email address.

To find definitions of commonly used column headers, follow this link: Common Column Headers.

Bottom

Mb718.png

Print - This will allow the user to print the report.

Mb719.png

Setup - Click to go back to the Setup box.

Help - Click to view written instructions and/or videos.

Mb724.png

Photo File - Export of Student Information for Photography Companies.

Note - Do not use Excel to open or save the file created from this utility. Excel will trim off the leading zero on a student's ID and cause problems for the photographer.




Student Master Main Page


JCampus Main Page

Retrieved from EDgear Wiki