Convert the Text Table to the Template of the Bill Materials

You can convert a text table into a template for bills of materials, if it includes text macros. Bill of Materials templates can be created by a person responsible for modifying the system who has previous experience of modifying the Vertex environment.

The Bill of Materials on the drawing sheet in the Symbol Library is implemented as a text table that has been converted into a template for Bills of Materials. Currently, text can only be printed on one row of the Bill of Materials.

Create a template for Bills of Materials as follows:

1. Add a text table to the list field of the drawing sheet.
2. Modify the table columns into suitable widths.
3. Enter the desired fields of the Bill of Materials database in the columns as text macros.

   An Example: #PNO:a#.

   You can also create conditional fields. If the first field is empty, print the next one instead etc.

   An Example: [LABEL?#PIC_ID:a#;#CODE:a#]

   The PIC_ID field will be printed in the column if it has been filled, and the CODE field if the PIC_ID field is empty. Otherwise, the normal text macro properties are used.

4. Select a table and then select the context-sensitive function Convert to Parts List template.
5. Select the output format used by the Bill of Materials. If the text is already a template for Bills of Materials, it will remain unchanged.

   The output format and order are defined in the Kompot setting file.

   An Example: records= "order= -PNO"

   As a conditional clause:

   An Example: records= "where PNO <>------ order= -PNO"

   The fields can be selected for output determined by the format or the table as follows, naming the format # or adding the keyword

   fieldsfromsheet= 1

6. If you continue editing the text table fields, you can reconvert the table into a Bill of Materials template and reselect the output format.

   When editing text, do not delete the upside down exclamation marks ( ¡ ) appearing between text macros.