Anyone else having an issue exporting bat files from the excel sheet that comes with CM 6.1(2) for VG224's? Every time I try to export to bat format button, I get an error message that says "Object doesn't support this property or method". And that's just inputing the mac address and nothing else and trying to export. file version is bat 18.104.22.1680(13)
TAC says it's a bug - no workaround at this time. To get around the Phone/Users tab, I was able to create the .csv separately and import them just fine. But the VG224 is really screwed up because the headers in the BAT file and the sample file don't match. About as far as I get is creating the gateway but not the individual ports.
...But in the Job Scheduler I still get: "Could not insert new row - duplicate value in a UNIQUE INDEX column"
someone knows why?
TAC workaround for the phones/user issue: First of all use the bat template from an older cucm 6.x version (see attachment). Then put the phones and users in via bat, the cfa field isn't filled which is a bug. If you run the job again and check the "overwrite" checkbox it should work.
By the way, we have the same issue with VG224 GWs and there is no workaround. Just updating to the newest ES..
I was finally able to insert MGCP VG224's using BAT. I used the BAT 6.0 file, entered my information on the VG224 tab, used a VG224 BAT Tamplate where only port 2/0 was configured (Device Pool, CSS, Location, etc.). I configured the Line template for that one port, then imported using the normal BAT format. Took two tries...it seems as though BAT wants to create the gateway completely. The first time I created the gateway but didn't configure any ports - that didn't seem to work.
Using CUCM: System version: 22.214.171.1240-13
noticed the same...
But you will still have two bugs:
1) The CFA CSS and destination is empty.
2) As soon as you've inserted a gateway, you can't add ports via bulk. You have to insert the gateway with all 24 ports configured at the first time.