跳至正文
OpenAgentSkill
浏览已开放 · 目录记录日期 2026-11-21 · 自动更新和账户服务暂时关闭。
数据与分析

csv-to-sif

Export a project's FF&E product-library CSV as dealer-system SIF. Use to produce a .sif schedule; use sif-to-csv for the reverse direction.

AlpacaLabsLLC · 已有 AI 审核记录

安装与使用

运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。

npx skills add AlpacaLabsLLC/skills-for-architects --skill csv-to-sif

技能说明


name: csv-to-sif description: Export a project's FF&E product-library CSV as dealer-system SIF. Use to produce a .sif schedule; use sif-to-csv for the reverse direction. allowed-tools:

  • Read
  • Write
  • Edit
  • Bash
  • Glob
  • Grep
  • AskUserQuestion

/as:csv-to-sif — CSV to SIF Converter

Harness note: use /as:<skill> on Claude Code and $<skill> on Codex. Resolve <skill-root> as the directory containing this loaded SKILL.md and <plugin-root> as the plugin root that contains skills/, and use equivalent native tools when host tool names differ.

Converts the nearest project's product-library.csv into a SIF output file for dealer and procurement systems such as Hedberg, CAP, CET, Cyncly Worksheet, ProjectMatrix, Studio Webware, and Design Manager.

When to Use

  • Sending a specification to a dealer for quoting
  • Importing product data into a dealer management system
  • Sharing a standardized product list with procurement
  • Converting an FF&E schedule into a format dealers expect

SIF Format Reference

SIF is a text-based key-value format. Each line is CODE=VALUE, terminated by CRLF. Products are separated by records starting with PN=.

Core fields

CodeNameRequiredDescription
SFSpecification FileNoProject reference (header, once per file)
STSpecification TitleNoDisplay title (header, once per file)
PNProduct NumberYesSKU or model number. Marks the start of a new record.
PDProduct DescriptionYesProduct name and description
MCManufacturer CodeYes3-5 character code (HMI, KNL, STC)
MNManufacturer NameNoFull manufacturer name
QTQuantityYesInteger quantity
NTQuantity (alt)NoSome systems use NT instead of QT
GCCategory / Group CodeNoProduct category
G0Vendor / Group IDNoVendor or dealer identifier

Pricing fields

CodeNameDescription
PLList PriceUnit list price (numeric, no currency symbol)
P1Price Tier 1Primary price (some systems use P1 instead of PL)
P2Price Tier 2Alternate price tier
P4Price Tier 4Alternate price tier
P5Price Tier 5Alternate price tier
I1Unit List Price (Cyncly)Used by Cyncly Worksheet
I2Purchase 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)

Product detail fields

CodeNameDescription
TGSide Mark / TagRoom name, area code, or project tag
ONOption NumberMust pair with OD
ODOption DescriptionFinish, fabric, color selection
ANAttribute NumberMust pair with AD
ADAttribute DescriptionDimension, weight, or other attribute
WTWeightProduct weight
VOVolumeProduct volume
PRCProduct Category (Cyncly)Category for Cyncly Worksheet

Link fields

CodeNameDescription
ProductURLProduct Page URLLink to manufacturer product page
ImageURLProduct Image URLLink to product image
PVPicture PathWindows bitmap or TIF file path

Alternate manufacturer codes (by system)

SystemCodePurpose
StandardMC3-5 char manufacturer code
Cyncly WorksheetMGManufacturer code (replaces MC)
Cyncly WorksheetMNFull manufacturer name
CET / ConfiguraECManufacturer code (alt)

File structure example

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

Rules

  • Each line is one field: CODE=VALUE
  • Lines terminated by CRLF
  • Blank line between records
  • PN starts a new record — must come first in each record
  • ON/OD and AN/AD pairs must stay together
  • No embedded line breaks within a field value
  • Empty values use CODE= with nothing after the equals sign

Step 1: Accept Input

Read ../../schema/product-schema.md and ../../schema/csv-conventions.md. Default to the nearest ancestor containing PROJECT.md and validate its product-library.csv with python3 "<plugin-root>/skills/master-schedule/scripts/csv-library.py" validate product --project <project-root> before conversion. This skill is read-only with respect to the CSV; its structured output remains SIF.

CSV file:

/as:csv-to-sif ./product-data-import.csv

Pasted CSV:

/as: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

Step 2: Choose Target System

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:

  • Standard: MC for manufacturer, PL for price, QT for quantity
  • CET: EC for manufacturer, standard pricing
  • Cyncly: MG/MN for manufact
阅读完整来源 ↗