[cisco-voip] CUCM Announcement Files Location

Mon Apr 18 13:44:00 EDT 2016

Just curious if I’m the only one wondering why Cisco hasn’t implemented a download button in the GUI for things like this, MOH files, and TFTP files (ringtones, background images, etc).  CUCM seems kind of selfish – it will let us easily give things to it via uploading in the GUI, but try to download something from it, and you have to use CLI, get your SFTP server going, and remember the path of where the files are at.  CUCM’s been around for how long now??? ☺

Kevin

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Anthony Holloway
Sent: Monday, April 18, 2016 10:07 AM
To: Brian Meade <bmeade90 at vt.edu>
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CUCM Announcement Files Location

Good catch Brian.  I did limit the output to only files with "Sample" and "ulaw.wav" in the filename, as I thought Nick was asking about the built-in files and not custom ones he had uploaded.

So, I decided to upload a custom announcement, and I found that the file was not in that directory.  Instead, the file is renamed, and then placed in the CustomAnn directory.

Here is a screenshot of the Announcement Configuration page where I uploaded a WAV file named asdf.wav as an Announcement with name "asdf" to the English United States locale.

[Inline image 2]

Here I am piecing together a SQL query to find my Announcement, and associated file prefix which will come in handy for the "file list" command:

admin:run sql select ca.name<http://ca.name> as announcement, cal.filename as origfilename, ta.name<http://ta.name> as tftpfilenameprefix, tul.name<http://tul.name> as locale from customannouncement as ca left join customannouncementlocale as cal on ca.pkid = cal.fkcustomannouncement left join typeannouncements as ta on ca.tkannouncements = ta.enum left join typeuserlocale as tul on cal.tkuserlocale = tul.enum where ca.name<http://ca.name> = 'asdf'
announcement origfilename tftpfilenameprefix locale
============ ============ ================== =====================
asdf         asdf.wav     Custom_05001       English United States
admin:

Here is the "file list" command, which shows my file with the new name:

admin:file list tftp CustomAnn/english_united_states/Custom_05001*
Custom_05001.alaw.wav                   Custom_05001.g729.wav
Custom_05001.ulaw.wav                   Custom_05001.wb.wav
Custom_05001.xml
dir count = 0, file count = 5
admin:

And here is how you download that file (or all of them rather):

admin:file get tftp CustomAnn/english_united_states/Custom_05001*
Please wait while the system is gathering files info ...done.
Sub-directories were not traversed.
Number of files affected: 5
Total size in Bytes: 132785
Total size in Kbytes: 129.67285
Would you like to proceed [y/n]?

Alternatively, you can play it in your browser just to check it quick, like this (I found the wideband one to work for me):

http://yourcucm.yourdomain.com:6970/CustomAnn/english_united_states/Custom_05001.wb.wav

On Fri, Apr 15, 2016 at 10:55 AM, Brian Meade <bmeade90 at vt.edu<mailto:bmeade90 at vt.edu>> wrote:
What command did you run as Anthony's example was only looking for the example files?

Make sure you're just using:
file list tftp english_united_states

On Fri, Apr 15, 2016 at 11:50 AM, Nick via cisco-voip <cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>> wrote:
Hi Anthony

Thanks for the reply, the custome files i uploaded are not stored in this location, I can only see the files listed in your example.

Regards

Nick

On 14 April 2016 at 20:46, Anthony Holloway <avholloway+cisco-voip at gmail.com<mailto:avholloway+cisco-voip at gmail.com>> wrote:
Inspect

admin:run sql select * from typeannouncementfile where name like '%Sample%'
enum ishidden name                    filename              isuserlocale description                          moniker
==== ======== ======================= ===================== ============ ==================================== =============================
28   f        Welcome Greeting Sample WelcomeSample.wav     t            Welcome Greeting sample announcement ANN_FILE_WELCOME_GREET_SAMPLE
29   f        Wait In Queue Sample    WaitInQueueSample.wav t            Wait In Queue sample announcement    ANN_FILE_WAIT_IN_QUEUE_SAMPLE

Identify

admin:file list tftp english_united_states/*Sample*ulaw.wav
WaitInQueueSample.ulaw.wav              WelcomeSample.ulaw.wav
dir count = 0, file count = 2

dir count = 0, file count = 12

Download

admin:file get tftp english_united_states/*Sample*ulaw.wav
Please wait while the system is gathering files info ...done.
Sub-directories were not traversed.
Number of files affected: 2
Total size in Bytes: 127162
Total size in Kbytes: 124.18164
Would you like to proceed [y/n]?

On Thu, Apr 14, 2016 at 9:40 AM, Nick via cisco-voip <cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>> wrote:
Hi All

Does anyone know the cli location of the announcement files in CUCM that are used for call queuing, i need to download them so I can migrate them to new servers.

Regards

Nick

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160418/45b5b236/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 93031 bytes
Desc: image002.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160418/45b5b236/attachment.png>