Author Topic: Accessing to the "SMDR Raw" Table in the CAM Database  (Read 3784 times)

krist-off

  • Newbie
  • *
  • Offline Offline
  • Posts: 2
    • View Profile
Accessing to the "SMDR Raw" Table in the CAM Database
« on: August 17, 2006, 10:51:05 AM »
I have a Problem with the Database, I have not all columns in the "SMDR Raw" Table in the CAM Database !

I use the sqliteodbc version 0.69.(curent version)

if we check in the CAM , in Menu "Live" SMDR I have all columns, but in the Database with the sqliteodbc I haven't all columns.

exemple : I don't have the colums with the format : F or H or I

could someone can help us solve this problem

Thanks

Administrator

  • Administrator
  • Super User
  • *****
  • Offline Offline
  • Posts: 171
    • View Profile
Re: Accessing to the "SMDR Raw" Table in the CAM Database
« Reply #1 on: August 17, 2006, 11:14:57 AM »
The SMDR Raw table is a reflection of the data that is being delivered by the telephone system.  That data usually has a number of fields that are excess or different format.  CAM only requires Date, Time, Duration, Source/User/Ext, Digits, Account ...to generate the Cost, Location and call type.  In order for the "Raw" data to be translated into "CAM" database, you will need to make sure the software is using the right "PBX" driver.  The driver interprets and decodes the data into standard fields.

The best thing to do is to send 2 files to callaccounting.ws:

c:\bill\smdrlog.txt   
and
c:\bill\billlog.txt

We can then identify your problem and determine if you need an alternate driver.

Regards
Administrator