Subject: BTS file example and description
From: Andrei Vlaicu <[email-masked]>
To: Andrei Vlaicu <[email-masked]>
Date: Sun, 2 Jul 2017 11:44:46 +0200

BTS file is csv file in UTF-8 coding. Default delimiter is ";". You may
change delimiter to "," in Settings.
Decimal delimiter is ".".
Attached file is just example of some possible variants.
File must contain 17 columns.

Mandatory fields:

1. tech - Technology
Integer number.
1 - GSM
2 - WCDMA
3 - LTE
4 - CDMA

2. mcc - Mobile Country Code
Integer number.

3. mnc - Mobile Network Code
Integer number.

4. lac_tac - LAC/TAC
Integer number.
for GSM and WCDMA - LAC
for LTE - TAC
for CDMA - SID

5. node_id - RNC/NodeB Id
Integer number.
for GSM - empty field
for WCDMA - RNC Id or emty field
for LTE - NodeB Id
for CDMA - NID

6. cid - Cell Id
Integer number.
for CDMA - BID
Please note: for LTE ECI = 256*node_id + cid, for WCDMA UCID =
65536*node_id + cid.

Optional fields:

7. psc_pci - PSC/PCI
Integer number.
for GSM - empty field
for WCDMA - PSC
for LTE - PCI

8. band - Frequency Band
Text field.
For example: 900 or 1800 or 2100 or C1 or C2 or 2600 ....
On Main screen you will see instead of GSM/WCDMA/CDMA/LTE for example -
G900 or G1800 or U2100 or UC1 or UC2 or L2600 ...
"G", "U", "C" and "L" prefixes will be added to band1. Only first 5 letters
from band1 name will be visible on Main screen and 4 in table of
measurements.

9. arfcn - ARFCN
Integer number.
Will be shown on Main screen.

10. site_name - Site Name
Text field.

11. cell_lat - Cell Latitude
Decimal number.

12. cell_long - Cell Longitude
Decimal number.

13. cell_name - Cell Name
Text field.

14. azimuth - Sector Azimuth
Decimal number.

15. height - Antenna Height
Decimal number.

16. tilt_mech - Antenna Mechanical tilt
Decimal number.

17. tilt_el - Antenna Electrical tilt
Decimal number.

ATTENTION: no any analysis is performed while loading this file to DB. Only
one check: strings with wrong number of columns will be ignored.
First string will be skipped. It is supposed that it contains column names.