cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
357
Views
5
Helpful
4
Replies
Anton Tutunov
Beginner

Import phones and users to CUCM 9.1

Hi!

I have CUCM 9.1 and I need import some users and phone from bat.xlsm but have problem.

Then I tried on update users tab select and change value "Number of Access Control Group", " Number of Controlled Devices" and other I see message from Excel "Type mismatch", but how I think must add columns " Number of Access Control Group" and other. This first problem.

 

On Phones tab I tried change value "Maximum number of Phones Lines" for example "1" and get message "Please enter numeric values in the Text boxes". This second problem.

 

I tried using Office 2013, 2010, 2007, all security parameters in Excel was disabled.

 

My bat.xlt file attached.

 

Can you help me please?

 

4 REPLIES 4
li007il89
Beginner

Hello Anton,

 

Do you resolve this issue? I have the same problems.

 

Best regards,

Uladzimir

What I see in the original poster's bat.xlt is that he has not yet added "Directory Number" as a field using "Create File Format". After that is done, then the field for "Maximum Number of Lines" works.

 

Uladzimir - Please post your bat.xlt/xlsm so we can take a look.

Hello Maren,

Thanks a lot for your reply.

I have problems with Users tab.

I received "Type mismatch" error when I'd tried to increase number of controlled devices.

 

type mismatch error.jpg

I believe this is an Excel/Windows version issue on your local PC. When I opened the bat.xlsm you posted on my PC using Windows 7 64-bit and Excel 2016, it works fine and I am able to modify that field.

I did some poking and found this on Microsoft's site:
https://support.microsoft.com/en-us/help/983246/type-mismatch-error-message-when-you-run-a-vba-macro-in-a-64-bit-versi

Which is not to say that the above is your exact problem, but I bet it's related.

Content for Community-Ad

Spotlight Awards 2021