#! /bin/sh # IPND reconcilliation # file name format #IPNDRU.... #IPNDRU.VICTR.0000001.0000255.001 # #IPNDRU is a constant # is the File Source # is the run number identifying the output file. # It indicates that the file was part of the # MMMMMMMth run of an extract for this filesource. # is a file sequence number with leading 0 # Span number. All Output On Request download files are limited # to 100,000 rows of data. The first 100,000 rows are written to # span 001. Requests that generate > 100,000 rows are written to # additional spanned files. If the number of output files exceeds 999, # the spanned number will increment to 1000 onwards. emailonly="" if [ -n "$1" ]; then emailonly="$1" echo "emailonly=[$emailonly]" fi if [ -n "$emailonly" ]; then logfile="ipnd1_recon_emailonly.log" else logfile="ipnd1_recon.log" fi rm -f "$logfile" #IPND_emailaddresslist="rod@transmit.com.au praveen.peiris@victrack.com.au jennifer.stevens@victrack.com.au robyn.douglas@victrack.com.au sam.musso@victrack.com.au Bharath.Bhooshan@VICTRACK.com.au" IPND_emailaddresslist="rod@transmit.com.au praveen.peiris@victrack.com.au jennifer.stevens@victrack.com.au" #IPND_emailaddresslist="rod@transmit.com.au " File_Source_Code="VICTR" CSP_Code="447" Data_Provider_Code="VICTRA" #ipnd_user="t_victr" ipnd_user="p_victr" #ipnd_system="ipndfts-t" ipnd_system="ipndfts-p" FSNfile="ipnd1.fseq" #ipnd_folder="/u/catcom/database/ipnd" ipnd_folder=`pwd` if [ -n "$1" ]; then DODBG="$1" fi DODBG="1" if [ -f "$FSNfile" ]; then File_Sequence_Number=`cat "$FSNfile" | awk -v "noinc=$noinc" '{ last_File_Sequence_Number = $1 if ( noinc == "1" ) File_Sequence_Number = last_File_Sequence_Number else File_Sequence_Number = last_File_Sequence_Number + 1 printf("%0.7d", File_Sequence_Number) }'` else File_Sequence_Number="0000001" fi # Testing #IPNDRU.VICTR.0000001.0000255.001 #File_Sequence_Number="0000255" File_Sequence_Number="0000305" echo "Testing..." >>"$logfile" echo "File_Sequence_Number=[$File_Sequence_Number]" >>"$logfile" Run_Number="0000002" reconfilename="IPNDRU.${File_Source_Code}.{Run_Number}.${File_Sequence_Number}" # Testing #reconfilename="IPNDRU.VICTR.0000001.0000255.001" reconfilename="IPNDRU.VICTR.0000002.0000305.001" # # download encrypted IPND reconciliation report file # srcf="${ipnd_user}@${ipnd_system}:./download/${reconfilename}.asc" # #destf="$ipnd_folder/${reconfilename}.asc" # destf="catcom@s-vm-telmax01:$ipnd_folder/${reconfilename}.asc" # ipnd1_scp "$srcf" "$destf" # # # decrypte recon file # # # decrypt err file # chmod 644 ${reconfilename}.asc # echo "ipnd1_recon: gpgdec ${reconfilename}" >>"$logfile" # gpgdec "${reconfilename}" # # # copy .asc encrypted recon file and decrypted version to intermediate box # ipnd1_send "${reconfilename}.asc" # ipnd1_send "${reconfilename}" # # # move recon file and .asc incrypted version to save # mv "${reconfilename}.asc" I_P_N_D.save # mv "${reconfilename}" I_P_N_D.save # Testing only Testing="$2" if [ "$2" = "Testing" ]; then Testing="$3" if [ -z "$Testing" ]; then Testing="3" fi fi # get yesterdays date yesterday_YYYYMMDD=`date -d "1 day ago" '+%Y%m%d'` today_YYYYMMDD=`date '+%Y%m%d'` if [ -z "$emailonly" ]; then awk -v "RECON=1" \ -v "DODBG=$DODBG" \ -v "Testing=$Testing" \ -v "yesterday_YYYYMMDD=$yesterday_YYYYMMDD" \ -v "today_YYYYMMDD=$today_YYYYMMDD" \ -v "File_Source_Code=$File_Source_Code" \ -v "CSP_Code=$CSP_Code" \ -v "Data_Provider_Code=$Data_Provider_Code" \ -v "File_Sequence_Number=$File_Sequence_Number" \ -v "outfile=$File_Sequence_Number" \ -v "reconfilename=I_P_N_D.save/${reconfilename}" \ -f ipnd1_recon.awk >>"$logfile" fi #cat "$logfile" # file to send in email recon_err_csv_filename="ipnd1_recon_err.csv" recon_uploadfilename="ipnd1_recon_upload.${File_Sequence_Number}" recon_VT_transactionsfilename="recon_VT_transactions" # zipped in ipnd1_recon.awk ipnd1_recon_zipfile="ipnd_recon_${today_YYYYMMDD}.zip" # email result emaillist="rod@transmit.com.au" #emaillist="telmax21@mon2" #emaillist="rshepp44@gmail.com" if [ -n "$emailonly" -a "$emailonly" != "1" ]; then emaillist="$emailonly" fi attfiles="$ipnd1_recon_zipfile" t21em_content=" Please find the attached zip $ipnd1_recon_zipfile containing these files... $recon_err_csv_filename - Reconcillation discrepancies $recon_uploadfilename - IPND upload file to correct reconcillation discrepancies $recon_VT_transactionsfilename - Current Victrack Telmax21 Directory and TBS Services used to compare $reconfilename - IPND reconcillation extract data file download from IPND server " export t21em_content ematt "$attfiles" "IPND Reconcillation $today_YYYYMMDD" "$emaillist" exit 0