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

Import materials list

1. The heat number must be unique. If you have more than one material with the same heat number, enter a lot number;
   
2. You may enter the WeldTrace base metal reference (check this article to learn more about base metals in WeldTrace) or enter the P number;
   
3. For product forms plate, sheet, rod, box tube and other, enter the thickness value in column G;
   
4. For product forms pipe and tube, enter the OD, wall thickness and schedule in columns H, I and J;
   
5. For product form structural, enter the major size, minor size and thickness values in columns L, M and N;
   
6. If the product form is pipe fitting, enter the pipe fitting type value in column K;
   
7. The last 5 columns are optional and are for managing your inventory;

Upload the csv file

CSV file with errors

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.

1. The error here is for a base metal reference that is invalid; 
   
2. 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

• Related Articles

• Materials

  In the materials section you can add and maintain the heat numbers, mill test certificates and dimensions of the materials that you would use in a project.  When you click on the "Materials" menu in a project, you will be taken to the materials list ...

• Import Consumables List

  Import Consumables List

• Projects or Jobs

  A project is a set of welds defined by a job or an order. A project can have anywhere from one weld to thousands of welds. WeldTrace uses the term project and in small fabrication settings, the term job would be equivalent to a project. Projects list ...

• Add a Material (one at a time)

  This knowledge base article is about adding a material to a project one at a time. For adding more than one material at a time, please read the article: Import Materials List Add material page Select the base metal Click on the "+" button in the ...

• Cloning a Project

  This article is about cloning a project into another project. If you are looking to copy or clone a project's settings alone, please refer this article. Only the Super User and Account Administrators who are given access to the "Admin" menu will be ...