Bom Parameters

This section of the board file defines the BOM information that is available for the board.

Syntax

BOM
  { SOURCE BOM_FILE
        FILENAME := "filename";
        BOMFILE_TYPE := "bomFileType";
        { START_LINE := startLine;
        { EXCEL_SHEET_COUNT := excelSheetCount;
        { EXCEL_SHEET_NUMBER := excelSheetNumber;
        { COLUMN_DELIMITERS := delimiters;
        { MERGE_DELIMITERS := [ TRUE | FALSE ];
        { FIXED_COLUMN_WIDTHS := columnWidths;
        { DEVICEREF_DELIMITERS := delimiters;
        FIELDS
            { "field" := "column"; }
            ...
        END;
    END; }

  { SOURCE NETLIST
        FILENAME := "filename";
        { AUTO_IMPORT := [ TRUE | FALSE ];
        FIELDS
            { "field" := "column"; }
            ...
        END;
    END; }

  { SOURCE SCHEMATIC
        FILENAME := "filename";
        FIELDS
            { "field" := "column"; }
            ...
        END;
    END; }

Where the variables are:

filename

The filename of the source of BOM data

bomFileType

The type of BOM file: one of Csv, Delimited, FixedWidth or Excel

startLine

Indicates the line number to start importing data from the BOM file. Not relevant if the bomFileType is Excel.

excelSheetCount

Indicates the number of sheets in the Excel file, if bomFileType is Excel.

excelSheetNumber

Indicates the number of the sheets in the Excel file to import data from, if bomFileType is Excel.

delimiters

A list of delimiters to use to break up the fields of the BOM file, if bomFileType is Delimited.

columnWidths

A list of the widths of the columns in the BOM file, if bomFileType is FixedWidth.

deviceRefDelimiters

A list of delimiters to use to separate device references, when fields in the BOM file contain lists of delimiters.

field

A name of a BOM field to import data into from the source.

column

The name of a column in a BOM source to import data from.

Example

BOM
    SOURCE BOMFILE
        FILENAME := "..\\Board Data\\XJDemo.csv";
        BOMFILE_TYPE := "Csv";
        START_LINE := 2;
        DEVICEREF_DELIMITERS := ',';
        FIELDS
            "Reference" := "1";
            "Description" := "2";
            "Value" := "3";
        END;
    END;

    SOURCE SCHEMATIC
        FILENAME := "..\\Board Data\\DemoBoard.pdf";
        FIELDS
            "Reference" := "Ref";
            "Part Number" := "Part";
        END;
    END;
END;