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.

Zur Installation springen

Repository: skeeper75/widget.creator
Letzte Quellaktivität: 27. Februar 2026 um 10:30
Erkannte Sprache von SKILL.md: Englisch
Sterne: 0
Forks: 0

Installationsoptionen

Standardmäßig ist der Prompt ausgewählt, der zuerst die Quelle prüft. Sie können zu einem direkten Befehl wechseln oder eine lokale Kopie herunterladen.

Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.

Ein direkter Befehl überspringt den Prüf-Prompt. Prüfen Sie die Quelle, bevor Sie ihn ausführen.

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

Der Befehl bleibt in einer Zeile. Scrollen Sie horizontal, um ihn vor dem Kopieren vollständig zu prüfen.

Sie bevorzugen eine lokale Kopie? Laden Sie die Dateien herunter, die SkillsMP derzeit vorliegen.

Quelldateien prüfen

Lesen Sie SKILL.md und alle von SkillsMP angezeigten Begleitdateien, bevor Sie sich für eine Installation entscheiden.

SKILL.md

Quellanweisungen · Schreibgeschützte Vorschau

Zurück zur Suche Zurück zur 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

Alle aus diesem Repository ansehen

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

Installationsoptionen

Quelldateien prüfen

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

Quellinformationen

Installationsoptionen

Quelldateien prüfen

Mehr aus diesem Repository

Mehr aus diesem Repository

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