Shape nesting BOM keywords

Shape nesting data model

▪	Keywords describing the type of BOM

These keywords have to be entered in cell A1 of the template.

{Nesting.
	StructuredList}	The type of BOM intended for sequential iteration of shape nesting data model tree taking into account the level of the item in the model. Such BOMs contain data about different types of items (Desktop, Sheet, Instances).
	List}	BOM type intended to provide a list about the items of any one type. For example, BOM about raw material sheets or piece instances.
	IncludedProducts}	BOM type intended to provide a list of products which are involved in the designed shape nesting.

▪	Keywords defining the data model iteration method (in tables)

These keywords are always used in combination.

{Table.Start.<papildomas subraktažodis>}

{Table.DataDescription(<data filter specification>)}

.....

{Table.End}

A combination of keywords means that the model’s data tree iteration cycle is run from beginning to end. Iteration is carried out in accordance with the BOM type indicated in cell A1 of the template.

The space between the keyword should be filled by keywords which specifically indicate what property data should be displayed in the table and where. This is done by {Tabel.DataDescription} keyword, which marks the beginning of data layout.

{Table.

Start}

Intended to iterate the data without any exceptions according to the BOM type specified in table A1 of the template. Iterating through Nesting, Desktop, Sheet and Instance items, if using {Nesting.StructuredList} or {Nesting.List} BOMs.

Start.

NestingDesktop}

Intended to iterate all raw material worktops.

NestingSheet}

Intended to iterate all raw material sheets.

NestingInstances}

Intended to iterate all instances of designed shape nesting.

Important! During output of data to a table, BOM generator automatically merges similar items. If only piece part code {Item.Piece.Part.Code} is required to be output to the table, even if there are several instances, they will be provided in a single item. This is because the generator sees this field as uniform, because they originate from the same part.

If the number of items is requested {Item.Quantity}, the number of piece instances collected during the whole shape nesting will be output. However, if we add data fields separating these items (e.g. {Item.LabelPos.X} and {Item.LabelPos.Y}), there will be a difference in the data model item description and it will be output by separate items for each instance in the final BOM.

Board}

Intended to iterate all board-type materials in the given shape nesting.

Important! Only the following types of material can be included in nesting technology and shape nesting:

▪

Board

▪	Laminated Board

▪	Multilayer Board

LaminatedBoard}

Intended to iterate all laminated board-type materials in the given shape nesting.

MultilayerBoard}

Intended to iterate all multilayer board-type materials in the given shape nesting.

DataDesription<(Data Filter)>}

This keyword is intended to mark an area where the table area containing the keywords that output the values of the data model item properties begins. The end of the area is marked by the keyword {Table.DataDescription} or {Table.End}. This keyword can also serve as a data filter so that the data we need to work with be filtered during iteration. For example, we know that a material we need is involved in shape nesting, we know the material code and want to generate a BOM for this material only. In such case, the user can specify a filter, which will filter out only those data tree items which correspond to the material code.

For example:

{Nesting.List}	Parts from Laminated Board and Material color F01
	Part title data		Material
	Code	Name	Code	Name	Color Code	Color Name
{Table.Start.NestingPieceInstance}
{Table.DataDescription({Item.Piece.Part.FillWorkpiece.Material.Type}=Laminated Board AND {Item.Piece.Part.FillWorkpiece.Material.Color.Code}=F01)}	{Item.Piece.Part.Code}	{Item.Piece.Part.Name}	{Item.Piece.Part.FillWorkpiece.Material.Code}	{Item.Piece.Part.FillWorkpiece.Material.Name}	{Item.Piece.Part.FillWorkpiece.Material.Color.Code}	{Item.Piece.Part.FillWorkpiece.Material.Color.Name}
{Table.End}

The filter contains a keyword defining an item property and the desired value of the property. Several requests may be merged into one by using operators AND/OR. Please note than AND and OR values cannot be mixed in the same filter.

LastRowBorders}

Intended to mark the list row of the output table, if its formatting is different from the formatting of the main rows.

RawForSum}

Indicates the row in the table where the column sum is output.

ColumnSum}

Indicates the column in the table, the values of which will be summed and output in the place of the keyword.

When BOM is generated, one can imagine that the generator iterates through shape nesting data tree and the indicator shows a specific data item during each step. Depending on the type of item the indicator stands on, respective properties can be read from the item.

Item type =

Nest

{Item.

Code}

