File size: 1,778 Bytes
4d0d437 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 | import streamlit as st
st.markdown(
"""
# CIQ 2G Generator Documentation
## 1. Objective
Generate CIQ 2G deliverables from OML dump and CIQ raw input, including optional free BCF extraction.
## 2. When to use this tool
Use this page when preparing or validating 2G CIQ before deployment.
## 3. Input files and accepted formats
- Required: dump file (`.xlsb`)
- Required for CIQ generation: CIQ raw 2G file (`.xlsx` or `.xls`)
- Optional: forbidden BCF list (`.xlsx`, `.xls`, `.xlsb`)
## 4. Required columns/fields
Forbidden BCF file should include one of these pairs:
- `BSC` and `BCF`
- or `BSCID` and `BCFID`
Optional parameters:
- `MCC` (default: 610)
- `MNC` (default: 2)
## 5. Step-by-step usage
1. Open `Apps > CIQ 2G Generator`.
2. Upload dump `.xlsb`.
3. Optionally generate and download `BCF libre`.
4. Upload CIQ brut 2G file.
5. Set MCC/MNC if needed.
6. Click `Generate` and review sheet tabs.
7. Download final CIQ Excel.
## 6. Outputs generated
- optional `BCF_LIBRE.xlsx`
- generated CIQ 2G workbook (download as `CIQ_2G.xlsx`)
- in-app sheet preview tabs
## 7. Frequent errors and fixes
- Missing dump file.
- Fix: upload `.xlsb` first.
- CIQ generation blocked.
- Fix: upload CIQ brut 2G file.
- Forbidden BCF mismatch.
- Fix: verify expected column names.
## 8. Minimal reproducible example
- Input: valid dump `.xlsb` + `samples/CIQ_2G.xlsx`.
- Action: click `Generate` with default MCC/MNC.
- Expected result: sheet tabs and downloadable `CIQ_2G.xlsx`.
## 9. Known limitations
- Processing time depends on dump size.
- Source CIQ template quality directly affects output.
- Forbidden list handling depends on expected BSC/BCF column format.
## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)
|