Jump to content


< Back to Forum


 

Set Cdr Disposition Field Using $rv


  • Please log in to reply

#1 Maciej 17 December 2015 - 01:47 AM

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?



#2 SupportTeam 17 December 2015 - 08:55 AM

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



#3 Maciej 17 December 2015 - 05:47 PM

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?



#4 SupportTeam 17 December 2015 - 06:46 PM

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