Database and 5 simple reports created for Asterisk system
$30-250 USD
Closed
Posted over 13 years ago
$30-250 USD
Paid on delivery
Client is looking for the development of a SQL or MySQL database to receive data from a third party and parse into fields that can be used to compile different ad hoc reports.
The phone system is Asterisk based and will automatically export the data into the database you create.
This is the schema of the data being imported into your database that you create:
src - Source of call
dst - Destination of call
callLength - duration of call in seconds disposition - Information about call status -- NO ANSWER, FAILED, ANSWERED, etc.
callDate - date and time of call
callType -- inbound, outbound, ext2ext, etc.
accountCode -- for future use
userField - for future use
This is a very simple database structure and considered a easy project. We will also need 5 reports created such as By Agent By Day, By Agent for Date Range, By Team, AGENT DETAIL REPORT and QUEUE SUMMARY REPORT. I can provide the examples of these reports to you.
If you are interested in doing this quick and simple task, please place a bid and I will send you the RFP with all of the detailed info as well as examples of the reports.
Hi this is Sandip having over 5 years of experience in asterisk. I pretty much understood what you want and can develop that in not more than 10 days of time. Don't worry about the pricing thing. Just send me more details about the project at my mail.
Hi,
I have over 5 years of experience in c#+vb.net+asp.net+sql server+sharepoint+ssrs+ssis.
I have strong knowledge of database and sql reporting services.
I can provide the sample of reports if you need.
I assure you I can do this task easily.
Regards
Mahakar
Hi, I am a database developer with plenty of experiences in SQL Report Writing . I have a question . What reporting tools are you going to use to display data ? If it is MS-SQL , then it is SQL Reporting Services Or Is it MS Access to show data ?
Hello,
My name is Jeff and I'd be interested in completing this project for you.
I have extensive experience with Asterisk CDR logs and database crunching and could quickly produce the database implementation and reporting per your specifications.
I've been working in large scale Asterisk implementations for several years and am confident that you'll be pleased with the quality of my work.
I can fine tune anything after the initial delivery if you're not completely happy after the initial presentation of course.
Assuming that you chose me for the project, I would have a couple of questions that would need to be answered before getting started:
1. Do you need me to setup the cdr_mysql settings on the Asterisk system(s)?
2. Do you have a preferred programming language for the reporting engine?
3. Will this system run on the Asterisk server itself?
4. Do you have any logos or aesthetic features that you'd like implemented in the reporting system?
Thank you for the consideration for the project and if you have any questions for me, I'd be happy to respond via private message.
Jeff