Import from csv file – Milestone XProtect Essential 2014 User Manual
Page 46

Milestone XProtect
®
Essential 2014
Administrator's Manual
www.milestonesys.com
46
Getting started
Import from CSV file
Import data about hardware devices and cameras as comma-separated values (CSV) from a file. This
is a highly effective method if you set up several similar systems.
Add Hardware Devices wizard - Import from CSV File - example of CSV file
The following is an example of a CSV file for use when cameras and server are online. It includes the
parameters HardwareAddress, HardwarePort, HardwareUsername, HardwarePassword and
HardwareDriverID. Note that HardwareUserName and HardwareDriverID are optional parameters.
You can leave out the HardwareUsername if you have not changed the default HardwareUsername
for the device. HardwareDriverID is an optional field. If empty, it is automatically set to autodetect.
HardwareAddress;HardwarePort;HardwareUsername;HardwarePassword;Hardwa
reDriverID;
192.168.200.220;80;root;pass;128;
192.168.200.221;80;user;password;165;
192.168.200.222;80;r00t;pass;172;
192.168.200.223;80;;p4ss;
192.168.200.224;80;usEr;pASs;
Add hardware: Import from CSV file - CSV file format and requirements
The CSV file must have a header line (determining what each value on the following lines is about),
and the following lines must each contain information about one hardware device only. A minimum of
information is always required for each hardware device:
Name
Description
HardwareAddress
IP address of the hardware device.
HardwareUsername
User name for hardware device's administrator account.
HardwarePassword
Password for hardware device's administrator account.
HardwareDriverID
If cameras and server are offline
—specify a HardwareDriverID for
each hardware device you want to add. Example: ACTi ACD-2100
105 indicates that you should use 105 as the ID if adding an ACTi
ACD-2100 hardware device.
Existing configuration parameters that are not specified in CSV file remain unchanged. If a parameter
value for an individual camera in the CSV file is empty, the existing parameter value remains
unchanged on that camera. Most system integrators store hardware device information in
spreadsheets like Microsoft Excel, from which they can save the information as comma-separated
values in a CSV file.
The following applies for the information present in CSV files:
The first line of the CSV file must contain the headers, and following lines must contain
information about one hardware device each