Need someone with some serious mysql skills to automate reports in excel

Discussion in 'Programming' started by oneclickfixed, May 7, 2008.

  1. #1
    Please give me a quote and terms. I need this done immediately. This is a serious project.

    Details:
    We are using an asterisk based phone system that captures all call data in a mysql database. There are 20 different extensions in the phone system. We need to have a report generated from this data 3 times per day and automatically emailed in an excel spreadsheet.

    The first page needs to be a summary sheet with a breakdown of how many inbound and outbound calls each extension made. And then show totals for everyone. Then we need a 1 page detailed report for each extension that details the caller id and call duration that they made in that time period.

    All the data is in a mysql database on a centos linux system. The asterisk flavor is Trixbox. So I guess it will be a cronjob that initiates the querry.

    Please let me know how much this will cost and how long it will take to complete. I prefer to hire someone that has a reputation here or somehow can show me that they can get the job done.
     
    oneclickfixed, May 7, 2008 IP
  2. saurabhj

    saurabhj Banned

    Messages:
    3,459
    Likes Received:
    61
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    Hi, I can work on this and will make it working for you. You can checkout my thread from my signature link regarding my services. Thanks !!
     
    saurabhj, May 7, 2008 IP
  3. phptechie

    phptechie Well-Known Member

    Messages:
    885
    Likes Received:
    10
    Best Answers:
    2
    Trophy Points:
    165
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    Hi,

    I'm a Freelance PHP MySQL programmer with 5+ yrs of exp , checkout my online portfolio linked in my signature.

    I can do those cron jobs (you have to provide me with the SHELL access to the server), pls do contact me via either of the messengers listed in my profile page.


    Looking fwd to hear back from you.
     
    phptechie, May 7, 2008 IP