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].

    """
)