Færdiggjort

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.

Evner: AJAX, JavaScript, MySQL, PHP, Software Arkitektur

Se mere: 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

Om arbejdsgiveren:
( 5 bedømmelser ) Spencerville, Canada

Projekt ID: #764784

Tildelt til:

drailean

hi, please check the PM

$450 USD in 7 dage
(268 bedømmelser)
7.0

30 freelancere byder i gennemsnit $350 timen for dette job

lukeyan

experienced php/web developer, please check PM for details

$400 USD in 7 dage
(218 bedømmelser)
7.9
NickolaS

Hi, please, check your PM

$300 USD på 1 dag
(411 bedømmelser)
7.9
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 Flere

$600 USD in 40 dage
(88 bedømmelser)
7.7
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 dage
(168 bedømmelser)
7.5
omtechnologies

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

$350 USD in 3 dage
(211 bedømmelser)
7.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 dage
(129 bedømmelser)
6.8
kssoftphp

I can do it

$250 USD in 4 dage
(96 bedømmelser)
6.9
developersinc

Please check PMB.

$500 USD in 10 dage
(76 bedømmelser)
6.7
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 Flere

$500 USD in 5 dage
(25 bedømmelser)
6.3
$500 USD in 3 dage
(61 bedømmelser)
6.5
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 dage
(25 bedømmelser)
5.7
robindersingh

Please see pm, thanks and regards,robin

$250 USD in 3 dage
(19 bedømmelser)
5.1
rz931

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

$250 USD in 2 dage
(14 bedømmelser)
4.9
tucupeis

hi please check pm

$300 USD på 1 dag
(4 bedømmelser)
4.5
mkhall

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

$350 USD in 7 dage
(13 bedømmelser)
5.0
Fherjam

Let's do it!

$250 USD in 5 dage
(13 bedømmelser)
4.3
icubelab

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 inform Flere

$600 USD in 7 dage
(1 bedømmelse)
3.6
amsak

Placing bid

$250 USD in 7 dage
(8 bedømmelser)
3.7
edwingunasingh

Please check PMB

$275 USD in 7 dage
(4 bedømmelser)
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 dage
(4 bedømmelser)
2.2