What problem does it solve?
This Skill orchestrates the extraction of asset task fields from natural language descriptions, Word documents, or Excel files and writes them into the asset_missions Excel sheets, enabling consistent project management for art assets.
Core Features & Use Cases
- Automatic field extraction: from natural language, Word docs, or Excel files to populate a standardized task record.
- Version-based grouping: automatically groups tasks by version and writes to SoFunny3D_<归属项目>_<版本>.xlsx.
- Update-or-create behavior: existing tasks (by name) are updated; new tasks are appended.
- Git-assisted resource discovery (optional): when author and time range are provided along with a repo path, extracts resource file names from Git commits to enrich the "资源名称" field.
Quick Start
Use the skill to generate asset mission entries from a natural language description, or from a Word/Excel file. Examples:
- New task from text: 提交示例,嘎嘎射击 v3.2,任务名称为“德刚模型制作”,归属版本 v3.2,归属项目嘎嘎射击。
- Batch from Word: 处理文件 docs/嘎嘎射击_V3.2.docx,自动提取并写入任务表。
- Batch from Excel: 处理文件 docs/嘎嘎射击_V3.2.xlsx,批量写入任务表。
Note: The Quick Start commands are plain text and should be used as-is without code fences.
Example commands:
- venv/bin/python src/write_excel.py 任务名称 德刚模型制作 归属项目 嘎嘎射击 归属版本 v3.2
- venv/bin/python src/read_doc_and_write.py docs/嘎嘎射击_V3.2.docx --project 嘎嘎射击 --version v3.2
- venv/bin/python src/read_excel_and_write.py docs/嘎嘎射击_V3.2.xlsx