OpenCutList
English
English
  • Introduction
  • OpenCutList
  • What's new?
    • In Version 6.0
    • In Version 5.0
  • Getting Started
    • Installation
      • Toolbar
      • Preferences
      • Presets
    • Components
    • Updating
  • Features
    • Materials
    • Parts
      • Print
      • Export to CSV
        • Customization
      • Draw
        • Export to Layout
      • Estimate
      • Options
      • Parts List
        • Edit Part
        • Cutting Diagrams
          • Dimensional
          • Sheet Goods
          • Export
        • Labels
      • Export Part Drawing
        • Export 2D Part Projection
        • Export 3D Part Geometry
    • Import
    • Smart Paint Tool
    • Smart Axes Tool
    • Smart Export Tool
    • More
  • Tutorials
    • Coffee Table
    • Tutorials on YouTube
    • OpenCutList to Shaper Origin
  • Getting Help
    • Shortcuts for Speed
    • Frequently Asked Questions
    • More Questions and Bugs
  • For Translators
    • General
    • Transifex Help
Powered by GitBook
On this page
  • Native Columns
  • Formulas

Was this helpful?

Export as PDF
  1. Features
  2. Parts
  3. Export to CSV

Customization

CSV Exports can be customized using the advanced formula editor.

PreviousExport to CSVNextDraw

Last updated 7 months ago

Was this helpful?

Columns of the exported data can be customized using the Formula editor.

Native Columns

The native columns are the raw columns that depend on the selected Source (Summary, Parts List or List of Instances).

For each column, you may

  • change its title

  • hide or show it

  • remove or add it

  • change the alignment (this will have no effect in the exported file!)

The order of columns can be changed by dragging the left handle.

You can preview your configuration at any time.

The settings can be saved to a preset for future use.

You can also add new columns, for example to add the result of a formula.

Formulas

A formula can be added to each column to define its content. To be as powerful as possible, formula are written in Ruby code.

For example, to add the string "ABC-" in front of each designation, use

"ABC-" + @Designation

To replace the edge material name by an X, use

@Edge Length 1.empty? ? '' : 'X'

This tells OpenCutList that you want to concatenate two strings, instead of just using the native value of the column.

To get a list of available variables, type @ into the formula field. In front of each variable, a small colored square will tell you what is the type of this variable.

The meaning is

  • Orange A: area

  • T: material type, an object that represents a material type name with following test functions:

    • is_solid_wood?

    • is_sheet_good?

    • is_dimensional?

    • is_hardware?

    • is_edge?

    • is_veneer?

  • E: edge object that hold 3 sub properties :

    • material_name - the edge material name (S: string)

    • std_thickness - the edge thickness (L : length)

    • std_width - the edge width (L : length)

  • V: veneer object that hold 2 sub properties :

    • material_name - the veneer material name (S: string)

    • std_thickness - the veneer thickness (L: length)

Depending on the type of value, certain operations may not yield the expected result. Adding a length to a quantity will probably not make sense, and the column might be empty.

S:

I: , a number without decimal part

L: , a number measuring a length

Black A: or list of something

string
integer
length
array
Page cover image