6.5.3 Bulk equipment update

We can export and update multiple equipment and virtual equipment configurations. This feature can be accessed from the Site and equipment configuration menu => Equipment configuration export submenu. The first step is to search for the equipments and select some of them from the result list. Only equipments with same type can be exported into one file because the export file will also contain type specific parameters. The file header contains the equipment type and the property names. The data is in table format, one equipment per line. The file format can be either a text file or an Excel XLSX file, however the later is only available if PVSR is running on a Linux 6 or 7 system. When using the text file format the data separator is the tabulator character. If the equipment has an IP address parameter and there are JAGA measurements (Availability, RTT and RTT MinMax) belonging to the equipment (based on the name of the measurements and the name of the equipment) then they are exported as well, but only if there is just one measurement instance per each of these types and they belong to the same JAGA equipment. Otherwise the JAGA measurements are not exported. In case of virtual equipments the system searches for JAGA measurements among the measurements belonging to the virtual equipment and these must be “unambiguous” in the same way as described for the normal equipments. In both cases (normal and virtual equipments) if none of the selected equipments have linked JAGA measurements then the header will not contain the related parameter names.

Exported equipment properties are:

·       ID: identifier number, must not be changed

·       Name

·       Description

·       Parent site

·       Collect data

·       Keep collected data for days

·       Timeout (sec)

·       Retries

·       Default measurement interval

·       Type specific properties, for example for SNMP equipments: IP address, Community, SNMP version

·       Linked JAGA measurements state: Y (yes) or N (no) value

·       JAGA measurement properties

Exported virtual equipment properties are:

·       ID: identifier number, must not be changed

·       Name

·       Description

·       Parent site: only filled in when the virtual equipment has only one parent site

·       Linked JAGA measurements state: Y (yes) or N (no) value

·       JAGA measurement properties

The export file can be edited with any external text editor. However it is important that the data separator character must remain to be the tabulator character when using the text file format. The file can be imported using the Site and equipment configuration menu => Bulk equipment update submenu. The user has to specify the import file and the processing mode. The “Validate only” option does the same operations as the “Full process”, but it does not commit the changes into the database. The import process validates the header part of the import file and it will only accept the file if the header is the same as in the export file, with the exception of the JAGA measurement part: if this part is missing from the header then the linked JAGA measurements will not be processed.

Property validation rules are:

·       Name: has to be unique in the system

·       Description: no restrictions

·       Parent site: only unique site names are accepted

·       Collect data: required, the value has to be Y (yes) or N (no)

·       Keep collected data for days: required, number

·       Timeout (sec): required, number

·       Retries: required, number

·       Default measurement interval: required, number

·       Type specific properties: format and required

·       Linked JAGA measurements state: the system also checks during the import that the JAGA measurements - equipment relations are not ambiguous (only one JAGA equipment, etc…). The value has to be Y (yes) or N (no)

·       JAGA measurements properties: have to be present if it’s a required parameter

If the equipment name or IP address changes then the modification will be apply to all of the linked JAGA measurements as well.