Author Topic: Reading from a CSV or similar format?  (Read 10713 times)

bwhitby

  • Newbie
  • *
  • Offline Offline
  • Posts: 2
    • View Profile
    • Email
Reading from a CSV or similar format?
« on: August 15, 2005, 01:11:45 AM »
I have cdr info coming in from a number of sources including asterisk, and public voip providers. I need to rate and cost these calls and tie them back to the originating extension. So my cdr info in not contained in one document nor are the file formats similar nor are they available at the same time. I however am proposing to create a single cdr (using Perl) with all the relevant info. This I propose to do once per day in batch mode.

My questions are:
•   What file format/template should I use for this standard format?
•   How do I import this into your program, i.e. what driver do I use?

sergey

  • Moderator
  • Sr. Member
  • *****
  • Offline Offline
  • Posts: 48
    • View Profile
Re: Reading from a CSV or similar format?
« Reply #1 on: August 15, 2005, 09:39:45 AM »
- Most appropriate in this case would be Avaya IP Office format, which is documented at Avaya's website: http://support.avaya.com/elmodocs2/ip_office/R1.3/40DHB0002USDT_1.pdf

- This format is parsed by the Avaya (IP Office) driver

However, please note that CAM is able to collect data from different data sources simultaneously and use different drivers for every data source, thus making it possible to avoid creating of single cdr via Perl script. In case you are interested in latter approach of using multiple data sources please e-mail CDR samples and connection details for every data source to support@callaccounting.ws.

Various alternate ways of connecting to Avaya IP Office:
http://www.callaccounting.ws/release/CAM to Avaya IP Office Connection.pdf
« Last Edit: March 14, 2006, 11:00:36 AM by Administrator »