CSV export

You can export the list of devices found on the network and later import them into LANconfig in one go. LANconfig stores the list of managed devices in a CSV file.

To export the data, proceed as follows:

  1. Select the menu item File > Export device list.
  2. Set the location to save the file.
  3. Enter a file name.
  4. Specify the column separator, which separates the various device parameters.
  5. Start saving by clicking on Save.
  6. A dialog confirms the number of data sets stored.
  7. Close the dialog by clicking OK.

The resulting CSV file contains the following data (one record per line):

DEVICE_PATH;DEVICE_INTERFACE;DEVICE_TIMEOUT;DEVICE_ADDRESS;
DEVICE_ADMIN;DEVICE_PASSWORD;DEVICE_SNMPCOMMUNITY;DEVICE_NAME;
DEVICE_STARTUP;DEVICE_PROTOCOLS;DEVICE_PORTS;DEVICE_DESCRIPTION;
DEVICE_COMMENT;DEVICE_LOCATION;DEVICE_TYPE;DEVICE_EXTENDED_NAME;
DEVICE_PRODUCTCODE;DEVICE_SERNO;DEVICE_HWADDR;DEVICE_HWREL;
DEVICE_BACKUP;DEVICE_VPN;DEVICE_SSH_FINGERPRINT;DEVICE_CREDENTIALS
MyGroup;IP;3;192.168.2.101;;;;LANCOM WLC-4025;1;263;;;;;
LANCOM WLC-4025;LANCOM WLC-4025;;4000841918000018;00a0571218bb;C;"31;
C:\Users\MyUser\AppData\Roaming\LANCOM\LANconfig\Config\;
\%y_%mn_%dn\%N_%G_%F[1-4]_%hh-%mm-%s;12|";;
02:5a:e5:42:ea:d2:da:f0:93:b5:d0:3d:0c:08:70:b8;

The first line contains the name of the device parameters. The following lines itemizes the various devices line by line, and their parameters are separated by semicolons. If 2 semicolons appear in direct succession, then the enclosed parameter value is blank.

The variable names in the first row correspond to the following LANconfig entries:

Note: Use a text editor or spreadsheet to manage the list of exported devices.
Note: If a device password is stored in LANconfig, the password is saved in cleartext in the CSV file. Remember to delete these access credentials before you pass this file on or save it to a freely accessible server.

www.lancom-systems.com

LANCOM Systems GmbH | A Rohde & Schwarz Company | Adenauerstr. 20/B2 | 52146 Wuerselen | Germany | E‑Mail info@lancom.de

LANCOM Logo