db_query / documentations /database_doc.py
DavMelchi's picture
adding number of site per lac to GSM and WCDMA charts
c58bec1
import streamlit as st
st.markdown(
"""
## Database Processing App Documentation
### Overview
This app is designed to process and generate databases from uploaded dump files. It provides a user-friendly interface for uploading files, selecting database types, and downloading processed databases.
### Getting Started
1. Upload a dump file: Click on the "Upload updated dump file" button to select a file in .xlsb format.
2. Select a database type: Choose a database type from the available options (2G, 3G, LTE, All, or NEI).
3. Download the processed database: Once the processing is complete, click on the "Download" button to save the processed database in .xlsx format.
### Required Sheets
The app requires the following sheets to be present in the uploaded file:
1. **2G :**
- BTS
- BCF
- TRX
- MAL
2. **3G :**
- WCEL
- WBTS
- WNCEL
3. **LTE :**
- LNBTS
- LNCEL
- LNCEL_FDD
- LNCEL_TDD
4. **NEI :**
- ADCE
- ADJS
- ADJI
- ADJG
- ADJW
- BTS
- WCEL
5. **MRBTS :**
- MRBTS
6. **INVUNIT :**
- INVUNIT
Please ensure that these sheets are present in the uploaded file to avoid any errors.
### Database Types
The app supports the following database types:
- 2G: Process 2G database
- 3G: Process 3G database
- LTE: Process LTE database
- All: Process all databases (2G, 3G, and LTE)
- NEI: Process neighbors database
### Troubleshooting
- Error messages: If an error occurs during processing, an error message will be displayed. Please check the file format and required sheets before trying again.
- File format: Only .xlsb files are supported. Please convert your file to the correct format before uploading.
### FAQ
- What is the maximum file size allowed?: The maximum file size allowed is 200MB.
- How long does the processing take?: The processing time depends on the file size and complexity. Please wait for the processing to complete.
### Contact
If you have any questions or issues with the app, please contact [Dav Melchi] at [davmelchi@gmail.com].
"""
)