University of Oregon

Upload Files from Client Machine to Job Scheduling Servers

Audience
Faculty/Staff
Researcher
Student
GTF

As part of the migration of banner jobs over to Applications Manager, we need a way to upload files to the Applications Manager servers for use as parameters to the modules/chains in Applications Manager. There are many jobs in banner that require an input file as one of their parameters, most notably FGRLINT. The old way of doing this was to use sFTP or Filezilla to copy your file from your computer (client machine) to your daisy account. With Applications Manager, you will not have the same sort of account structure that you did on daisy. But, you still need a way to get your input files on to the Applications Manager servers.

We decided to create a BANNER form that will allow you to upload files to the Applications Manager servers. This new form is called GWBLOAD and can be accessed from the *GENERAL menu on BANNER. The form will has a file area that lists the files to be loaded and a field to name the Applications Manager job/process that will use the named files.

  1. Upload Files Queue: The file(s) that you wish to upload to the Applications Manager servers
    1. Select the Browse... button that will display a file chooser dialog allowing you to easily find your files.
  2. Applications Manager module/chain that will use this file: This is the Applications Manager job/process that will use this file as an input.
    1. This field is free text and not validated, so make sure that you give it the correct name.
  3. Convert queued text files to Linux. Check this box if your file was created on a windows machine and you are having trouble running the job in Applications Manager that uses this file.

There are two buttons towards the bottom of the screen

  1. Upload Files
    1. Once the "Upload Files Queue" and "Applications Manager module/chain that will use this file" fields are entered, the user can select the "Upload Files" button, which then copies the file to the Applications Manager Servers. But, before copying the file to the Applications Manager servers, the file is given a unique name using this convention:
    2. [user]_filename_[seq].[ext] – where user is your banner user id, seq is the nextval of a new sequence generator that was built for the form, and ext is the extension of the filename. Example: file to load => c:\test.lis; file on Applications Manager server => joey_test_1.lis
  2. Cancel
    1. The Cancel button will perform a rollback function and clear the form.
    2. Using your uploaded file in an Applications Manager Module/Chain
    3. Once you’ve uploaded your file to the Applications Manager Servers, you can start Applications Manager and request the module/chain that will use your uploaded file. Following is a visual of how to request FGRLINT using a file that has been uploaded to the Applications Manager servers.

Using your uploaded file in an Applications Manager Module/Chain


Once you’ve uploaded your file to the Applications Manager Servers, you can start Applications Manager and request the module/chain that will use your uploaded file. Following is a visual of how to request FGRLINT using a file that has been uploaded to the Applications Manager servers.

 

Request the FGRLINT module from Applications Manager.
 

 

 

  1. Enter the System ID. List of values is available
  2. Enter the Input Data Filename. List of values is available. See picture below

Note that when you click on LOV for the Input Data file name, a List of values window is displayed with all the files you have uploaded to the Applications Manager servers using the GWBLOAD banner form. This window displays the uploaded filename, the date uploaded and the actual filename on the Applications Manager server. The files will be listed in descending date order so your most recent upload appears first. Select the file you want as input to FGRLINT.

  1. Enter values for parameters 4, 5 and 6.
  2. Press Submit button and your FGRLINT module runs.