/f5-import

description: Import documents - single, batch, analyze, or schema management
argument-hint: <file|dir> [--batch|--analyze|--schema] [options]

/f5-import - Unified Document Import Command

Import requirements, design documents, or change requests from Excel files using MCP Excel server.

**Consolidated command** that replaces:

• `/f5-import-batch` → `/f5-import <dir> --batch`
• `/f5-import-analyze` → `/f5-import <file> --analyze`
• `/f5-import-schema` → `/f5-import --schema <action>`

MODE DETECTION

Parse $ARGUMENTS to determine mode:

| Pattern | Mode | Description | |---------|------|-------------| | `<dir> --batch` | BATCH | Batch import from folder | | `<file> --analyze` | ANALYZE | Analyze file structure | | `--schema <action>` | SCHEMA | Schema management | | `<file>` (default) | IMPORT | Single file import |

---

MODE: BATCH

**Usage:**

/f5-import .f5/input/excel/0203/ --batch
/f5-import .f5/input/excel/ --batch --recursive
/f5-import .f5/input/excel/ --batch --pattern "UI13_*.xlsx"
/f5-import .f5/input/excel/ --batch --dry-run

Batch Flags

| Flag | Description | |------|-------------| | `--batch` | Enable batch mode | | `--recursive` | Include subfolders | | `--pattern <glob>` | Filter files by pattern | | `--parallel <n>` | Parallel import count | | `--stop-on-error` | Stop on first error |

See original batch documentation for full details.

---

MODE: ANALYZE

**Usage:**

/f5-import requirements.xlsx --analyze
/f5-import data.xlsx --analyze --verbose
/f5-import data.xlsx --analyze --suggest-schema

Analyze Flags

| Flag | Description | |------|-------------| | `--analyze` | Enable analyze mode | | `--verbose` | Show detailed analysis | | `--suggest-schema` | Generate schema file | | `--sheet <name>` | Analyze specific sheet |

See original analyze documentation for full details.

---

MODE: SCHEMA

**Usage:**

/f5-import --schema list
/f5-import --schema show <name>
/f5-import --schema create <name>
/f5-import --schema validate <name>
/f5-import --schema delete <name>

Schema Actions

| Action | Description | |--------|-------------| | `list` | List all schemas | | `show <name>` | Display schema details | | `create <name>` | Create new schema | | `edit <name>` | Edit existing schema | | `validate <name>` | Validate schema | | `delete <name>` | Delete schema | | `export <name>` | Export schema | | `import <file>` | Import schema from file |

See original schema documentation for full details.

---

MODE: IMPORT (Default)

ARGUMENTS

The user's request is: $ARGUMENTS

⚠️ CRITICAL OUTPUT RULES

**KHÔNG ĐƯỢC tạo files ở `docs/`, `output/`, hoặc thư mục khác.**

**BẮT BUỘC tuân theo cấu trúc sau:**

| Document Type | Output Path | |--------------|-------------| | Requirements | `.f5/specs/srs/v{VERSION}/requirements.md` | | Screen List | `.f5/specs/basic-design/v{VERSION}/screens/screen-list.md` | | API List | `.f5/specs/basic-design/v{VERSION}/api/api-list.md` | | Table List | `.f5/specs/basic-design/v{VERSION}/database/table-list.md` | | Screen Detail | `.f5/specs/detail-design/v{VERSION}/screens/` | | API Detail | `.f5/specs/detail-design/v{VERSION}/api/` | | Change Request | `.f5/input/change-requests/` | | Bug Report | `.f5/input/bugs/` | | Jira CSV | `.f5/csv/{filename}_jira.csv` |

**VERSION format:** `v1.0.0`, `v1.1.0`, `v2.0.0`

**✅ CORRECT paths:**

.f5/specs/srs/v1.0.0/requirements.md ✅
.f5/specs/basic-design/v1.0.0/screens/screen-list.md ✅
.f5/specs/basic-design/v1.0.0/database/table-list.md ✅

**❌ WRONG paths:**

docs/requirements.md ❌
output/requirements.md ❌
requirements.md ❌ (in root)
.f5/specs/basic-design/v1.0.0/screen-list.md ❌ (missing screens/ folder!)

STEP 1: CHECK MCP EXCEL SERVER

1.1 Verify MCP Excel Availability

Check if MCP Excel server is available:
- Server: @anthropic/mcp-excel (or configured Excel MCP)
- Required capabilities: read_workbook, list_sheets, read_sheet

**If MCP Excel NOT available:**

## ⚠️ MCP Excel Server Not Available

The MCP Excel server is required for importing Excel files.

### Setup Instructions

1. **Install MCP Excel server:**
   ```bash
   npm install -g @anthropic/mcp-excel

2. **Configure in Claude Desktop settings:**

   {
     "mcpServers": {
       "excel": {
         "command": "mcp-excel",
         "args": []
       }
     }
   }

3. **Restart Claude Desktop** and try again.

Alternative: Manual Import

Place a CSV export in `.f5/input/` and use `/f5-import <file.csv>`

**If MCP Excel available:** Continue to Step 2.

## STEP 2: PARSE USER REQUEST

| Pattern | Action |
|---------|--------|
| `<filename>.xlsx` or `<filename>.xls` | **IMPORT_EXCEL** |
| `<filename>.csv` | **IMPORT_CSV** |
| `--type <type>` | Specify document type |
| `--version <version>` | Specify version label |
| `--schema <schema>` | Use custom schema |
| `--sheet <name>` | Import specific sheet |
| `--dry-run` | Preview without writing |

## STEP 3: LOCATE AND READ FILE

### 3.1 Search Order

```bash
# Priority search paths
1. Current directory: ./<filename>
2. Input requirements: .f5/input/requirements/<filename>
3. Input basic-design: .f5/input/basic-design/<filename>
4. Input detail-design: .f5/input/detail-design/<filename>
5. Input change-requests: .f5/input/change-requests/<filename>

3.2 Read Excel with MCP

Use MCP Excel to:
1. mcp_excel.list_sheets(file_path) → Get available sheets
2. mcp_excel.read_sheet(file_path, sheet_name) → Read data
3. Extract headers from first row
4. Extract data rows

3.3 Extract Embedded Images (if supported)

If MCP Excel supports image extraction:
1. mcp_excel.extract_images(file_path) → Get embedded images
2. Save to: .f5/output/images/{REQ_ID}_{INDEX}.png
3. Create markdown references

STEP 4: AUTO-DETECT DOCUMENT TYPE

4.1 Header Pattern Detection

| Headers Detected (Japanese/English) | Document Type | |-----------------------