How to Quote Linear Products Using a CSV File.

Quote linear products in SecturaFAB by uploading a CSV file.

Let’s discover how.

1. Download the linear products CSV templates.
   • Defined Linear Products
   • Undefined Linear Products

The defined linear products CSV template is used when the linear items needing to be quoted are already uploaded in SecturaFAB.

Let’s explore an example of a request for quote of a list of linear

Items	Quantity
4395-0113-01	55
4385-4581-01	53
4395-0119-01	61
1751-2437-0010	58
4395-0125-01	33
MB-56	79
SP-35	68
SP-29	50
SP-28	24
4385-5896-01	24
4395-0739-01	57
4385-3425-01	23
4385-2267-01	76
4356-5796-01	3

Fill in the defined linear products template with the following information

• Item Type — The category or classification that describes the item.
• Part Number — A unique alphanumeric code assigned to the item.
• Revision Number — A version assigned to an item, indicating any changes, updates, or modifications made.
• Quantity — The number of parts needed for the quote.
• Product Name — The name of the product.
• Length — The measurement of the product.
• Units — The standard measurement to define the length of the product. Typically expressed in inches or centimeters.
• Machine — The machine that will be used to cut the linear products.

Now thank you know how to format let’s discover how to make use of the undefined linear product template.

In this example, more information is needed for undefined linear products. These are products that have not been uploaded into SecturaFAB.

You will need to fill in the following information:

• Item Type — The category or classification that describes the item.
• Part Number — A unique alphanumeric code assigned to the item.
• Revision Name— A version assigned to an item, indicating any changes, updates, or modifications made.
• Quantity— The number of parts needed for the quote.
• Product Type — The classification or purpose of the product. Linear parts typically being bar, structural or tube.
• Product Sub Type — A more specific classification of a product type based on characteristics such as shape or cut.

Now, let’s explore an example of how to set up the dimensions of a C-Channel using the undefined linear CSV.

For a C-Channel, we would fill in the following.

• Dim1 — Depth
• Dim1_Unit —Unit of measure
• Dim2 — Web thickness
• Dim2_Unit — Unit of measure
• Dim3 — Flange width
• Dim3_Unit — Unit of measure
• Dim4 — Flange thickness (if applicable)
• Dim4_Unit — Unit of measure
• Grade — MS
• Length — The measurement of the product.
• Units — The standard measurement to define the length of the product. Typically expressed in inches or centimeters.
• Machine — The machine that will be used to cut the linear products.

Now you are ready to upload a CSV using “CAD Files” in SecturaFAB instead of manually inputting each line item.