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