[Download-List] Using SUBR in DOWNLOAD
Linda Lacelle
llacelle at hamilton.edu
Wed Aug 20 07:31:51 EDT 2008
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 <mailto: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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080820/663f9fb0/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: llacelle.vcf
Type: text/x-vcard
Size: 305 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080820/663f9fb0/attachment.vcf>
More information about the download-list
mailing list