AudioCodes 310HD, Administrator'S Manual, Page: 30 / 284

310HD, 320HD and 420HD IP Phones
Administrator's Manual 30 Document #: LTRT-09910
4.5.5 CSV File
The csv file contains a list of tags and a list of the tag’s values. The first line in the file
contains the list of tags (comma-separated) and each of the other lines contains a list of
values, where each line record represents an individual IP phone.
The csv file is usually exported from the customer’s IP-PBX or some other database and
typically contains the list of IP phones (e.g. MAC, extension ID, user name and password
of each IP phone).
Table 4-1: Example of CSV File
[mac] [name] [id] [password]
00908F123456 Jonathan 4071 12345
00908F123457 David 4418
12345
When opened as a text file, the csv file appears similar to the example below:
[mac],[name],[id],[password]
00908F123456,Jonathan,4071,12345
00908F123457,David,4418,12345
4.5.6 Template File
The template file defines the format of the generated configuration files, but contains tags
instead of actual values. The VoIProvision utility reads the template file and replaces each
tag with actual values from the csv file.
Example of a template file:
system/type=310HD
voip/line/0/enabled=1
voip/line/0/id=[id]
voip/line/0/auth_name=[name]
voip/line/0/auth_password=[password]
include global.cfg
4.5.7 Generated Configuration Files
The generated configuration (.cfg) files use a similar format to the template file; however
the tags are replaced with the actual values that are read by the VoIProvision utility from
the csv file. One of the tags defined in the csv file, should be used as the .cfg file name (in
order for the VoIProvision utility to generate a separate .cfg file for each line record in the
csv file). Typically the tag which defines the MAC address is used as the .cfg file name.
4.5.8 Starting the VoIProvision Utility
The VoIProvision utility can run on both the Linux and Windows platforms. The
VoIProvision utility initially parses the csv file to generate the list of tags. The VoIProvision
then reads each line record of values in the csv file and for each line record, does the
following:
„ Parses the line record to create a list of values
„ Opens the template file
„ Generates the .cfg file name and create a new .cfg file
„
Reads the template file, associates the mapped tags with actual values from the csv
file and writes the result to the .cfg file
„
Closes the .cfg file and template file
http://arttel.ru