IssabelPBX CDR Search & CSV File Result is not Tally

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

IssabelPBX CDR Search & CSV File Result is not Tally

limez17

Hi!

I've been wondering why CDR Search in IssabelPBX(Unembedded) result is showing my user's extension(Not the device extension). But when doing CDR filter then download as CSV file. The CLID column is showing device extension not the user extension.

Anyone knows how to fix this?

asternic

Issabel does not support user & device mode, that is inherited from FreePBX and is something we will not pursue. The CDR report in unembeded issabelpbx is probably going away as there is a cdr report on issabel itself.

Best regards,

limez17

asternic Thank you for your reply!
Noted that user & device mode is not supported but overall on my setup. User and device is enabled and working as intended.

For the CDR Report inside IssabelPBX, my goal to filter outgoing with User extension CID. Its doable. Only problem is when downloading that search result into .csv file.
What specific script do I need to modify in order for search result and search result download to have identical data?

CDR Report inside Issabel 4 is lacking the Name of the CLID.

asternic

Hi,

Github from the issabel-reports:

https://github.com/IssabelFoundation/reports/

And specifically the cdr module:

https://github.com/IssabelFoundation/reports/tree/master/modules/cdrreport

On your local installation, it is found in /var/www/html/modules/cdrreport

Best regards,

limez17

asternic Thank you for your feedback! This is well noted. Will start to work it out, then share my solution if found any.

limez17

Hi!

I'm unable to understand the content of "/var/www/html/modules/cdrreport/index.php" file.
Therefore i'm unable to modify what i need to modify.

Below is my findings:
1. Table "cdr" is inside database "asteriskcdrdb".
2. Table "cdr" have column "clid" which value format is: "Agent Name" <Device Extension>
Some entries data format is "Agent Name" <User Extension>
3. There are other tables in "cdr" table. Which are:
cnum - User Extension
cnam - Name of the User Extension

My theory:
1. Unembedded IssabelPBX CDR search result column "clid" is getting its value from "cnum" & "cnam" columns in "cdr" table of "asteriskcdrdb". I'm unable to confirm because i'm unable to read the "index.php" file.
2. Now if I download the Unembedded IssabelPBX CDR search result into ".csv" file. It will base its columns value from embedded Issabel CDR report module.

Now:
1. How can I get "cnum" & "cnam" columns to show up on the downloaded ".csv" file?
2. How can I get "cnum" & "cnam" columns to show up on embedded Issabel 4 CDR module?

Thank you in advance!

asternic

I am sorry you are unable to understand code,,, maybe it is not as straightforward as you might think as there are classes being used outside of the index.php file itself, howerver, what you want to do is on the index.php file (modifying exporting fields). The latest version (available on github, already includes cnum and cname, ook at around line 273 where there is an if condition with the hint hint method isExportAction(). There is a loop, and on that loop a set of assignments, here is what you have on the latest github version (probably not the latest stable version you might have installed):

       if(is_array($arrResult['cdrs']) && $total>0){
            foreach($arrResult['cdrs'] as $key => $value){
                $arrTmp[0] = $value[0];
                $arrTmp[1] = $value[1];
                $arrTmp[2] = $value[11];
                $arrTmp[3] = $value[2];
                $arrTmp[4] = $value[3];
                $arrTmp[5] = $value[9];
                $arrTmp[6] = $value[4];
                $arrTmp[7] = $value[5];
                $iDuracion = $value[8];
                $iSec = $iDuracion % 60; $iDuracion = (int)(($iDuracion - $iSec) / 60);
                $iMin = $iDuracion % 60; $iDuracion = (int)(($iDuracion - $iMin) / 60);
                $sTiempo = "{$value[8]}s";
                if ($value[8] >= 60) {
                      if ($iDuracion > 0) $sTiempo .= " ({$iDuracion}h {$iMin}m {$iSec}s)";
                      elseif ($iMin > 0)  $sTiempo .= " ({$iMin}m {$iSec}s)";
                }
                $arrTmp[8]  = $sTiempo;

                $arrTmp[9]  = $value[6];  //uniqueid
                $arrTmp[10] = $value[12]; //recordingfile 
                $arrTmp[11] = $value[13]; //cnum 
                $arrTmp[12] = $value[14]; //cnam
                $arrTmp[13] = $value[15]; //outbound_cnum
                $arrTmp[14] = $value[16]; //did
                $arrTmp[15] = $value[17]; //userfield

                $arrData[] = $arrTmp;
            }
        }

Maybe this will help you

limez17

Thank you for your response.
This is well noted. Will check this.

By the way.
How to search in CDR of embedded Issabel? In unembedded, search filter is very flexible.
How to do the same thing on embedded?

asternic

I think GUI is quite clear, you can show filter and you have select boxes to search for different fields (src, destination, srcchannel, dstchannel, user field, etc,.. also you can search by disposition: answer,busy, etc).

If you think listing 20 field conditions in a huge list is flexible an usable, then you can still use it.. if you think you can improve the builtin issabel cdr, I gave you much more than a pointer on how to work on it. If you want a professional (and commercial) reporting tool, look at http://www.asternic.net for queues and http://www.asternic.net/cdrreports for CDR.

You are welcome to contribute improvements over the cdrreports module.

Best regards,