Import devices from Excel spreadsheet (Zenitel Connect Pro)

In larger Zenitel Connect Pro systems with many devices the best practice is often to use an Excel spreadsheet to prepare the initial configuration of Zenitel Connect Pro. When on site the spreadsheet can be imported into Zenitel Connect Pro.

• Download and open the Excel template file
• Select the tab Devices, and fill in:
  • Directory Number: The number you want to dial to reach the device
  • Name: The name you want to identify the device by
  • Type: Type of device; A drop-down list is available; Not mandatory
  • MAC address: A 12-character code found on the label of the device, and from the 2D code on the device box; Not mandatory
  • Location: Any descriptive text; Not mandatory
  • Comments: Any descriptive text; Not imported into Zenitel Connect; Not mandatory
  • CallButton Profile: Used to define the number to dial when a call button is pressed; Typically used for one- or two-button devices; You can use the same profile for several devices

Example spreadsheet

• Select the tab CallButton Profiles, and for the relevant profile enter the directory number to call when the call button is pressed ("Idle" cell), and optionally what action to take if the call button is pressed during a call ("InCall" cell).

Link buttons to CallButton Profiles

• Save the spreadsheet using a descriptive file name.

• Log in to the web interface of Zenitel Connect Pro, and go to Devices and Connections > Configuration, and select the Import icon and select the Excel file you just created.

Import device configuration from Excel file

A message will appear that the file has been parsed, select the appropriate options:

File parsed, with options

• The Excel spreadsheet may contain devices which are already configured in Zenitel Connect Pro; it is possible to select to delete those from Zenitel Connect Pro and import them again or to ignore them during the import
• A second possibility is to ignore the import of the already defined devices, but to update the call button configuration with the information as defined in the spreadsheet

After importing the Excel file the new devices will appear in the configuration table of Zenitel Connect Pro:

Successful import of devices from Excel

When the devices are connected to the network, run the Scan function to discover the devices:

• If the MAC-address was included in the import from the spreadsheet, the discovered devices will automatically be assigned
• If the MAC-address was not included in the import from the spreadsheet, select "Click to assign" on a discovered device, and pick the directory number you want to assign to the device from the drop down list.