Exporting Users from Director for Import to Conf Bridge

[getzjd]

Is there any easy way to build the conference bridge bulk import file from a user list exported from Shoreware Director?

Why does it appear that the shoreware user manager and the converged conference bridge are not linked in any way as far as users go?

[getzjd]

I have trouble imagining that ShoreTel would develop a conference bridge that did not directly talk with their phone system. What kind of hokey pokey setup is that?

Does anyone know if it is in the works to integrate the two? It just makes no sense to me.

Still trying to find the best way to import 250 users. I can spend 3 days working on exporting and formatting an import file or I can just start typing.

[BLenarcik]

ShoreTel didn't develop the bridge. It comes from an OEM (Notice the "Powered by eDial" text scattered in the management web site?).

The bridge does support AD/LDAP integration and with AD support coming in ShoreTel 9.0, you end up with a way to integrate the user lists between the 2. Besides, you don't need an extension on the ShoreTel PBX to be a user on the bridge.

It might be easier to install the free MySQL GUI tools on the ShoreWare Server and use the MySQL Query Browser to write a simple select statement to get the bridge userIDs. Director automatically creates the user email address and bridge user ID from the GUI Login Name and appending "@domain.com". Here's the query:

SELECT BridgeUserID from users u;


If this field is not populated, you can extract the user name and format it in the way that the bridge requires ([email protected]) with this query:

SELECT CONCAT(GuiLoginName, "@domain.com") from users u;

If the user part of the email address doesn't follow the format of first intial + lastname, you can use the TabAddresses table to get the first name and last name fields and MySQL string functions to assemble the bridge ID as you like. For example, if the format is FirstName + Last Intitial, the query would be:

SELECT CONCAT(FirstName, Left(LastName, 1), "@domain.com") FROM tabaddresses t;

Once you have the query results you want, MySQL Query Browser has a simple menu option to export the results to CSV, HMTL, XML, Excel, or PLIST (property list) formats. From there, you can build the rest of the import fields pretty quickly.