- Contents
CSV List Import Technical Reference
Create a CSV Managed IP phone-Template list
Follow this procedure to create a CSV managed IP phone based on template.
To create a CSV Managed IP Phone-Template list:
-
Open a copy of CSV Managed IP Phone List-Template.xlsx.
The following table provides descriptions of each attribute.
Attribute
Description
Name
(Required) Type the name of the IP phone.
Template
(Required) Type the managed IP phone template for this IP phone. The template name must be identical to one of the templates you have created.
Proxy Group
Type the Registration (Proxy) Group to be used with the managed IP phone template for this IP phone.
If this value is left blank, Managed IP Phone Assistant will fill in the Registration Group defined in the template.
Extension
Type the primary appearance extension number for this IP phone.
When this value is left blank, it will remain blank in Managed IP Phone Assistant.
Identification Address
If you know the IP address for this IP phone ahead of time, type the SIP connection address in the form of
sip:xxx@[IPaddress]:[portnumber], e.g.,sip:320@172.17.238.68:5060.If you do not know the IP address, leave this value blank. It will be filled in when the phone registers with the CIC Server following provisioning.
Label
(Polycom only) Type the label that will be used for the primary appearance of this IP phone and the associated SIP station. Typical values for
label
are the station extension or the user's extension (in the case where one user will almost always be using the station).When this value is left blank, Managed IP Phone Assistant will fill in the Name attribute (IP phone name).
Address
If you know the address for this IP phone ahead of time, type:
For Polycom phones: The MAC address of the IP phone. Polycom addresses start with
00:04:f2.For SIP Soft Phones: The full computer name for the IP phone. To make sure you get the full computer name, navigate to My Computer > Properties > Computer Name and note the Full Computer Name. For example:
PattyJ.acme.com.For Interaction SIP Station phones: The MAC address of the IP phone. Interaction SIP Station MAC addresses start with
00.26.fd.For AudioCodes or Genesys phones: The MAC address of the IP phone. AudioCodes and Genesys addresses start with
00:90:8f.If you do not know the address ahead of time:
For Polycom phones: You must manually provision using the provisioning IVR.
For SIP Soft Phones: You must manually provision using the SIP Soft Phone Provisioning wizard.
For Interaction SIP Station phones: The Interaction SIP Station cannot be provisioned through the provisioning IVR. If the MAC address was not known at the time the CSV list is created, the MAC address must be manually entered for each Interaction SIP Station in the Interaction Administrator Managed IP Phone container before the corresponding phone is set up and booted.
For AudioCodes or Genesys phones: You must manually provision using the provisioning IVR.
-
Type the attributes in the appropriate columns for each managed IP phone and associated SIP station to create.
-
Save the file as ".csv" file type.
-
If a message indicating that the ".csv" file cannot preserve some of the macros in the Excel file appears, click Yes. Managed IP Phone Assistant doesn't need those macros when importing the file.
Here is an example of the resulting CSV Managed IP Phone List.csv file as it appears in Excel:
When the CSV file is opened in a text editor, the IP phone information is separated by commas, with one IP phone listed per line.
-
Download your CSV Managed IP Phone list-Template.csv file to a secure location on the CIC Server.

