Jump to content
Ganesh

Daily CDR in MS-Excel/CSV file format

Recommended Posts

Hi Support,

 

Our customer using the snomONE PBX is receiving the daily CDR to the email ID configured. It is a screen shot of call logs and these CDRs are not in editable format and it is difficult to search for specific numbers in the CDR.

 

It would be nice if we could receive the CDR in MS-Excel/CSV file format. If you could include a tab in the "Call Logs" for downloading the CDR in CSV format, it would be a great option!

 

Hope this feature can be included in the next release :)

 

Cheers

Ganesh

Share this post


Link to post
Share on other sites

We will open a feature request for this item.

 

Hi,

 

Any further progress on this please? We hope to see this feature in the next release.

 

Regards

Ganesh

Share this post


Link to post
Share on other sites

Not sure what you are looking for. As I mentioned none of the emails are editable, generally.

Have you tried editing the an email that you received from someone else (other than PBX CDR)? You can edit only if you hit "reply" or "forward"

Share this post


Link to post
Share on other sites

Not sure what you are looking for. As I mentioned none of the emails are editable, generally.

Have you tried editing the an email that you received from someone else (other than PBX CDR)? You can edit only if you hit "reply" or "forward"

I think what he is saying is that he would like to be able to download the CDR's from the web interface in CSV format so that he can edit them in excel.

 

In addition to this, it would be nice to be able to search the CDRs or Browse by extension or phone number through the call log web interface. I have two customers that would liek to search the logs by extension to see if their guys are doing what they are supposed to without having to go line by line of the PBX call log or log into their extensions. Maybe this could be in the domain administrator screen to sort by extension or phone number. If this is already available, please send me a link to the wiki or something on it.

Share this post


Link to post
Share on other sites

If you go to Admin/ Settings page you can go down to the CDR and Recordings heading and add the following string to your CDR URL field.

 

file:$c/$m/$d.csv

 

This will get you an editable excel CSV for each day. The CSV file is created with all the calls for each day with this string. Each call shows the in and out leg since SNOM is BBUA. The file is located in the CDR folder in the SNOMONE directory. I suppose you could use CRON to send the file daily.

 

Maybe this will do what you are looking for.

Share this post


Link to post
Share on other sites

Dear Sir,

 

We have developed a small service that is able to receive and extract the information contained into the midnight reports sent by SnomOne (both, CDR and ACD reports), with that information, the service creates CSV files and forwards them to the customer's e-mail. Please contact us in case you are interested and would you like to see a demonstration:

 

slondono@vertical.com.co

 

Thank you!

Share this post


Link to post
Share on other sites

If you go to Admin/ Settings page you can go down to the CDR and Recordings heading and add the following string to your CDR URL field.

 

file:$c/$m/$d.csv

 

This will get you an editable excel CSV for each day. The CSV file is created with all the calls for each day with this string. Each call shows the in and out leg since SNOM is BBUA. The file is located in the CDR folder in the SNOMONE directory. I suppose you could use CRON to send the file daily.

 

Maybe this will do what you are looking for.

 

 

Dear Team,

 

we did this settings, but when we view the CDR, very difficult to read/search. hence my end customer is not accepted this format.

As he was looking some standard format of CDR. pl find the CDR and format which customer is looking in the attachment

 

please work out and provide us the solution at the earliest

 

BR

Ramesh

Share this post


Link to post
Share on other sites

Did you forget attachment?

 

Dear Team,

 

the output of the CDR it can be MS - Excel/CSV file format

it should contain standard columns like caller/callee duration of the call etc.......

 

customer can easily search the required number details

 

BR

Ramesh

Share this post


Link to post
Share on other sites

Note that PBX does not support any CDR standards. But we do have column names on the top of the CSV file since 4.5.0.1050 version. But if they really have some specific requirements, then we can take a look at it.

Share this post


Link to post
Share on other sites

Dear Support Team,

 

Ref to your above above reply mail, we have installed latest Snom ONE version 4.5 1075

and shown CDR is getting generated inside the c:\program files\Snon\snom ONE\local host\cdr

 

but the customer is looking through web login should be able to download the CDR on dially basis. because the server will be placed in datacenter

retreving CDR daily is quite difficult task, if it is possibe through HTTP access then any where we can download the CDR.

 

pl let me know this can be done if yes procedure please.

 

 

BR

Ramesh

Share this post


Link to post
Share on other sites

Dear Support Team,

 

thanks for your reply mail,

 

can we get CDR editable daily emails from the domain

even if it is CSV file format also it is ok

 

daily if we can get csv file from the domain is it possible

 

if yes please let me know the procedure

 

BR

Ramesh

Share this post


Link to post
Share on other sites

In the latest version we have the support for HTML attachments (instead of coming in as the body of the email). Please check it out and see if that is sufficient.

Share this post


Link to post
Share on other sites

Dear Support team,

 

can you please explain me how to set it up,so that i can get HTTP editable attachment

 

i have installed 4.5 1075 delta version

 

i need daily CDR report in CSV file format to my e-mail ID

 

BR

Ramesh

Share this post


Link to post
Share on other sites

First you need to install 4.5.0.1090 version. Second, it is an HTML attachment, not the CSV. If really want the CSV, we can add it to the next version.

Yes yes yes, that would be awesome if you can add download to csv in the next version! :)

Share this post


Link to post
Share on other sites
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.

Loading...

×
×
  • Create New...