From Cisco CallManager Administration, go to the Application menu ( Install Plug-in ( Cisco Bulk Administration Tool. Download the application to the C Drive. When the download is complete, install the application. To access the folder and copy the file “bat.xlt” to his desktop. From your lab Partner’s PC, open MS Excel and go to the. I`m having some difficulties generating csv from the bat.xlt file downloaded from my CUCM publisher using excel 2010 I download the file, enable editing and macros, I hit the 'create file format' button to generate the columns I need, all looks good so far.
![]() 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. 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. 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. • • Please like my Facebook page to get latest updates and share this article. Alchemy synth mobile studio download. Artinsoft visual basic upgrade companion serial. Get a free Visual Basic Upgrade Companion license! Are you a developer with a small VB to.NET migration project (up to 20,000 lines of code)? For a limited time you can get a free license of our advanced Visual Basic Upgrade Companion, a tool that will substantially increases the percentage of automation of the overall.NET conversion process, making it as quick, easy, and painless as humanly.
0 Comments
Leave a Reply. |