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

Owned by Denise Kidd
Last updated: Nov 06, 2024
4 min read

Prepare your file

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

  • Name your file [with NO SPACES] using your preferred naming convention. Be sure to note these file names because you’ll need them when you run your process.

  • 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.

image-20240314-141741.png

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.

image-20240314-141909.png

GLRSLCT: Create a Selection ID

Create a Selection ID for each list of students.

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

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

    1. There is no convention for Selection IDs - just make sure you make note of it because you’ll need to have it when you run your process.

  3. Enter a description and check Manual. Recommended: repeat the Selection ID in this field.

  4. Save.

To search for a previously-created Selection ID:

  1. In GLRSLCT, enter STUDENT in the Application field.

  2. Click the lookup button on the Selection ID field to search.

GJAPCTL: Run the GJRPSIM process

  1. In the Process field, enter GJRPSIM and leave parementer set blank. Click Go.

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

    1. 01 Application ID - STUDENT in all caps

    2. 02 Selection ID - The Selection ID you created in GLRSLCT

    3. 03 Creator ID - Your username in all caps (e.g., DKIDD)

    4. 04 - System Indicator - M

    5. 05 - Import Type - I

    6. 06 - File Path or File Name - your file name (include the .csv at the end of the file name and lower its lowercase (the csv, not the name of the file)

    7. 07 - Purge all records - N

    8. 08 - N

    9. 09 - N

  3. Next block to Submission (don’t click any boxes here).

  4. Save.

GLAEXTR: Review your list

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

    1. Enter your Selection ID.

    2. Enter your username as DKIDD.

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

    If you see the following warning, click OK.

If there’s a problem with your list, you may want to view the output files for errors. You will need to resolve the error, which is either in your file or the parameters set in GJAPCTL, and then complete the steps again.

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.

Complete your bulk process

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

Appendix

To create a new Application if needed:

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

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