Uploading G Numbers into Banner to Create a Student List
With the uploading process, Banner-users can import a group of G Numbers into Banner and create an Excel-friendly list of student names, addresses, phone numbers, majors at time of enrollment, and demographic information based on the G Numbers you have uploaded into Banner. Here's how:
Steps 1 -- 3: Prepare the Data, Upload the Data, and Run the GWRPOPR report
Complete directions for Steps 1--3 are located on the main Banner Uploading Help Page.
Step 4: Create Detailed Student List
Once you have performed Steps 1--3, you can run the detailed student list (GWRPLST) which specifies the addresses, phone numbers, majors at time of enrollment, and demographic information of the students whose G Numbers you have uploaded. This report can also be moved into Excel format.
Banner Combined Population Selection -- GWRPLST (Demographic List)
GWRPLST creates a list of students, along with details about each student, from a Population Selection you have previously created. A download-friendly version of the report is also created. The report includes names, G numbers, addresses, phone numbers, majors at time of enrollment, and demographic information.
Please note that the major codes listed on the GWRPLST report indicate the declared major at time of enrollment, not necessarily the student's current major.
- From the Banner Main Menu, type GWRPLST, then press Enter.
- Click the Go button and then Next Section
- On the right side of the Parameter Values section, complete the parameter values as shown:
What to Type
If today's date does not appear, use the keystroke shortcut T + Enter key.
Example: 05-DEC-2011 (for December 5, 2011)
05: Address Type
06: Delete This Population?
07: Sort Code
To sort by Name, type 1
To sort by Zip Code, then Name, type 2
|08: Term Code|
Type the Term Code for the Term You want:
|09: Email Selection||P = MyPCC email address|
S = Student's personal email address, if on file
- When you have finished entering the parameter values above, click the Next Section
- Click the Save button on the bottom right of your screen.
You will see a message at the bottom left of the screen: Look for Printout in yourname_gwrplst_99999.lis.
- Open Report Viewer to view and/or print your report.
Two files are created for this report:
- The file name that ends with .lis is a viewable report.
- The file name that ends with .txt contains the same information in download-friendly format.
To download the .txt report, click on the blue button that looks like this:
Go through the downloading process to save and convert your report into Excel format. Choose "tab delimited" and indicate "^" (carat symbol) as the delimiting character.
For more information on how to download reports, refer to: Downloading from Banner into Excel or Word.