Bill Of Materials (BOM)

<< Click to Display Table of Contents >>

Navigation:  Import and Export >

Bill Of Materials (BOM)

A BOM can be used to load multiple parts into a Primecut Workorder or Quote at once by means of a csv spreadsheet.

 

There are two types of built-in BOM Import supported, as well as custom importer plugin DLLs which Kinetic can tailor to your needs.

 

Database BOM (*.BOM)

 

BOM1gra

These buttons shown above are used to load and export this type of BOM.

 

This suits manufacturing businesses, where a BOM (kitset) of parts for an assembly or machine can be created.  The parts these BOM references are expected to already exist in the Primecut Database, and are referenced by PartName.  The BOM is very simple, just a list of comma delimited partnames and quantities (and an optional item notes column) with no header row PartName,Quantity,[ItemNotes].

 

 

This BOM just creates Workorder or quote line items from preeloaded parts.

 

for example:

 

CS1553-P12,2

CS1553-P15,1

CS1553-P16,7

 

or with item notes:

 

CS1553-P12,2,"Needs Galvanising"

CS1553-P15,1,""

CS1553-P16,7,"Needs Galvanising"

 

The part names must exist in the database, and the latest revision will be used.

You can export a BOM from a workorder or quote using the Save BOM button shown above.

 

Generic BOM (*.csv)

bom2

These BOMs are loaded via the normal part open dialog, and then in the file open dialog selecting Comma Separated Values (*.csv) from the file type drop down.

 

When the parts do not pre-exist in the database, and both parts and line items referencing the parts need to be created, then this is the type to use.   Typically the csv file will sit in the same folder as the DXF, dwg or NC1 files it references.  These files can also be used to create simple rectangular parts defin3ed by Width and Height without referencing a file.

This style of BOM is more general, and has a header row defining the columns.  The columns in square brackets are optional, columns without square brackets are required.

 

PartName,Grade,Thickness,Qty[,Width][,Height][,PartNotes][,ItemNotes][,Piecemark]

 

PartName: is the path to the drawing file

If the .CSV import file is in the same directory then the PartName is the name of the file "example.dxf"

If the it is in a different directory then must specify the full directory of the file "C:\Users\MyUser\MyDrawingsDirectory\example.dxf"

The part name in primecut will be imported without the file extension. In this case imported part name would be "example"

Grade & Thickness Material and Thickness must already exist. If not you will get a warning that it doesn't when you import.  Thickness is specified in the default units Primecut is running in, or may be specified with an mm or " unit specifier to remove ambiguity; if inch  thicknesses are represented as fractions then it it is suggested to ensure they are appended with " and let Primecut interpret them.

ItemNotes and Piecemark Properties attached to the workorder item.

Width and Height Columns

These columns must appear together if they are used.

If the path specified by the name is not found, then the part is treated as a rectangular shape. The width and height columns indicate which the dimensions (optional otherwise).

 

Example:

PartName,Grade,Thickness,Qty
C:\part1.dxf, A36, 0.500, 20
C:\part2.dxf, A36, 0.500, 30
C:\part3.dxf, A36, 0.250, 5

 

 

Custom Plugin DLLs

Kinetic can also develop a custom DLL to import a csv file of your own format which may include extra columns, and these can also create the workorder or quote header information as well, ie they can create entire workorders and quotes.  Contact Kinetic for pricing.