<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'>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.<br>----- Original Message -----<br>From: "Linda Lacelle" <llacelle@hamilton.edu><br>To: jsummers@transy.edu, "Cedarville DOWNLOAD Users" <download-list@cedarville.edu><br>Cc: "Sally Crawford" <scrawford@ocean.edu><br>Sent: Wednesday, August 20, 2008 6:31:51 AM GMT -06:00 US/Canada Central<br>Subject: Re: [Download-List] Using SUBR in DOWNLOAD<br><br><title></title>
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.<br>
<br>
HTH, Linda<br>
<br>
Jeffery Summers wrote:
<blockquote cite="mid:011201c90237$0c6cbf00$25463d00$@edu">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">I
appreciate the quick reply!</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">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. </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Thanks,</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Jeff</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";"> Sally
Crawford
[<a class="moz-txt-link-freetext" href="mailto:scrawford@ocean.edu" target="_blank">mailto:scrawford@ocean.edu</a>] <br>
<b>Sent:</b> Tuesday, August 19, 2008 3:51 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:jsummers@transy.edu" target="_blank">jsummers@transy.edu</a>; Cedarville DOWNLOAD Users<br>
<b>Subject:</b> RE: [Download-List] Using SUBR in DOWNLOAD</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">In
the STUDENTS file, I have 'dict items' like this:</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">LIST
DICT STUDENTS WITH @ID LIKE O06.STU.TERM.GPA BY TYP BY @ID TYP LOC CONV
NAM<br>
E FORMAT SM ASSOC 15:47:46 Aug 19 2008
1
<br>
@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC..... <br>
<br>
O06.STU.TERM.GP I SUBR('S.MIO.T MD25 TERM
GPA 7R
S
<br>
A
RANS','STUDEN
<br>
T.TERMS',STUD
<br>
ENTS.ID:"*":
<br>
SUBR('SELINP'
<br>
,PROMPT.TERM,
<br>
'Enter
TERM',
<br>
''):"*UG",
'S
<br>
TTR.TERM.GPA'
<br>
,'X') </span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">R18
computed columns don't like SELINP, as far as I know.</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">For
current credits, I use this in the STUDENTS file:</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">LIST
DICT STUDENTS WITH @ID LIKE O06.STU.TERM.CRED BY TYP BY @ID TYP LOC
CONV NA<br>
ME FORMAT SM ASSOC 15:49:29 Aug 19 2008
1
<br>
@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC..... <br>
<br>
O06.STU.TERM.CR I SUBR('S.GET.T MD25 TERM
CRED 5R
S
<br>
ED
ERM.CREDS',ST
,
<br>
UDENTS.ID,SUB
<br>
R('SELINP',PR
<br>
OMPT.TERM,
'E
<br>
nter TERM',''
<br>
),'UG','R') </span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">If
you want to look at additional terms, you can do this:</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">LIST
DICT STUDENTS WITH @ID LIKE O06.STU.TERM2.GPA BY TYP BY @ID TYP LOC
CONV NA<br>
ME FORMAT SM ASSOC 15:50:24 Aug 19 2008
1
<br>
@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC..... <br>
<br>
O06.STU.TERM2.G I SUBR('S.MIO.T MD25 TERM2
GPA 7R
S
<br>
PA
RANS','STUDEN
<br>
T.TERMS',STUD
<br>
ENTS.ID:"*":
<br>
SUBR('SELINP'
<br>
,PROMPT.TERM2
<br>
,'Enter TERM2
<br>
',''):"*UG",
<br>
'STTR.TERM.GP
<br>
A','X')</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Courier New";">LIST
DICT STUDENTS WITH @ID LIKE O06.STU.TERM2.CRED BY TYP BY @ID TYP LOC
CONV N<br>
AME FORMAT SM ASSOC 15:50:42 Aug 19 2008
1
<br>
@ID............ TYP LOC.......... CONV NAME........... FORMAT SM
ASSOC..... <br>
<br>
O06.STU.TERM2.C I SUBR('S.GET.T MD25 TERM2
CRED 8R
S
<br>
RED
ERM.CREDS',ST
,
<br>
UDENTS.ID,SUB
<br>
R('SELINP',PR
<br>
OMPT.TERM2,
'
<br>
Enter
TERM2',
<br>
''),'UG','R') </span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<p><span style="font-size: 10pt;">------------------------------------------------------------------------------------------<br>
Sally Crawford * Systems Analyst<br>
Ocean County College * 1 College Drive, Toms River, NJ 08753-2239<br>
Tel 732-255-0400 x2156 * Fax 732-255-0501<br>
<a class="moz-txt-link-abbreviated" href="mailto:scrawford@ocean.edu" target="_blank">scrawford@ocean.edu</a> * <a class="moz-txt-link-abbreviated" href="http://www.sungardhe.com" target="_blank">www.sungardhe.com</a> * <a class="moz-txt-link-abbreviated" href="http://www.ocean.edu" target="_blank">www.ocean.edu</a><br>
<br>
CONFIDENTIALITY: This e-mail (including any attachments) may contain
confidential,<br>
proprietary and privileged information, and unauthorized disclosure or
use is
prohibited.<br>
If you received this e-mail in error, please notify the sender and
delete this
e-mail<br>
from your system.</span> </p>
<div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<blockquote style="margin-top: 5pt; margin-right: 0in; margin-bottom: 5pt;">
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
<div class="MsoNormal" style="text-align: center;" align="center"><span style="font-size: 12pt; font-family: "Times New Roman","serif";">
<hr align="center" size="3" width="100%"></span></div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">
<a class="moz-txt-link-abbreviated" href="mailto:download-list-bounces@cedarville.edu" target="_blank">download-list-bounces@cedarville.edu</a>
[<a class="moz-txt-link-freetext" href="mailto:download-list-bounces@cedarville.edu" target="_blank">mailto:download-list-bounces@cedarville.edu</a>] <b>On Behalf Of </b>Jeffery
Summers<br>
<b>Sent:</b> Tuesday, August 19, 2008 3:42 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a><br>
<b>Subject:</b> [Download-List] Using SUBR in DOWNLOAD</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal">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. </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Below is the text from the computed columns
currently used:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Last Major Term GPA:</p>
<p class="MsoNormal">SUBR("S.CALC.STU.GPA",TRANS("STUDENT.TERMS",CMPM.PERSON.ST.ID:"*2007.2*UG",STTR.STUDENT.ACAD.CRED,"X"),"T")</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Current Active Creds:</p>
<p class="MsoNormal">SUBR("S.UDT.TRANS","STUDENT.TERMS",(CMPM.PERSON.ST.ID:"*2008.1*UG"),"STTR.ACTIVE.CRED")</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Jeffery Summers</p>
<p class="MsoNormal">Transylvania University</p>
<p class="MsoNormal">Administrative Computing</p>
<p class="MsoNormal">300 N. Broadway</p>
<p class="MsoNormal">Lexington, KY 40508</p>
<p class="MsoNormal"><a href="mailto:jsummers@transy.edu" target="_blank">jsummers@transy.edu</a></p>
<p class="MsoNormal"> </p>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><span style="font-size: 12pt; font-family: "Times New Roman","serif";">
<hr align="center" size="3" width="100%"></span></div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";">Successfully
Scanned by the McAfee SIG 3200 Appliance. </span></p>
</div>
</blockquote>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><span style="font-size: 12pt; font-family: "Times New Roman","serif";">
<hr align="center" size="3" width="100%"></span></div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";">Successfully
scanned by McAfee SIG 3200 Appliance. </span></p>
</div>
</div>
<div>
<hr>Successfully Scanned by the McAfee SIG 3200 Appliance.
</div>
<pre><hr size="4" width="90%">
_______________________________________________
download-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a>
<a class="moz-txt-link-freetext" href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a>
</pre>
</blockquote>
<br>_______________________________________________
download-list mailing list
download-list@cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list
</div></body></html>