callaccounting.ws forum

callaccounging.ws => Call Accounting Mate Q&A => Topic started by: krist-off on August 17, 2006, 10:51:05 AM

Title: Accessing to the "SMDR Raw" Table in the CAM Database
Post by: krist-off 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

Title: Re: Accessing to the "SMDR Raw" Table in the CAM Database
Post by: Administrator 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