[Download-List] Using SUBR in DOWNLOAD

[Jeffery Summers]

I appreciate the quick reply!

 

We think alike!  This was the way I first designed the extract.  SELINP does
have problems in UI, unfortunately, but when running this manually in
terminal it still runs fine and dandy.  But now I am changing it to run it
without user input through cron.  Hard-coding terms in the various computed
columns isn't a problem but it is tedious and easy to forget a field here
and there (even when its documented. ;-)).  The eligibility extract/related
fields only need to be updated once per term and if possible I'd like to
have a one-stop-shop within DOWNLOAD if possible.  

 

Thanks,

Jeff

 

From: Sally Crawford [mailto:scrawford at ocean.edu] 
Sent: Tuesday, August 19, 2008 3:51 PM
To: jsummers at transy.edu; Cedarville DOWNLOAD Users
Subject: RE: [Download-List] Using SUBR in DOWNLOAD

 

In the STUDENTS file, I have 'dict items' like this:

LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM.GPA BY TYP BY @ID TYP LOC CONV
NAM
E FORMAT SM ASSOC 15:47:46 Aug 19 2008 1

@ID............ TYP LOC.......... CONV NAME........... FORMAT SM ASSOC.....

 

O06.STU.TERM.GP I   SUBR('S.MIO.T MD25 TERM GPA        7R     S

A                   RANS','STUDEN

                    T.TERMS',STUD

                    ENTS.ID:"*":

                    SUBR('SELINP'

                    ,PROMPT.TERM,

                    'Enter TERM',

                    ''):"*UG", 'S

                    TTR.TERM.GPA'

                    ,'X') 

 

R18 computed columns don't like SELINP, as far as I know.

 

For current credits, I use this in the STUDENTS file:

 

LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM.CRED BY TYP BY @ID TYP LOC
CONV NA
ME FORMAT SM ASSOC 15:49:29 Aug 19 2008 1

@ID............ TYP LOC.......... CONV NAME........... FORMAT SM ASSOC.....

 

O06.STU.TERM.CR I   SUBR('S.GET.T MD25 TERM CRED       5R     S

ED                  ERM.CREDS',ST ,

                    UDENTS.ID,SUB

                    R('SELINP',PR

                    OMPT.TERM, 'E

                    nter TERM',''

                    ),'UG','R') 

 

If you want to look at additional terms, you can do this:

 

LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM2.GPA BY TYP BY @ID TYP LOC
CONV NA
ME FORMAT SM ASSOC 15:50:24 Aug 19 2008 1

@ID............ TYP LOC.......... CONV NAME........... FORMAT SM ASSOC.....

 

O06.STU.TERM2.G I   SUBR('S.MIO.T MD25 TERM2 GPA       7R     S

PA                  RANS','STUDEN

                    T.TERMS',STUD

                    ENTS.ID:"*":

                    SUBR('SELINP'

                    ,PROMPT.TERM2

                    ,'Enter TERM2

                    ',''):"*UG",

                    'STTR.TERM.GP

                    A','X')

 

LIST DICT STUDENTS WITH @ID LIKE O06.STU.TERM2.CRED BY TYP BY @ID TYP LOC
CONV N
AME FORMAT SM ASSOC 15:50:42 Aug 19 2008 1

@ID............ TYP LOC.......... CONV NAME........... FORMAT SM ASSOC.....

 

O06.STU.TERM2.C I   SUBR('S.GET.T MD25 TERM2 CRED      8R     S

RED                 ERM.CREDS',ST ,

                    UDENTS.ID,SUB

                    R('SELINP',PR

                    OMPT.TERM2, '

                    Enter TERM2',

                    ''),'UG','R')  

 

----------------------------------------------------------------------------
--------------
Sally Crawford * Systems Analyst
Ocean County College * 1 College Drive, Toms River, NJ 08753-2239
Tel 732-255-0400 x2156 * Fax 732-255-0501
scrawford at ocean.edu * www.sungardhe.com * www.ocean.edu

CONFIDENTIALITY: This e-mail (including any attachments) may contain
confidential,
proprietary and privileged information, and unauthorized disclosure or use
is prohibited.
If you received this e-mail in error, please notify the sender and delete
this e-mail
from your system. 

 

 


  _____  


From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Jeffery Summers
Sent: Tuesday, August 19, 2008 3:42 PM
To: download-list at cedarville.edu
Subject: [Download-List] Using SUBR in DOWNLOAD

I'd like to simplify an extract I run for athletic eligibility.  Instead of
changing terms in 3 or 4 spots I'd prefer to change them in one place,
preferably the DOWNLOAD script.  

 

Below is the text from the computed columns currently used:

 

Last Major Term GPA:

SUBR("S.CALC.STU.GPA",TRANS("STUDENT.TERMS",CMPM.PERSON.ST.ID:"*2007.2*UG",S
TTR.STUDENT.ACAD.CRED,"X"),"T")

 

Current Active Creds:

SUBR("S.UDT.TRANS","STUDENT.TERMS",(CMPM.PERSON.ST.ID:"*2008.1*UG"),"STTR.AC
TIVE.CRED")

 

As written they don't work; I get error messages when it reaches the part
where I build the key.  Is something like the above possible in DOWNLOAD or
must I continue to use my computed columns?

 

Thanks,

 

Jeffery Summers

Transylvania University

Administrative Computing

300 N. Broadway

Lexington, KY 40508

jsummers at transy.edu

 


  _____  


Successfully Scanned by the McAfee SIG 3200 Appliance. 

  _____  

Successfully scanned by McAfee SIG 3200 Appliance. 



Successfully Scanned by the McAfee SIG 3200 Appliance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080819/b23a8334/attachment.html>