Loading IDs from a .csv for bulk processing (GJAJFLU/GJAPCTL/GJRPSIM/GLAEXTR)

Prepare your file

• Your .csv file should contain only a single column of TU ID numbers with a column header.

• Name your file with the name of the bulk process you will be using. For example, SGPADVA, SGAMSTU, SFAMREG, etc.

  • If you need to do the process with different lists, it’s a good idea to add an identifier to differentiate them from one another.

  • For example, if you’re using SFAMREG to register student for different CRNs, you might use, SFAMREG_24679 (SFAMREG_CRN).

• Ensure that the file type is .csv.

 See an example

GJAJFLU: Upload your file

1. In the Job field, enter GJRPSIM. Go.

2. Click the Insert button.

3. Click the Select File button and choose your file from where you’ve saved it.

4. In the Delete After days field, enter 0.

5. Save.

Upon saving, you will see the following notifications. This is normal. Click the bell in the upper right corner and move on to the next step.

GJAPCTL: Run the GJRPSIM process

1. In the Process field, enter GJRPSIM and REGBulkProcess (for example, REGSGAMSTU) for the Parameter Set. Go.

2. Next block to Parameter Values. Enter the following parameters:

   1. 02 Creator ID - your username in all caps

   2. Leave all other parameters the same.

3. Next block to Submission.

4. Save.

GLAEXTR: Review your list (optional)

1. In the key block confirm or enter the Application (STUDENT) and Selection ID. Go.

   1. The Selection ID is the bulk process you’re using. For example, SGPADVA, SGAMSTU, SFAMREG, etc.

2. You will see the list of students pulled in from your .csv file.

   

   If you see the following warning, click OK.

   

Complete your bulk process

Navigate to your intended bulk processing screen. Set up the changes you want to make.

• Managing fee assessment rate codes (SFAREGS/SGAMSTU)

• Adding and dropping students in bulk (SFAMREG)

Appendix

To create a new Application:

1. Go to GLRAPPL. Type in the preferred application code.

2. Next block. Enter a description. System is S. Save.

To create a new Selection ID:

1. Go to GLRSLCT. Enter STUDENT for the application.

2. In the Selection ID field, type in your preferred Selection ID. Go.

3. Enter a description and check Manual. Our convention is to use the bulk process you’re using as the Description. Save.

To view output files:

1. Go to GJIREVO. Click the button on the Number field.

   1. Each run of the job outputs 2 files: one with the extension .lis and one with .log.

   2. As an additional check, you can select the .lis file to confirm the correct number of records were pulled in from the .csv.

2. Select the appropriate file in the Available Files window. Click OK. The .lis file displays.