What problem does it solve?
This Skill automates batch importing of Excel-based requirements into Yunxiao cloud project management (云效). It guides users to select a target project before creating work items, reducing manual data migration and ensuring consistent mappings.
Core Features & Use Cases
- Excel parsing & header discovery: reads the Excel file, detects headers, and extracts fields like 需求标题/描述, 跟进人, 提交人, 需求类型, 归属模块, 预期收益.
- Project selection gate: prompts the user to choose the target project before any creation to prevent misrouted work items.
- Mapping & HTML description: maps负责人, 需求类型 to internal IDs, and builds a rich HTML description for each item.
- Batch creation with safeguards: creates work items in sequence with rate limiting and per-item error handling, continuing on failures.
- Audit-ready output: provides a completion report with totals.
Quick Start
Upload the Excel file (docs/氪金兽.xlsx) and run the import tool to start batch creation after selecting a project.