Canoa Help Docs & Support
Go to AppContact Support
  • Getting Started
    • What is Canoa?
    • Navigating our Platform and Features
      • Standard Features
      • Upgraded Features
    • Quick Start Guide
    • Keyboard Shortcuts
    • Begin with a Template
    • Arranging your Canvas Dashboard
  • Collect
    • How to create a furniture & accessories presentation
    • How to add Links into Canvas
    • How to add an Inspiration Image
      • Copy-Paste from Canvas to Canvas
      • Copy-Paste from Pinterest to Canvas
      • Copy-Paste from Miro to Canvas
      • Copy-Paste from your desktop to Canvas
    • How to start a Canvas from a Drawing
    • How to start a Canvas from Public Catalogs
    • How to add a Product from the Public Catalogs
    • How to search for Products
    • How to create Custom Products
    • How to use Canoa AI
    • Understanding and using Products
    • How to format data with CanoaGPT
    • My Catalog
      • Working in Table view
        • Navigating the Table view
        • How to import your product data
          • How to import 2D vector data (drawings)
            • Best practices for uploading vector data
          • Best Practices for Data Formatting
        • How to edit your product data
    • Integrations & Compatibility
      • Working with Pinterest
      • Working with CET
      • Working with Designer Pages
      • Working with Material Bank
      • Working with Spec
  • Design
    • How to create collages & vignettes for your presentations
    • How to duplicate Images
    • How to add Text
    • How to add Custom Colors
    • How to use the Drawing Tools
    • How to Import and Scale floor plans
    • How to Use the Walls Tool
    • How to draw an Area
    • How to Use the Markup Tool
    • How to Use the Dimension Tool
    • How to use Frames
    • How to organize your Canvas with Frames
    • How to create a Product List
    • How to use the Product Side Panel
    • How to adjust your Product Card view
    • How to use Dashboards
      • Creating a Dashboard
      • Editing the Dashboard settings
      • How to use Areas in a Dashboard and Product List
    • How to design with second life products
    • How to design with generic products
  • Share
    • How to share your Canvas
    • How to invite team members to collaborate
    • How to provide Comments
    • How to use Presentation Mode
    • How to download a Product List
      • How to export a SIF file from Canvas
        • Customizing SIF Export Field Mappings
      • How to bring your Product List data into Microsoft Excel
      • How to bring your Product List data into Google Sheets
      • How to bring your Product List data into Airtable
      • How to bring your Product List data into AutoCAD
      • How to bring your Product List into your Revit model
    • How to export data from a Dashboard
    • How to export or print your Canvas
      • How to export or print your Canvas with Frames
    • How to embed a Canvas
      • How to embed a Canvas into Notion
      • How to embed a Canvas into Squarespace
      • How to embed a Canvas into Webflow
    • How to share products from My Catalog (Gallery)
    • How to share custom products from My Catalog (Table)
    • How to export your product data from My Catalog
      • How to export a SIF file from My Catalog/Table View
  • Choose a Plan
    • Free
    • Pro
    • Studio
    • Custom
    • For Brands
  • Support
    • Managing your account
      • How to create an account
      • How to edit your account settings
      • How to add and remove users from your account
      • How to change your account subscription
      • How to edit and view billing information
      • How to set an email domain to your account
      • How to switch between accounts
    • FAQs
      • Does Canoa work on mobile?
      • How does the carbon estimator work?
      • Are there any discounts for students and teachers?
      • Inventory (Canoa IMS)
      • Orders (View Only)
    • 🛶Canoa University
      • 🪢Implementing your Onboarding Program
        • 💻Accessing your Canoa Account
      • 🗃️Collect: Inspiration & Custom Products
      • 🎨Design: Mood Boards & Presentations
      • 📐Design: Space Planning in Canvas
      • 🏗️Products Lists, Budgets & Dashboards
      • 🪑Onboarding for Brands
        • How to share with your audience that your products are on Canoa
Powered by GitBook
On this page
  • What is the SIF file format?
  • Structure of a SIF File
  • Key Elements of a SIF File
  • Schema Definition
  • File Structure
  • Can SIF Files Contain Links to Other Files?
  • Accessing your Product List:

Was this helpful?

  1. Share
  2. How to download a Product List

How to convert your Product List data into a SIF file

Easily convert your Product List CSV data into a SIF file to use with software for contract office furniture specification and procurement.

Last updated 9 months ago

Was this helpful?

What is the SIF file format?

The Simple Interchange Format (SIF) is a text-based file format used for data interchange between systems. It typically consists of key-value pairs, where each key represents a specific attribute of a product or configuration, and the value is the corresponding data. The keys and values are separated by an equal sign (=), and each pair is usually placed on a new line. Entries (which represent individual records, such as products) are separated by a blank line.

Need to convert a schedule into SIF for import into Spec or Worksheet?

Click for a step-by-step process on how to do it.

Structure of a SIF File

  1. Key-Value Pairs:

    • Each line contains a key and its corresponding value in the format key=value.

    • If a value is not available, the format key= is used, leaving the value empty.

  2. Entry Separation:

    • Each entry (e.g., a product) is separated by a blank line to distinguish between different records.

Example SIF File

Here's an example of a SIF file format:

PN=102813-
PD=*Cut Key,UM Series
MC=FMS
GC=R
P1=2.00
P2=2.40
P4=10.00
P5=99.00
WT=0.00
VO=0.00
NT=1
G0=0000126471

PN=1B2JK7-
PD=*Lock Plug and Key,Chrome UM Series
MC=FMS
GC=R
P1=10.00
P2=12.00
P4=10.00
P5=99.00
WT=0.00
VO=0.00
NT=1
G0=0000126471

