Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Unity Bulk edits

Hi All

I have a customer running Unity 5.0

Each semester they have to go into Unity and CHANGE users Alternate Extension and their MWI extension,.

Is there a way they can use a .csv that contains the user and their new Alternate extension and MWI extension,to CHANGE existing users?

I see the bulk import tool, but didn't see a way to change existing users

thanks for any help!

8 REPLIES
Cisco Employee

Re: Unity Bulk edits

Hi!

Check the Bulk Edit Tool, you can do a query of the subscribers you want to change and then modify fields like Alternate Extensions.

http://www.ciscounitytools.com/App_BulkEditUtility_40.htm

Works fot 5.X too

Regards, Tere. If you find this post helpful, please rate! :)
New Member

Re: Unity Bulk edits

I see where you can change the field, but what we need is to change multiple users to multiple extensions

Ie.

tim jones - alternate extension was 5000 is now 6000

sarah steel - alternate extension was 3000 is now 5000

over 1000 users they have to change each semester.

In the bulk edit you can change the field but it only allows you to change it to the same number for everyone.

I need a way to use a file to change multiple people to multiple numbers at once

thanks!

New Member

Re: Unity Bulk edits

I see where you can change the field, but what we need is to change multiple users to multiple extensions

Ie.

tim jones - alternate extension was 5000 is now 6000

sarah steel - alternate extension was 3000 is now 5000

over 1000 users they have to change each semester.

In the bulk edit you can change the field but it only allows you to change it to the same number for everyone.

I need a way to use a file to change multiple people to multiple numbers at once

thanks!

Silver

Re: Unity Bulk edits

Rather than using a .CSV file (like CallManager), its easier in Unity to use the Bulk Edit tool.

Tell them to look for a folder called "commserver\Utilities\BulkEdit" and run the application from here (or go straight from Tools Depot > Administration Tools)

They just need to select the subscribers and edit the relevant fields....

Please rate if useful.....

New Member

Re: Unity Bulk edits

The tool would allow them to change all of the users to a single alternate extension or manipulate their extension to make an alternate extension

But their alternate extensions do not correlate to their actual extensions. So the the bulk edit looks like it won't work.

Unless someone knows a way for it to work

Silver

Re: Unity Bulk edits

Unfortunately there's no other way of doing it that I know of. You can export the data via an information dump (in tools depot) but there's no way of re-importing it with the changes.

The only other way is to possibly do it in SQL but I've looked at editing the tables and it doesn't look fun!

Silver

Re: Unity Bulk edits

If Bulk is not enough I use SQL update query against Unity database. You need to be careful, but works great ;)

--

regards,

PK

Silver

Re: Unity Bulk edits

You can find some more information about UnityDB here:

http://www.ciscounitytools.com/Applications/UnityObjectModel.doc

--

regards,

PK

142
Views
0
Helpful
8
Replies