Banner UNIX Upload/Download Instructions
All SCT-delivered and UNCG-created job submission external file load programs will use Banner Data Load Directories. You need to obtain a Banner UNIX account if you need to load external files into the Banner system or retrieve generated data files from Banner. This Banner UNIX account is separate from and in addition to the default UNIX Web publishing account provided to all employees.
- Banner Data Load Directories
- Directory Structure Breakdown Table
- Obtaining a Banner UNIX Account
- Uploading for Input into Banner:
- Downloading Output from Banner:
Banner Data Load Directories
The banner-uservol directory that was used on the VMS operating system will not be used on the UNIX system due to system constraints. UNIX will use what are now called Banner Data Load Directories for data loads into and out of Banner. All SCT delivered and UNCG created job submission external file load programs will use these Banner Data Load Directories.
- The UNIX Banner data load directory path for pre-production (UGVAL3) is /banvol/load/ugval3/
- The UNIX Banner data load directory path for production (BANPRD) is /banvol/load/banprd/
Directory Structure Breakdown Table
Beneath the main data load directory are subdirectories for each client office. The names for these subdirectories follow the SCT naming convention standard as shown in the table below:
| Office | First Character | Production FTP Directory | Jobsub Short Cut | Client Owner |
|---|---|---|---|---|
| Alumni | a | /banvol/load/banprd/alumni/ | aload/ | Jill Goodman |
| Acct Rcv | t | /banvol/load/banprd/arsys/ | tload/ | Larry O'Barr |
| Fin Aid | r | /banvol/load/banprd/finaid/ | rload/ | Deborah Tollefson |
| Finance | f or w | /banvol/load/banprd/finance/ | fload/ | Chris Burnett |
| General | g | /banvol/load/banprd/general/ | gload/ | Robert Carver |
| Payroll | p | /banvol/load/banprd/payroll/ | pload/ | Chris Burnett |
| Student | s | /banvol/load/banprd/student/ | sload/ | Ellen Robbins |
Using these subdirectories will keep data for each client office separate. Data that will be uploaded or downloaded will be automatically directed to these directories. You do NOT have to have access to these directories to retrieve standard Banner list files that are normally produced by processes run through job submission. For now you will have to have special access in order to place data files for upload or retrieve non-standard data files from these directories. This should be limited to a select few staff members for each of the client offices (those that run programs that input or output data files).
NOTE: In the near future there will be a change that will use a function of AppWorx where all output from a job will be available thru AppWorx. Then users will be able to view, print, and move all the output from a job including data files.
Obtaining a Banner UNIX Account
You will only need to obtain a Banner UNIX account if you need to load external files into the Banner system or retrieve generated data files from Banner. This Banner UNIX account is separate from and in addition to the default UNIX Web publishing account provided to all employees. An example of this would be the FAFSA file sent to Financial Aid that has to be loaded into Banner. Standard list and log files can be accessed using the database option in job submission. When you obtain this account, the name and password will be the same as your Novell account.
Go to the University Computing Accounts page and print the UNCG Banner File Load (UNIX) Account Request. Fill in the required information.
Uploading for Input into Banner
File Naming
NOTE: UNIX is case sensitive. Banner will use the exact case to find the data file. For example, if the data file on the UNIX server is in all upper case and the program trying to find the file is looking for a lower case name, the file will never be found. For example MYFILE.DAT, MyFile.Dat and myfile.dat are all unique file names in UNIX. If you get a File Not Found error, first check not only the spelling but also the case of each character. Also unlike the VMS operating system, there are no version numbers in UNIX. The UNIX operating system handles files much like the Windows operating system on your PC. Files are always overwritten if the name is exactly the same. All input data files are expected by the system to be in the proper load directory. See the Directory Structure breakdown table.
All SQR programs looking for specific data file names have been modified to read the file name as all lowercase. If your file will be input into one of these programs the file name MUST be saved in lowercase.
If an SQR program uses a job submission parameter to name a data file, the file name can be in any case and typed appropriately in the job submission parameter in order to find the correct file. It must match the actual file name case. We recommend that clients use lowercase at all times. Remember data loads from Banner will also use the exact case to create a data file. Also the file name must be preceded by the Jobsub shortcut shown in the table below (i.e. aload/myfile.dat).
SQR External File Load Table
The following is a list of SQR Programs and appropriate Banner data load directories:
| SQR Program | Description | Data Load Directory | Jobsub Short Cut |
|---|---|---|---|
| AZPACTD | Alumni Activity Delete/Restore | /banvol/load/banprd/alumni/ | aload/ |
| AZPAP04 | Load Campus Call Updates | /banvol/load/banprd/alumni/ | aload/ |
| AZPEMAL | Alumni Email Program | /banvol/load/banprd/alumni/ | aload/ |
| AZPGSDL | Gift Society Delete or Restore | /banvol/load/banprd/alumni/ | aload/ |
| AZPMIG3 | Alumni Modify Campaign | /banvol/load/banprd/alumni/ | aload/ |
| AZPSPDL | Alumni Special Purpose Code Delete Records | /banvol/load/banprd/alumni/ | aload/ |
| AZPSPIX | Alumni Special Purpose Insert | /banvol/load/banprd/alumni/ | aload/ |
| GZPZIPL | Zip code Upload | /banvol/load/banprd/general/ | gload/ |
| RZPGRNT | Web Based Grant Delivery | /banvol/load/banprd/finaid/ | rload/ |
| SZPEMAL | Upload Student Emails | /banvol/load/banprd/student/ | sload/ |
| SZPEMPS | UNCG HRS to Banner, Employee Audit/Update Program | /banvol/load/banprd/student/ | sload/ |
| SZPLAPS | Advanced Placement Scores | /banvol/load/banprd/student/ | sload/ |
| SZPPLEX | Placement Exam Score Load | /banvol/load/banprd/student/ | sload/ |
| SZPSCLD | Smart Card Load into Banner | /banvol/load/banprd/student/ | sload/ |
| SZRHLOD | Honor Dept Spec Appr Data Load | /banvol/load/banprd/student/ | sload/ |
| TZPDCAL | Detail Code Accounting Load | /banvol/load/banprd/arsys/ | tload/ |
| TZPLFTR | Load Foreign Transactions | /banvol/load/banprd/arsys/ | tload/ |
| TZRAFSA | UAS Perkins Load | /banvol/load/banprd/arsys/ | tload/ |
| TZRARFS | AR to FRS Conversion Procedure | /banvol/load/banprd/arsys/ | tload/ |
FTP
WINFTP will NOT work with the new UNIX system. You will now FTP your data file to the appropriate load directory using Core FTP Pro, which supports secure FTP and can be configured to work well with UNIX. This program is located in the Application Explorer folder on the network. Do not attempt to use any other FTP or SFTP software to move data files to the UNIX load directories.
To use Core FTP v13c:
- Double click the Core FTP v13c icon in the Application explorer. Notepad will execute and display the following:
- You must close the Notepad document to continue. These are the steps it dictates that need to be accomplished:
- Install Core FTP from the Application Explorer on your desktop.
- Open up Core FTP and click on Help.
NOTE: A login screen called site manager will appear; you do not have to log in at this time. Close the window. - Click on Yes to register and then choose the File button.
- From the file button go into the following path: T:\coreftp\v1.3c\
- Choose the file reg.rgf and click OK.
- Your version of Core FTP should now be fully licensed. You can tell for sure when you close down the program and reopen it because it will say it is licensed.
- Close the Core FTP window and reopen it. The following screen will pop up:
- On this screen do the following:
- Enter a Site Name. This can be any desired title.
- In the Host field, enter
tstbandb.uncg.edufor test environment (UGVAL3) andprdbandb.uncg.edufor production (BANPRD2). - Enter your user name and password.
NOTE: This is your Novell account not Banner. - Check the SSH/SFTP box. This is critical for logging in.
- Click on the Advanced button. Highlight SSH and make certain that the box labeled Simulate ASCII mode for SFTP is checked.
IMPORTANT! This must be done for each new site that is created.
- Then click on Transfers in the left-hand column and choose Set default transfer mode to ASCII.
IMPORTANT: This must be done on each new site that is created.
Your window should now look something like the following:
Click on Connect to continue. The first time you connect you will get the following window. Click Yes.
The following screen example should open for your transfers.
In the above example, the left side is the C: drive of your PC and the right side is the load directory for the Financial Aid Department. This directory would be where Financial Aid would place their files to be loaded into Banner and where currently any data file from Banner would be retrieved. (Later AppWorx will handle output.)
In the above example, the directory temp on a PC is displayed on the left and the Finance offices load directory on ugval4 is displayed on the right.
Before transferring, make sure that your file name is unique and that you are consistent when using capital letters (UNIX is case-sensitive). Point to your destination directory. For example, Finance feeds to be processed in Production (BANPRD) is /banvol/load/banprd/finance/ and run the transfer.
NOTE: DO NOT attempt to use the Jobsub shortcut.
When you are finished transfering the file(s), you will be able to run your program from Banner job submission. If job submission requires an input file name, you will not need to type your directory again but rather enter the Jobsub shortcut followed by the file name. The reason for this shortcut is that the form limits file names to 30 characters which need to include the directory. By using the shortcut there are still 24 characters for the client's file name.
Downloading Output from Banner
Running a Job Through Job Submission
All SCT delivered and UNCG created job submission programs will put the standard .lis and .log files in the JOBSUB directory. This directory is not available for client viewing. AppWorx can access these files for you.
The lis and log files are named programname_oneupnumber.lis and programname_oneupnumber.log. For example, shrediy_12345.lis and shrediy_12345.log will be in the student load directory. In order to review/save a .lis file you will need to use the print option of DATABASE on the job submission form and review your output in the Banner form GJIREVO.
Use of the DATABASE option and GJIREVO can be found in the Banner Documentation and via Storing Output in the Database.
All SQR programs creating specific data file names have been
modified to create file names in all lowercase. If an SQR program
uses a job submission parameter to name a created file, the file can be
in any case the client chooses. Do not use the Jobsub shortcut
on these files. The file will be found in the appropriate data load
directory in the same case as typed in the job submission parameter.
Again it is recommended that the client uses lowercase to avoid future confusion. You must also remember to use unique
file names. If you repeat an output file name, it will overwrite the
prior version of the same file name. In that circumstance, the prior
version will be unrecoverable.