Load Patrons

From Staffwiki

(Difference between revisions)
Jump to: navigation, search
(To extract data from Banner® in SIF format)
m
Line 16: Line 16:
You must have a Banner account appropriate to this task.  Discuss the requirements with Helen Jackson of ITD.
You must have a Banner account appropriate to this task.  Discuss the requirements with Helen Jackson of ITD.
-
# UNIX access username and passowrd
+
# UNIX access username and password
-
#  
+
# SQL access username and password.  The sql_username may be the same as the UNIX login username.
# Log in to Banner
# Log in to Banner
-
## Login: <username>
+
## '''Type''' PROD
-
## Password: <password>
+
## '''Login:''' <username>
 +
## '''Password:''' <password>
 +
## Optionally use '''ls''' to list files
# Extract the data
# Extract the data
-
## Type PROD
+
## '''sqlplus''' <sql_username>
-
##  
+
## '''start''' sif_student2.sql
 +
## Enter value for file name: '''<output_file_name>'''
 +
## Wait until the extraction and creation of the SIF file is completed
 +
## '''!''' Type a single explamation point and press Enter
# Retrieve the data
# Retrieve the data
# Post-process the records
# Post-process the records

Revision as of 17:39, 28 August 2008

Contents

Loading Patron Records

Reference Documents

  1. Batch Loading Patron Data into I-Share Voyager Databases.
  2. Patron Record Standard Interface File (Annotated)

Introduction

The "patron load" is a recurring process which must take

expiration of records
expiration of patrons
change of patron status
avoidance of duplication

into account.

To extract data from Banner® in SIF format

You must have a Banner account appropriate to this task. Discuss the requirements with Helen Jackson of ITD.

  1. UNIX access username and password
  2. SQL access username and password. The sql_username may be the same as the UNIX login username.
  1. Log in to Banner
    1. Type PROD
    2. Login: <username>
    3. Password: <password>
    4. Optionally use ls to list files
  2. Extract the data
    1. sqlplus <sql_username>
    2. start sif_student2.sql
    3. Enter value for file name: <output_file_name>
    4. Wait until the extraction and creation of the SIF file is completed
    5. ! Type a single explamation point and press Enter
  3. Retrieve the data
  4. Post-process the records
  5. Re-examine the file for proper structure
    1. Remove leading "garbage" record(s)
    2. Check the alignment of fields
    3. Remove duplicated records within the file
  6. Re-examine file file for field-level issues
    1. Clear SSN's as needed
    2. Translate or re-map Patron Group Codes
  7. Transmit the file to CARLI
  8. Generate a Patron Load Work Request Order (WRO)
  9. Examine the WRO diagnostics
  10. Repair the file as needed by repeating the above
  11. Verify WRO submission for full records
  12. Notify appropriate personnel
Personal tools