#!/bin/ksh
find /devl/bfx/ecif/etl/visibility/parameterfiles/ -exec grep -l CNTCT {} \; | while read file
do ls -l $file
sed -e 's/CNTCT/CNTCTST/' $file> $file.tmp
mv $file.tmp $file
done
find /devl/bfx/ecif/etl/visibility/parameterfiles/ -exec grep -l DBCIBNR {} \; | while read file
do ls -l $file
sed  's/DBCIBNR/DBCIBC4/g' $file> $file.tmp
mv $file.tmp $file
done

#!/bin/bash
echo "Today is $(date)"
echo " This script will copy Prod Unix code into Breakfix Env."
echo "Choose Project: (1-18)"
echo " 1- CAM Extracts"
echo " 2- CASNCOA Extracts"
echo " 3- CDC Extracts"
echo " 4- CTMNZ Extracts"
echo " 5- CYBERLIFE  Extracts"
echo " 6- DW_ASCII_Conversion"
echo " 7- ECIF2CIFLOW"
echo " 8- ECIFNZ Extracts"
echo " 9- KEYNOTE Extracts"
echo " 10- NRS Extracts "
echo " 11- VANTAGE Extracts"
echo " 12- Prospects Extracts"
echo " 13- Visibility Extracts"
echo " 14- DW Extracts"
echo " 15- CASS MASN"
echo " 16- NWBank"
echo " 17- EASE"
echo " 18- Email Harvest"
echo " 19- CIM Stats Extract"
echo " 20- Change Identifier"
echo " 21- OFAC Extract"
echo " 22- Common Objects"
echo " 23- PLB Prefix Extract"
echo " 24- EDelivery Extract"
echo " 25- Farm Bureau Extract"
echo " 26- CNT Harvest"
echo " 27- AKM2ECIF"
echo " 28- CTM Claim Account Load"
echo " 29- Batch Processor"
echo " 30- Unload2MF"
echo " 31- ECIF_BATCHSTAT"
echo " 32- ALSEXTRACT"
echo " 33- SUPPORT"

echo "  ************************************"
echo ""
read Project
export Project1=$Project
case $Project in
        1) export Project=CAM_Extracts
	export ProjectTarget=camextract
        ;;
        2) export Project=casncoaext
	export ProjectTarget=casncoaext
        ;;
        3) export Project=cdcextract
	export ProjectTarget=cdcextract
        ;;
        4) export Project=ctmnzextract
	export ProjectTarget=ctmnzext
        ;;
        5) export Project=CYBERLIFE_EXTRACT
	export ProjectTarget=cyberlife
        ;;
        6) export Project=DW_ASCII_Conversion
	export ProjectTarget=dwascconv
        ;;
        7) export Project=ECIF2CIFLOW
	export ProjectTarget=ecif2ci
        ;;
        8) export Project=ecifnzext
	export ProjectTarget=ecifnzext
        ;;
        9) export Project=KEYNOTE_EXTRACT
	export ProjectTarget=keynote
        ;;
        10) export Project=NRS_EXTRACT
	export ProjectTarget=nrsextract
        ;;
        11) export Project=VANTAGE_EXTRACT
	export ProjectTarget=vantage
        ;;
        12) export Project=PROSPECTS_EXTRACT
	export ProjectTarget=prospects
        ;;
        13) export Project=visibility
	export ProjectTarget=visibility
        ;;
        14) export Project=dwextract
	export ProjectTarget=dwextract
        ;;
        15) export Project=cassmasn
	export ProjectTarget=cassmasn
        ;;
        16) export Project=nwbank
	export ProjectTarget=nwbank
        ;;
        17) export Project=ease
	export ProjectTarget=ease
        ;;
        18) export Project=emailharvest
	export ProjectTarget=emailharvest
        ;;
        19) export Project=cimstatsextract
	export ProjectTarget=cimstatsextract
        ;;
        20) export Project=changeid
	export ProjectTarget=changeid
        ;;
        21) export Project=ofacextract
	export ProjectTarget=ofacextract
        ;;
        22) export Project=common_objects
	export ProjectTarget=common_objects
        ;;
        23) export Project=plb_prefix_extract
	export ProjectTarget=plbextract
        ;;
        24) export Project=edelivery_extract
	export ProjectTarget=edelextrct
        ;;
        25) export Project=farm_bureau_extract
	export ProjectTarget=farm_bureau_extract
        ;;
        26) export Project=cntharvest
	export ProjectTarget=cntharvest
        ;;
        27) export Project=akm2ecif
	export ProjectTarget=akm2ecif
        ;;
        28) export Project=ctmclactld
	export ProjectTarget=ctmclactld
        ;;
        29) export Project=batchproc
	export ProjectTarget=batchproc
        ;;
        30) export Project=unload2mf
	export ProjectTarget=unload2mf
        ;;
	31) export Project=ECIF_BATCHSTAT
	export ProjectTarget=batchstats	
        ;;
	32) export Project=ALSEXTRACT
	export ProjectTarget=alsextract 
	;;
	33) export Project=support
	export ProjectTarget=support
        ;;
esac
case $Project1 in
        1) export Project=CAM_Extracts
	export ProjectTarget=camextract
	scp  ecifetls@boom.nwie.net:/vol/ecif/etl/$ProjectTarget/bin/*.* ecifetls@boom.nwie.net:/devl/bfx/ecif/etl/$ProjectTarget/bin/
	scp  ecifetls@boom.nwie.net:/vol/ecif/etl/$ProjectTarget/scriptfiles/*.* ecifetls@boom.nwie.net:/devl/bfx/ecif/etl/$ProjectTarget/scriptfiles/
	scp  ecifetls@boom.nwie.net:/vol/ecif/etl/$ProjectTarget/parameterfiles/*.* ecifetls@boom.nwie.net:/devl/bfx/ecif/etl/$ProjectTarget/parameterfiles/
	scp  ecifetls@boom.nwie.net:/vol/ecif/etl/$ProjectTarget/sql/*.* ecifetls@boom.nwie.net:/devl/bfx/ecif/etl/$ProjectTarget/sql/
	scp  ecifetls@boom.nwie.net:/vol/ecif/etl/$ProjectTarget/maestro/*.* ecifetls@boom.nwie.net:/devl/bfx/ecif/etl/$ProjectTarget/maestro/
	scp  ecifetls@boom.nwie.net:/vol/ecif/etl/$ProjectTarget/syncsort/*.* ecifetls@boom.nwie.net:/devl/bfx/ecif/etl/$ProjectTarget/syncsort/
	ssh  ecifetls@boom.nwie.net export "'$ProjectTarget'" < /webdata/ecif/etl/scripts/dbchange.sh ;;
esac

#!/bin/ksh

find /devl/bfx/ecif/etl/"${ProjectTarget}"/parameterfiles/ -exec grep -l "CNTCT" {} \; | while read file
do
     ls -l "${file}"
     sed -e 's/CNTCT/CNTCTST/g' "${file}" > "${file}.tmp"
     mv "${file}.tmp" "${file}" 
done
# 
find /devl/bfx/ecif/etl/"${ProjectTarget}"/parameterfiles/ -exec grep -l "DBCIBNR" {} \; | while read file
do
     ls -l "${file}"
     sed -e 's/DBCIBNR/DBCIBC4/g' "${file}" > "${file}.tmp" 
     mv "${file}.tmp" "${file}"
done