Concluído

Creating an invoice or detailed record from a .txt file

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.

Habilidades: AJAX, JavaScript, MySQL, PHP, Arquitetura de software

Veja mais: where can i get javascript, how can i get more traffic, get a supplier, detail phone number, what is a javascript, canada numbers, what is a php file, worse, where is invoice?, txt, time record, record call, invoice example, how to get an invoice, create invoice, call record, b2, alberta, placed call, sorting supplier

Acerca do Empregador:
( 4 comentários ) Spencerville, Canada

ID do Projeto: #764784

Concedido a:

drailean

hi, please check the PM

$450 USD em 7 dias
(203 Comentários)
6.6

31 freelancers estão ofertando em média $352 nesse trabalho

lukeyan

experienced php/web developer, please check PM for details

$400 USD in 7 dias
(196 Comentários)
7.9
omtechnologies

PHP Professionals ready to start on your project. Please check PMB for details

$350 USD in 3 dias
(178 Comentários)
7.7
NickolaS

Hi, please, check your PM

$300 USD em 1 dia
(342 Comentários)
7.5
BestWeb4U

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!

$390 USD in 7 dias
(169 Comentários)
7.5
sritechnocrat

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 Mais

$600 USD in 40 dias
(61 Comentários)
7.3
kssoftphp

I can do it

$250 USD in 4 dias
(90 Comentários)
6.8
developersinc

Please check PMB.

$500 USD in 10 dias
(77 Comentários)
6.7
ecodes

Invoicing code can be completed within few hours as I have completed such tasks numerous times. Please check pmb for more details. Best Regards

$250 USD in 2 dias
(117 Comentários)
6.6
$500 USD in 3 dias
(56 Comentários)
6.4
qtorixsystems

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 Mais

$500 USD in 5 dias
(26 Comentários)
6.4
rajtuhin1

I have maximum good feedback in my profile. Lets discuss about when we can start, I have gone through PDF.

$250 USD in 5 dias
(25 Comentários)
5.7
robindersingh

Please see pm, thanks and regards,robin

$250 USD in 3 dias
(18 Comentários)
4.9
rz931

I can start right now. I'am experienced in creating web application that generate PDF's.

$250 USD in 2 dias
(14 Comentários)
4.9
mkhall

I can implement this for you. Please see my PM concerning the details of my proposed implementation.

$350 USD in 7 dias
(13 Comentários)
5.0
tucupeis

hi please check pm

$300 USD em 1 dia
(4 Comentários)
4.5
arun88m

Hi, This can be done. I have earlier done a similar kind of work. Please check my PM for more details. Regards, Arun Saragadam.

$250 USD in 6 dias
(21 Comentários)
4.3
Fherjam

Let's do it!

$250 USD in 5 dias
(9 Comentários)
4.0
amsak

Placing bid

$250 USD in 7 dias
(8 Comentários)
3.7
edwingunasingh

Please check PMB

$275 USD in 7 dias
(4 Comentários)
2.9
sumithjoshi

Dear Sir Ji, We have done EXCEL TO MYSQL AND MYSQL TO EXCEL CONVERSION TYPE OF WORK. Please check PM.

$301 USD in 8 dias
(4 Comentários)
2.2