Script to collect CDR's from server, and input data into DB
- or -
Post a project like this1706
£400(approx. $502)
- Posted:
- Proposals: 8
- Remote
- #2488521
- OPPORTUNITY
- PRE-FUNDED
- Awarded
Description
Experience Level: Expert
Hi,
We have a large wholesale account with a mobile wholesale provider. We have a server containing all CDRs for mobile devices, which is updated on a 4 hr or 24hr basis depending when the network send it over.
The CDRs are available through SFTP or FTPS. You will need to have a demo server for this to begin and I will provide demo CDRs, we can then link the script to our CDR server once the work is complete.
I need a script that is run once per 3 hours, checks for any new data, and then converts that data into the database. (IE, calls, texts, SMS, MMS, Data usage).
The database needs to be setup so that each phone number creates its own table. If the script see's a new number, then a new table will be created for this number. This isolates and ensures that all numbers have their own table for their data.
This database will be used in the future to provide usage stats to customers (through calculation of database information) and also to calculate any overage, however - that is part 2 of the project.
I can provide sample CDRs, I look forward to your proposals.
Steve
We have a large wholesale account with a mobile wholesale provider. We have a server containing all CDRs for mobile devices, which is updated on a 4 hr or 24hr basis depending when the network send it over.
The CDRs are available through SFTP or FTPS. You will need to have a demo server for this to begin and I will provide demo CDRs, we can then link the script to our CDR server once the work is complete.
I need a script that is run once per 3 hours, checks for any new data, and then converts that data into the database. (IE, calls, texts, SMS, MMS, Data usage).
The database needs to be setup so that each phone number creates its own table. If the script see's a new number, then a new table will be created for this number. This isolates and ensures that all numbers have their own table for their data.
This database will be used in the future to provide usage stats to customers (through calculation of database information) and also to calculate any overage, however - that is part 2 of the project.
I can provide sample CDRs, I look forward to your proposals.
Steve
Steve C.
95% (16)Projects Completed
17
Freelancers worked with
17
Projects awarded
46%
Last project
29 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies