القائمة
Convert a CSV or Excel FF&E product list to SIF (Standard Interchange Format) for dealer and procurement systems.
يُحدَّد Prompt الذي يراجع المصدر أولًا بشكل افتراضي. يمكنك التبديل إلى أمر مباشر أو تنزيل نسخة محلية.
اقرأ SKILL.md وأي ملفات مرافقة يعرضها SkillsMP قبل أن تقرر التثبيت.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
يتجاوز الأمر المباشر Prompt المخصّص للمراجعة. افحص المصدر قبل تشغيله.
npx skills add https://github.com/DreamLab-AI/agentbox --skill csv-to-sifيبقى الأمر في سطر واحد. مرّر أفقيًا لمراجعته كاملًا قبل النسخ.
تفضّل نسخة محلية؟ نزّل الملفات المتاحة حاليًا لدى SkillsMP.
Implement features with tests and quality gates, debug hard bugs, and stress-test designs. Use when building a feature with TDD/EDD, chasing a stubborn multi-function bug (feedback-loop-first), interrogating a design before coding, or running a coverage/security/accessibility quality-gate pass. Supersedes agentic-qe, reasoningbank-*, and pair-programming.
Plan-execute-reflect loop over a persistent Python kernel (the `code-interpreter` MCP): write Python, execute, observe the returned trace (stdout / exception / last value), then revise. Variables, imports, and dataframes survive across every tool call in the session. Use for multi-step numerical reasoning, data wrangling, scientific Q&A, hypothesis-test loops, or any task where intermediate state must persist between turns and a runtime result should drive the next step.
Fires as a post-task hook after a non-trivial completed task (3+ tool calls, observable terminal outcome) to distil 0-N generalisable IF/THEN lessons from the trajectory and store them in RuVector so they surface at the start of similar future tasks; also invocable manually to record a lesson after a complex or failed task. NOT for trivial (<3 tool calls) or interrupted tasks, and NOT a general memory-write tool — it writes only ex:DistilledLesson records to the code-harness-lessons namespace. Schema, gates, prompt, and contradiction/archive policy live in references/.
استنادا إلى تصنيف SOC المهني
عرض SKILL.md
| name | csv-to-sif |
| description | Convert a CSV or Excel FF&E product list to SIF (Standard Interchange Format) for dealer and procurement systems. |
| allowed-tools | ["Read","Write","Edit","Bash","Glob","Grep","AskUserQuestion"] |
| user-invocable | true |
Converts a CSV, Excel, or Google Sheets product list into a SIF (Standard Interchange Format) file for import into dealer and procurement systems like Hedberg, CAP, CET, Cyncly Worksheet, ProjectMatrix, Studio Webware, and Design Manager.
SIF is a text-based key-value format. Each line is CODE=VALUE, terminated by CRLF. Products are separated by records starting with PN=.
| Code | Name | Required | Description |
|---|---|---|---|
SF | Specification File | No | Project reference (header, once per file) |
ST | Specification Title | No | Display title (header, once per file) |
PN | Product Number | Yes | SKU or model number. Marks the start of a new record. |
PD | Product Description | Yes | Product name and description |
MC | Manufacturer Code | Yes | 3-5 character code (HMI, KNL, STC) |
MN | Manufacturer Name | No | Full manufacturer name |
QT | Quantity | Yes | Integer quantity |
NT | Quantity (alt) | No | Some systems use NT instead of QT |
GC | Category / Group Code | No | Product category |
G0 | Vendor / Group ID | No | Vendor or dealer identifier |
| Code | Name | Description |
|---|---|---|
PL | List Price | Unit list price (numeric, no currency symbol) |
P1 | Price Tier 1 | Primary price (some systems use P1 instead of PL) |
P2 | Price Tier 2 | Alternate price tier |
P4 | Price Tier 4 | Alternate price tier |
P5 | Price Tier 5 | Alternate price tier |
I1 | Unit List Price (Cyncly) | Used by Cyncly Worksheet |
I2 | Purchase Price (Cyncly) | Used by Cyncly Worksheet |
S- / S% | Sell Discount % | Sell = PL - (PL × S- × 0.01) |
P% / B% | Purchase/Buy % | Cost = PL × (P% × 0.01) |
| Code | Name | Description |
|---|---|---|
TG | Side Mark / Tag | Room name, area code, or project tag |
ON | Option Number | Must pair with OD |
OD | Option Description | Finish, fabric, color selection |
AN | Attribute Number | Must pair with AD |
AD | Attribute Description | Dimension, weight, or other attribute |
WT | Weight | Product weight |
VO | Volume | Product volume |
PRC | Product Category (Cyncly) | Category for Cyncly Worksheet |
| Code | Name | Description |
|---|---|---|
ProductURL | Product Page URL | Link to manufacturer product page |
ImageURL | Product Image URL | Link to product image |
PV | Picture Path | Windows bitmap or TIF file path |
| System | Code | Purpose |
|---|---|---|
| Standard | MC | 3-5 char manufacturer code |
| Cyncly Worksheet | MG | Manufacturer code (replaces MC) |
| Cyncly Worksheet | MN | Full manufacturer name |
| CET / Configura | EC | Manufacturer code (alt) |
SF=Project Alpha - FF&E Specification
ST=FF&E Schedule — March 2026
PN=670
PD=Eames Lounge Chair and Ottoman
MC=HMI
MN=Herman Miller
GC=Seating
QT=3
PL=5695.00
WT=92
TG=Executive Lounge
OD=Santos Palisander / Black MCL Leather
AN=DIM
AD=32.75W x 32.5D x 33.5H in
ProductURL=https://www.hermanmiller.com/products/seating/lounge-seating/eames-lounge-chair-and-ottoman/
ImageURL=https://www.hermanmiller.com/content/dam/hmicom/page_assets/products/eames_lounge_chair_and_ottoman/mh_prd_ovw_eames_lounge_chair_and_ottoman.jpg
PN=164-500
PD=Saarinen Round Dining Table 54"
MC=KNL
MN=Knoll
GC=Tables
QT=1
PL=4750.00
TG=Dining Area
OD=Arabescato Marble Top / White Base
AN=DIM
AD=54dia x 28.5H in
CODE=VALUEPN starts a new record — must come first in each recordON/OD and AN/AD pairs must stay togetherCODE= with nothing after the equals signCSV file:
/csv-to-sif ~/Documents/project/ffe-schedule.csv
Google Sheet:
/csv-to-sif 1FMScYW9guezOWc_m4ClTQxxFIpS6TNRr373R-MJGzgE
Pasted CSV:
/csv-to-sif
Product,Brand,SKU,Qty,Price,Finish,Room
Eames Lounge Chair,Herman Miller,670,3,5695,Walnut/Black Leather,Executive Lounge
Saarinen Table 54,Knoll,164-500,1,4750,Arabescato/White,Dining
Ask which dealer system the SIF file is for (affects which field codes to use):
Target system:
1. Standard (Hedberg, CAP, ProjectMatrix) — default
2. CET / Configura (SPEC)
3. Cyncly Worksheet (CAPSIF)
4. Design Manager
Default to Standard if not specified. The main differences:
Auto-detect column mappings from header names:
| CSV Column (common names) | SIF Field |
|---|---|
| Product Name, Name, Description, Product | PD |
| SKU, Model, Part Number, Product Number | PN |
| Brand, Manufacturer | MC + MN |
| Qty, Quantity, Count | QT |
| Price, List Price, Unit Price | PL |
| Finish, Color, Configuration | OD |
| Room, Location, Area, Tag, Side Mark | TG |
| Category | GC |
| Weight | WT |
| Discount, Discount % | S- |
| URL, Product URL, Link | ProductURL |
| Image, Image URL | ImageURL |
| W, D, H (dimensions) | AD (with AN=DIM) |
If using the master 33-column schema (defined in ../../schema/product-schema.md):
| Column | SIF Field |
|---|---|
| A (Link) | ProductURL |
| C (Product Name) | PD |
| E (SKU) | PN |
| F (Brand) | MC + MN |
| J (Category) | GC |
| K-O (W, D, H, Seat H, Unit) | AD (with AN=DIM) |
| P (Weight) | WT |
| Q (Materials) | AD (with AN=MAT) |
| R (Colors/Finishes) | OD (with ON=FIN) |
| S (Selected Color/Finish) | OD (primary, replaces R if present) |
| T (List Price) | PL |
| AC (Image URL) | ImageURL |
| AD (Tags) | TG |
If the mapping is ambiguous, ask the user to confirm.
Convert full brand names to standard 3-5 character codes:
| Brand | MC Code | Brand | MC Code |
|---|---|---|---|
| Herman Miller | HMI | Blu Dot | BLU |
| MillerKnoll | MKN | Design Within Reach | DWR |
| Knoll | KNL | Fritz Hansen | FRH |
| Steelcase | STC | Vitra | VIT |
| Haworth | HAW | Arper | ARP |
| Teknion | TEK | Muuto | MUU |
| Humanscale | HUM | HAY | HAY |
| Kimball | KIM | Flos | FLS |
| National | NAT | Louis Poulsen | LPO |
| OFS | OFS | Artemide | ART |
| HBF | HBF | Restoration Hardware | RHB |
| Bernhardt | BRN | West Elm | WEL |
| Geiger | GEI | CB2 | CB2 |
For unknown brands, use first 3-5 characters uppercased. Flag for the user to verify.
Show a preview of the first 3 records before generating the file:
## SIF Preview (first 3 of 12 records)
Record 1:
PN=670
PD=Eames Lounge Chair and Ottoman
MC=HMI
MN=Herman Miller
GC=Seating
QT=3
PL=5695.00
WT=92
TG=Executive Lounge
OD=Santos Palisander / Black MCL Leather
AN=DIM
AD=32.75W x 32.5D x 33.5H in
...
12 records total. Generate SIF file? (y/n)
Write the .sif file with CRLF line endings:
# Output path: same directory as input, or specified path
{input-dir}/{input-name}.sif
✓ Generated ffe-schedule.sif
Target: Standard (Hedberg/CAP/ProjectMatrix)
12 records · 8 fields per record avg
Manufacturers: HMI (5), KNL (3), STC (2), BLU (2)
Total list value: $47,830.00
Saved to: ~/Documents/project/ffe-schedule.sif
/ffe-schedule — generate a schedule first, then convert to SIF/sif-to-csv — round-trip: CSV → SIF → send to dealer → receive updated SIF → back to CSV/product-spec-bulk-cleanup — clean up the CSV before converting