VoiceGuide IVR Software Main Page
Jump to content

Monitor and logging using a database

Recommended Posts

By the way, my client, wants to monitor and logging using a database format, how often and from which no the incoming call happen and related activity,

is there any api or existing ready thing to leverage ?

 

Thanks

 

Cargo MS

Share this post


Link to post

Have you had a look at Call Detail Records (CDRs) ?

These show details of each call and the CallerID/DNIS

 

Also, CDRs can be made to store all the user selections and files recorded etc. during the entire call. From: http://www.voiceguide.com/vghelp/source/html/log_cdrs.htm

 

The Result Variables defined during the call can be optionally saved in the lastdata field. To enable this add this entry to the [Log] section of the VG.INI file:

 

CDR_LastData_SaveRv=1

 

 

 

Contents of $RV[CDR_amaflags] will be placed in the 16th CDR field.

 

Contents of $RV[CDR_user] will be placed in the 17th CDR field.

 

The CDRs are stored in the database as well as in the CDR file.

 

The database by default is an SQLite database saved in VG's \data\ subdirectory (vgDb.db file).

 

You can however use a database engine of choice (SQLServer and MySQL are most common choices). For information on how to set which database engine VoiceGuide is to use see: http://www.voiceguide.com/vghelp/source/html/dial_vgdb_external_config.htm

 

 

Another option is to automatically import the comma delimited 'script logs' into a database, but that may involve writing custom import scripts.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×