I gang

MySQL database program

We have a telephone system that records call information into a mysql database. I need this information to be analyzed so we can spot trends etc. I would like to be able to display and print line graphs of calls taken and calls lost etc between two dates. Also be able to break down which how many each extension takes (theres only 3 extensions). I would also like reports automatically produced and emailed.

1) The shift reports that needs to be sent automatically following a schedule (which we can edit)

The email reports would need to give the details in text
e.g.
Date- From Time To Time
Total calls: 100 Total lost: 51
Ext 225: 50
Ext 227: 25
Ext 228: 25

then it would need a line graph displaying the same information embedded in the email.
I don't want a PDF, it's needs to be displayed so the person receiving it can't ignore it because they can't be bothered to open another program.

I also want a trigger to put a warning in the subject field when missed calls exceed a certain amount
(we need this amount to editable as an option)


2) The weekly report needs to sent out just in graph form which we will print out and store.
This will need to go to a different email address.

3) We then need a facilty to create a report at will.

We need to have the following choices.
By date range, including/excluding extension, including/excluding queues, answer/unanswered calls.
Outputting results by text / graphs /both.

Hope this helps you get a better idea of what we are after.

Færdigheder: Databehandling, Excel

Se mere: program line, mysql database , lost excel, program graphs, data trends excel, display mysql, reports mysql , can program, database processing, telephone system, display program, theres, reports mysql database, calls database, print excel, program program excel, excel data mysql database, telephone data, database system excel, graphs excel, excel extension, database information, mysql database extension, data excel mysql, mysql display

Om arbejdsgiveren:
( 10 bedømmelser ) Cheltenham, United Kingdom

Projekt-ID: #310033

Tildelt til:

Arenabpo

Hello, we are web application experts, we can do this project, pls view PMB, Thank you!

$360 USD in 4 dage
(11 bedømmelser)
5.0

34 freelancere byder i gennemsnit $436 for dette job

asyraf1156

Hi.. I can do this program for you.. Please see Pm.. Thanks

$250 USD in 3 dage
(31 bedømmelser)
5.0
becomeexpert

Easy job for me. Thanks, Tonmay

$500 USD in 7 dage
(22 bedømmelser)
4.4
wincent

i can finish this work.

$500 USD in 5 dage
(6 bedømmelser)
3.8
VisualTech585

Hi, I can help with this project. Please read PMB.

$750 USD in 14 dage
(1 bedømmelse)
3.8
musaulker

I'm PHP-MySQL expert working over 5 years. I can do this job. I'm sending details in personal message..

$750 USD in 15 dage
(2 bedømmelser)
3.7
majormf

i am ready

$300 USD in 6 dage
(2 bedømmelser)
3.4
guruplus

Hi, Pls refer my PMB Regards Balaji

$250 USD in 5 dage
(3 bedømmelser)
3.2
mjtk

Expert in LAMP, experience in additional open source tools which will yield a clean, functional, and robust system tailored to your needs. Please see PMB.

$750 USD in 14 dage
(1 bedømmelse)
2.8
supweb

Hi, I have view your requirement ,it's clear, let me do it for you, we will provide quality [url removed, login to view] you!

$400 USD in 4 dage
(1 bedømmelse)
2.4
megsoft

Please check your PMB

$350 USD in 7 dage
(2 bedømmelser)
1.9
hendrolim

check PM please

$500 USD in 10 dage
(1 bedømmelse)
1.0
mydearjani

I WILL DO IT FOR YOU AS SOON AS U CAN POSSIBLE

$500 USD in 5 dage
(0 bedømmelser)
0.0
acumensofttech

Hello, Pls check pmb for more details. Thanks Sourav Acumen Soft Technologies

$750 USD in 25 dage
(0 bedømmelser)
0.0
minhas760

Hi dear. We are willing to work on this job. Please! consider this bid and see pmb for further talk. Thank you.

$400 USD in 7 dage
(0 bedømmelser)
0.0
restart

Please see the details in my PMB.

$600 USD in 10 dage
(0 bedømmelser)
3.8
corinth24891

Corinth2489: Hi, I got your PM. Please send me the information from the MySQL database (the tables) or one of the CDR file (In my Broadsoft PABX experience, the machine produces CDR files which I need to analyze and Mere

$250 USD in 30 dage
(0 bedømmelser)
0.0
ciha

Please contact me. Thank you.

$350 USD in 14 dage
(0 bedømmelser)
0.0
gthijs

Hello Sir/Madam, I work as a data typish in a big company for a few years. I know for sure to finish this kind of job correctly and fast. Please contact/email me. Thank you. Gthijs

$300 USD in 3 dage
(0 bedømmelser)
0.0
rriahi

Dear Sir I have over 10 years of data manipulation and data mining experience. I would like to provide your company our high quality services. Please contact me for more details regarding tools and work methods. Mere

$500 USD in 7 dage
(0 bedømmelser)
0.0
cyberdocuments

Hi, I have gone over your RFP,Please Read My PMB for vital information regarding the bid

$500 USD in 15 dage
(0 bedømmelser)
2.6