Import Materials List
For general information on how to import data with a csv or spreadsheet file, please refer this article: https://support.weldtrace.com/portal/en/kb/articles/import-data-spreadsheet
Enter data in the template file
- The heat number must be unique. If you have more than one material with the same heat number, enter a lot number;
- You may enter the WeldTrace base metal reference (check this article to learn more about base metals in WeldTrace) or enter the P number;
- For product forms plate, sheet, rod, box tube and other, enter the thickness value in column G;
- For product forms pipe and tube, enter the OD, wall thickness and schedule in columns H, I and J;
- For product form structural, enter the major size, minor size and thickness values in columns L, M and N;
- If the product form is pipe fitting, enter the pipe fitting type value in column K;
- The last 5 columns are optional and are for managing your inventory;
Upload the csv file
WeldTrace will read the csv file and evaluate the data and if there are any errors a warning message as shown in the screenshot above will appear. Data that is not acceptable or with some errors will be in red text and highlighted in a red background.
- The error here is for a base metal reference that is invalid;
- This field has an extra space. Please use the exact terms including hyphens;
|
Product Form
|
Pipe Fitting Type
|
Unit of Measure
|
|
Plate
|
Pipe-Nipple |
For pipe fitting & other
|
|
Pipe
|
Tee
|
Ea |
| Pipe Fitting |
Reducing Tee
|
|
|
Tube
|
Elbow
|
For linear measures
|
|
Box Tube
|
Concentric Reducer
|
mm
|
|
Structural
|
Eccentric Reducer
|
m
|
|
Sheet
|
Flange-Weld Neck
|
ft
|
|
Rod
|
Flange-Slip on
|
|
|
Other
|
Flange-RTJ Ring Joint
|
For plate & sheet
|
|
|
Flange-Socket Weld
|
Sq. m
|
|
|
Flange-Blind
|
Sq. ft
|
|
Welded Valve
|
|
|
|
|
O-Let-WOL
|
|
|
|
O-Let-EOL
|
|
|
|
O-Let-TOL
|
|
|
|
O-Let-SOL
|
|
|
|
Cap
|
|
|
|
Swage |
|
|
|
Coupling
|
|
|
|
Plug
|
|
|
|
Union
|
|
|
|
Bushing
|
|
|
|
Threaded Fitting
|
|
|
|
Other Pipe Fitting
|
|
Go to the next section: Consumables