06-27-2012 12:10 PM - edited 03-16-2019 11:53 AM
Hello,
Is there a way to bulk change VG224 lines? I would like to extend No Answer Ring Durration for about 400 lines, but I can't seem to pull them up in Bulk Administration. I am using CUCM 8.0.
Solved! Go to Solution.
06-27-2012 12:14 PM
If you can't do it via BAT, then you'd need to look at using the SQL interface. You can do almost anything via this: Including trashing your CUCM DB
GTG
06-27-2012 12:24 PM
I don't use BAT, so I can't help there. For bulk work, I tend to use the SQL console interface:
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cli_ref/8_6_1/cli_ref_861.html#wp39876
GTG
06-27-2012 12:40 PM
No. But I do have the 600-page data dictionary PDF on my desktop . (I do a fair bit of writing custom CUCM apps) The database has a fair amount of protection within in (strong referential integrity, query throttling, etc) But it won't stop you running a DELETE query where you've missed off the WHERE clause . Oh, and there's no transaction support to help you either. (well, not that's exposed to us mere mortals...)
Providing you're sensible, and test on your dev CUCM, it's not too bad.
GTG
06-27-2012 12:14 PM
If you can't do it via BAT, then you'd need to look at using the SQL interface. You can do almost anything via this: Including trashing your CUCM DB
GTG
06-27-2012 12:20 PM
That's interesting. My understanding is that CUCM these days uses Informix. With respect to BAT, can you detail what would be involved?
06-27-2012 12:24 PM
I don't use BAT, so I can't help there. For bulk work, I tend to use the SQL console interface:
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cli_ref/8_6_1/cli_ref_861.html#wp39876
GTG
06-27-2012 12:34 PM
Wow, that's actually pretty interesting. There it is; running SQL statements on the CLI. If this "run sql
06-27-2012 12:40 PM
No. But I do have the 600-page data dictionary PDF on my desktop . (I do a fair bit of writing custom CUCM apps) The database has a fair amount of protection within in (strong referential integrity, query throttling, etc) But it won't stop you running a DELETE query where you've missed off the WHERE clause . Oh, and there's no transaction support to help you either. (well, not that's exposed to us mere mortals...)
Providing you're sensible, and test on your dev CUCM, it's not too bad.
GTG
06-27-2012 12:46 PM
Oh, I see where you're coming from (helps explain how you would recommend making database changes directly via CLI). No, this is definitely not a practical method for day to day things (I do some work in MySQL, so I understand what you're saying.) Yes, I would like to avoid a situation whereby I can accidentally blow away an entire table by forgetting a clause after a long day of staring at a screen.
However, I was not aware of this direct manipulation of data. Fascinating. I can't use this approach but I'm glad you mentioned it
06-27-2012 12:48 PM
Gordon,
One question - I've not worked with any databases outside of MySQL, but it sounds like other RDBMs are able to handle standard SQL queries, correct? That sounds really handy since you can write one set of queries and make it portable between multiple platforms, no?
06-27-2012 12:52 PM
Sorry, don't understand what you're saying/asking.
GTG
06-27-2012 01:03 PM
Hi Shikamarunara,
Wow! Gordon has given you some great insights here (as usual +5 "G" )
If you don't want to go that route and blow up the dB like I would likely do
Have you tried BAT>Phones>Add/Update Lines>Query if you have anything common
you can search on like Device Pool for these VG's you would be good to go.
Cheers!
Rob
"Show a little faith, there's magic in the night" - Springsteen
06-27-2012 03:01 PM
Hey Rob,
Good to hear from you again. How's the weather up there
I tried updating the lines in Bulk Administration the same as I would any line, but for some reason FXS lines do not show up in the query. Struck me as odd. Unfortunately, I can't search based on device pool because the search isn't narrow enough. Can you update VG224 lines with Bulk Administration on your system?
07-12-2018 06:34 PM
Sorry, 6 years late but I knew I had done this before but couldn't remember how, found this post in the search. I've used this method from v8 on.
1) Bulk Admin Export all Gateways, download the TAR ball,
2) extract gateway.csv
3) Open gateway.csv using Excel or Calc, set the type for all cells to text,
4) remove all gateway ports and types from the CSV that are not needed (FXO, PRI, H323 etc). You can delete the columns not needed, check for syntax errors (#NAME can go away)
5) modify all the cells that need to be updated
6) save the updated gateway.csv
7) open the CSV in a text editor (notepad++, gedit) and remove all the extra commas
8) open the tar ball, remove the gateway.csv from the tar ball and add your updated gateway.csv
9) upload the new tar ball to bulk admin Import
10) import the changes overwriting existing configuration
11) check the errors, spot check imports for the updated.
Hope this helps someone.
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