We use Verizon for Toll-free services for our clients, we never see the 800 number come in on our dial peers and we receive billing data in the form of delimited text files. The person who used to do our billing is no longer with the company and the software they wrote to chew the files into CSV's disappeared. Is there any off the shelf software out there to deal with Verizon billing data files?
I suppose I could crossreference the CDR database with the numbers that the 800's are bound to to back out the minutes from the data, but I was hoping for a product to help us with this billing.
Thanks,
Ariel
Aparrently the files are
Aparrently the files are delimited by number of characters per field (e.g. caller number - 10 characters from position x(i) to x(ii) in each row in the text file). There is a large design document from Verizon that explains the formatting, that we have. The previous guy wrote a program in C to chew the files (1 file per day) and pick out the columns we needed and dump them to csv that we could then cross reference with the customers. I may just have to rewrite it.
If he was an employee paid to
If he was an employee paid to develop that code, then its your intellectual property. Ask him for the source code. He might just give it up.
It's rather our fault that we
It's rather our fault that we don't have it. We had our previous server die rather spectacularly and I had to rebuild from backups and the SVN repository that I built to keep all the asterisk configs in. The source was in a folder that was not backed up nightly on this server. Bad form for us, but the executable and apparently the source are toast unless I can get the old server to boot up again. It was an old Dell with a PERC 3Di that won't see the containers anymore.
if its a text file, you could
if its a text file, you could just use bash scripting to do it.. here is the first part of a script that parses voicemail.conf to get username/password etc just using the while and read commands.
cat /etc/asterisk/voicemail.conf | grep -e "=>" | (
IFS=,;
while read userpass firstlast email pager options; do
user=$(echo $userpass | cut -d "=" -f 1 | sed s/" "//);
fname=$(echo $firstlast | cut -d " " -f 1);
lname=$(echo $firstlast | cut -d " " -f 2);
A shell script or perl might
A shell script or perl might just be the way to go. I have more experience with shell scripting. Thanks a lot!
how is it formatted? I suppose as long as source and destination #'s are there you could reformat it with a script into something that looks like asterisk Master.csv. You could fudge the fields the billing software isnt concerned with. Theres a lot of packages that would read asterisk CSV files for billing.
Is verizon not sending you the DNIS when they send the call? or is it that you lack a gateway box and so the only CDR you have is the end-point re-written destination?