10-15-2012 01:14 AM - edited 03-12-2019 09:54 AM
This document describes some issues that could occur and the possible resolutions in BAT(Bulk Administration Tool)
Bulk Administration menu is accessible only from first node of Cisco Unified Communications Manager.
To resolve it make sure that you are logged into first node of Cisco Unified Communications Manager.
After logging into Cisco Unified Communications Manager Administration, all the Bulk Administration windows are not accessible.
This problem may arise due to restricted access to the application given to the User ID. Contact the System Administrator to be granted required permissions
Clicking the Export to BAT Format button in the BAT.xlt file does not seem to do anything.
In order to resolve it click a blank cell. The button can seem to be disabled if the cursor is on the text in a cell or in the text box.
Check the version of Microsoft Excel that you are using. Customers have reported problems with BAT.xlt when they were using Excel 97.
Use Microsoft Excel 2000 version or higher.
BAT Excel spreadsheet does not respond to actions like Add More Lines and so on.
To resolve it ensure that Enable Macros option is selected while opening BAT Excel spreadsheet.To enable macros in BAT.xlt use the following steps:
a. Open BAT.xlt.
b. Go to Menu >Tools >Macro > Security.
c. Set the Security Level to Medium.
d. Close BAT.xlt and open it again. When prompted, choose Enable Macros.
The number of lines in the data file should be less than or equal to the number of lines that are configured in the BAT phone template, but is not. For example, the phone template has three lines, and, of these, Lines 1, 2, and 3 are configured. You should use a phone data file with up to three configured lines. 1111, 2222, 4444 results in Line1-1111, Line2-2222, Line3-none, Line4-4444.
Recommended Action Check the BAT phone template that you intend to use. The number of lines that are specified on the CSV data file should not exceed the number of lines that are configured in the BAT phone template. Also, the number of speed dials that the CSV data file specifies should not exceed the maximum possible number of speed dials for the BAT phone template that you plan to use.
The CSV file that you uploaded to Cisco Unified Communications Manager Server using File Upload Configuration widow, does not display in the File Name drop-down list box field for various operations. For example, if you uploaded a CSV file for inserting phones using Uploading/Downloading menu option in Bulk Administration menu, but the file does not appear as one of the options in the Insert Phone Configuration window File Name drop-down list box.
Resolution:-
Check and make sure that the file is uploaded for the right function. In the preceding example, the you might have uploaded the file for Phones - Insert All details, where as the CSV file actually belongs to Phones -Insert Specific details. Delete the file through Upload/Download Files menu option and upload it for the right function.
You schedule jobs with a specific scheduled time for execution. But, the jobs remain in Pending state, even after the scheduled time.
Check for the following details:
a. Check that Cisco Bulk Provisioning Service (BPS) is started.
b. Check that there is no other job in Processing state. BPS can process only one job at a time.
c. Check if Stop Processing is requested for BPS transactions. If so, go to Job Scheduler window and click Start Processing.
After you submit jobs with all the required data, the jobs show in Hold state on the job scheduler window. These jobs do not get executed.
Recommended Action You need to activate jobs that are in Hold state, before they can be executed by BPS. Go to Job Scheduler window and follow the process to activate the job.
After you submit a job with all the required data, choose Bulk Administration > Job Scheduler. Enter the appropriate search criteria for the job you scheduled and click Find. The job does not display in the search results. Check if Hide is chosen in the third drop-down list box in the Search Options area of the Find and List Jobs window. This option hides all the completed jobs. If the job you submitted is already complete then it will not be displayed in the Search Results area.
In the Find and List jobs window, choose Show from the third drop-down window and click Find again. The search results now display completed jobs also.
The CSV file contains MAC addresses. You cannot provide dummy MAC addresses when MAC addresses are present in any row in the CSV file.
Resolution:- If you want to use dummy MAC addresses, create a new CSV file that contains only those records for which you have not specified MAC addresses. Alternatively, you can specify MAC addresses in the CSV file and not check the Create Dummy MAC Address check box.
In Microsoft Excel packaged with Office XP, macro security is set to high by default. Due to this setting, macros in BAT.xlt cannot run which renders BAT.xlt unusable.
To enable macros in BAT.xlt use the following steps:
a. Open BAT.xlt.
b. Go to Menu >Tools >Macro > Security.
c. Set the Security Level to Medium.
d. Close BAT.xlt and open it again. When prompted, choose Enable Macros.
The CSV file contains MAC addresses. You cannot provide dummy MAC addresses when MAC addresses are present in any row in the CSV file.
If you want to use dummy MAC addresses, create a new CSV file that contains only those records for which you have not specified MAC addresses. Alternatively, you can specify MAC addresses in the CSV file and not check the Create Dummy MAC Address check box.
Great doc!
Thanks Leonardo !!!
Hello,
I would like to add a point for those who are francophone like me and whose format defined in the regional settings are French.
When trying to add a number to define the number of Directory Number we want. No matter what value enter; we get the error message "Please enter a numeric value". Which does not make sense because normally we definitively enter a number.
To resolve the problem you can only change the parameter Format in the regional settings and change it for English.
If you are somewhat familiar with Visual Basic in Excel, you can choose this solution:
The Visual Basic code in BAT validates the version of Excel by using a function that creates an error message. In many places, in the VBA code we find:
If Application.Version <= 11 Then
strLimit = 254
Else: strLimit = 15998
End IF
If you replace this with
If Val(Application.Version) <= 11 Then
strLimit = 254
Else: strLimit = 15998
End IF
You will no longer get this error message. Remember to use the "find and replace" to make sure you make the change everywhere in the code.
It is this link that has helped us to solve the problem https://www.rondebruin.nl/win/s9/win012.htm
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: