db_query / documentations /ciq_4g_doc.py
DavMelchi's picture
Refactor CIQ 3G final schema config
d13ea55
import streamlit as st
st.markdown(
"""
# CIQ 4G Generator Documentation
## 1. Objective
Generate 4G CIQ outputs from raw CIQ Excel input with configurable naming and MCC/MNC values.
## 2. When to use this tool
Use this page when preparing LTE CIQ outputs for deployment planning or verification.
## 3. Input files and accepted formats
- Required: CIQ brut 4G file (`.xlsx` or `.xls`)
## 4. Required columns/fields
Input must follow expected 4G CIQ raw schema.
User-configurable inputs:
- `Year suffix` (default: `26`)
- `Bands string` (default: `G9G18U9U21L8L18L26`)
- `MCC` (default: 610)
- `MNC` (default: 2)
## 5. Step-by-step usage
1. Open `Apps > CIQ 4G Generator`.
2. Upload CIQ brut 4G file.
3. Set suffix/bands/MCC/MNC values.
4. Click `Generate`.
5. Review generated sheet tabs.
6. Download `CIQ_4G.xlsx`.
## 6. Outputs generated
- generated sheets preview in tabs
- downloadable workbook `CIQ_4G.xlsx`
## 7. Frequent errors and fixes
- Missing CIQ file.
- Fix: upload `.xlsx`/`.xls` input.
- Processing error.
- Fix: validate source template and required columns.
- Wrong MCC/MNC values in output.
- Fix: verify numeric MCC/MNC before generation.
## 8. Minimal reproducible example
- Input: `samples/CIQ_LTE.xlsx`
- Action: use defaults and click `Generate`.
- Expected result: generated sheet tabs and downloadable `CIQ_4G.xlsx`.
## 9. Known limitations
- Strict dependency on CIQ raw schema.
- Incorrect parameter values can propagate to outputs.
- No dump cross-check is performed in this page.
## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)