Creating an invoice or detailed record from a .txt file
$250-750 USD
Terminado
Publicado hace más de 13 años
$250-750 USD
Pagado a la entrega
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.
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 Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan.
With Regards Sri Technocrat.
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!
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 required reports. The maximum time i would take will be 5 days.
Looking forwards
Regards
Umer
Dear Sir,
Hello!
We have gone through your requirements, all ready we have done such type of work. If you have any questions feel fee to get in touch us for more clarifications. Please visit PMB for more information.
With Regards
iCUBE Lab