PN=232092-
PD=*Lock Plug and Key,Black UM Series
MC=FMS
GC=R
P1=10.00
P2=12.00
P4=10.00
P5=99.00
WT=0.00
VO=0.00
NT=1
G0=0000126471

Key Elements of a SIF File

  • PN (Part Number): Unique identifier for the part or product.

  • PD (Product Description): Description of the product.

  • MC (Manufacturer Code): Code representing the manufacturer.

  • GC (Group Code): Group or category code.

  • P1, P2, P4, P5 (Price Points): Various price-related fields.

  • WT (Weight): Weight of the product.

  • VO (Volume): Volume of the product.

  • NT (Count/Flag): Numeric value indicating a count or specific flag.

  • G0, G1, etc. (Group Identifiers): Additional group-related information.

Usage

SIF files are useful for:

  • Data Interchange: Transferring product information between different systems in a structured and standardized format.

  • Data Import/Export: Facilitating the import and export of data between systems, ensuring consistency and accuracy.

The example provided gives a basic overview of how data is structured in a SIF file. The actual keys and their meanings may vary depending on the specific application and requirements of the systems involved.

Schema Definition

The common schema consists of several key-value pairs, where each key represents a specific attribute of a product or configuration. The keys are derived from analyzing the provided data files and identifying common elements.

Key-Value Pairs

Each entry in the SIF file is defined by a set of key-value pairs. Below is the detailed specification of each key:

  1. CR (Creation/Reference Code)

    • Description: Code indicating creation or a specific reference.

    • Format: String

  2. G0, G1, G2, G3, G4, G5 (Group Identifiers)

    • Description: Identifiers for grouping related items.

    • Format: String

  3. GC (Group Code)

    • Description: Code representing the group category.

    • Format: String

  4. MC (Manufacturer Code)

    • Description: Code representing the manufacturer.

    • Format: String

  5. NT (Count/Flag)

    • Description: Numeric value indicating a count or a specific flag.

    • Format: Integer

  6. O1, O2, O4, O5 (Option Fields)

    • Description: Fields representing various options or configurations.

    • Format: String or Numeric, depending on context.

  7. OD (Option Description)

    • Description: Description of the option.

    • Format: String

  8. OG (Option Group)

    • Description: Group to which the option belongs.

    • Format: String

  9. ON (Option Number)

    • Description: Numeric identifier for the option.

    • Format: Integer

  10. P1, P2, P4, P5 (Price Points)

    • Description: Different price points or values associated with the product.

    • Format: Decimal

  11. PD (Product Description)

    • Description: Description of the product.

    • Format: String

  12. PN (Part Number)

    • Description: Identifier for the part number.

    • Format: String

  13. PO (Purchase Order)

    • Description: Identifier related to purchase orders.

    • Format: String

  14. SL (Storage/Layout)

    • Description: Information related to storage or layout.

    • Format: String

  15. SO (Sales Order)

    • Description: Identifier related to sales orders.

    • Format: String

  16. TO (Transaction Order)

    • Description: Identifier related to transaction orders.

    • Format: String

  17. VO (Volume)

    • Description: Volume measurement.

    • Format: Decimal

  18. WT (Weight)

    • Description: Weight measurement.

    • Format: Decimal

Example of an Empty SIF Entry

Below is an example of an empty SIF entry following the common schema. Each key is present, but the values are empty.

CR=
G0=
G1=
G2=
G3=
G4=
G5=
GC=
MC=
NT=
O1=
O2=
O4=
O5=
OD=
OG=
ON=
P1=
P2=
P4=
P5=
PD=
PN=
PO=
SL=
SO=
TO=
VO=
WT=

File Structure

  • Each product or configuration entry is separated by a blank line.

  • Each attribute within an entry is represented as key=value.

  • If an attribute value is empty, the format is key=.

This specification ensures a standardized format for all SIF files generated using the common schema, facilitating seamless data integration and interchange across various systems.

Can SIF Files Contain Links to Other Files?

Yes, SIF files can contain links to other files. However, this depends on the specific implementation and the system using the SIF file. In a general context, SIF files are designed to store structured data in key-value pairs, and you can include URLs or file paths as values associated with specific keys.

How to Include Links in SIF Files

To include links to other files in a SIF file, you can add key-value pairs where the value is the URL or file path to the other file. Here’s how you can do it:

  1. Identify the Key: Determine the appropriate key in your schema to store the link. This could be a new key or an existing one like Product URL, Image URL, or similar.

  2. Add the Link as a Value: Ensure the value associated with the key is the URL or file path to the other file.

Example SIF Entry with Links

Here’s an example of a SIF entry that includes links to other files:

makefileCopy codePN=12345
PD=Example Product
MC=Example Manufacturer
P1=100.00
P2=90.00
P4=10.00
P5=5.00
VO=0.5
WT=1.0
G0=Example Vendor
GC=Example Category
NT=10
ProductURL=https://example.com/product/12345
ImageURL=https://example.com/images/product_12345.jpg

Steps to Include Links in Your SIF File Using CanoaGPT

  1. Prepare Your Data: Ensure your CSV or other source data includes columns for the links you want to include (e.g., Product URL, Image URL).

  2. Map the Columns to SIF Keys: When using CanoaGPT to convert your data to a SIF file, map these columns to appropriate keys in the SIF schema.

  3. Generate the SIF File: CanoaGPT will include the links in the SIF file as part of the conversion process.

Accessing your Product List:

here
How to download a Product List