Importing Devices from a CSV File

The .csv file must have the following format:

The following rules apply for format of the file content:

• The first line (Header) must list all attributes for the devices that are listed in the file. It is not necessary that all attributes are present.
• The first value must be the DeviceName, the remaining columns can be placed in a different order.
• The number of attributes listed in the Header line must match the number of values in the following lines per device. If the numbers do not match, the import will stop at the first error.
• Double-quotes are accepted and recommended for each cell.
• Only the comma is accepted as separator character, do not add spaces.
• If the DeviceType is to be localized in the CM console it must be one of the following values:
   VoIP adapter, VoIP phone, WAP, firewall, broadband router, storage-misc, bridge, print server, specialized, PBX, webcam, power-device, media device, phone, remote management, telecom-misc, proxy server, security-misc, terminal, load balancer, printer, PDA, game console, general purpose, router, switch, server.

Device lists in the form of .csv files can be directly imported into the CM database with all their provided information. This way you can create new devices in the database and update existing devices with new values.

To import the devices listed in a .csv file proceed as follows:

1. Select Device Groups from the left window pane.
2. Select the group in the left window pane to which devices are to be added.
3. Select Edit > Import Devices from CSV File
   The Open dialog box appears on the screen.
4. Browse to the desired .csv file and select it.
5. Click Open to open the list.
    The Select Devices from the List dialog box appears on the screen.
6. Select the device from the list to be added to the group.InformationYou can select all devices in the list by clicking Select All .
7. Check the Create not Existing Devices box if the list contains devices which are not yet in the CM database and which are to be created.
8. Click OK to confirm.

Not existing devices are added to the CM database.

If changes on existing devices were made, the Import a CSV File dialog box appears on the screen, giving you the possibility to save the import results as a .xml file via the respective icon .

If operational rules are assigned to the device group you are adding the imported devices to and the respective system variable is activated, a confirmation window appears.