[Download-List] Using SUBR in DOWNLOAD

Linda Miller lcmiller at aurora.edu
Wed Aug 20 09:01:04 EDT 2008


We also have a file that we store the current, previous, future terms in. Then we TRANS to the file to get the term to use in some computed columns. Other times we use DOWNLOAD in a paragraph followed by DATA statements to send the desired term to SELINP. 
----- Original Message ----- 
From: "Linda Lacelle" <llacelle at hamilton.edu> 
To: jsummers at transy.edu, "Cedarville DOWNLOAD Users" <download-list at cedarville.edu> 
Cc: "Sally Crawford" <scrawford at ocean.edu> 
Sent: Wednesday, August 20, 2008 6:31:51 AM GMT -06:00 US/Canada Central 
Subject: Re: [Download-List] Using SUBR in DOWNLOAD 

Hi what we did here was create a little file that has the current terms fall and spring, next fall. We use these to update once a year at the appropriate time so that we do not have to update several cron jobs that need a term inputted. We used to do it for each cron job, but soon found that we would miss some. So we came up with this. Since its inception we have tons of stuff that access it to get the term to run stuff. 

HTH, Linda 

Jeffery Summers wrote: 




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",STTR.STUDENT.ACAD.CRED,"X"),"T") 



Current Active Creds: 

SUBR("S.UDT.TRANS","STUDENT.TERMS",(CMPM.PERSON.ST.ID:"*2008.1*UG"),"STTR.ACTIVE.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. 
_______________________________________________
download-list mailing list download-list at cedarville.edu http://mail.cedarville.edu/mailman/listinfo/download-list 
_______________________________________________ download-list mailing list download-list at cedarville.edu http://mail.cedarville.edu/mailman/listinfo/download-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080820/ebb0e7e6/attachment.html>


More information about the download-list mailing list