generate-asset-missions

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