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.

• Ensure that the file type is .csv.

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.

GJAPCTL: Run the GJRPSIM process

1. In the Process field, enter GJRPSIM and 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 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.

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.