Jump to content
ssa75012

ODBC LOG

Recommended Posts

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...