VoiceGuide IVR Software Main Page
Jump to content

Set Cdr Disposition Field Using $rv

Recommended Posts

Can You to write which variable is inserted to cdr files in field "disposition"?

 

How to change (or duplicate) saving cdr's from txt to database?

Share this post


Link to post

The CDR 'disposition" field cannot be set by user using an $RV.

 

The CDR 'disposition" field indicates whether the call was answered / not answered / etc. It reflects what actually happened with the call.

 

CDRs are already saved in the database by default. Please see the tables: cdrin and cdrout

Share this post


Link to post

1. We don't want to write any data to cdr "disposition" field, we need to know which data is inserted in this field. We need this to solve blind transfer call status identification.

 

2. how to store cdrs into database?

Share this post


Link to post

For outgoing calls the data that is saved by VoiceGuide in the disposition field can be accessed using $RV[OutDial_Result]

( more info on this here: http://voiceguide.com/forums/index.php?showtopic=12194 )

 

CDRs are saved in database by default. Nothing needs to be done. If you have setup VoiceGuide to use a different backed database for storing all its information then you just need to ensure that your database has all the right tables created.

 

From the trace posted in topic http://voiceguide.com/forums/index.php?showtopic=12194 it can be seen that your system was setup to use your own backend database instead of the default one that VoiceGuide installs. The traces also show that the tables:

 

cdrout

cdrin

stats_ivr_call

 

do not exist on your database server. Once those tables are created then you should see them being populated.

150000.795  12         ERROR v7.5.5669.23446 (10-Jul-15 12:01:32.48) DbProcessQueue_DoQueuedWork_RunCoreSql : ERROR: 42P01: relation "stats_ivr_call" does not exist
150003.346  12         ERROR v7.5.5669.23446 (10-Jul-15 12:01:32.48) DbProcessQueue_DoQueuedWork_RunCoreSql : ERROR: 42P01: relation "cdrout" does not exist
150009.177  12         ERROR v7.5.5669.23446 (10-Jul-15 12:01:32.48) DbProcessQueue_DoQueuedWork_RunCoreSql : ERROR: 42P01: relation "cdrin" does not exist

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
×