Creating an invoice or detailed record from a .txt file
$250-750 USD
Bezahlt bei Lieferung
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.
Projekt-ID: #764784
Über das Projekt
Vergeben an:
30 Freelancer bieten im Durchschnitt $350 für diesen Job
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Mehr
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!
Invoicing code can be completed within few hours as I have completed such tasks numerous times. Please check pmb for more details. Best Regards
Hello This seems a perfect job for me. i will develop a software for you which will have an option called "Import". It basically converts the text file into a database table(s). Once this is done i can make u the re Mehr
I have maximum good feedback in my profile. Lets discuss about when we can start, I have gone through PDF.
I can implement this for you. Please see my PM concerning the details of my proposed implementation.
Dear Sir Ji, We have done EXCEL TO MYSQL AND MYSQL TO EXCEL CONVERSION TYPE OF WORK. Please check PM.