Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
Notices
Welcome to
LinuxQuestions.org , a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free.
Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please
contact us . If you need to reset your password,
click here .
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a
virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month.
Click here for more info.
01-10-2014, 12:23 AM
#61
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
have a query..but let me check the details ..then will take your help..
Thanks in advance
Last edited by santosh0782; 01-10-2014 at 12:51 AM .
01-11-2014, 06:10 AM
#62
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
Hi Friend,
I am working on a new script, and getting this error:
Error:
./thrshld_rms.sh
./thrshld_rms.sh: line 105: unexpected token `newline', conditional binary operator expected
./thrshld_rms.sh: line 105: syntax error near `\'
./thrshld_rms.sh: line 105: ` "${val[1]}" -ge 5 && "${val[1]}" -lt 10 || \ '
=====================================
could you please help me to get this error resolved, and if there are any suggestions to make this script more human readable then please advise. Thanks a lot in advance :-)
script:
Sample 3 input files(Here as of now we are not sure, how the AverageAnswerDelay's data format would be, for now we got the screenshot of this dashboard where the AverageAnswerDelays time is shown in this format HH:MM:SS, considering the same i have written a script, but if it is only in seconds then will change it later, once i get the access to database then will check ,if it is coming in digits only like 30 sec or etc..or the format is same in HH:MM:SS)
also, in the script i used the threshold for all the fields(AverageAnswerDelay ie. AAD,AverageSpeedOfAnswer ie.ASA,CallsWaiting i.e Cwait,CallsAnswered ie.ACD,CallsAbandoned ie. Cabnd) if it crosses that then their color will get change.
Opt1.txt:
"AverageAnswerDelay"||','||"AverageSpeedOfAnswer"||','||"CallsWaiting"||','||"CallsAnswered"||','||" CallsAbandoned"
------------------------------------------------------------------------------------------------------------------
00:00:31,00:00:32,3,2,1
Opt2.txt:
"AverageAnswerDelay"||','||"AverageSpeedOfAnswer"||','||"CallsWaiting"||','||"CallsAnswered"||','||" CallsAbandoned"
------------------------------------------------------------------------------------------------------------------
00:00:34,00:00:03,9,3,1
Opt3.txt:
"AverageAnswerDelay"||','||"AverageSpeedOfAnswer"||','||"CallsWaiting"||','||"CallsAnswered"||','||" CallsAbandoned"
------------------------------------------------------------------------------------------------------------------
00:01:06,00:00:07,3,2,1
Code:
#-----------------------------------------------------------------#
#!/bin/ksh
#-----------------------------------------------------------------#
dataDir="/home/www/BCARD/data/rms/"
scriptDir="/home/www/BCARD/scripts/rms/"
Pge_Update_dt="/home/www/BCARD/custom/CEMV/RMS/"
#-----------------------------------------------------------------#
#. /wload/111t/app/oracle/oe/bin/oracle_login
#for i in opt1 opt2 opt3
#do
#sqlplus CEMVOWNER/c3mv0wner#@Dacon @$i.sql
#done
#opt1_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt1_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt1_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt1_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
opt1_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt1_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt1_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
#opt2_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt2_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt2_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt2_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
opt2_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt2_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt2_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
#opt3_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt3_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt3_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt3_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
opt3_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt3_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt3_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
#-----------------------------------------------------------------#
#Defining Variables for lables and their values
#-----------------------------------------------------------------#
val[1]=${opt1_AAD}
val[2]=${opt2_AAD}
val[3]=${opt3_AAD}
val[4]=${opt1_ASA}
val[5]=${opt2_ASA}
val[6]=${opt3_ASA}
val[7]=${opt1_Cwait}
val[8]=${opt2_Cwait}
val[9]=${opt3_Cwait}
val[10]=${opt1_ACD}
val[11]=${opt2_ACD}
val[12]=${opt3_ACD}
val[13]=${opt1_Cabnd}
val[14]=${opt2_Cabnd}
val[15]=${opt3_Cabnd}
lbl[1]='Opt 1 Sched : MaxWaitTime'
lbl[2]='Opt 2 Operations : MaxWaitTime'
lbl[3]='Option 3 : MaxWaitTime'
lbl[4]='Opt 1 Sched : AverageAnswerDelay'
lbl[5]='Opt 2 Operations : AverageAnswerDelay'
lbl[6]='Option 3 : AverageAnswerDelay'
lbl[7]='Opt 1 Sched : CallsWaiting'
lbl[8]='Opt 2 Operations : CallsWaiting'
lbl[9]='Option 3 : CallsWaiting'
lbl[10]='Opt 1 Sched : CallsAnswered'
lbl[11]='Opt 2 Operations : CallsAnswered'
lbl[12]='Option 3 : CallsAnswered'
lbl[13]='Opt 1 Sched : CallsAbandoned'
lbl[14]='Opt 2 Operations : CallsAbandoned'
lbl[15]='Option 3 : CallsAbandoned'
#-----------------------------------------------------------------#
#Drawing Pad
#-----------------------------------------------------------------#
#Reflecting data in 15 xmls for(MaxWaitTime/AverageAnswerDelay,AverageAnswerDelay/AverageSpeedOfAnswer,CallsWaiting,CallsAnswered/ACDCalls and CallsAbandoned/AbandonedCalls)
#-----------------------------------------------------------------#
for i in $(seq 1 1 15)
do
echo "<chart manageResize='1' bgAlpha='50' pallette='1' bgColor='FFFFFF' bgAlpha='45' bgRatio='50,45' bgAngle='90'>" >>${dataDir}/dp_${i}a.TMP.xml
echo "<annotations scaleText='1'>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotationGroup id='Grp1'>" >>${dataDir}/dp_${i}a.TMP.xml
if [[ $i -le 6 && \
"${val[1]}" -lt 5 || \
"${val[2]}" -lt 5 || \
"${val[3]}" -lt 5 || \
"${val[4]}" -lt 30 || \
"${val[5]}" -lt 30 || \
"${val[6]}" -lt 30 ]]
then
echo "GREEN"
echo " <annotation type='text' x='175' y='50' fontSize='80' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='17' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ $i -le 6 && \
"${val[1]}" -ge 5 && "${val[1]}" -lt 10 || \
"${val[2]}" -ge 5 && "${val[2]}" -lt 10 || \
"${val[3]}" -ge 5 && "${val[3]}" -lt 10 || \
"${val[4]}" -ge 30 && "${val[4]}" -lt 60 || \
"${val[5]}" -ge 30 && "${val[5]}" -lt 60 || \
"${val[6]}" -ge 30 && "${val[6]}" -lt 60 ]]
Then
echo "AMBER"
echo " <annotation type='text' x='175' y='50' fontSize='80' bold='1' label='${val[$i]}' color='FF7E00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='17' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ $i -le 6 && \
"${val[1]}" -ge 11 || \
"${val[2]}" -ge 11 || \
"${val[3]}" -ge 11 || \
"${val[4]}" -ge 60 || \
"${val[5]}" -ge 60 || \
"${val[6]}" -ge 60 ]]
then
echo "RED"
echo " <annotation type='text' x='175' y='50' fontSize='80' bold='1' label='${val[$i]}' color='FF0000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='17' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
if [[ $i -gt 6 && \
"${val[7]}" -lt 1 || \
"${val[8]}" -lt 1 || \
"${val[9]}" -lt 1 || \
"${val[10]}" -eq "${opt1_ACD}" || \
"${val[11]}" -eq "${opt2_ACD}" || \
"${val[12]}" -eq "${opt3_ACD}" || \
"${val[13]}" -lt 10 || \
"${val[14]}" -lt 10 || \
"${val[15]}" -lt 10 ]]
then
echo "GREEN"
echo " <annotation type='text' x='175' y='50' fontSize='100' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ $i -gt 6 && \
"${val[7]}" -lt 2 || \
"${val[8]}" -lt 2 || \
"${val[9]}" -lt 2 || \
"${val[13]}" -lt 20 || \
"${val[14]}" -lt 20 || \
"${val[15]}" -lt 20 ]]
then
echo "AMBER"
echo " <annotation type='text' x='175' y='50' fontSize='100' bold='1' label='${val[$i]}' color='FF7E00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ $i -gt 6 && \
"${val[7]}" -gt 5 || \
"${val[8]}" -gt 5 || \
"${val[9]}" -gt 5 || \
"${val[13]}" -lt 21 || \
"${val[14]}" -lt 21 || \
"${val[15]}" -lt 21 ]]
then
echo "RED"
echo " <annotation type='text' x='175' y='50' fontSize='100' bold='1' label='${val[$i]}' color='FF0000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
echo " </annotationGroup>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</annotations>" >>${dataDir}/dp_${i}a.TMP.xml
echo "<styles>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <definition>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <style name='myBevel' type='Bevel' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " </definition>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <application>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <apply toObject='Background' styles='myBevel' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " </application>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</styles>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</chart>" >>${dataDir}/dp_${i}a.TMP.xml
done
#-----------------------------------------------------------------#
#To Populate Today's date and Time
#-----------------------------------------------------------------#
last_date=$(date)
echo '<?xml version="1.0"?>'>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<root>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<date>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<LastUpdatedDt>$last_date</LastUpdatedDt>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "</date>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "</root>">>${Pge_Update_dt}/LastUpdatedDate.xml
#-----------------------------------------------------------------#
Last edited by santosh0782; 01-11-2014 at 06:46 AM .
01-11-2014, 07:00 AM
#63
LQ Veteran
Registered: Sep 2003
Posts: 10,532
This might be a simple typo:
Code:
elif [[ $i -le 6 && \
"${val[1]}" -ge 5 && "${val[1]}" -lt 10 || \
"${val[2]}" -ge 5 && "${val[2]}" -lt 10 || \
"${val[3]}" -ge 5 && "${val[3]}" -lt 10 || \
"${val[4]}" -ge 30 && "${val[4]}" -lt 60 || \
"${val[5]}" -ge 30 && "${val[5]}" -lt 60 || \
"${val[6]}" -ge 30 && "${val[6]}" -lt 60 ]]
Then # that should be then, not Then
echo "AMBER"
Also: The first line of the script must be the she-bang. Remove the the lines in front of it.
1 members found this post helpful.
01-11-2014, 07:19 AM
#64
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
ok, Thanks a lot :-)
one more thing, actually i am awwy from my workdesk, and i have taken this code in an e-mail, now on my laptop i have linux in Virtual Box, do you know any way to copy this code from my e-mail to Linux in Virtual Box, so that i can copy all this code to linux and try running this script here only.
i was trying to copy code and paste but its not working.. is there any way?
01-11-2014, 07:36 AM
#65
LQ Veteran
Registered: Sep 2003
Posts: 10,532
I'm not sure I can help with this one, I hardly ever use Windows (haven't used windows at home since 1997) and I'm not familiar with Virtual Box.
If Virtual box does not have the capability to copy-paste to from Windows I would save the attachment (or copy/paste to a new text file if the script is part of the e-mail body) and scp it to the VM (using winScp).
Do make sure that the file in the VM is a Linux text file and not a Windows one (different EOL). You can use the dos2unix command to convert if needed.
1 members found this post helpful.
01-11-2014, 07:52 AM
#66
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
ok, No Problem..
Really appreciated your help.
Thanks a lot once again :-)
01-11-2014, 11:10 PM
#67
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
Hi,
Can we convert time into seconds and seconds into to time again.
for e.g. 00:01:03 want to convert this time to seconds only
and 258 seconds i want to convert it into the HH:MM:SS format, can we do that?
01-12-2014, 02:38 AM
#68
LQ Veteran
Registered: Sep 2003
Posts: 10,532
Quote:
Originally Posted by
santosh0782
Hi,
Can we convert time into seconds and seconds into to time again.
for e.g. 00:01:03 want to convert this time to seconds only
and 258 seconds i want to convert it into the HH:MM:SS format, can we do that?
Are you looking for something like this:
Code:
#!/bin/bash
# time to seconds
TIME="0:4:18"
TS=( ${TIME//:/ } )
time2sec=$(( ${TS[0]}*3600 + ${TS[1]}*60 + ${TS[2]} ))
echo "$TIME -> $time2sec"
# seconds to time
SECONDS="258"
((h=${SECONDS}/3600))
((m=(${SECONDS}%3600)/60))
((s=${SECONDS}%60))
sec2time="$h:$m:$s" # without a possible leading zero
#sec2time=$(printf "%02d:%02d:%02d\n" $h $m $s) # with a possible leading zero
echo "$SECONDS -> $sec2time"
exit 0
This would be the result:
Code:
0:4:18 -> 258
258 -> 0:4:18
or, when needing the possible leading zero:
Code:
0:4:18 -> 258
258 -> 00:04:18
Last edited by druuna; 01-12-2014 at 02:42 AM .
Reason: Added leading zero possibility
1 members found this post helpful.
01-12-2014, 09:45 PM
#69
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
Thanks a lot Friend :-) , i was looking out for the same. :-)
01-12-2014, 09:48 PM
#70
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
Hi Friend,
as i am working on new script, and i am unable to find out where is the error its giving me. could you please help me with the below code to find out the error and remove it.
Error message:
./thrshld_rms.sh: line 77: syntax error at line 104: `newline' unexpected
Code:
#!/bin/ksh
dataDir="/home/www/BCARD/data/rms/"
scriptDir="/home/www/BCARD/scripts/rms/"
#RMS_xml="/home/www/BCARD/data/rms/"
#RMS_TMP_xml="/home/www/BCARD/data/rms/"
Pge_Update_dt="/home/www/BCARD/custom/CEMV/RMS/"
#-----------------------------------------------------------------#
#. /wload/111t/app/oracle/oe/bin/oracle_login
#for i in opt1 opt2 opt3
#do
#sqlplus CEMVOWNER/c3mv0wner#@Dacon @$i.sql
#done
opt1_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt1_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt1_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
#opt1_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt1_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt1_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt1_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
opt2_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt2_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt2_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
#opt2_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt2_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt2_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt2_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
opt3_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt3_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt3_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
#opt3_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt3_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt3_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt3_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
#-----------------------------------------------------------------#
#Defining Variables for lables and their values
#-----------------------------------------------------------------#
val[1]=${opt1_AAD}
val[2]=${opt2_AAD}
val[3]=${opt3_AAD}
val[4]=${opt1_ASA}
val[5]=${opt2_ASA}
val[6]=${opt3_ASA}
val[7]=${opt1_Cwait}
val[8]=${opt2_Cwait}
val[9]=${opt3_Cwait}
val[10]=${opt1_ACD}
val[11]=${opt2_ACD}
val[12]=${opt3_ACD}
val[13]=${opt1_Cabnd}
val[14]=${opt2_Cabnd}
val[15]=${opt3_Cabnd}
lbl[1]='Opt 1 Sched : MaxWaitTime'
lbl[2]='Opt 2 Operations : MaxWaitTime'
lbl[3]='Option 3 : MaxWaitTime'
lbl[4]='Opt 1 Sched : AverageAnswerDelay'
lbl[5]='Opt 2 Operations : AverageAnswerDelay'
lbl[6]='Option 3 : AverageAnswerDelay'
lbl[7]='Opt 1 Sched : CallsWaiting'
lbl[8]='Opt 2 Operations : CallsWaiting'
lbl[9]='Option 3 : CallsWaiting'
lbl[10]='Opt 1 Sched : CallsAnswered'
lbl[11]='Opt 2 Operations : CallsAnswered'
lbl[12]='Option 3 : CallsAnswered'
lbl[13]='Opt 1 Sched : CallsAbandoned'
lbl[14]='Opt 2 Operations : CallsAbandoned'
lbl[15]='Option 3 : CallsAbandoned'
#-----------------------------------------------------------------#
#Drawing Pad
#-----------------------------------------------------------------#
#Reflecting data in 15 xmls for(MaxWaitTime/AverageAnswerDelay,AverageAnswerDelay/AverageSpeedOfAnswer,CallsWaiting,CallsAnswered/ACDCalls and CallsAbandoned/AbandonedCalls)
#-----------------------------------------------------------------#
for i in $(seq 1 1 15)
do
echo "<chart manageResize='1' bgAlpha='50' pallette='1' bgColor='FFFFFF' bgAlpha='45' bgRatio='50,45' bgAngle='90'>" >>${dataDir}/dp_${i}a.TMP.xml
echo "<annotations scaleText='1'>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotationGroup id='Grp1'>" >>${dataDir}/dp_${i}a.TMP.xml
if [[ $i -le 6 && \
"${val[1]}" -lt 5 || \
"${val[2]}" -lt 5 || \
"${val[3]}" -lt 5 || \
"${val[4]}" -lt 30 || \
"${val[5]}" -lt 30 || \
"${val[6]}" -lt 30 ]]
then
echo " <annotation type='text' x='175' y='50' fontSize='80' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='17' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ $i -le 6 && \
"${val[1]}" -ge 5 && "${val[1]}" -lt 10 || \
"${val[2]}" -ge 5 && "${val[2]}" -lt 10 || \
"${val[3]}" -ge 5 && "${val[3]}" -lt 10 || \
"${val[4]}" -ge 30 && "${val[4]}" -lt 60 || \
"${val[5]}" -ge 30 && "${val[5]}" -lt 60 || \
"${val[6]}" -ge 30 && "${val[6]}" -lt 60 ]]
then
echo " <annotation type='text' x='175' y='50' fontSize='80' bold='1' label='${val[$i]}' color='FF7E00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='17' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ $i -le 6 && \
"${val[1]}" -ge 11 || \
"${val[2]}" -ge 11 || \
"${val[3]}" -ge 11 || \
"${val[4]}" -ge 60 || \
"${val[5]}" -ge 60 || \
"${val[6]}" -ge 60 ]]
then
echo " <annotation type='text' x='175' y='50' fontSize='80' bold='1' label='${val[$i]}' color='FF0000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='17' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
if [[ $i -gt 6 && \
"${val[7]}" -lt 1 || \
"${val[8]}" -lt 1 || \
"${val[9]}" -lt 1 || \
"${val[10]}" -eq "${opt1_ACD}" || \
"${val[11]}" -eq "${opt2_ACD}" || \
"${val[12]}" -eq "${opt3_ACD}" || \
"${val[13]}" -lt 10 || \
"${val[14]}" -lt 10 || \
"${val[15]}" -lt 10 ]]
then
echo " <annotation type='text' x='175' y='50' fontSize='100' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ $i -gt 6 && \
"${val[7]}" -lt 2 || \
"${val[8]}" -lt 2 || \
"${val[9]}" -lt 2 || \
"${val[13]}" -lt 20 || \
"${val[14]}" -lt 20 || \
"${val[15]}" -lt 20 ]]
then
echo " <annotation type='text' x='175' y='50' fontSize='100' bold='1' label='${val[$i]}' color='FF7E00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ $i -gt 6 && \
"${val[7]}" -gt 5 || \
"${val[8]}" -gt 5 || \
"${val[9]}" -gt 5 || \
"${val[13]}" -lt 21 || \
"${val[14]}" -lt 21 || \
"${val[15]}" -lt 21 ]]
then
echo " <annotation type='text' x='175' y='50' fontSize='100' bold='1' label='${val[$i]}' color='FF0000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='175' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
echo " </annotationGroup>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</annotations>" >>${dataDir}/dp_${i}a.TMP.xml
echo "<styles>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <definition>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <style name='myBevel' type='Bevel' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " </definition>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <application>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <apply toObject='Background' styles='myBevel' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " </application>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</styles>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</chart>" >>${dataDir}/dp_${i}a.TMP.xml
done
#-----------------------------------------------------------------#
#To Populate Today's date and Time
#-----------------------------------------------------------------#
last_date=$(date)
echo '<?xml version="1.0"?>'>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<root>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<date>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<LastUpdatedDt>$last_date</LastUpdatedDt>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "</date>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "</root>">>${Pge_Update_dt}/LastUpdatedDate.xml
#-----------------------------------------------------------------#
01-13-2014, 03:22 AM
#71
LQ Veteran
Registered: Sep 2003
Posts: 10,532
Do you get that error message with the script you posted or one that might be different? I'm asking because the lines mentioned in the error message point to an empty line (line 77) and to a seemingly random val[X] entry (line 104).
At first glance and without knowing what this code is supposed to do I only see one thing that might have caused the error: One or more val[X] array entries do not have the content you expect it to be.
- First thing you should do is to put double quotes around the assignments:
Code:
val[1]="${opt1_AAD}"
val[2]="${opt2_AAD}"
val[3]="${opt3_AAD}"
etc
- Second thing: Check the content of the val[X] entries to see if they are what is expected (which could be a typo or unforseen entry in your input file). Insert this piece of code after
lbl[15]='Option 3 : CallsAbandoned' and before
#Drawing Pad :
Code:
for X in $(seq 1 15)
do
echo "val[$X] : ${val[$X]}"
echo "lbl[$X] : ${lbl[$X]}"
done
exit 0
This will show the content of the val and lbl array's (and exit when that is done).
1 members found this post helpful.
01-13-2014, 03:41 AM
#72
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
Thanks a ton Friend :-)
I written the code below way now, and it working fine.
Code:
#!/bin/ksh
dataDir="/home/www/BCARD/data/rms/"
scriptDir="/home/www/BCARD/scripts/rms/"
#RMS_xml="/home/www/BCARD/data/rms/"
#RMS_TMP_xml="/home/www/BCARD/data/rms/"
Pge_Update_dt="/home/www/BCARD/custom/CEMV/RMS/"
#-----------------------------------------------------------------#
#. /wload/111t/app/oracle/oe/bin/oracle_login
#for i in opt1 opt2 opt3
#do
#sqlplus CEMVOWNER/c3mv0wner#@Dacon @$i.sql
#done
opt1_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt1_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt1_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
#opt1_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt1_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt1_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt1_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt1.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
opt2_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt2_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt2_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
#opt2_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt2_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt2_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt2_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt2.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
opt3_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #MaxWaitTime (AverageAnswerDelay)
#opt3_AAD=$(awk -F ',' '{ print $1 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt3_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #AverageAnswerDelay (AverageSpeedOfAnswer)
#opt3_ASA=$(awk -F ',' '{ print $2 }' ${scriptDir}/opt1.txt|grep '^[0-9]'|awk -F ':' 'BEGIN{OFS=""} { print $1,$2,$3 }')
opt3_Cwait=$(awk -F ',' '{ print $3 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsWaiting (CallsWaiting)
opt3_ACD=$(awk -F ',' '{ print $4 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsAnswered (ACDCalls)
opt3_Cabnd=$(awk -F ',' '{ print $5 }' ${scriptDir}/opt3.txt|grep '^[0-9]') #CallsAbandoned (AbandonedCalls)
#-----------------------------------------------------------------#
#Defining Variables for lables and their values
#-----------------------------------------------------------------#
val[1]="${opt1_AAD}"
val[2]="${opt2_AAD}"
val[3]="${opt3_AAD}"
val[4]="${opt1_ASA}"
val[5]="${opt2_ASA}"
val[6]="${opt3_ASA}"
val[7]="${opt1_Cwait}"
val[8]="${opt2_Cwait}"
val[9]="${opt3_Cwait}"
val[10]="${opt1_ACD}"
val[11]="${opt2_ACD}"
val[12]="${opt3_ACD}"
val[13]="${opt1_Cabnd}"
val[14]="${opt2_Cabnd}"
val[15]="${opt3_Cabnd}"
lbl[1]='Opt 1 Sched : MaxWaitTime'
lbl[2]='Opt 2 Operations : MaxWaitTime'
lbl[3]='Option 3 : MaxWaitTime'
lbl[4]='Opt 1 Sched : AverageAnswerDelay'
lbl[5]='Opt 2 Operations : AverageAnswerDelay'
lbl[6]='Option 3 : AverageAnswerDelay'
lbl[7]='Opt 1 Sched : CallsWaiting'
lbl[8]='Opt 2 Operations : CallsWaiting'
lbl[9]='Option 3 : CallsWaiting'
lbl[10]='Opt 1 Sched : CallsAnswered'
lbl[11]='Opt 2 Operations : CallsAnswered'
lbl[12]='Option 3 : CallsAnswered'
lbl[13]='Opt 1 Sched : CallsAbandoned'
lbl[14]='Opt 2 Operations : CallsAbandoned'
lbl[15]='Option 3 : CallsAbandoned'
#-----------------------------------------------------------------#
#Drawing Pad
#-----------------------------------------------------------------#
#Reflecting data in 15 xmls for(MaxWaitTime/AverageAnswerDelay,AverageAnswerDelay/AverageSpeedOfAnswer,CallsWaiting,CallsAnswered/ACDCalls and CallsAbandoned/AbandonedCalls)
#-----------------------------------------------------------------#
for i in $(seq 1 1 15)
do
echo "<chart manageResize='1' bgAlpha='50' pallette='1' bgColor='FFFFFF' bgAlpha='45' bgRatio='50,45' bgAngle='90'>" >>${dataDir}/dp_${i}a.TMP.xml
echo "<annotations scaleText='1'>" >${dataDir}/dp_${i}a.TMP.xml
echo " <annotationGroup id='Grp1'>" >>${dataDir}/dp_${i}a.TMP.xml
if [[ $i -le 3 ]]
then
if [[ "${val[$i]}" -lt 5 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='85' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ "${val[$i]}" -ge 5 && "${val[$i]}" -le 10 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='85' bold='1' label='${val[$i]}' color='FF7E00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ "${val[$i]}" -ge 11 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='85' bold='1' label='${val[$i]}' color='FF0000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
fi
if [[ $i -gt 3 && $i -le 6 ]]
then
if [[ "${val[$i]}" -le 30 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='85' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ "${val[$i]}" -gt 30 && "${val[$i]}" -le 60 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='85' bold='1' label='${val[$i]}' color='FF7E00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ "${val[$i]}" -gt 60 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='85' bold='1' label='${val[$i]}' color='FF0000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
fi
if [[ $i -gt 6 && $i -le 9 ]]
then
if [[ "${val[$i]}" -lt 1 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='100' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ "${val[$i]}" -ge 1 && "${val[$i]}" -le 5 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='100' bold='1' label='${val[$i]}' color='FF7E00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ "${val[$i]}" -gt 5 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='100' bold='1' label='${val[$i]}' color='FF0000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
fi
if [[ $i -gt 9 && $i -le 12 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='100' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
if [[ $i -gt 12 && $i -le 15 ]]
then
if [[ "${val[$i]}" -lt 10 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='100' bold='1' label='${val[$i]}' color='00FF00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ "${val[$i]}" -ge 10 && "${val[$i]}" -le 20 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='100' bold='1' label='${val[$i]}' color='FF7E00' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
elif [[ "${val[$i]}" -gt 20 ]]
then
echo " <annotation type='text' x='212.5' y='50' fontSize='100' bold='1' label='${val[$i]}' color='FF0000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " <annotation type='text' x='212.5' y='110' fontSize='18' bold='1' label='${lbl[$i]}' color='000000' align='center' font='tohama,helvetica,arial,sans-serif' />" >>${dataDir}/dp_${i}a.TMP.xml
fi
fi
echo " </annotationGroup>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</annotations>" >>${dataDir}/dp_${i}a.TMP.xml
echo "<styles>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <definition>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <style name='myBevel' type='Bevel' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " </definition>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <application>" >>${dataDir}/dp_${i}a.TMP.xml
echo " <apply toObject='Background' styles='myBevel' />" >>${dataDir}/dp_${i}a.TMP.xml
echo " </application>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</styles>" >>${dataDir}/dp_${i}a.TMP.xml
echo "</chart>" >>${dataDir}/dp_${i}a.TMP.xml
done
#-----------------------------------------------------------------#
#To Populate Today's date and Time
#-----------------------------------------------------------------#
last_date=$(date)
echo '<?xml version="1.0"?>'>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<root>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<date>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "<LastUpdatedDt>$last_date</LastUpdatedDt>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "</date>">>${Pge_Update_dt}/LastUpdatedDate.xml
echo "</root>">>${Pge_Update_dt}/LastUpdatedDate.xml
#-----------------------------------------------------------------#
01-13-2014, 05:00 AM
#73
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
Hi Friend,
Code:
opt1_AAD=$(awk -F ',' '{ print $1 }' opt1.txt|grep '^[0-9]')
opt1_ASA=$(awk -F ',' '{ print $2 }' opt1.txt|grep '^[0-9]')
opt2_AAD=$(awk -F ',' '{ print $1 }' opt2.txt|grep '^[0-9]')
opt2_ASA=$(awk -F ',' '{ print $2 }' opt2.txt|grep '^[0-9]')
opt3_AAD=$(awk -F ',' '{ print $1 }' opt3.txt|grep '^[0-9]')
opt3_ASA=$(awk -F ',' '{ print $2 }' opt3.txt|grep '^[0-9]')
# time to seconds
for t in "${opt1_AAD}" "${opt1_ASA}" "${opt2_AAD}" "${opt2_ASA}" "${opt3_AAD}" "${opt3_ASA}"
do
TIME="${t}"
TS=( ${TIME//:/ } )
time2sec=$(( ${TS[0]}*3600 + ${TS[1]}*60 + ${TS[2]} ))
echo "$TIME -> $time2sec"
done
output:
00:01:12 -> 72
01:01:52 -> 3712
00:00:11 -> 11
00:00:05 -> 5
00:00:16 -> 16
00:00:07 -> 7
how could i get the output in the below format:
opt1_AAD=72
opt1_ASA=3712
opt2_AAD=11
opt2_ASA=5
opt3_AAD=16
opt3_ASA=7
so that i'll use these values to populate in the xmls by just putting ${opt1_AAD} ... etc
01-13-2014, 06:10 AM
#74
LQ Veteran
Registered: Sep 2003
Posts: 10,532
I think the above approach is the hard way to accomplish this.
I assume that this:
Code:
opt1_AAD=$(awk -F ',' '{ print $1 }' opt1.txt|grep '^[0-9]')
fills opt1_AAD with a time (HH:MM:SS) from opt1.txt
I'm rather sure that the awk statement can be expanded to do all you want (get the time and convert it to seconds). However, I cannot provide you with an example 'cause I don't know what opt1.txt looks like.....
Here's a solution for doing it the hard way:
Code:
#!/bin/bash
opt1_AAD="00:01:12"
opt1_ASA="01:01:52"
opt2_AAD="00:00:11"
opt2_ASA="00:00:05"
opt3_AAD="00:00:16"
opt3_ASA="00:00:07"
opt1_AAD=$(X=( ${opt1_AAD//:/ }) ; echo "$((${X[0]}*3600+${X[1]}*60+${X[2]}))")
opt1_ASA=$(X=( ${opt1_ASA//:/ }) ; echo "$((${X[0]}*3600+${X[1]}*60+${X[2]}))")
opt2_AAD=$(X=( ${opt2_AAD//:/ }) ; echo "$((${X[0]}*3600+${X[1]}*60+${X[2]}))")
opt2_ASA=$(X=( ${opt2_ASA//:/ }) ; echo "$((${X[0]}*3600+${X[1]}*60+${X[2]}))")
opt3_AAD=$(X=( ${opt3_AAD//:/ }) ; echo "$((${X[0]}*3600+${X[1]}*60+${X[2]}))")
opt3_ASA=$(X=( ${opt3_ASA//:/ }) ; echo "$((${X[0]}*3600+${X[1]}*60+${X[2]}))")
You could use a loop to do this:
Code:
#!/bin/bash
opt1_AAD="00:01:12"
opt1_ASA="01:01:52"
opt2_AAD="00:00:11"
opt2_ASA="00:00:05"
opt3_AAD="00:00:16"
opt3_ASA="00:00:07"
for t in opt1_AAD opt1_ASA opt2_AAD opt2_ASA opt3_AAD opt3_ASA
do
X=( ${!t//:/ } )
eval ${t}=$(( ${X[0]}*3600 + ${X[1]}*60 + ${X[2]} ))
done
01-13-2014, 06:20 AM
#75
Member
Registered: Nov 2013
Posts: 132
Original Poster
Rep:
ok, Sample files:
opt1.txt :
"OldestCallWaiting"||','||"AverageSpeedOfAnswer"||','||"CallsWaiting"||','||"CallsAnswered"||','||"C allsAbandoned"
------------------------------------------------------------------------------------------------------------------
00:01:12,01:01:52,3,2,1
opt2.txt:
"OldestCallWaiting"||','||"AverageSpeedOfAnswer"||','||"CallsWaiting"||','||"CallsAnswered"||','||"C allsAbandoned"
------------------------------------------------------------------------------------------------------------------
00:00:11,00:00:05,9,3,1
opt3.txt:
"OldestCallWaiting"||','||"AverageSpeedOfAnswer"||','||"CallsWaiting"||','||"CallsAnswered"||','||"C allsAbandoned"
------------------------------------------------------------------------------------------------------------------
00:00:16,00:00:07,7,2,1
now , how could we use it in below variables to convert the file timings into seconds
Code:
opt1_AAD=$(awk -F ',' '{ print $1 }' opt1.txt|grep '^[0-9]')
opt1_ASA=$(awk -F ',' '{ print $2 }' opt1.txt|grep '^[0-9]')
opt2_AAD=$(awk -F ',' '{ print $1 }' opt2.txt|grep '^[0-9]')
opt2_ASA=$(awk -F ',' '{ print $2 }' opt2.txt|grep '^[0-9]')
opt3_AAD=$(awk -F ',' '{ print $1 }' opt3.txt|grep '^[0-9]')
opt3_ASA=$(awk -F ',' '{ print $2 }' opt3.txt|grep '^[0-9]')
All times are GMT -5. The time now is 05:38 PM .
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know .
Latest Threads
LQ News