#!/bin/sh
# File	: upl_netapp-data.sh
# By	: Maarten.deBoer@Atos.net, 171227
# Subject	: Script to upload NetApp-data
PGM=`basename $0|cut -d\. -f1`
VER="0.1"
TMP="/tmp/${PGM}.$$"

MAILTO="maarten.deboer@atos.net"

#BASEDIR="/appl/mdr/afsp/NL"
BASEDIR="`pwd | sed 's/scripts//'|sed 's/bin//'`"
LOG="${BASEDIR}/log/${PGM}.log"

UPLFILE="/home/nl19471/upload/ATOS-EMEA--SAM_Report--December_2017_AFSP.csv"

echo "`date` ${PGM} v${VER} started."|tee -a ${LOG}
echo "BASEDIR=${BASEDIR}"
echo "UPLFILE=${UPLFILE}"
sleep 1

touch ${TMP}

cat ${UPLFILE} | while read LINE
do
#  echo "${LINE}"

  CONTRACT=`echo ${LINE}|awk -F\; '{print $1}'`
  SERNR=`echo ${LINE}|awk -F\; '{print $4}'|sed 's/ //g'|grep [0-9]`
  SYSTEMNAME=`echo ${LINE}|awk -F\; '{print $5}'`
  EOSDATE=`echo ${LINE}|awk -F\; '{print $10}'`

  if [ "${SERNR}" != "" ]; then
    echo "|${SERNR}|${SYSTEMNAME}|${EOSDATE}|${CONTRACT}|"
  fi




done  # cat UPLFILE

rm ${TMP}
exit 0