Customization
CSV Exports can be customized using the advanced formula editor.
Columns of the exported data can be customized using the Formula editor.
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 that can be used to contain the result of a formula.
A formula can be added to each column to change its content from the native value to something different. To be as powerful as possible, formula are written in Ruby code.
As an example, we want to add the string "ABC-" in front of each designation. Type
"ABC-" + @Designationinto the Formula. 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 type this variable has.
The meaning is
S: stringI: integer, a number without decimal partL: length, a number measuring a length- Black
A: array or list of something - Orange
A: area 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.
Last modified 4mo ago