problems generating csv using bat.xlt in CUCM 11.0

[chaman prakash]

Hello gentlemen

I`m having some difficulties generating csv from the bat.xlt file downloaded from my CUCM publisher using excel 2016 as well as excel 2013

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!

[Chris Deren]

Can you share your file?

Make sure your Excel is 32-bit edition, as BAT file dos not work with 64-bit.

[chaman prakash]

Hi Chris,

Thanks for your revert. Please find attached file 

[Chris Deren]

The buttons on this file do not work, use the bat.xlt which you download from your CUCM and let us know if that does not work either.

[chaman prakash]

Hi ,

I downloaded the file from CUCM and tried still same error.

Even i verified i am using 32 bit of excel