I am a long distance reseller in Canada and receive Call Detail Records from my supplier in the form of .txt files. There is a new file everyday, and it outlines the long distance calls my customers made that day, as well as incoming calls to their 800 numbers. Here is an example of the information and how it is displayed in the file; these are 2 call records:
0 6136582511 6135921642 Aug 2 2010 10:31:03:300AM Aug 2 2010 10:30:20:100AM Aug 2 2010 10:30:49:700AM 0.5000 0.0065 0.0130 Canada - Ontario 613 000188837 B2 0 Rebiller Outbound LD Traffic 97 000000840896379
0 6136582511 4035271594 Aug 3 2010 5:30:59:100PM Aug 3 2010 5:28:49:800PM Aug 3 2010 5:28:59:800PM 2.0000 0.0260 0.0130 Canada - Alberta 403 000188837 B2 0 Rebiller Outbound LD Traffic 97 000000842171746
The information included here is the calling number, the number called, the date and time the call was made, the length of the call, the charge, the rate, where the call was placed to and some additional info that is not relevant to my needs. What I require is to be able to turn these .txt files into individual call records for each of my customers. It would take SOME of the information, like the numbers called, date & time, call destination and would then calculate the cost based on my rates, display the records and total it up at the bottom. It would create a separate record for each customer based on the phone number; a typical phone bill is what I'm looking for. Right now I'm simply creating a single .txt file at the end of the month, sorting by customer and creating individual records in Excel spreadsheets. But it is time consuming and as I get more customers it's only going to get worse.
I've uploaded a copy of what I give to customers now so you can see what I'm looking to achieve. The only difference is my supplier is now basing it on minutes instead of seconds like you'll see in the example.
**NOTE** Ideally, I will need to be able to add different destinations & rates (ie. Canada 3¢, Australia 4¢ etc) and the software will need to be able to tell either by Country Code (included in the phone number) or by one of the text fields in the .txt file. I have about 500 or so individual destinations each with their own unique price.
30 freelancere byder i gennemsnit $350 timen for dette job
I’m a web expert - professional with an experience of 8 years in making website designs. I am very pleasure if I can get a chance to work with you. Many thanks!