ODBC LOG

[ssa75012]

Is it possible to find a manuel witch explain how to link axon log with MS Acess?

[Guest nchto]

Please refer to the documentation that came with the software. You can access the Axon help file at: C:\Program Files\NCH Swift Sound\Axon\Help\index.html

[ssa75012]

Sorry but before post this message I read the documentation.

I found nothing or it's too light!

[tomomark]

Hi,

 

I am also having problems setting up ODBC logging and alike cant find anything in the documentation that explains how to configure it.

 

thanks

mark

[ahoman]

Hi,

 

I am also having problems setting up ODBC logging and alike cant find anything in the documentation that explains how to configure it.

 

thanks

mark

 

My example:

Install MySQL

Install MySQL ODBC driver

 

In MySQL create a database (example: pbx)

Under pbx database, create a table (example: calllog)

Fields:

date--format date

time--format time

from_number--format VARCHAR/CHAR (30 characters may be enough)

to_number-- same format as dfrom_number

duration--format int

 

Create a DSN in MySQL ODBC (DSN name example: MySQL) with database point to pbx database

 

In Axon ODBC Log

ODBC DSN: <enter your DSN name (my example is "MySQL")>

User name: <your MySQL login name>

Password: <your MySQL password>

SQL COMMAND: <example INSERT INTO calllog (date, time, from_number, to_number, duration) values ('%date%', '%time%', '%from%','%to%','%duration%')>

 

You can display the above information on web by means of php script. If you want to calculate the time for billing, set up another user table and set the tariff, then total cost=tariff X duration

 

If your config is properly done, your can trace the SQL command under Axon log txt some what like this:

16:32:20 Executing SQL command: INSERT INTO calllog (date, time, from_number, to_number, duration) values ('2007-11-06', '16:31:55', '98xxx','sip:984201011@10.0.xxx.xxx:5060','24')

 

 

Hope this can help

[EricJudge06]

Hi...is there any way to just log the entire line of call data into the database, without splitting it up into the date, time, duration, etc.? Is there another piece of software that might be able to do this?

 

We already have our own custom code for our call system that splits the logs up into different columns in our database. But we have been getting the log line over a serial port with different software. Now our company is going to an IP PBX system and we are trying to find software that can send the whole IP PBX line into an ODBC connection the same way.

 

Alternatively, are other columns available from this software besides the 5 shown such as the extension, trunk, and incoming/outgoing call status? Thanks...

[ahoman]

Hi...is there any way to just log the entire line of call data into the database, without splitting it up into the date, time, duration, etc.? Is there another piece of software that might be able to do this?

 

We already have our own custom code for our call system that splits the logs up into different columns in our database. But we have been getting the log line over a serial port with different software. Now our company is going to an IP PBX system and we are trying to find software that can send the whole IP PBX line into an ODBC connection the same way.

 

Alternatively, are other columns available from this software besides the 5 shown such as the extension, trunk, and incoming/outgoing call status? Thanks...

 

You can combine the variables into one string such as..

$log_line=%date%.' '.%time% (and so on, the operator depends on what language you are using)

then, use SQL comand

INSERT INTO calllog (log_line) values ('$log_line')

 

I also want to know other Axon variables besides of %date%, %time%....., I can not found them and I hope Axon can release these variables too.

[jrs.reign]

We already accept our own custom cipher for our alarm arrangement that splits the logs up into altered columns in our database. But we accept been accepting the log band over a consecutive anchorage with altered software. Now our aggregation is traveling to an IP PBX arrangement and we are aggravating to acquisition software that can forward the accomplished IP PBX band into an ODBC affiliation the aforementioned way.

 

 

________________

ip pbx

[Guest N.C.H a.n]

Is it possible to find a manuel witch explain how to link axon log with MS Acess?

Hi,

 

Go into the control panel -> administrative tools -> data sources and create a new data source to your access database.

Make sure you have the correct fields in the table and it should be smooth sailing from there.

 

Thankyou