innojini-huni-data-import

HuniPrinting master data Excel-to-DB import workflow using ExcelJS + TOON format. Extracts Excel with full formatting metadata (cell colors, fonts, merged cells) for tacit knowledge preservation, then converts to TOON format for 93% token savings. Supports product master, pricing tables, and MES item management data. Use when importing huni seed data, analyzing 상품마스터 or 가격표, working with xlsx files, running excel extract/convert scripts, or mapping toon files to DB tables.

跳到安装

仓库: skeeper75/widget.creator
最近来源活动: 2026年2月27日 10:30
检测到的 SKILL.md 语言: 英语
星标: 0
分支: 0

安装方式

默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。

用 Codex 或 Claude 帮你安装复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。

直接命令不会经过审查 Prompt；运行前请先检查来源。

npx skills add https://github.com/skeeper75/widget.creator --skill innojini-huni-data-import

命令会保持在同一行。复制前请横向滚动并检查完整内容。

想先保存到本地？可下载 SkillsMP 当前能够提供的文件。

检查来源文件

决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。

SKILL.md

来源说明 · 只读预览

返回搜索返回安装

innojini-edicus-integration

Edicus 플랫폼(모션원) 연동 전문 스킬. 온라인 편집기 기반 맞춤형 인쇄물(포토북, 명함, 스티커 등) 주문 시스템 구현 시 사용. JS SDK 초기화, Server API 호출, 주문 workflow 연동, 렌더링 처리 필요 시 자동 활성화.

2026-02-27

figma-development

Comprehensive Figma development toolkit for Plugins, Widgets, Code Connect, and MCP Server integration. 🔹 플러그인: "Figma plugin", "플러그인 개발", "Figma 확장", "Plugin API" 🔹 위젯: "Figma widget", "FigJam 위젯", "인터랙티브 협업", "Widget API" 🔹 Code Connect: "Code Connect", "디자인-코드 연결", "Dev Mode 코드", "컴포넌트 매핑" 🔹 MCP Server: "Figma MCP", "Cursor Figma", "AI 코딩 Figma", "디자인→코드 AI" 🔹 REST API: "Figma API", "Variables API", "디자인 토큰", "design tokens" Use when building Figma extensions, connecting design systems to code, or integrating Figma with AI coding tools.

2026-02-27

innojini-huni-db-schema

HuniPrinting Widget Builder DB 스키마 참조 스킬. 20개 테이블 구조, 핵심 설계 원칙 (huni_code, ECA 제약, MES 매핑 조건), SPEC 대 테이블 매핑을 포함. DB 설계 검증, 스키마 구현, 마이그레이션 작성 시 사용. Use when designing or validating HuniPrinting DB schema, writing Drizzle migrations, or referencing existing table structures.

2026-02-27

查看这个仓库的全部 Skills

HuniPrinting Data Import Workflow

Pipeline: Excel (.xlsx) → JSON (ExcelJS, with colors) → TOON (93% smaller) → DB inserts

Quick Start

# Step 1: Extract Excel → JSON (run once, ~30s) pnpm tsx scripts/excel-extract.ts # Step 2: Convert JSON → TOON (fast, deterministic) pnpm tsx scripts/excel-to-toon.ts # Step 3: Analyze structure (AI reads TOON, NOT JSON) # Read ref/huni/toon/product-master.toon (224KB, ~1,287 lines) # Read ref/huni/toon/price-table.toon (127KB, ~1,557 lines) # Read ref/huni/toon/item-management.toon ( 25KB, ~284 lines) # Step 4: Update mappings if needed # Edit ref/huni/mappings/*.yaml # Step 5: Run import scripts pnpm tsx scripts/import/import-products.ts pnpm tsx scripts/import/import-papers.ts pnpm tsx scripts/import/import-prices.ts

File Size Reference

File

Format

Size

Est. Tokens

Use When

후니프린팅_상품마스터_260209.xlsx

xlsx

1.1MB

never read

source only

후니프린팅_인쇄상품_가격표_260214.xlsx

xlsx

250KB

never read

source only

품목관리.xlsx

xlsx

25KB

never read

source only

extracted/상품마스터_extracted.json

JSON

3.0MB

~150K

color analysis only

extracted/가격표_extracted.json

JSON

2.3MB

~115K

color analysis only

extracted/품목관리_extracted.json

JSON

340KB

~17K

color analysis only

toon/product-master.toon

TOON

224KB

~11K

standard analysis

toon/price-table.toon

TOON

127KB

~6K

standard analysis

toon/item-management.toon

TOON

25KB

~1.2K

standard analysis

Rule: Always use TOON for analysis. Use JSON only when cell color metadata is required.

HuniPrinting Data Import Workflow

Pipeline: Excel (.xlsx) → JSON (ExcelJS, with colors) → TOON (93% smaller) → DB inserts

Quick Start

File Size Reference

File

Format

Size

Est. Tokens

Use When

후니프린팅_상품마스터_260209.xlsx

xlsx

1.1MB

never read

source only

후니프린팅_인쇄상품_가격표_260214.xlsx

xlsx

250KB

never read

source only

품목관리.xlsx

xlsx

25KB

never read

source only

extracted/상품마스터_extracted.json

JSON

3.0MB

~150K

color analysis only

extracted/가격표_extracted.json

JSON

2.3MB

~115K

color analysis only

extracted/품목관리_extracted.json

JSON

340KB

~17K

color analysis only

toon/product-master.toon

TOON

224KB

~11K

standard analysis

toon/price-table.toon

