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:

• DEVICE_PATH: Path name in the folder view
• DEVICE_INTERFACE: Connection type
• DEVICE_TIMEOUT: Maximum response time of the device
• DEVICE_ADDRESS: IP address or domain name and COM port or telephone number respectively
• DEVICE_ADMIN: Administrator name
• DEVICE_PASSWORD: Administrator password
• DEVICE_SNMPCOMMUNITY: The SNMP community of the device
• DEVICE_NAME: Device name
• DEVICE_STARTUP: Checking of the device at startup
• DEVICE_PROTOCOLS: Communication protocols
• DEVICE_PORTS: Ports
• DEVICE_DESCRIPTION: Description
• DEVICE_COMMENT: Comment
• DEVICE_LOCATION: Location of device
• DEVICE_TYPE: Device type
• DEVICE_EXTENDED_NAME: Device name with any supplements
• DEVICE_PRODUCTCODE: Product code
• DEVICE_SERNO: Serial number
• DEVICE_HWADDR: MAC address
• DEVICE_HWREL: Hardware release
• DEVICE_BACKUP: Storage location for the configuration backup created by LANconfig
• DEVICE_VPN: Parameter set for 1-Click-VPN
• DEVICE_SSH_FINGERPRINT: Cached fingerprint of the imported SSH key, also see Exporting key fingerprints when commissioning CC devices
• DEVICE_CREDENTIALS: Cached fingerprint of the device's internal ssh-rsa key