Unity Bulk edits

Unanswered Question

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!

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

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!

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!

tim.giles Wed, 06/18/2008 - 06:53
User Badges:
  • Silver, 250 points or more

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.....

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

tim.giles Wed, 06/18/2008 - 07:12
User Badges:
  • Silver, 250 points or more

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!

pklos Wed, 06/18/2008 - 07:12
User Badges:
  • Silver, 250 points or more

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


--

regards,

PK

Actions

This Discussion