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, a Device 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 |
We will take the below .csv as an example
devicename,prompt,locationname,tel,lat,long,groupname ,,Location A,1234567890,40.7128,-74.006,Group A DeviceA,no,Location A,1234567890,40.7128,-74.006, ,,Location B1,,,,Group B ,,Location B2,,,,Group B DeviceB,no,Location B1,,,, ,no,Location B2,,,, ,,Location C1,,,,Group C ,,Location C2,,,,Group C DeviceC1,no,Location C1,,,, DeviceC1,no,Location C2,,,, DeviceC2,yes,,,,,Group C
| 1 | devicename | prompt | locationname | tel | lat | long | groupname |
| 2 | Location A | 1234567890 | 40.7128 | -74.006 | Group A | ||
| 3 | DeviceA | no | Location A | 1234567890 | 40.7128 | -74.006 | |
| 4 | Location B1 | Group B | |||||
| 5 | Location B2 | Group B | |||||
| 6 | DeviceB | no | Location B1 | ||||
| 7 | DeviceB | no | Location B2 | ||||
| 8 | Location C1 | Group C | |||||
| 9 | Location C2 | Group C | |||||
| 10 | DeviceC1 | yes | Location C1 | ||||
| 11 | DeviceC1 | yes | Location C2 | ||||
| 12 | DeviceC2 | yes | Group C |
Row 1:
These are the headers of each of the columns
Row 2:
The Location `Location A` is created, with several properties like a phone number, and a position on the map. It is made part of the Group `Group A`.
Row 3:
The Device `DeviceA` is created, and given the Location `Location A`.
Note that `Location A` is repeated, so it must be given the exact same properties it has been given elsewhere to avoid a conflict.
Row 4-5:
The Locations `Location B1`, and `Location B2` are created, and made part of Group `Group B`.
Row 6-7:
The Device `DeviceB` is created, and given the Locations `Location B1`, and `Location B2`. The user of this Device will be able to select either of these Locations, but is not prompted to do so.
Row 8-9:
The Locations `Location C1`, and `Location C2` are created, and made part of Group `Group C`.
Row 10-11:
The Device `DeviceC1` is created, and given the Locations `Location C1`, and `Location C2`. The user of this Device will be able to select either of these Locations, and will be prompted to do so every time Little Green Button starts.
Row 12:
The Device `DeviceC2` is created, and given the Group `Group C`. The user of this Device will be able to select all Locations from this Group, and will be prompted to do so every time Little Green Button starts.
If a `Location C3`, part of `Group C` were to be created, `Device C1` would not be able to select this Location, unless it is explicitly assigned to this Location, whereas `Device C2` would be able to select this new Location, as it is given all Locations from `Group C`.
The order of the rows does not influence the end result of the configuration.
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.