In the isir_post.log file, the main problem is that there are no records found, but there is one error that can be fixed. This is probably going to happen every year.

Enter column commands

Column 1 (Line 1, Pos 1)...Field? .SSN

%Field .SSN not described in USERS2:[FINAID.EDE.FILES]07ISIR

Column 1 (Line 1, Pos 1)...Field? .XLASTNAMEx

Column 2 (Line 1, Pos 18)...Field? .xFIRSTNAMEx

Column 3 (Line 1, Pos 31)...Field? .xMIDDLEINITx

Column 4 (Line 1, Pos 33)...Field? .EXCLUDE 

To fix, DESCR 07isir and add fieldname of SSN to the studentid field.

$ desc isir

Type "HELP" for assistance

DESCRIBE Option? list

File(s) <Current>?

Fields <ALL>? studentid

Listing format <BRIEF>? full

Output to <TT:>?

Lines per page <23>?

Heading?

Number of copies <1>?

Press RETURN on bell to continue listing

05-Feb-07 01:13 PM                                                      Page 1

                        USERS2:[FINAID.EDE.FILES]07ISIR

Field 140:   .ID             .SOCSECNUM      .STUDENTID

  1) Fst,Lst:  659,667  (   9)  Key 1, Dup   6) Update ? YES

  2) Explain: Current SSN                    7) Transf ? YES

  3) Heading: "Current SSN"                  8) CPrefix: <None>

  4) Prompt : <Explanation>                  9) EditMsk: <None>

  5) Initial? YES                           10) Numeric? YES

                                            11) Decimal: 0

DESCRIBE Option? name

NAME Suboption? add

Field name to Add? ssn

Assignment field? Studentid

Another customization we make every year, in order for the menu item ISIRUPD to work, is to create .shortid in ISIR descriptor. In DESCRIBE, create a new field which overlays the last 4 char of the .studentid.  Name it “shortid.”

Now, to go back to the main problem –no records found to post…

SKY_READ
(1) loads the records in USERS2:[AID_USERS.EDEFTP]IDSA*.DAT to ISIR data file;
(2) moves the IDSA*.DAT file to USERS2:[AID_USERS.EDEFTP.PROCESSED] and increments the file number (extension).

Set your default to USERS2:[AID_USERS.EDEFTP].  Do a DIR lookup of files.  If there are no IDSA files there, you’ll know that none are waiting for SKY_READ.  Some may have errored out, though, and be in the Processed directory.

AID_USERS.EDEFTP> dir [.processed]*08*.dat/date

Directory USERS2:[AID_USERS.EDEFTP.PROCESSED]

IDSA08BK.dat;9        5-FEB-2007 09:54:34.24

IDSA08BK.dat;8        5-FEB-2007 09:54:34.24

IDSA08BK.dat;7       26-JAN-2007 08:40:34.71

Several have been processed, but the files need examination to see if they’re identical.

AID_USERS.EDEFTP> differ [.processed]idsa08bk.dat;9 idsa08bk.dat;8

Number of difference sections found: 0

Number of difference records found: 0

DIFFERENCES /IGNORE=()/MERGED=1-

    USERS2:[AID_USERS.EDEFTP.PROCESSED]IDSA08BK.dat;9-

    USERS2:[AID_USERS.EDEFTP.PROCESSED]IDSA08BK.dat;8

AID_USERS.EDEFTP> differ [.processed]idsa08bk.dat;9 idsa08bk.dat;7

File USERS2:[AID_USERS.EDEFTP.PROCESSED]IDSA08BK.dat;9

    2   8447862873FU01FULBRIGHT       STACIE      L5209 S. HARVARD #E

    3   8440621234HO01HOUCK           SHERRIE     R6315 MUSSON RD

    4   8445621037HA01HARJO           KIMBERLY    RPO BOX 157

    5   8447661066LU01LUCAS           NANCY       A303 LIZA LANE

    6   8619033268HY01HYDE            JOSHUA      W6222 S 107TH E AVE APT 3

    7   8621125511RO01ROBINSON        LORRAINA    J112 PARKDALE COURT

******

File USERS2:[AID_USERS.EDEFTP.PROCESSED]IDSA08BK.dat;7

    2   8447883184GR01GRUBBS          SAMUEL      P3218 S. 93RD E. AVE. APT#127

    3   8445024823NO01NORMAN          CHANDELL    L16108 BRENNER PASS

    4   8446962268MC01MCMULLEN        KATIE       L221 W. 42ND STREET

************

Number of difference sections found: 1

Number of difference records found: 6

DIFFERENCES /IGNORE=()/MERGED=1-

    USERS2:[AID_USERS.EDEFTP.PROCESSED]IDSA08BK.dat;9-

    USERS2:[AID_USERS.EDEFTP.PROCESSED]IDSA08BK.dat;7

---