uc-560 : Automatic CDR file on FTP

[nicanor00]

Hi

I have a UC-560 and I want to send automaticaly the CDR for all outgoing call to the FTP server

I it possible to configure this feature on uc-560

If yes how can I configure it ?

sh version
Cisco IOS Software, UC500 Software (UC500-ADVIPSERVICESK9-M), Version 15.0(1)XA,
RELEASE SOFTWARE (fc2)
Copyright (c) 1986-2009 by Cisco Systems, Inc.
Compiled Thu 22-Oct-09 06:29

ROM: System Bootstrap, Version 15.0(1r)XA, RELEASE SOFTWARE (fc1)

Please help

[Nathan Compton]

In CCA you can go to the following menu to set this up:

Applications>General Settings>Call Accounting

In there you can setup Call Accounting to a FTP server.

Regards,

Adam Compton

[nicanor00]

Thanks

I generated the file

However when we open it there are no column  headers, just numbers, etc..

How can I reorganise this file in other to analyse and understand it well ?

Is there any free tools to analyse and interprate this file ?

Please help

1232568764,7,0,1,"B151715E E72E11DD 800BB43C  428570BC","","","12:12:42.039 PST Wed Jan 21 2009","","12:12:44.659 PST  Wed Jan 21 2009","12:12:44.659 PST Wed Jan 21  2009","","","answer",0,"",0,0,0,0,"12223334444","12223334444","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"Tariff:Unknown","","0","","","","","","","","","","","","","0/1:2","","","","","","","","","","","","","","","","","","","","","","","RegularLine","","","","","","TWC","01/21/2009  12:12:42.043","12223334444","",0,7,B151715E E72E11DD 800BB43C  428570BC,7,"","","","","",""
1232568772,9,0,1,"B3B46786 E72E11DD 800FB43C  428570BC","","","12:12:50.953 PST Wed Jan 21 2009","","12:12:52.203 PST  Wed Jan 21 2009","12:12:52.203 PST Wed Jan 21  2009","","","originate",0,"",0,0,0,0,"201","201","812223334444","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,"Tariff:Unknown","","0","","","","","","","","","","","","","0/1:2","","","","","","","","","","","ton:0,npi:0,pi:0,si:0,#:201","","","","ton:0,npi:0,#:12223334444","ton:0,npi:0,pi:0,si:0,#:201","","","","812223334444","","","RegularLine","","","","","","TWC","01/21/2009  12:12:50.947","201","812223334444",0,9,B3B46786 E72E11DD 800FB43C  428570BC,9,"","","","","",""

[Nathan Compton]

The format of a CDR file is .CSV, with is the data separated by commas.  .CSV files can be opened in Excel and it will be separated into columns.  There are CDR analysis programs out there, but as far as I know, you have to pay for all of those.  This link shows some third party software you can use.

https://supportforums.cisco.com/docs/DOC-9758

You can also see calls in the CME GUI formatted a little better.

Regards,

Adam Compton    

[nicanor00]

Hi

I aupgraded my IOS

boot system flash uc500-advipservicesk9-mz.150-1.XA3a

But the file is not send on the FTP server

• the FTP it is not working, I am using Fizilla server on my computer (FTP server test 172.25.0.240)

000554: Oct 27 14:39:35.307: %VOICE_FILE_ACCT-3-DUMPFAIL: Could not dump to remo

te file - open ftp://cisco:cisco@FTP://172.25.0.240/.UC_560.10_27_2010_

16_39_34.663. Error=516(Unknown error 516)

• The file are created and stored in the flash

How can the file can be copied automatically on the FTP server and deleted and not stored in the flash

Please help

[Darren DeCroock]

I would check the settings in your running config.  Should contain the following:

gw-accouting file
primary ftp 1.1.1.1:21/ username cisco password cisco

maximum buffer-size 40
maximum cdrflush-timer 15

maximum retry-count 3
maximum fileclose-timer 60
cdr-format compact
acct-template callhistory-detail

Then test with the following command:

file-acct flush with-close