...

The idea is that you prepare the file in your favorite spreadsheet application (Open Office Calc, Excel, gnumeric etc.) and export it to a .csv file. Later you can upload the file and sipXconfig will create the users and phones for you. You can put phones in one or more groups, which helps if you want to configure common parameters for them.

Image Removed

v4.2 The CSV file has to have a title line (though the actual title strings don't matter) and the following columns (in the listed order):

• User name
• Voice-mail PIN
• SIP password
• First name
• Last name
• User alias
• Email
• User group
• Phone serial number
• Phone model
• Phone group
• Phone description

(NOTE: use this template http://scm.sipfoundry.org/rep/sipX/branches/3.6/sipXconfig/neoconf/test/org/sipfoundry/sipxconfig/bulk/csv/cutsheet.csv for  for sipXconfig !Ver3Ver.64.png!2 and older.)

Each line from the imported file will result in the creation of a user with the phone assigned to that user (One line per device). If user group or phone group fields are not empty, the newly created user and phone will be added to the respective group. Groups will be created if they do not exist already.

...

Only the user name and the phone serial number are mandatory fields. You can leave the remaining fields empty, in which case sipXconfig will not overwrite their values. However, the column layout of the spreadsheet file has to be maintained.

v4.4 Version 4.4 added new columns in the CSV file as follows (in the listed order):

• User name
• Voice-mail PIN
• SIP password
• First name
• Last name
• User alias
• EMail address
• User group
• Phone serial number
• Phone model
• Phone group
• Phone description
• Im Id
• Job Title
• Job department
• Company name
• Assistant name
• Cell phone number
• Home phone number
• Assistant phone number
• Fax number
• Alternate email
• Alternate im
• Location
• Home street
• Home city
• Home state
• Home country
• Home zip
• Office street
• Office city
• Office state
• Office country
• Office zip
• Did number
• Office mail stop
• Active greeting - it has one of the following values: "none", "standard", "outofoffice", "extendedabsence" which means Default system greeting, Standard, Out of office and Extended absence
• Email voicemail notification - it has one of the following values: "0", "1", "2" which means 'No notification', 'E-mail notification' and 'Synchronize with the IMAP server'
• Email format - it has one of the following values: "FULL", "MEDIUM", "BRIEF"
• Email attach audio - it has one of the following values: "true"/"false"
• Alternate email voicemail notification - it has one of the following values: "0", "1", "2" which means 'No notification', 'E-mail notification' and 'Synchronize with the IMAP server'
• Alternate email format - it has one of the following values: FULL, MEDIUM, BRIEF
• Alternate email attach audio -  it has one of the following values: "true"/"false"
• Internal Voicemail Server - it has one of the following values: "true"/"false" which means Internal Voicemail Server/Microsoft Exchange UM Voicemail Server
• Caller ID - externally visible user Caller ID
• Block Caller ID - it has one of the following values: "true"/"false"
• Additional phone settings - it contains MicroBrowser settings for Polycom phones and it has the following form: "setting_name1=setting_value1,setting_name2=setting_value2,..". 
  The following settings are supported: mb/proxy, mb/idleDisplay/home, mb/idleDisplay/refresh, mb/main/home, mb/main/idleTimeout, mb/main/statusbar, mb/limits/nodes, mb/limits/cache 
• Additional line settings - it contains the text label which appear on the Polycom's display adjacent to the associated line key and it has the following form: "reg/label=your_text_label"
  
  

Valid Manufacturer / Model Combinations

...