Unique reference

[bghayad]

Hello;

Is there a unique reference that can be used to reach for the call in the reporting and the recorded file for this call?

Goautodial.org 2.6.18, VERSION: 2.4-309a,BUILD: 110430-1642, Digium, Inc. Wildcard TE220 dual-span T1/E1/J1

Regards
Bilal

[bghayad]

Dears;

Any help? Any advise or direction?

Regards
Bilal

[gardo]

All leads have uniqueid. If you have recordings enabled, they should be accessible via the admin interface. What are you trying to achieve?

[bghayad]

First of all, thanks alot for your kindly reply.

What I need is the following:

To have a unique reference that I can use it to get the call details, also I hope if I can use it to get the recorded file of this call. Well, at least to be able to reach for this call at the CDR or at the log or the report based on the unique reference.

In other words, let us assume that the unique reference was 10000, so using it I can reach for the recorded call and for the call log. For example, if I have this unique reference (the 10000 in our example), I can reach for the call details (at which time happened and for how much the duration stayed, ... .etc). One more point, I hope also (this is not condition, but prefer if existed), if I can use this 10000 to reach for the recorded file.

Why I need this?

It is because the same caller might call multiple time, so I can not depend on the telephone number if I need to search for the call details because I will find multiple calls from the same telephone number. I would if I can use the unique reference to refer to this call with its details, it will be more specified. And it will be more great if ths unique reference can be used to reach for the recorded file.

Hope I explained well.
Fully thanks again.
Regards
Bilal

[DomeDan]

Yeah you should use uniqueid in vicidial_log
which is the same as vicidial_id in recording_log and uniqueid in call_log
Example:

Code: Select all

SELECT * FROM vicidial_log A
INNER JOIN recording_log B ON B.vicidial_id=A.uniqueid
INNER JOIN call_log C ON C.uniqueid=A.uniqueid
LIMIT 0,20

[bghayad]

Big thanks for your help and answer

From the GUI, there is nothing to do it?

Regards
Bilal

[DomeDan]

oh it was a GUI question, then I leave this to gardo or someone else using goautodial

[bghayad]

Originally it was database question and u helped me and answered me, so I am very thanks.

But now really I need to know if possible to achieve this via GUI?

Regards
Bilal

[gardo]

It's not for the moment. However, you can try using PHPMyadmin. It's a web GUI for Mysql.

[bghayad]

Fully thanks for the help and advise.

But I found that the vicidial_log is empty, Why? What is the required settings to have data in this table?

Regards
Bilal

[williamconley]

Each Lead and agent has a list of calls made to that lead (on the associated record for that lead or user). It also has links to all the recordings for that entity.

Is there a reason you need a "log" for each call that is not related to each lead?

[bghayad]

Is there a reason you need a "log" for each call that is not related to each lead?

* You mean a log for the calls that is related to the agent or the user?

If yes, then from where?

Regards
Bilal

[williamconley]

Log in to vicidial, use "search for a lead" in the Lists menu. Each result will show a single lead and all information pertaining to that lead.

Log in to vicidial, use "Users" menu to select a single user, then click on "user stats". That page will show all informatio pertaining to that user. (This one, however, has a search feature by date since users may have millions of records!)