README.md

---
title: OML DB Tools
emoji: 🏢
colorFrom: red
colorTo: green
sdk: streamlit
sdk_version: 1.46.1
app_file: app.py
pinned: false
---

## OML DB Tools (Streamlit)

OML DB Tools is a multi-page Streamlit application for telecom engineering workflows:
- database generation from OML dumps
- CIQ generation and CIQ verification
- dump core parsing
- UE capability parsing
- geospatial utilities (GPS conversion, distance, KML generation)
- KPI and capacity analysis tools

## Quick Start

1. Create and activate a Python virtual environment.
2. Install dependencies:
   - `pip install -r requirements.txt`
3. Run the Streamlit app:
   - `.\run_app.ps1 -App streamlit`
   - or `python -m streamlit run app.py`

Default local URL: `http://localhost:8501`

## Authentication

The app uses Streamlit secrets for login:
- `username`
- `password`

Configure them in your local Streamlit secrets file before sharing the app.

## Main Functional Areas

1. Apps
   - Database processing, CIQ generators, CIQ verification, dump core parser, UE capability parser, GPS tools, KML generator, clustering, dump compare.
2. Capacity Analysis
   - GSM/WBTS/WCEL/LCG/LTE capacity analysis.
3. Paging Analysis
   - GSM LAC load analysis.
4. KPI Analysis
   - LTE traffic drop, KPI anomaly detection, traffic analysis.
5. Documentations
   - In-app user documentation pages (from the top navigation).

## Input Formats (most used)

- Dump files: `.xlsb`
- CIQ files: `.xlsx` / `.xls`
- KPI reports: `.csv` (depending on page)
- UE capability exports: `.txt`
- GPS / distance / KML helpers: `.xlsx`

## In-App Documentation

Use `Documentations > Documentation Home` in the app for:
- page-by-page usage guides
- required columns and file templates
- troubleshooting notes
- known limitations

## Hosted Version

https://davmelchi-db-query.hf.space/

## Release Notes

See `Changelog.md` for version history.