cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Troubleshooting BAT

5530
Views
20
Helpful
3
Comments

 

 

 

Introduction

 

 

This document describes some issues that could occur and the possible resolutions in BAT(Bulk Administration Tool)

 

 

Issue :-  Bulk Administration menu does not display in Cisco Unified Communications Manager Administration.

 

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.

 

 

Issue :-   Cannot access complete Bulk Administration functionality.

 

 

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

 

 

Issue :-  Export to BAT Format button does not work in BAT.xlt file.

 

 

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.

 

 

Issue :-  BAT Excel spreadsheet gives a compilation error while exporting data to the CSV format.

 

 

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.

 

 

Issue :-  BAT Excel spreadsheet does not respond to actions.

 

 

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.

 

 

Issue :- Data files (CSV) format do not match Phone Template/Sample File.

 

 

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.

 

 

Issue :- Uploaded CSV file does not display in the File Name drop-down list box.

 

 

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.

 

 

Issue :- Jobs remain in Pending state even after the scheduled time expires.

 

 

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.

 

 

Issue :-  Jobs remain in Hold state.

 

 

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.

 

 

Issue :- Job does not display in the Find and List Jobs window.

 

 

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.

 

 

 

Issue :- MAC address values are not allowed in the file if dummy MAC address values are desired.

 

 

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.

 

 

Issue :- The BAT.xlt spreadsheet does not work with Microsoft Excel XP (Office XP)

 

 

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.

 

Issue:-  MAC address values are not allowed in the file if dummy MAC address values are desired.

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.

 

 

Related Links

Comments
Collaborator

Great doc!

Rising star

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

 

Content for Community-Ad