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, for example to add the result of a formula.
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:
I: , a number without decimal part
L: , a number measuring a 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.
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)
Exporting data from OpenCutList to a CSV file or clipboard.
The List of Instances, the Parts List or the Summary can be exported or prepared for a Copy to Clipboard.
When selecting List of Instances, OpenCutList exports each part on its own row. Parts List and Summary export the data as represented on screen.
Only visible groups are part of the export. If you hide a group in the Parts List, it will not appear in the export.
If units are shown in the Parts List, dimensions will be exported with units as well. On the Customization tab, rows can be selected, ordered or used to compute derived data.
The Separator allows you to select among Tabulator, Comma or Semicolon as the sign to separate columns.
Encoding defines how special characters (beyond ASCII) will be encoded in the file. UTF-8 is a widely supported encoding.
By clicking on the Preview, you may copy everything (values including headers) or just values to the clipboard.
