QUESTION:
We have some
processes in Banner (specifically
Student Schedules) that we would like to
run late at night. Although there is a
“submit” time feature on the Banner job
submission form, this feature is not yet
activated. We do have FormFusion, from
Evisions, and would like to use this
product. Need help in setting the
Banner process to execute late at night
and when complete, call FormFusion to
e-mail the output. How can we do this?
ANSWER:
Below is a shell file that was provided
by one of our clients.
Robert Long, UALR
Financial Systems Administrator
U of Arkansas at Little Rock
2801 South University Ave
Little Rock, AR 72204-1099
(501) 569-8620
This script was written specifically for
the TSRCBIL process to be run in
Schedule/Bill mode.
There are two scripts shown below. The
first script (TWRBILL.SHL) is the script
that will actually call TSRCBIL and
then, in turn, call FormFusion to e-mail
the bills. You will need to modify this
script to provide the name of the
printer where the output will be printed
(in case e-mail does not execute) and
the necessary parameters for EVILP.
#!/bin/bash -v
#
# twrbill.shl
#
#cd /home/jobsub/bills
tstamp=`date +%Y%m%d_%H`
LOG=twrbill.log
. ./billprm.shl >>$LOG
$EXE_HOME/tsrcbil -f <twrbill.prm
>$LOG
evilp -evilis tsrcbil.lis -eviproc
tsrcbil -evispp confirm -eviuser
user -evipass password -eviprint lp -c
-o dp -dPRINTER_NAME >>$LOG
mv tsrcbil.lis tsrcbil_${tstamp}.lis
>>$LOG
rm tsrcbil.lis_0_pdf.lis >>$LOG
rm tsrcbil.lis_0 >>$LOG
This second script is used to build the
parameters that will be used as input to
the process being executed. You will
need to make sure the proper parameters
and userid and password are specified.
The user should have permission to
execute TSRCBIL.
#!/bin/bash
##
## billprm.shl
##
rm twrbill.prm
PFILE=twrbill.prm
term=200510
today=`date +%d-%b-%Y`
billparm=EBILLS
duedate=14-JAN-2005
UIDPSWD = USERID/PASSWOR
echo $UIDPSWD >> $PFILE
echo "" >> $PFILE
echo "$term" >> $PFILE
echo "$today" >> $PFILE
echo "1MA" >> $PFILE
echo "2BI" >> $PFILE
echo "3PR" >> $PFILE
echo "" >> $PFILE
echo "N" >> $PFILE
echo "COLLECTOR" >> $PFILE
echo "EBILL" >> $PFILE
echo "" >> $PFILE
echo "N" >> $PFILE
echo "Y" >> $PFILE
echo "$billparm" >> $PFILE
echo "%" >> $PFILE
echo $duedate >> $PFILE
echo $today >> $PFILE
echo "Y" >> $PFILE
echo "66" >> $PFILE
You then set up a cron job to call the
twrbill.shl at the time you want it
executed. 
