Monitor and logging using a database

[cargoms]

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

[SupportTeam]

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.