[cisco-voip] CUCM Announcement Files Location
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@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] CUCM Announcement Files Location
*Inspect* admin:run sql select * from typeannouncementfile where name like '%Sample%' enum ishidden namefilename isuserlocale description moniker === = = 28 fWelcome Greeting Sample WelcomeSample.wav t Welcome Greeting sample announcement ANN_FILE_WELCOME_GREET_SAMPLE 29 fWait In Queue SampleWaitInQueueSample.wav t Wait In Queue sample announcementANN_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@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@puck.nether.net > https://puck.nether.net/mailman/listinfo/cisco-voip > > ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] CUCM Announcement Files Location
Thanks Pete, they are not stored in the CustomAnn folder as I have been able to view the files there, it just list the following, any idea what any of the other folders are called as there are 88 in the tftpdata folder but i cant see what they are dir count = 88, file count = 841 admin:file list activelog cm/tftpdata/CustomAnn english_united_kingdom AnnResult.xml CiscoCustomANNReport.xml dir count = 1, file count = 2 admin: On 14 April 2016 at 16:58, Pete Brown wrote: > Nick, > > Might try this location... > > > /usr/local/cm/tftp/CustomAnn/ > > > If you have problems retrieving the files using the console, you should be > able to extract the files directly from the _UCM_ANN.tar file generated as > part of the last DRS backup set. > > > Thanks, > > Pete > > -- > *From:* cisco-voip on behalf of Nick > via cisco-voip > *Sent:* Thursday, April 14, 2016 9:40 AM > *To:* cisco-voip@puck.nether.net > *Subject:* [cisco-voip] CUCM Announcement Files Location > > 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@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] CUCM Announcement Files Location
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 wrote: > *Inspect* > > admin:run sql select * from typeannouncementfile where name like '%Sample%' > enum ishidden namefilename isuserlocale > description moniker > === = > = > 28 fWelcome Greeting Sample WelcomeSample.wav t > Welcome Greeting sample announcement ANN_FILE_WELCOME_GREET_SAMPLE > 29 fWait In Queue SampleWaitInQueueSample.wav t > Wait In Queue sample announcementANN_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@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@puck.nether.net >> https://puck.nether.net/mailman/listinfo/cisco-voip >> >> > ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] CUCM Announcement Files Location
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@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-v...@gmail.com> wrote: > >> *Inspect* >> >> admin:run sql select * from typeannouncementfile where name like >> '%Sample%' >> enum ishidden namefilename isuserlocale >> description moniker >> === = >> = >> 28 fWelcome Greeting Sample WelcomeSample.wav t >> Welcome Greeting sample announcement ANN_FILE_WELCOME_GREET_SAMPLE >> 29 fWait In Queue SampleWaitInQueueSample.wav t >> Wait In Queue sample announcementANN_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@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@puck.nether.net >>> https://puck.nether.net/mailman/listinfo/cisco-voip >>> >>> >> > > ___ > cisco-voip mailing list > cisco-voip@puck.nether.net > https://puck.nether.net/mailman/listinfo/cisco-voip > > ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
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 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@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-v...@gmail.com> wrote: >> >>> *Inspect* >>> >>> admin:run sql select * from typeannouncementfile where name like >>> '%Sample%' >>> enum ishidden namefilename isuserlocale >>> description moniker >>> === = >>> = >>> 28 fWelcome Greeting Sample WelcomeSample.wav t >>> Welcome Greeting sample announcement ANN_FILE_WELCOME_GREET_SAMPLE >>> 29 fWait In Queue SampleWaitInQueueSample.wav t >>> Wait In Queue sample announcementANN_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@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@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip >>> >> >> ___ >> cisco-voip mailing list >> cisco-voip@puck.nether.net >> https://puck.nether.net/mailman/listinfo/cisco-voip >> >> > ___ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
Re: [cisco-voip] CUCM Announcement Files Location
Hi Anthony Many thanks for your replies on this subject, unfortunately I am unable to download the files, did you successfully downlaod a file in your testing. admin:file get tftp CustomAnn/english_united_kingdom/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: 337601 Total size in Kbytes: 329.68848 Would you like to proceed [y/n]? y SFTP server IP: 10.19.101.163 SFTP server port [22]: User ID: nick Password: * Download directory: / /usr/local/platform/conf/fips.cnf (Permission denied) admin: Regards Nick On 18 April 2016 at 16:06, Anthony Holloway wrote: > 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 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@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-v...@gmail.com> wrote: >>> *Inspect* admin:run sql select * from typeannouncementfile where name like '%Sample%' enum ishidden namefilename isuserlocale description moniker === = = 28 fWelcome Greeting Sample WelcomeSample.wav t Welcome Greeting sample announcement ANN_FILE_WELCOME_GREET_SAMPLE 29 fWait In Queue SampleWaitInQueueSample.wav t Wait In Queue sample announcementANN_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@puck.nether.net> wrote: > Hi All > > Does anyone know the cli location of
Re: [cisco-voip] CUCM Announcement Files Location
Nick- You may want to take a look at CSCua90744. Every time I have needed to change custom announcements since 8.6, I've had to contact TAC to have them gain root access and change the folder permissions on every subscriber. Best regards, Benjamin On Thu, Apr 21, 2016 at 4:28 AM Nick via cisco-voip < cisco-voip@puck.nether.net> wrote: > Hi Anthony > > Many thanks for your replies on this subject, unfortunately I am unable to > download the files, did you successfully downlaod a file in your testing. > > admin:file get tftp CustomAnn/english_united_kingdom/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: 337601 > Total size in Kbytes: 329.68848 > Would you like to proceed [y/n]? y > SFTP server IP: 10.19.101.163 > SFTP server port [22]: > User ID: nick > Password: * > Download directory: / > /usr/local/platform/conf/fips.cnf (Permission denied) > admin: > Regards > > Nick > > > > On 18 April 2016 at 16:06, Anthony Holloway < > avholloway+cisco-v...@gmail.com> wrote: > >> 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 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@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-v...@gmail.com> wrote: > *Inspect* > > admin:run sql select * from typeannouncementfile where name like > '%Sample%' > enum ishidden namefilename > isuserlocale description moniker > === = > > = > 28 fWelcome Greeting Sample WelcomeSample.wav t >Welcome Greeting sample announcement ANN_FILE_WELCOME_GREET_SAMPLE > 29 fWait In Queue SampleWaitInQueueSample.wav t >Wait In Queue sample announcementANN_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,