cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
304
Views
0
Helpful
1
Replies

CSV Format

level_3rd
Level 1
Level 1

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?

1 Reply 1

Adrian Saavedra
Level 7
Level 7

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:

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml

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.

Regards,

- adrián.