Jump to content

CDR output to CSV. Missing data?


dslepnev
 Share

Recommended Posts

Hello,

I have configured CDR's output to CSV file. But I found that not all records are stored in the file. For example:

 

Below call from extension to PSTN. It's ok.

20090321101329, 213, 989267901766, 0

 

Here is incoming call from trunk gateway to pbxnsip. Here is no sourse number and called number.

20090321110155, , , 1

 

Ok, I have modified CDR_FORMAT value in pbx.xml to "$w$20e$20c$5d$10c$10i$20F$20T$o$v$x$y"

 

It helps but, not clear:

20090408203235, , , 3, ,ea19da5462,345@test;user=phone>, <sip:111@test>,,attendant

As you can see when I try to take sourse and destination number from SIP headers they have also additional data with phone number.

 

Advice please, how I need to configure cdr_format to see in the CDR call from extension and call from PSTN (Trunk) onto extension?

Link to comment
Share on other sites

Hello,

I have configured CDR's output to CSV file. But I found that not all records are stored in the file. For example:

 

Below call from extension to PSTN. It's ok.

20090321101329, 213, 989267901766, 0

 

Here is incoming call from trunk gateway to pbxnsip. Here is no sourse number and called number.

20090321110155, , , 1

 

Ok, I have modified CDR_FORMAT value in pbx.xml to "$w$20e$20c$5d$10c$10i$20F$20T$o$v$x$y"

 

It helps but, not clear:

20090408203235, , , 3, ,ea19da5462,345@test;user=phone>, <sip:111@test>,,attendant

As you can see when I try to take sourse and destination number from SIP headers they have also additional data with phone number.

 

Advice please, how I need to configure cdr_format to see in the CDR call from extension and call from PSTN (Trunk) onto extension?

 

Can you first verify whether you have the correct data under <pbx install dir>/cdr? This folder contains CDRs in the XML format. You should be able to locate the corresponding file and verify. If that file shows the correct data, then we may have some issue in the CSV format.

Link to comment
Share on other sites

Can you first verify whether you have the correct data under <pbx install dir>/cdr? This folder contains CDRs in the XML format. You should be able to locate the corresponding file and verify. If that file shows the correct data, then we may have some issue in the CSV format.

 

I have checked XML files in the cdr folder. Here is all information collected correctly. Everything is ok, but not with CSV.

Link to comment
Share on other sites

Seem to work ok here. Can you tell me the OS and call scenario, say, whether it is coming thought the AA or Hunt/Agent group etc?

 

OS: Windows XP, pbxnsip version 3.2.0.3144 (Win32).

Call scenario:

PSTN --E1-->AC Mediant 1000 --SIP-->pbxnsip AA (111) --> Hunt group (444).

from Mediant it's looks like a call to specified phone number of AA (111).

Link to comment
Share on other sites

OS: Windows XP, pbxnsip version 3.2.0.3144 (Win32).

Call scenario:

PSTN --E1-->AC Mediant 1000 --SIP-->pbxnsip AA (111) --> Hunt group (444).

from Mediant it's looks like a call to specified phone number of AA (111).

 

 

Is it possible for you to verify whether a normal call works fine, i.e., PSTN--E1--AC--SIP--pbxsnip AA--extension?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...