TD 92326GB
2009-03-10 / Ver. E
Installation and Operation Manual
VoIP Gateway
172
Appendix E: How to add a Large Number of Users to the VoIP Gateway
By using the Mail Merge function in Microsoft Word and a structured data source, for
example an Excel spreadsheet, multiple users can be added to the VoIP Gateway.
This process involves the following steps:
• Create a database (or use an existing source)
• Create a Word document (a command template)
• Add placeholders for database fields to the document
• Merge the data from the data source into the document
E.1
Set up a Database for Mail Merge
1
Create a database in Excel with the relevant fields (no spaces in header row).
• Long_Name
• Name
• Extension
• User filter (if applicable)
• Call diversion filters (if applicable)
Example:
2
Save the database
E.2
Add Database Fields to a Mail Merge Document
3
Open Microsoft Word and create a command template as follows:
Tip:
Create and configure one user in the PBX > Objects. Then, to see all
commands needed, view the configuration in Diagnostics > Config show.
Insert Merge Fields after the "=" signs into the proper places, as described in the
following steps:
4
Place the cursor where you want to insert the field and select Insert > Field.
5
Mark "MailMerge"in the
Categories
drop-down list and "MergeField" in the
Field
names
drop-down list.
Long_name
Name
Extension
User_filter
Div_filter
Billy Bob
Billy
1000
Normal
Local
Joe Jens
Joe
1001
Normal
Local
Hank Hill
Hank
1002
Normal
Local
For VoWiFi:
mod cmd FLASHDIR0 add-item 101
(cn=)(h323=)(e164=)(loc=.)(node=root)(pbx=<user filter="" cd-
filter=""/>)
For IP-DECT:
mod cmd FLASHDIR0 add-item 101
(cn=)(h323=)(e164=)(loc=.)(node=root)(pbx=<user filter="" cd-
filter=""/>)(pbx=<gw name="DECT" dsp=""/>)
