The The MyLGB portal allows importing of a larger number of Devices, Locations, or Groups through the Import page.
Access the Import page under Configuration to upload a .csv file. A large amount of Devices, Locations, and Groups and the relationships between them can be supplied this way.
An example .csv file can be downloaded from this page, which can be opened, edited, and exported ready for upload using spreadsheet tools like Google Sheets, LibreOffice's Calc, Microsoft Office's Excel, or even using any plain-text editor.
This example file is the starting point for your configuration to be uploaded. Each row represents a relation between a Device and a Location, a Location and a Group, or a combination of all three.
Columns are as follows;
| Column | Value |
|---|---|
| devicename | Device name |
| prompt | Prompt the user of this Device to select a Location when Little Green Button starts. Either yes or no, can only be yes if the Device in the first column has more than one Location associated with it. |
| locationname | The name of the Location. |
| tel | Optional. The phone number associated with the Location. Has to be repeated for each row mentioning this Location. |
| lat | Optional. The latitudinal coordinate for this Location. Has to be repeated for each row mentioning this Location. |
| long | Optional. The longitudinal coordinate for this Location. Has to be repeated for each row mentioning this Location. |
| groupname | Name for the Group this Location is a part of |
Below are the contents of the example .csv file
devicename,prompt,locationname,tel,lat,long,groupname DeviceA,no,Location A,1234567890,40.7128,-74.006,Group A DeviceB,no,Location B,,,,Group B DeviceC,no,Location B,,,,Group B DeviceD,yes,Location C,,,,Group C DeviceD,yes,Location D,,,,Group C
| devicename | prompt | locationname | tel | lat | long | groupname |
|---|---|---|---|---|---|---|
| DeviceA | no | Location A | 1234567890 | 40.7128 | -74.006 | Group A |
| DeviceB | no | Location B | Group B | |||
| DeviceC | no | Location B | Group B | |||
| DeviceD | yes | Location C | Group C | |||
| DeviceD | yes | Location D | Group C |
Importing this file will result in a configuration that has 4 Devices:
- DeviceA, assigned to Location A with telephone number 1234567890 at coordinates 40.7128,-74.006, part of Group A
- DeviceB, assigned to Location B, part of Group B
- DeviceC, assigned to Location B, part of Group B
- DeviceD, assigned to Location C, and Location D, part of Group C. The user of this device will be prompted to select one of these locations each time Little Green Button starts.
The Groups will be created to escalate the Alert to their own Group only. This can be easily adjusted by editing the Escalation Path for each Group.
Import a file by dropping it on to the indicated area, or clicking the area to browse to your .csv file to upload.
An overview will be presented with a summary of the changes to be made. Click Start to commence the import.
Once completed, the items will be added to the configuration.
Importing items will result in them being added to the configuration. The import will not replace, change, or delete any existing items. Remove all configurations prior to the upload if a clean slate is required.
Before the upload is processed, it is validated for any inconsistencies or values that would result in a configuration that can not be published.
For example, if the same Location has a phone number or geolocation coordinate in two different rows that do not match, it is flagged as a data inconsistency and will have to be corrected before re-uploading the file.