[cisco-voip] CUCM Announcement Files Location

Mon Apr 18 13:55:58 EDT 2016

They will get around to building a nice Java interface for this in a few
years.  You will need to use IE in compatibility mode with an old version
of Java though.

On Mon, Apr 18, 2016 at 1:44 PM, Damisch, Kevin <Kevin.Damisch at oneneck.com>
wrote:

> 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??? J
>
>
>
> 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.
>
>
>
> [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/854fb385/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 93031 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20160418/854fb385/attachment.png>