VoiceGuide IVR Software Main Page
Jump to content

Saving logs in database

Recommended Posts

After getting incoming call all logs will be saved in folder but i want save that logs in database also please let me know how can i do this.

I want to save logs in database  for outgoing and incoming 

Share this post

Link to post

Do you want to save the entire CallEvents or vgEngine etc. logs in database? or some other logs?

Share this post

Link to post

Call event log like once calls ended i need to save complete information regarding the call in database.

Share this post

Link to post

The CallEvents log does not contain complete information about the call. It for example does not contain all the Result Variables created during the call etc.

Many users just save the selected information to database using a Database Query module ran from the 'After Hangup' script.

'After Hangup' script: https://www.voiceguide.com/vghelp/source/html/call_finish.htm

Database Query module: https://www.voiceguide.com/vghelp/source/html/moddbquery.htm

What are you trying to achieve by loading call events data into a database?

Would CDR records be enough?

CDRs are already saved into VoiceGuide's default backend database. See: https://www.voiceguide.com/vghelp/source/html/log_cdrs.htm


As far as a CallEvents log is concerned, it is in JSON format. You could write some external app that reads that file and loads information that is important to you from it at end of day into your database table.

Sample CallEvents entry below:

{ "call": {
  "crn": "8000001",
  "port": "1",
  "direction": "in",
  "time_start": "2019-01-07 19:37:38",
  "events": "
    193738.189|state|<offered> : cid= , dnis= connected|||||0|0|0|0
    193738.222|state|[Get Client ID] Number Input|||||0|0|0|0
    193738.238|state|[Get Client ID] Playing wav (PayGetId.wav)|||||0|0|0|0
  "length": "14.679"


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