Customization

CSV Exports can be customized using the advanced formula editor.

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

• S: string

• I: integer, a number without decimal part

• L: length, a number measuring a length

• Black A: array or list of something

• 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.