Reporte IVR

This site is best viewed in a modern browser with JavaScript enabled.

yayafernandez

Hola a todos, hay algun addons gratis para poder sacar un reporte de las opciones seleccionadas en los IVR???? Muchas gracias

dickson

Out of the box, no, Sadly.
BUT you can modify the dialplan that would save these entries to a file that you could go get.

system(echo "${STRFTIME(${EPOCH},,%d%m%Y- 
%H:%M:%S)},${CALLERID(all)},${UNIQUEID},${IVR_CONTEXT},${IVR_MSG},${EXTEN}" >> /tmp/survey.txt)

The output would look like this in the file

18092019-13:12:49,Dickson <8860>,1568823166.13959,ivr-12,,1
18092019-13:14:12,Dickson <8860>,1568823249.13960,ivr-09,,2

Breaks down to :

DDMMYY-HH:MM:SS clid name <calling number>, UNIQUE ID,IVR#, Digit selected

So in the first example i called the ivr at 13:12:49 and in IVR-12, i selected option 1
Second example i called at 13:14:12 and in ivr-09 i selected option 2.

Would that kind of report work for you? If so (include any changes) i'll write some instructions and post how to do it.

clopez2007

dickson Buen día.

Es una buena opción, yo creo que a muchos nos ayudaría tener esa información, donde se realizan los cambios para poder obtener este informe.

Gracias.

dickson

(sorry English is my native language, I hope this translates properly)
Step 1>
Find your IVR

Open up /etc/asterisk/extensions_additional.conf

Each IVR has a heading like

[ivr-XX] ; IVRNAME(x)

include => ivr-XX-custom
include => from-ivr-directory-Disabled
exten => fax,1,Goto(${CUT(FAX_DEST,^,1)},${CUT(FAX_DEST,^,2)},${CUT(FAX_DEST,^,3)})
.....
.....
exten => hang,1,Playback(vm-goodbye)
exten => hang,n,Hangup

;--== end of [ivr-XX] ==--;

Step 2>
Copy this entire ivr portion

Step 3>
PASTE it into the bottom of
/etc/asterisk/extensions_override_freepbx.conf

Step 4>
Modify the code for each IVR selection

In my example below I have 3 selections
Your IVR will be different, but will have simlar "Goto(XXXXX)"

exten => 1,1(ivrsel-1),Goto(app-pbdirectory,pbdirectory,1)

exten => 2,1(ivrsel-2),Goto(app-blackhole,hangup,1)

exten => 3,1(ivrsel-3),Goto(macro-pincollection,s,1)

Make the changes similar to this:

Step 5: "Move the destination to next line"

exten => 1,1
(ivrsel-1),Goto(app-pbdirectory,pbdirectory,1)

Step 6: "Add the exten designation to the front: exten => X,2 "

exten => 1,1
exten => 1,2(ivrsel-1),Goto(app-pbdirectory,pbdirectory,1)

Step 7: "Paste in the data you want collected on the end of the first line like: ,system(echo...."

exten => 1,1,system(echo "${STRFTIME(${EPOCH},,%d%m%Y- %H:%M:%S)},${CALLERID(all)},${UNIQUEID},${IVR_CONTEXT},${IVR_MSG},${EXTEN}" >> /tmp/reportivr.txt)
exten => 1,2(ivrsel-1),Goto(app-pbdirectory,pbdirectory,1)

Step 8>
Repeat this for each IVR entry.

It will look something like this when you are done. Here i've made changes to my IVR that had 3 entries.
Critical changes are the "exten => X,2" values that you need to put in.

exten => 1,1,system(echo "${STRFTIME(${EPOCH},,%d%m%Y-%H:%M:%S)},${CALLERID(all)},${UNIQUEID},${IVR_CONTEXT},${IVR_MSG},${EXTEN}" >> /tmp/reportivr.txt)
exten => 1,2(ivrsel-1),Goto(app-pbdirectory,pbdirectory,1)

exten => 2,1,system(echo "${STRFTIME(${EPOCH},,%d%m%Y-%H:%M:%S)},${CALLERID(all)},${UNIQUEID},${IVR_CONTEXT},${IVR_MSG},${EXTEN}" >> /tmp/reportivr.txt)
exten => 2,2(ivrsel-2),Goto(app-blackhole,hangup,1)

exten => 3,1,system(echo "${STRFTIME(${EPOCH},,%d%m%Y-%H:%M:%S)},${CALLERID(all)},${UNIQUEID},${IVR_CONTEXT},${IVR_MSG},${EXTEN}" >> /tmp/reportivr.txt)
exten => 3,2(ivrsel-3),Goto(macro-pincollection,s,1)

Step 9>
Save your changes

Step 10>
run this command from CLI:

asterisk -rx 'core reload'

Test
After you make a call to your IVR, you should see a file in /tmp/reportivr.txt that contains the data.

Please remember. The code in "override.conf" will always be the priority code run. If you change the IVR using the PBX GUI, you will have to repeat the above steps, but first erasing out the modified code in _override.conf and making the changes again.

alejandromanuel22

dickson esto es exactamente lo que yo hice, y con ayuda de agi pasaba los datos a una bd. desde la cual los programadores pueden consultar y mostrar reportes. es la unica forma de ver lo que marco en un ivr

clopez2007

dickson Gracias por el aporte.

dickson

alejandromanuel22
ah good idea about the AGI. I am not very experienced with AGI commands, but that would be very helpful

alejandromanuel22

dickson its a easy agi.
in dial plan
exten => 1,n,agi(name of agi.php,variable1,variable2,variable3)

and put the agi in /var/lib/asterisk/agi-bin

#!/usr/bin/php -q
<?php
require('phpagi.php');
$host="10.150.0.4";
$user="USUARIO";
$pw="PW";
$db="DB";

$agi = new AGI();
$agi->answer();
$NUMERO = $argv[1]; //variable1
$Opcion= $argv[2]; //variable2
$Opncion2= $argv[2]; //VARIABLE3

$con=mysql_connect($host,$user,$pw) or die("no conecta a la db".mysql_error());
mysql_select_db($db,$con)or die ("Error en db");
$sql ="INSERT INTO llamada(Numero, Opcion,Opcion1) VALUES ('$NUMERO','$Opcion','$Opcion2')";

mysql_query ($sql);
mysql_close($con);

?>

and its all

dickson

alejandromanuel22 Thank you, this example you provided is very helpful for me for another project I have!

yayafernandez

Muchas gracias a todos, lo estare probando. - Thank you very much everyone, I will be testing it

epinero

Hola Dickson y todos, estuvimos probando en lab el código pero no escribe en la base de datos

Parte del log de la consola:

-- Launched AGI Script /var/lib/asterisk/agi-bin/encuesta1.php
-- <SIP/7034-00000036>AGI Script encuesta1.php completed, returning 0

Sin embargo revisamos en la base de datos y el AGI no escribe en la base de datos los resultados

Saludos y gracias