When adding products, costs, and/or materials into SecturaFAB, you can either manually create each one with the "ADD" button, or you can import all of them at the same time using a .csv file. Below are the three formats you will need to use to accomplish this. There are also three .csv files attached that you may use.
Materials
When importing, you will need to make sure your excel file is set up in the following way. The following list, should be input to Row 1, each letter in the list below should correspond with letter of the column. Please make sure to watch for any capitals, or underscores, as this is case sensitive.
- MaterialGrade
- Description
- MaterialGroup
- GroupCode
- ProductType
- Density
- Density_Units
- Waterjetmachinablinity
- Remark
Your Materials csv files should now look something like this. There is an example of a material that will be successfully imported into SecturaFAB
Costs
When importing, you will need to make sure your excel file is set up in the following way. The following list, should be input to Row 1, each letter in the list below should correspond with letter of the column. Please make sure to watch for any capitals, or underscores, as this is case sensitive.
- PriceBook
- Name
- CostType
- Cost
- Price
- Cost_Units
- Currency
- Currency_Symbol
- MaterialGrade
- Thickness
- Thickness_Units
- ExternalReference
Your Costs csv files should now look something like this. There is an example of a Cost that will be successfully imported into SecturaFAB:
Products
When importing, you will need to make sure your excel file is set up in the following way. The following list, should be input to Row 1, each letter in the list below should correspond with letter of the column. Please make sure to watch for any capitals, or underscores, as this is case sensitive. The products csv file will have quite a few columns that will need to be filled out, so the examples will be split into 2 pictures.
- ProductType
- ProductSubType
- ProductName
- Category
- SubCategory
- ProductCode
- ProductDescription
- Size
- WeihtCategory
- TimeCategory
- IncludeInPriceList
- Account
- WebUrl
- ShapeName
- Dim1
- Dim1_Unit
- Dim2
- Dim2_Unit
- Dim3
- Dim3_Unit
- Dim4
- Dim4_Unit
- Area
- Area_Unit
- Perimeter
- Perimeter_Unit
- WeightLenght
- WeightLenght_Unit
- MaterialCrade
- MaterialExternalReference
- Thickness
- Thickness_Unit
- WeightArea
- WeightArea_Unit
- xDim
- xDim_Units
- yDim
- yDim_Units
- zDim
- zDim_Units
- Weight
- Weight_Units
- ServiceType
- ProductConfigName
- SKU
- Length
- Length_Unit
- Width
- Width_Unit
- ExcludeFromNest
Part 1 (A - AB):