Exporting CSV data sets

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 CSV file that is generated contains the following data:

DEVICE_PATH;DEVICE_INTERFACE;DEVICE_ADDRESS;DEVICE_TIMEOUT;DEVICE_STARTUP;
DEVICE_PROTOCOLS;DEVICE_PORTS;DEVICE_ADMIN;DEVICE_PASSWORD;DEVICE_NAME;
DEVICE_DESCRIPTION;DEVICE_TYPE;DEVICE_SERNO;DEVICE_HWADDR;DEVICE_HWREL;
DEVICE_LOCATION;DEVICE_COMMENT;DEVICE_BACKUP;DEVICE_VPN
Group1;IP;192.168.2.35;10;1;263;;admin;Ht34bd5L;Etage1;L-54ag;LANCOM 
L-54ag Wireless;008520600482;00a0570bc9bf;B;;;;
Group1;IP;192.168.2.34;10;1;263;;admin;Ht34bd5L;Etage2;L-54ag;LANCOM 
L-54ag Wireless;008520600843;00a05719a8fb;B;;;;
    

The first row contains the name of the device parameters. Each row that follows contains the parameter values for one device. If 2 semicolons appear in direct succession, then the enclosed parameter value is blank.

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

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