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
"""
)