Designed shape nesting code. Its value is taken from the Code field, which is available in the Properties tab of the side browser. This value can be edited by the user..

Nesting Code and Name properties in Browser

Name}

Designed shape nesting code. Its value is taken from the Name field, which is available in the Properties tab of the side browser. This value can be edited by the user.

FileDrive}

Outputs the hard drive address where the designed shape nesting file lies.

FilePath}

Outputs the path where the designed shape nesting file lies.

FileName}

Outputs the name of the designed shape nesting file.

FileNameWithoutExtension}

Outputs the name of the designed shape nesting file without extension.

FullFileName}

Outputs the full name of the designed shape nesting file and the path.

DesktopCount}

Number of raw material worktops in the designed shape nesting.

Item type =

Desktop

{Item.

Index}

Outputs raw material worktop index provided by shape nesting editor.

Material.<Material Properties>}

Outputs raw material properties.

The main properties are listed below:

▪

Type

▪

Code

▪	Original.Code

▪

Name

▪	Original.Name

▪	Color.Code

▪	Color.Original.Code

▪	Color.Name

▪	Color.Original.Name

▪

Thickness

▪	HasGrain()

▪

Image()

The remaining properties and their description are available in Keyword Auto Complete.

PieceCount}

Outputs the number of pieces in the given worktop.

PieceInstanceCount}

Outputs the number of piece instances in the given worktop.

SheetCount}

Outputs the number of raw material sheets in the given worktop.

InfillEficiency}

Overall efficiency of filling raw material sheets.

Machine.<Properties>}

Outputs the properties of CNC machine which processes raw material sheets of the given worktop.

Available properties:

▪

Code

▪

Name

▪	ControlerName

▪	Description

Item type=

Sheet

{Item.

Index}

Raw material sequence number on the worktop.

Name}

Name of the raw material sheet.

TopCover.<Material Properties>}

Properties of the top cover material. Relevant for multilayer boards, when outputting information about the side of the board facing up during shape nesting.

BottomCover.<Material Properties>}

Properties of the bottom cover material of the board. Relevant for multilayer boards, when outputting information about the side of the board facing down during shape nesting.

Nesting.<Nesting properties>}

Gives access to all properties of the given shape nesting.

Desktop.<Desktop Properties>}

Gives access to all properties of raw material worktop.

PieceCount}

Outputs the number of pieces in the given sheet.

PieceInstanceCount}

Outputs the number of piece instances in the given sheet.

InfillEficiency}

Efficiency of filling the given raw material sheet.

Length}

Sheet length.

Width}

Sheet width.

Thickness}

Sheet thickness.

Margin}

Outputs the size of sheet margins.

SheetImage(<height>)}

Outputs the image of the given sheet for printing as an MS Excel file according to printing settings defined for the sheet.

CNCprogram.

Outputs CNC program properties.

FileName}	Name of the CNC program file.
FileNameWithoutExtension}	Outputs the name of the CNC program file without extension.
FileDrive}	Outputs the hard drive address where the CNC program file lies.
FilePath}	Outputs the path to the CNC program.
FullFileName}	Outputs the full name of the CNC program file and the path.
Machine.<Machine Properties>}	Outputs the properties of the CNC machine processing this raw material sheet.

Item type =

Instance

{Item.

Piece.

Access to the properties of piece instance..

Part.<Part properties>}

Gives access to all properties of the piece part.

Nesting.<NestingProperties>}

Gives access to all properties of the given shape nesting.

Desktop.<Desktop Properties>}

Gives access to all properties of raw material worktop where the given instance lies.

Sheet.<Sheet Properties>}

Gives access to all properties of raw material sheet where the given instance lies.

CountInSheet}

Outputs the number of given instances on the sheet where it lies.

CountInDesktop}

Outputs the number of given instances in the whole raw material worktop.

Pozition.<Coordinate>}

Position of the base point of given piece instance in CAM technology with respect to the base point of the raw material sheet.

Coordinate: X or Y

AngleDeg}

Rotation angle (in degrees) of given piece instance on raw material sheet in CAM technology.

AngleRad)

Rotation angle (in radians) of given piece instance on raw material sheet in CAM technology.

InstanceImage(<Height>}

Outputs the image of the given piece in the keyword cell (at given height). Uses image printing settings as a MS Excel file.

InstanceImageInSheet(<Height>)}

Outputs the whole raw material nesting scheme highlighting the given piece on this sheet in the keyword cell (at given height).

Uses image printing settings as an MS Excel file.