Import IDs or PIDMs Process

Relevant to: faculty, staff, and students

This article contains information considered accurate at the time of publishing. Technology updates, changes in University security practices, policies and procedures may effect the information in this article - updates to articles are scheduled on a periodic basis and will address any required changes.

Import IDs or PIDMs (GJRPSIM) Process 

The Import list of IDs and PIDMs (GJRPSIM) process allows an institution to import an external CSV fiile containing a list of either IDs or PIDMs organized in a single column with a header, into the existing Population Selection Extract Base (GLBEXTR) table.  This feature provides an easy way to import IDs and PIDMs into an existing Population Selection to conduct further business processing accordingly.  

1. Save the Excel list as a .csv file with only the column header (ID) and student ID numbers.
2. To import your file, go to GJAJFLU. Enter GJRJFLU as the job and click GO.
   
   
   
   
   
    
3. Click the open file button next to select file to choose the file to upload.
   NOTE- if you already have a file uploaded and need to upload a different file, delete the old one using the delete button on the top right.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
    
4. Once you have chosen the file, click SAVE at the bottom.
   
   
   
   
   
   
   
   
   
   
   
    
5. Go to GJRPSIM and click GO.
6. The first three parameters should reflect the population that will be created with the IDs.
7. Parameter 06 should be the name of the file you uploaded.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
    
8. Click SAVE.
9. Go to GLAEXTR to review your records.
   
   
   To Import a File (in place of GUAUPLP)
   GKAODFT