: /bin/sh INFILE="TIMS_Upload.csv" exec 2>&1 >aeie2.log if [ ! -f "$INFILE" ]; then echo "No $INFILE to process - " `date` exit 0 fi #---------------------------------------------------- saveoldandloadnewdata() { #unload -d catcom -t directcustom -f arc/old/dc.unl.$$ #unload -d catcom -t directtemplate -f arc/old/dt.unl.$$ #unload -d catcom -t gengroup -f arc/old/gg.unl.$$ #unload -d catcom -t groupname -f arc/old/gn.unl.$$ #unload -d catcom -t gnextra -f arc/old/gne.unl.$$ # runisql 2>&1 <&1 #strip CR (^M) and SUB (^Z) from input data tr -d "\032\015" <$INFILE | awk -F'|' -v"today=$today" -f aeie2.awk 2>&1 #---------------------------------------------------- #201|E2BOD001|E|2|TOP.BOD.BOD|B00000000|1|T|| awk -F'|' ' { print $2 | "sort | uniq -d >gn.d" print $2 | "sort -u >gn.u" } ' < gn.unl #E2BOD001|BOARD OF DIRECTORS| awk -F'|' ' { print $1 | "sort | uniq -d >gne.d" print $1 | "sort -u >gne.u" } ' < gne.unl awk -F'|' ' { print $1 | "sort | uniq -d >gg.d" print $1 | "sort -u >gg.u" } ' < gg.unl if [ -s gn.d ]; then echo "ERROR: aeie2; duplicate grids created (see gn.d) - " `date` exit 1 fi if [ -s gne.d ]; then echo "ERROR: aeie2; duplicate grids created (see gne.d) - " `date` exit 1 fi if [ -s gg.d ]; then echo "ERROR: aeie2; duplicate child grids created (see gg.d) - " `date` exit 1 fi if [ -s gne.d ]; then echo "ERROR: aeie2; dupgrids created (see gne.d) - " `date` exit 1 fi if [ -s ugrid1.unl -a -s gn.unl -a -s gg.unl -a -s gne.unl -a -s dt.unl -a -s dc.unl ]; then echo "INFO: aeie2; installing new data - " `date` mv $INFILE arc/${INFILE}.$$ cp ugrid1.unl arc/ugrid.unl.$$ cp rej.unl arc/rej.unl.$$ mv ugrid1.unl ugrid.unl saveoldandloadnewdata else echo "" echo "" echo "" echo "" echo "" echo "" echo "" echo "" echo "" echo "" echo "" echo "ERROR: aeie2; 1 or more 0 size load files created - " `date` echo " DATA NOT LOADED" fi # send email tail -36 aeie2.log | mail -s "Integral Directory/Hierarchy Import" support@transmit.com.au Aust_CSC_-_NMS_VOICE@csc.com exit 0