README.md

metadata

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.