TOON

127KB

~6K

standard analysis

toon/item-management.toon

TOON

25KB

~1.2K

standard analysis

Rule: Always use TOON for analysis. Use JSON only when cell color metadata is required.

name	innojini-huni-data-import
description	HuniPrinting master data Excel-to-DB import workflow using ExcelJS + TOON format. Extracts Excel with full formatting metadata (cell colors, fonts, merged cells) for tacit knowledge preservation, then converts to TOON format for 93% token savings. Supports product master, pricing tables, and MES item management data. Use when importing huni seed data, analyzing 상품마스터 or 가격표, working with xlsx files, running excel extract/convert scripts, or mapping toon files to DB tables.
license	Apache-2.0
compatibility	Designed for Claude Code - widget.creator project
user-invocable	true
metadata	{"version":"1.0.0","category":"domain","status":"active","updated":"2026-02-27","tags":"excel, import, toon, huni, data, seed, token-optimization","argument-hint":"[extract\|convert\|analyze\|import\|status]"}
progressive_disclosure	{"enabled":true,"level1_tokens":150,"level2_tokens":3000}
triggers	{"keywords":["excel","import","huni","seed","상품마스터","가격표","품목관리","toon","xlsx"],"agents":["expert-backend","manager-ddd"],"phases":["run"]}

name	innojini-huni-data-import
description	HuniPrinting master data Excel-to-DB import workflow using ExcelJS + TOON format. Extracts Excel with full formatting metadata (cell colors, fonts, merged cells) for tacit knowledge preservation, then converts to TOON format for 93% token savings. Supports product master, pricing tables, and MES item management data. Use when importing huni seed data, analyzing 상품마스터 or 가격표, working with xlsx files, running excel extract/convert scripts, or mapping toon files to DB tables.
license	Apache-2.0
compatibility	Designed for Claude Code - widget.creator project
user-invocable	true
metadata	{"version":"1.0.0","category":"domain","status":"active","updated":"2026-02-27","tags":"excel, import, toon, huni, data, seed, token-optimization","argument-hint":"[extract\|convert\|analyze\|import\|status]"}
progressive_disclosure	{"enabled":true,"level1_tokens":150,"level2_tokens":3000}
triggers	{"keywords":["excel","import","huni","seed","상품마스터","가격표","품목관리","toon","xlsx"],"agents":["expert-backend","manager-ddd"],"phases":["run"]}

Hex Code	Color Name	Meaning	DB Action
F6B26B	Orange	필수옵션 (Required option)	must_have = true
FFFF00	Yellow	검토필요 (Needs review)	flag for manual check
E06666	Red	오류 (Error/Invalid)	skip row, log warning
CFE2F3	Light blue	표준데이터 (Standard data)	import normally
(none)	White/null	Normal data	import normally

TOON File	Sheet Name	Target Table	Notes
product-master.toon	(12 category sheets)	wb_products	product_type per sheet
product-master.toon	!디지털인쇄용지	papers	paper specs
price-table.toon	디지털출력비	print_cost_base	base print pricing
price-table.toon	후가공	postprocess_cost	finishing costs
item-management.toon	(all sheets)	mes_items	261 MES items total

Excel Feature	Interpretation	Handling
Bold row	Section header or category boundary	skip or use as grouping key
Merged cells	Hierarchical data, parent applies to children	propagate first cell value downward
Empty cell in merged range	Inherits value from top-left of merge	use `mergeInfo` from JSON if needed
Row with all empty cells	Separator or end of section	skip row
✓ / ✗ in cell	Boolean true/false	parse as boolean
`-` in cell	null or N/A	store as NULL
`*` prefix	Required field marker	set required = true
`/` separator	Multi-value list	split and store as array

innojini-huni-data-import

安装方式

检查来源文件

HuniPrinting Data Import Workflow

Quick Start

File Size Reference

HuniPrinting Data Import Workflow

Quick Start

File Size Reference

5-Phase Workflow

Phase 1: Extract Once

Phase 2: Convert to TOON

Phase 3: Analyze Structure

Phase 4: Design Mappings

Phase 5: Import to DB

Color Legend

DB Table Mapping

Excel Tacit Knowledge

Structural Patterns

Data Type Rules

Common Issues

File Structure Reference

Token Optimization Summary

Issue	Cause	Solution
TOON shows garbled Korean	UTF-8 BOM missing	`fs.writeFileSync(path, content, 'utf8')`
Merged cell value empty	Reading child cells	Use JSON `mergeInfo` or propagate from parent
Color not detected	Cell uses theme color not hex	Check JSON `style.fill.fgColor` for tint values
Row count mismatch	Hidden rows in Excel	ExcelJS includes hidden rows by default
Number parsed as NaN	Cell stores text not number	`Number(val.replace(/[^0-9.-]/g, ''))`
Sheet not found	Sheet name has trailing space	`sheet.name.trim()` when matching

innojini-huni-data-import

来源信息

安装方式

检查来源文件

同仓库更多 Skills

同仓库更多 Skills

HuniPrinting Data Import Workflow

Quick Start

File Size Reference

HuniPrinting Data Import Workflow

Quick Start

File Size Reference

5-Phase Workflow

Phase 1: Extract Once

Phase 2: Convert to TOON

Phase 3: Analyze Structure

Phase 4: Design Mappings

Phase 5: Import to DB

Color Legend

DB Table Mapping

Excel Tacit Knowledge

Structural Patterns

Data Type Rules

Common Issues

File Structure Reference

Token Optimization Summary