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.

Jump to install

Repository: skeeper75/widget.creator
Last source activity: February 27, 2026 at 10:30
Detected SKILL.md language: English
Stars: 0
Forks: 0

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

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

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

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

View all from this repository

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

Install options

Review the source files

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

Source facts

Install options

Review the source files

More from this repository

HuniPrinting Data Import Workflow

Quick Start

File Size Reference

More from this repository

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