BULK Administration tool - Phone/UDP updates

[radoslav-drabik]

Guys

I'd like to upgrade some existing phones/UDP in my cluster using the BULK Administration tool. What I have read so far I have got 3 options:

     1. "Export all details" -> Modify the file ->  then "Import all details" with "Override the existing configuration" (with all checkbox checked)

     2. "Export" using UDP file format" (specific fields only) -> Modify the file -> then "Import specific details" with "Override the existing configuration"

     3.  "Export all details" -> Modify the file (removing all columns I don't need) -> then "Import specific details" with "Override the existing configuration"

My questions:

     a) Do I have any another option to update Phones/UDP?

     b) Why do I have to choose "User Device Profiles Template Name" when doing "Import specific details" with Override the existing           configuration"? Is it doing something? I just want to upgrade some specific details defined in my csv file.

Thank you.

[William Bell · Accepted solution]

The optimal method will depend on what you are trying to change. The options you list will cover most needs but may be overkill. Just depends on what you are trying to modify. If I knew that then I could provide more direct feedback.

There are definitely other options. You could:

1. Update from the CLI using SQL. Not very practical if you are trying to update alot of fields with custom (per user) values but can be handy if you were doing something like changing the directory numbers from 4-digit to 10-digit (as an example). So, modifying things in bulk that aren't easily/efficiently addressable via BAT.  (example:

http://www.ucguerrilla.com/2012/04/updating-speed-dials-using-sql-queries.html)

2. Leveraging SQL using the AXL SQL Toolkit: The basic premise is the same as the CLI approach except that you can build a "bulk" change file off line and then use the tookit to execute all changes as a batch. So, same skills (more or less) are required. (example:

http://www.netcraftsmen.net/resources/blogs/running-sql-queries-on-cucm-6x7x-using-axl-soap-toolkit-part-2.html)

3. Custom script/app leveraging AXL/SOAP. Whether you are doing SQL update (like #2) or using the custom API calls (like updateLine, updateUser, etc.) you could use (or buy) a tool that basically optimizes your interface to the CUCM db repository. Probably overkill for your needs, but you did ask about options.

The point of using a template for specific details is because BAT needs to be able to determine what columns to expect in the csv file. Particularly for attributes/params that can be variable (like the number of lines, speed dials, users assigned to the device).

HTH.

Regards,

Bill

blog: http://ucguerrilla.com/

[radoslav-drabik]

Thank you..that's more than I expected.

2 more questions:

1. Let's say I have an existing UDP for 7960 with 2 speed dials. I am trying to update these two speed dials using a csv file, but my BAT template has only one speed speed dial. I am doing "insert with the override option". I will get an error, right?

2.  Will be any value from the BAT template used if I check "Override the existing configuration". The device profile should be updated with the values specified in the csv file only right?

Thank you.

[William Bell]

RADOSLAV DRABIK wrote:
1. Let's say I have an existing UDP for 7960 with 2 speed dials. I am trying to update these two speed dials using a csv file, but my BAT template has only one speed speed dial. I am doing "insert with the override option". I will get an error, right?

Yes, I believe this will result in an error message. You would need to create a template with 2 speed dials.

RADOSLAV DRABIK wrote:
2.  Will be any value from the BAT template used if I check "Override the existing configuration". The device profile should be updated with the values specified in the csv file only right?

I am not sure I follow. When you use the override existing config option, values in the CSV are written into the record and existing values are replaced. I am not sure if that is what you are asking.

HTH.

Regards,
Bill

blog: http://ucguerrilla.com

[radoslav-drabik]

Hi

I tried to change the user locale for an existing UDP.

1. TEST (Insert specific details + override option)

I created a .csv file containing:

     a) Device profile name

     b) Description

     c) User locale

I inserted the .csv file through BULK Administration ->UDP -> Insert -> UDP specific details + override option.

So it actually did change the user locale but besides it changed everything according the BAT template that I used.

That's something I didn't expect. I just wanted to change the user locale.

2. TEST (Insert all details + override option)

Then I tried to export all details for the UDP, changed the user locale field in the csv file and inserted it back using

BULK Administration  -> UDP-> Insert -> UDP all details+ override option. That worked for me.

This is really strange for me why I can't update an existing UDP without using the BAT template that overrides my custom profile.

[Ayodeji Okanlawon]

Radoslav,

BAT is doing exactly what you asked it to do. If you want to change only a single field, then just edit the entry for that field in your csv file. If you change the other entries and you select override option, then it would just that.

So just edit the field you want to change only..

[H-Alashi]

Hi william,
thanks for the shared values,

i have a question, how is it possible or the easiest way to do a bulk update of User Device Profile lines using a custom file (not query).
For each User Device Profile line in the custom file,I want to update Partition and CSS.

thank you in advance

Haron