Completed

shell script to INV data

I need a script where you in the top inform the period it must search in the log for. This period must always be two months. The first month is chosen as a specific month and year and the other month is set by default to the previous month, but it must be possible to change this to another month.

Hereafter it must for each line in the file [login to view URL] take the company name

Output listen must be made based on the company names, which are in the right side after : in Jul.txt. It must generate a list with the information below, whereafter the list must be send by mail to two different e-mail adresses.

Name Answered Total incomming calls

[login to view URL] Customer service 234 324

European-love Customer service 214 356

[login to view URL] Customer service 225 387

It must show answered and total incoming for both the first and the second month - it must also show the difference between the two months, where the difference is shown in red if it is positive and in black if it is positive. This must be shown both as the pure number and as a percentage. The oldest month must always be the basis, so if we have chosen January 2019 with 200 calls and June 2019 with 250 calls, then the difference is 50 calls (shown in black) and 25% (also shown in black). If we had then chosen June 2019 with 250 calls and August 2019 with 200 calls, then the difference is 50 calls (shown in red) and 20% (also shown in red).

[login to view URL] looks like this, it will continously change, thus the script must be able to automatically get the information from the file with the new changes.

/showname/442030342716 : [login to view URL] Customer service

/showname/442030342717 : European-love Customer service

/showname/442030342718 : [login to view URL] Customer service

/showname/442030342719 : [login to view URL] Customer service

/showname/442030342720 : [login to view URL] Customer service

/showname/442030342721 : [login to view URL] Customer service

/showname/442030342722 : [login to view URL] Customer service

/showname/442030342723 : [login to view URL] Customer service

/showname/442030342724 : [login to view URL] Customer service

Answered is found by searching like this

cat /var/log/messenger* | grep 'ubber = [login to view URL] Customer service' | wc -l

Total incomming is found by searching like this

cat /var/log/messenger* | grep 'ubber1 = [login to view URL] Customer service' | wc -l

Skills: Shell Script

See more: shell script check remotely number processes runing, bash shell script number format, bash shell script valid number, format phone number shell script, shell script telephone number word, shell script format number, inserting data mysql shell script, shell script determine argument number word, phone number shell script, shell script sort files number order bash, shell script remove line number, print formated number shell script, 4d result number check shell script, move data flash shell script, mysql export view data csv shell script, mysql shell script data entry, shell script check phone number format, shell script check valid number, shell script read data html file, shell script extract data website

About the Employer:
( 39 reviews ) Stenløse, Denmark

Project ID: #21266515

Awarded to:

VarunUnix

Hi I can write a shell script as per your requirement. My only doubt is the variation in [login to view URL] as you mentioned. WIll there be a change in format of [login to view URL] file ? If interested pls contact me. Thanks

$110 USD in 3 days
(19 Reviews)
4.1

3 freelancers are bidding on average $150 for this job

blackwhite123

Hello, I am pleasure with your job for shell script to INV data. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, bu More

$140 USD in 7 days
(0 Reviews)
0.0
logssky

I have 8+ years of experience in working Telecom projects & worked with CDRs. I would be able to deliver the best report as you expect.

$200 USD in 6 days
(0 Reviews)
0.0