CSV Format

Unanswered Question
Jun 11th, 2008

How do i get the CDR in the following attachments in true CSV format.My Call Accounting application (TAPIT by Trisys) will not process the Cisco 6 files?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Adrian Saavedra Wed, 06/11/2008 - 14:34

Hi friend,

Open the files in Excel and specify the following in the import window:

1.- Check the radio button for "delimited" and click Next button.

2.- Then check for comma separated and click Next.

3.- Then specify Text as the columns format. Click Finish.

Notice that values for dateTimeOrigination, dateTimeConnect and dateTimeDisconnect are integers.

These values must apply a formula to make them understandable. For this you can check this link:


Also notice that values for dateTimeConnect and dateTimeDisconnect are in GMT. You have to substract the number of hours according to your timezone.

Hope this helps little bit.


- adrián.


This Discussion