Introduction – UW Admissions Applications
Auto is an application created by Octamer that automates the acquisition of Undergraduate Applications from the Online vendor. It securely downloads and archives the Applications as PDF documents that can be viewed, reviewed, printed and otherwise utilized by the Enrollment Services sections of Admissions and Data Services, International Admissions and the Registrar’s Processing Center. Along with the many sources of Transcripts, Auto makes possible a Computer based repository that can be made available selectively to University Staff based on standardized roles to minimize paper and processing steps and to maximize timely throughput of Applicants. The current Online vendor is CollegeNet.
Basic AUTO Functionality
CollegeNet creates Applications based upon Online forms that are developed by Admissions. There are several types for Applicant categories; Freshmen, Post-Bac, Intl-Freshman, Transfer, etc. Some Application types are bundled with included documentation such as a Transcript or Letter. Every weekday morning at 02:00 hrs CollegeNet runs their Imager process and creates Zipped batches of 50 PDF’d Applications. A flat file is provided to allow the SDB import process to digest the incoming Applications. A UW-IT process gathers and utilizes the flat file and sends an Acknowledgement back to CollegeNet (at 03:00 hrs) to let their process know that the Applications have been received. The Imager process creates XML log files which are used by Auto to receive and sort the Applications. The Auto Button on the Microsoft Access form calls a batch script which does the bulk of Auto processing.
UAM – Undergrad Admissions Modernization
UAM incorporates some of Auto’s functionality within it. Currently Auto is still processing Transfer and International applications with Transcripts appended. Auto creates the Error Status reports which are shared with Admissions, Residency and OUR.
AUTO – ongoing
Created in 2011 and before, AUTO continues to be used until the transition to UAM is complete. Now used for Transfer applications, online and post-bac. When attached transcripts for International Transfer applications became unattached a new process was developed to re-attach them so when they are printed they are printed together. When the migration from Vitcos to Agora occurred a new work around for the 2FA was developed. Constant maintenance and improvement are implemented as needed. AUTO was one of the main business processes that was migrated from the Datamgmt Domain utilizing the Server Venus to the new UWIT Delegated Domain EM and the fileserver Nikon.
Auto Script
#/bin/bash
# fileinfo.sh
# New UW UG Application Script
# 2011-1103 -das-
#
/bin/date
AUTO="f:/1web/auto/"
ABIN="f:/1web/abin/" # point to progs
PATH="/bin:$ABIN:$PATH" # cygwin files
#
cd $AUTO # goto working area
#
# setup variables
export DATER=`date +%Y%m%d` # yyyymmdd
export DATEW=`date +%y%m%d` # yymmdd
export DATEA=`date +%Y-%m%d` # yyyy-mmdd
export ARGV=`basename "$1"` # or pass in a date
if ! (test -e $ARGV) then
export CC=`echo $ARGV|awk '{print substr($0,1,2)};'` # century
export YY=`echo $ARGV|awk '{print substr($0,3,2)};'` # year
export MM=`echo $ARGV|awk '{print substr($0,5,2)};'` # month
export DD=`echo $ARGV|awk '{print substr($0,7,2)};'` # day
export DATER=`echo $CC$YY$MM$DD`
export DATEW=`echo $YY$MM$DD`
export DATEA=`echo $CC$YY-$MM$DD`
fi
export APPNAME=$DATEA.txt
#
echo "Automatic Download for $DATER"
#
# DEBUG
rm -f Control* *.zip # delete previous files
#
# retrieve files from CN sftp - archive or new
/bin/date
echo $ABIN/pscp.exe -2 -4 -C -p -sftp -batch -pw "This is for UW" uwftp@sftp.applyweb.com:UW_Imager/archive/$CC$YY/$MM/$DD/\*\_$DATER\_\* .
# DEBUG
$ABIN/pscp.exe -2 -4 -C -p -sftp -batch -pw "This is for uwi" uwftp@sftp.applyweb.com:UW_Imager/archive/$CC$YY/$MM/$DD/\*\_$DATER\_\* .
if ! (test -e Control*) then
echo $ABIN/pscp.exe -2 -4 -C -p -sftp -batch -pw "This is for UW" uwftp@sftp.applyweb.com:UW_Imager/\*\_$DATER\_\* .
# DEBUG
$ABIN/pscp.exe -2 -4 -C -p -sftp -batch -pw "This is for uwi" uwftp@sftp.applyweb.com:UW_Imager/\*\_$DATER\_\* .
fi
/bin/date
#DEBUG
echo cp *.zip f:/1Web/zipfiles
cp *.zip f:/1Web/zipfiles &
echo cp Control* f:/1Web/ctlfiles
cp Control* f:/1Web/ctlfiles
/bin/date
# 2011-1115 add cnet_appl_sea.111115 -das-
# 2011-1116 applhold as archive -das-
echo $ABIN/pscp.exe -i $ABIN/key.ppk -p dale@140.142.17.136:/issdbftp/sr/app/applhold/cnet_appl_sea.$DATEW $APPNAME
$ABIN/pscp.exe -i $ABIN/key.ppk -p dale@140.142.17.136:/issdbftp/sr/app/applhold//cnet_appl_sea.$DATEW $APPNAME
if ! (test -e $APPNAME) then
echo $ABIN/pscp.exe -i $ABIN/key.ppk -p dale@140.142.17.136:/issdbftp/sr/app/cnet_appl_sea.$DATEW $APPNAME
$ABIN/pscp.exe -i $ABIN/key.ppk -p dale@140.142.17.136:/issdbftp/sr/app//cnet_appl_sea.$DATEW $APPNAME
fi
# archive webfile
echo cp $APPNAME f:/applications
cp $APPNAME f:/applications
echo cp $APPNAME f:/1web/webfiles
cp $APPNAME f:/1web/webfiles
# get error report
echo $ABIN/pscp.exe -i $ABIN/key.ppk -p dale@140.142.17.136:/issdbftp/sr/app/ugadmerr.txt ugadmerr.txt
$ABIN/pscp.exe -i $ABIN/key.ppk -p dale@140.142.17.136:/issdbftp/sr/app/ugadmerr.txt ugadmerr.txt
/bin/date
echo cp ugadmerr.txt f:/1web/ERRfiles/`find -maxdepth 1 -name ugadmerr.txt -printf "err%Ty%Tm%Td.txt\n"`
cp ugadmerr.txt f:/1web/ERRfiles/`find -maxdepth 1 -name ugadmerr.txt -printf "err%Ty%Tm%Td.txt\n"`
# Folder code
#DIR="$( cd "$( dirname "$0" )" && pwd )"
# 00000000011111111112222222222333
# 12345678901234567890123456789012
# Control_7_20111103_000000581.xml
/bin/date
DIMS="f:/dims" # point to DIMS
CNTL="$( ls -1 Control* )" # daily Control XMLs
ZIPL="$( ls -1 *.zip )" # daily ZIPs
DDIR=$DIMS/$DATER # daily directory
PDIR=$DIMS/$DATER/print # batch print directory
# make print directory
echo mkdir -p $PDIR
mkdir -p $PDIR
echo rm -f $PDIR/dirlist.txt
rm -f $PDIR/dirlist.txt
# make sub directories and unzip PDFs
for j in $ZIPL;
do
/bin/date
echo
echo Process $j:
echo
ZBAT="$( basename `echo $j | awk 'BEGIN {FS="_"}{print $5}'` .zip ) "
ZBAT="$( expr $ZBAT + 0 )"
BDIR=$DIMS/$DATER/$ZBAT # batch sub-directory
FDIR="$( echo $j | awk 'BEGIN {FS="_"}{print $1$4}' )"
echo mkdir -p $BDIR/$FDIR
mkdir -p $BDIR/$FDIR
echo cp $j $BDIR/$FDIR
cp $j $BDIR/$FDIR
/bin/date
echo pushd $BDIR/$FDIR
pushd $BDIR/$FDIR
echo unzip -o $j
unzip -o $j
echo rm $j
rm $j
FLST="$( ls UW*.pdf )"
for i in $FLST;
do
echo $i "|" $BDIR/$FDIR "|" $BDIR/$FDIR/$i >> $PDIR/dirlist.txt
done
# don't copy pdfs
# echo cp *.pdf $PDIR
# cp *.pdf $PDIR
echo popd
popd
done
/bin/date