ā01-28-2013 11:05 AM - edited ā03-16-2019 03:24 PM
Hello gentlemen
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..
after filling in some data in the 5 columns I need, witch are Device name, Decsription, Directory number, Display and Line text label (taking care to not enter illigal data, eg boolean, string, integer) I try to press the "Export to BAT format" button.
a popup message displays "please enter numeric value in the text boxes" and this popup will not go away no matter where I click inside excel after this
I try to enter a value above 0 in a text box, but I only get to enter a value in one of the boxes before the popup ruins the day, after that the popup message/error message appears immediately if I click anywhere in the spreadsheet
I have tried to save the file as an "Microsoft excel macro enabled worksheet" (.xlsm) but it doesnt seem to help
Thanks for your help!
.xlt file from CUCM included
Solved! Go to Solution.
ā01-28-2013 11:24 AM
Hi Geir,
It's likely one of these two bugs;
Description
Symptom:
BAT.xlt does not work in Microsoft excel 2010
Conditions:
Microsoft excel 2010
Workaround:
None
Details
Status:
Open
Last Modified:
May 07,2012
Product:
Cisco Unified Communications Manager (CallManager)
Platform:
Dependent
Severity:
6 - enhancement
or
Related Bugs
Cheers!
Rob
"Spend your life waiting,
for a moment that just don't come,
Well, don't waste your time waiting"
-Springsteen
ā01-28-2013 11:25 AM
I just tried your file and all is well, what did you enter under MAC address/device name?
Also, is this by any chance 64-bit Excel, if so that is not supported, only 32-bit Excel on either 32 or 64 bit Windows OS is supported.
HTH,
Chris
ā01-28-2013 11:24 AM
Hi Geir,
It's likely one of these two bugs;
Description
Symptom:
BAT.xlt does not work in Microsoft excel 2010
Conditions:
Microsoft excel 2010
Workaround:
None
Details
Status:
Open
Last Modified:
May 07,2012
Product:
Cisco Unified Communications Manager (CallManager)
Platform:
Dependent
Severity:
6 - enhancement
or
Related Bugs
Cheers!
Rob
"Spend your life waiting,
for a moment that just don't come,
Well, don't waste your time waiting"
-Springsteen
ā01-28-2013 01:05 PM
Hi Rob
found another PC with excel 2003 SP3, but unfortunatly it didnt work, so I`m obviously doing it wrong..
Do you know what the boxes in column G in the bat.xlt is for ? (boxes under Export to BAT format button)
I dont want to import this information into CUCM anyway so I dont understand why excel asks
I`m trying to import about 300 softphones(CIPC) into CUCM, at this point in time I do not have their MAC addresses because IP communicator isnt yet installed on my customers computers.
I wish to use the DN as the MAC address/device name..
but maybe this workbook only accepts a 12 digit MAC without : or -
perhaps you know witch macro/function that performs the check that generates the error message so I can turn it off?
ā01-28-2013 11:25 AM
I just tried your file and all is well, what did you enter under MAC address/device name?
Also, is this by any chance 64-bit Excel, if so that is not supported, only 32-bit Excel on either 32 or 64 bit Windows OS is supported.
HTH,
Chris
ā01-28-2013 11:42 AM
wow that was quick! :-)
I guess I have a 64 bit excel installation on this computer, the win7 is 64bit..
its a work PC that our IT department made for me
Next task will be digging in the closet and look for an old enough PC, hehe
I`ll let you know how it works out
anyways, thank you very much for your help my friend :-)
ā01-28-2013 01:03 PM
Hi Chris
found another PC with excel 2003 SP3, but unfortunatly it didnt work, so I`m obviously doing it wrong..
Do you know what the boxes in column G in the bat.xlt is for ? (boxes under Export to BAT format button)
I dont want to import this information into CUCM anyway so I dont understand why excel asks
I`m trying to import about 300 softphones(CIPC) into CUCM, at this point in time I do not have their MAC addresses because IP communicator isnt yet installed on my customers computers.
I wish to use the DN as the MAC address/device name..
but maybe this workbook only accepts a 12 digit MAC without : or -
perhaps you know witch macro/function that performs the check that generates the error message so I can turn it off?
ā01-28-2013 01:40 PM
I don't know what you have added in column G as the file you posted was the default blank template. If you don't want to specify MAC then you need to heck the "dummy MAC address" checkbox and the macro will assign one for you that later can be used with TAPS.
HTH,
Chris
ā01-28-2013 02:34 PM
I`m sorry, I got ahead of myself... :-)
In the original file, that was attached to the first question (downloaded from CUCM) there are two columns predefined when the "phones" tab is active, the textboxes are in D column...
After I had added the fields that I wanted with the "Create file format" button, the boxes ended up in the G column :-)
I`ll try using "dummy MAC address" and see where that leads me... if that dont work, I guess import will have to be done manuallly
ā01-28-2013 05:22 PM
If you have not populated the device name column the macro will not work unless you check the "dummy MAC address" check box, so if your plan is to either use TAPS or update the device name later simply check the checkbox. There should be no reason to build this amount of devices manually and we will surely guide you here if you are still having difficulties.
Chris
ā01-29-2013 02:58 PM
Hi Chris
I tried to populate the Device name column (not MAC addesses, but a 5 digit number..) that didnt work...I have also tried with a proper MAC address in the Device name column, but no luck.
Perhaps you can explain to me how important these "text boxes" are? I mean the ones under the "Export to BAT Format" button. can they be removed? because the info in these boxes are not important at this point
if I chech the "Cisco IP communicator" button, witch are the phones I wish to import, the "Dummy MAC address" checkbox goes away
ā01-29-2013 03:12 PM
Device Name is a required field unless you check the "Dummy MAC address" checkbox. Did you try that?
Simply add Directory Number field to the default view and check the checkbox and press the button. What do you get?
Please post tour saved template with your values.
Chris
ā09-13-2013 12:47 AM
Hi, I have a similar problem with bat file in CUCM9 (9.1.1a) and Microsoft Office 2013. Once I clicked to box "Maximum Number of Phone Lines" and I changed number, I always received text "Please enter numeric values in the Text boxes".
I have Win7 64bit and Office 2013 32bit. Do you know about any workaround???
Thank you so much
Karel
ā09-16-2013 01:24 AM
Hi, I resolved this problem by reconfiguring the Excel file in Visual Basic in Development mode in Excel. There is text line with "If Application.Version => 11 Then". Here, you must get your version of Excel.... I have MS Office 2013, so i gave here "If Application.Version = "15.0" Then". This string must be changed in whole document. Now, everything works fine....
Karel
ā01-22-2015 02:50 AM
Many thanks!!!
Quite so everything earned!
Forgive my English...
ā09-29-2017 03:56 AM
Using these steps I manage to reconfigure bat.xlt in CUCM 11.5.1., but I had to made same changes to module 1 with Visual Basic in Development mode in Excel 2010 for bat.xlt file too. Thanks for the guidance, it helped.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide