In preparation for a migration to CUCM 9.1.2 we need to update the owner ID field on around 7000 phones. The only way to do this through the bulk admin tool is to export phone all details, update the field and then re import all the phones. The export generates a .txt file. If I open this as an csv in excel it automatically chooses the column data types which messes with the number fields by stripping off leading 0s. If I try and import the data Excel says there are too many columns. How have others been able to work with the phone all details export?
In a presentation at Cisco Live 2013 they mentioned some utilities to help with this. Is BAT the only option? The option above probably will work but it can be scary when you have a lot of phones if you make a mistake anywhere.
One of my colleagues has a created a script that goes through the exported file and fixes up the service parameters so we got around these. I piloted re-importing a couple of hundred devices and few spat out sql/db connection errors. I then tried to update another 400 phones the next night and although the validation goes fine, when I try and import i'm faced witha Memory allocation error:
sql.SQLException: Memory allocation failed during query processing.
I know this is most likely specific to our CUCM environment and we will be doing a restart tonight to hopefully resolve the issue (the TAC engineer suggested restarting the DB service). However it just seems like one issue after another to do a fairly simple task. The whole process of having to import every field on every phone to update one field is rediculous. I have a list of phone IDs and a list of users, why isn't there a way to define a custom file format and use the update option rather than having to re-insert all details?
This blogger wrote a cURL AXL script to pretty much do what I'm suggesting:
I'm not able to access my old voice mail messages all of a sudden. The recording says something like 'the message is currently not available'. This has never happened before in all the years I have been using this system. I have t...
If you have 2 ISR routers, one acting as Failover, do we need to have both the same number of SRST licenses on the 2 routers?
No. You will only need the SRST licenses on the primary router. Because this feature...
You have reached the Cisco Logistics Support Center.. To Check Status of your RMA, visit Product Returns & Replacements (RMA).
Need help? Contact us by Phone or Email.
Phone: 1800 553 2447 Option 4