CDR Issued with CSV file in CM 5.1(3)

Unanswered Question
Feb 20th, 2008
User Badges:

Hi Pros,


I am having a stupid issue with CM 5.1(3) CAR Tool.


I want to show management only certain fields from summary and detail reports of users (skip the QoS field). So obviously I need to take a CSV report as PDF cant be customized.


The problem is when I take CSV report, there is no defined line for each call. The CSV just goes on in the same line on the report.


This means I am unable to export properly in Excel unless I manually hit "ENTER" after identifying one call.


This report is being generated by the CCM itself and I am unable to intercept the data before it opens in Internet Explorer.


Kindly advise what can be done so that each call detail comes in different line.


Pratik



Attachment: 
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Rajesh Revuru Wed, 02/20/2008 - 06:04
User Badges:
  • Silver, 250 points or more

If you open the file in CSV, it will dump everything in one cell with comma as delimiter.


You can convert that into multiple cells using excel. Go to "Data-->Text to Columns"-->select comma as delimiter and it will convert into individual cells.


HTh

pratik.rb Wed, 02/20/2008 - 23:03
User Badges:

Hi Rajesh,


I am able to convert into cells but the data needs line spacing. Each call data needs to be in individual line which is coming all in one line.


Pratik

cjrchoi11 Mon, 03/10/2008 - 14:49
User Badges:

Hi Pratik,


I have same issue. can you share to me if you resolved?


Thanks, John

pratik.rb Tue, 03/11/2008 - 00:02
User Badges:

No, this issue is still unresolved. I have CCM 5.1.3.

joeharb Wed, 03/19/2008 - 05:58
User Badges:

I am having the same issue...has anyone found a resolution....


Thanks,


Joe


rjrii Mon, 09/22/2008 - 06:59
User Badges:

Upgrading from CM 3.x to 6 introduced me to the same problem. Previous to the upgrade, when clicking on view report, the report would open with Excel embedded in the browser and you could then save the file, now, I get a single continous line of text with no line breaks.

rjrii Tue, 12/02/2008 - 19:11
User Badges:

Easiest way I found around this issue is to run the report. Once the data is displayed within IE right click on the page and choose properties. The properties will contain the URL directly to the CSV file on your server. Copy URL and open excel. Go to file - open and paste the URL to the csv and it should open it formatted properly.

r.amoranto Fri, 06/12/2009 - 08:13
User Badges:

Hi there,


I followed your instructions as I found version 6's CDR capability to present the data into a straight forward and readable document is quite the challenge. Unless you're like Russel Crowe in Amazing Minds.

CM ver. 4 through the SQL query was a lot better.


Is there a way to pull up the date/connect and disconnect times and show it in a column format?

konpapadd Mon, 08/24/2009 - 00:40
User Badges:

The workaround i found is this: Copy and paste the csv data in a text file. Open with ms word. Replace all ', ,' with '^p'. Replace all '" "' with '"^p". Save as plain text. Rename to .csv. Open with Excel, choose the first column and go Data->text to column->Delimited->check "Comma"->Finish

!!!

Actions

This Discussion