[cisco-voip] CUCM Announcement Files Location

[Anthony Holloway]

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.

[image: 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 as announcement, cal.filename as origfilename,
ta.name as tftpfilenameprefix, 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 = '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> 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> 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> 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> 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
>>>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>>>
>>>>
>>>
>>
>> _______________________________________________
>> cisco-voip mailing list
>> 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/d8c64400/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 54228 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160418/d8c64400/attachment.png>