Cucm Bat Xlt Download
Why do I have to add End-Users in CUCM? -Download the “bat.xlt” file (from upload/download section)-Add the end users details within “bat” file. Cisco Bulk Administration Tool (BAT). BAT is an Old Feature for CUCM and usually use during big phone deployments. Select bat.xlt and press Download Selected.
Cisco Call Manager Bulk Administration is pretty simple and awesome feature for adding and modifying multiple phones, users. While dealing with business phone systems like Cisco Call Manager BAT will save a lot of time for Administrators. The ‘ bat.xlt’ file is a Macro enable Spreadsheet (Excel) file that is available to download from Bulk Administration menu of CUCM. Unfortunately, some of the VBA macros are not compatible with 64bit hence bat.xlt didn’t seem to work with the Office 2013 and 2016 64bit version. I came to know this issue because I recently upgraded my MS Office to 2016 from 2010. Since BAT tool is quite greatly used I determined to attempt and fix it. This resolution should work for all versions of BAT.XLT file.
Lets take a look at CUCM BAT file Issue “Compiler error” solution. While trying to open bat.xlt file using MS Excel 2013/ 2016 you may ended up with the following error. “Compiler error The code in this project must be updated use on 64-bit systems. Please review and update Declare statements and hen mark them with the PtrSafe attribute” The quick workaround which I’m gonna explain here is ideally simple and straight forward.
Cisco Unified Communications Manager Bulk Administration Guide. Download the file BAT.xlt file to a local machine where Microsoft Excel is installed.
It doesn’t require VB Scripting skill LOL 🙂 How to fix CUCM BAT file Issue “Compiler error”? Step 1: Open bat.xlt file with MS Excel 2013/ 2016 You will be popped up with the error message, click OK (I clicked 2 times) Step 2: Edit bat.xlt VB Script You can see the following in RED color. Private Declare Function SHBrowseForFolder _ Lib “shell32” _ ( _ lpbi As BrowseInfo _ ) _ As Long Private Declare Function SHGetPathFromIDList _ Lib “shell32” _ ( _ ByVal pidList As Long, _ ByVal lpBuffer As String _ ) _ As Long Private Declare Function lstrcat _ Lib “kernel32” _ Alias “lstrcatA” _ ( _ ByVal lpString1 As String, _ ByVal lpString2 As String _ ) _ As Long Now change the Private Declare Function to Private Declare PtrSafe Function in the above three locations and save. (Literally we are adding the term PtrSafe ) While saving, you can choose a different name.
Compendium Of Contemporary Weapons Pdf more. Go ahead and open the new bat.xlt file and enjoy CUCM BATing Hope this helps, please share your comments below. I will be coming up with another Unified article soon. Meanwhile you may have interested to check out the following.
Japanese Made Epiphone Serial Numbers. • • Please like my Facebook page to get latest updates and share this article.