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.

Ir para a instalação

Repositório: skeeper75/widget.creator
Última atividade na origem: 27 de fevereiro de 2026 às 10:30
Idioma detectado do SKILL.md: inglês
Estrelas: 0
Forks: 0

Opções de instalação

Por padrão, está selecionado o prompt que primeiro revisa a origem. Você pode mudar para um comando direto ou baixar uma cópia local.

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Um comando direto ignora o prompt de revisão. Verifique a origem antes de executá-lo.

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

O comando permanece em uma só linha. Role horizontalmente para revisá-lo antes de copiar.

Prefere uma cópia local? Baixe os arquivos disponíveis atualmente no SkillsMP.

Revise os arquivos de origem

Leia o SKILL.md e os arquivos complementares exibidos pelo SkillsMP antes de decidir se vai instalar.

SKILL.md

Instruções da origem · Visualização somente leitura

Voltar à pesquisa Voltar à instalação

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

Opções de instalação

Revise os arquivos de origem

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

Informações da origem

Opções de instalação

Revise os arquivos de origem

Mais deste repositório

Mais deste repositório

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