Import a list of your WPS and PQR into WeldTrace with data in a spreadsheet file

Import WPS List

You may import your WPS list from other sources into the WPS library of Weld Trace. The data must be available in the CSV file format (comma separated values). 

Download the template file

Import WPS list in a CSV file
  1. Download the template file; 
  2. The template file will be downloaded and it should appear at the bottom left hand corner if you are using the Chrome browser. The location of the files that are downloaded from a browser could vary depending on your computer's settings;
  3. Click here to upload the file once you have the data entered;
  4. Link for the help center article on how to import data in a CSV file;

Enter data into the template file

Import WPS list in a csv file

Open the template with Excel or another program that can be used to edit csv files;
  1. Do not edit the header row and do not change the order of the columns. The import process will not work if you make any change to the header row;
  2. Enter the data. Please check the knowledge base article for adding the data one at a time to find which fields are mandatory and which ones are optional, for using special characters, number of characters, etc. Also make sure to check the spelling and abbreviations, like shown in this screenshot;
  3. Enter only the options given below in tables for each standard process, process type, joint type, product form and position;
  4. Enter the WeldTrace base metal reference that you will find in the first column of the base metals library. Use the whole text including the ""BM-" prefix;
  5. If PWHT is not applicable, enter "N/A" and if it is applicable, enter "yes";
  6. Enter "yes" if the WPS is qualified. Only the WPS that are qualified or prequalified (Qualified = Yes or Qualified = No & Prequalified = Yes) can be used in projects;
  7. Enter the PQR details. You can enter only one PQR per WPS through this method. If a WPS has more than one PQR, you can edit a WPS and add another PQR through the single entry method;

Populate the csv template

Refer the following tables for the list of acceptable values for each standard. Please note that these values are case-sensitive:

ASME IX

PROCESS
PROCESS TYPE
JOINT TYPE
PRODUCT FORM
POSITION
SMAWManualGroovePipeF
GTAWSemi-automaticFilletPlateF, H
GMAWAutomaticHFOL
F, H, V
FCAWMechanizedCROL
V
SAW
Plug/Slot
F, H, OH
PAW
STUD
F, V, OH
OFW


F, H, V, OH
STUD



All
EGW




ESW




EW-HDPE




FW-HDPE




AWS D1.1

PROCESS
PROCESS TYPE
JOINT TYPE
PRODUCT FORM
POSITION
SMAWManualGroovePipeF
GTAWSemi-automaticFilletPlateF, H
GMAWAutomatic
Box TubeF, H, V
FCAWMechanized

V
SAW


F, H, OH
EGW


F, V, OH
ESW


F, H, V, OH




All
Note: Use the weld type value in AWS D1.1 for the joint type column.

ISO 15614-1

PROCESS
PROCESS TYPE
JOINT TYPE
PRODUCT FORM
POSITION
15ManualButtPipeF
111Semi-automaticFilletPlateF, H
114Automatic

F, H, V
121Mechanized

V
125


F, H, OH
131


F, V, OH
135


F, H, V, OH
136


All
138



141



142



143



145




Note: Use the weld type value in ISO 15614-1 for the joint type column.

API 1104

PROCESS
PROCESS TYPE
JOINT TYPE
PRODUCT FORM
POSITION
SMAWManualButtPipeF
GTAWSemi-automaticFillet
F, H
GMAWAutomaticBranch
F, H, V
FCAWMechanized

V
SAW


F, H, OH
PAW


F, V, OH
OFW


F, H, V, OH
FBW


All

For all the other standards you may use any of the acceptable values given in the four tables above. WeldTrace currently accepts these standards: AS/NZS 1554.1, AS/NZS 1554.3, AS/NZS 1554.5, AS/NZS 1554.6, AS/NZS 1665, AS/NZS 3992, ASME B31.1, ASME B31.3, ASME B31.4, ASME B31.8, AWS B2.1, AWS D1.2, AWS D1.5, AWS D1.6, AWS D9.1, BS 4515-1, BS 4515-2, EN 1011-2, EN 1011-3 and you can also use the text "Other" for the other standards.

Abbreviations used for American Standards

SMAW – Shielded metal arc welding;
GTAW - Gas tungsten arc welding;
GMAW - Gas metal arc welding;
FCAW - Flux core arc welding;
SAW - Submerged arc welding;
PAW - Plasma arc welding;
RSW - Resistance spot welding;
MMAW - Manual metal arc welding;
EGW - Electrogas welding;
ESW - Electroslag welding;
OFW - Oxyfuel gas welding;
FBW - Flash butt welding;
CROL - Corrosion-resistant overlay;
HFOL - Hardfacing overlay;
FW-HDPE – Fusion welding (HDPE);
EW-HDPE – Extrusion welding (HDPE);
STUD - Stud welding;

Abbreviations used for ISO Standards

111 Manual Metal Arc Welding (MMAW);
114 Self-shielded tubular cored arc welding (FCAW);
121 Submerged arc welding with solid wire electrode (partly mechanized) (SAW);
125 Submerged arc welding with tubular cored electrode (partly mechanized) (SAW);
131 MIG welding with solid wire electrode (GMAW);
135 MAG welding with solid wire electrode (GMAW);
136 MAG welding with flux cored electrode (FCAW);
138 MAG welding with metal cored electrode (FCAW);
141 TIG welding with solid filler material (wire/rod) (GTAW);
142 Autogenous TIG welding (GTAW);
143 TIG welding with tubular cored filler material (wire/rod) (GTAW);
145 TIG welding using reducing gas and solid filler material (wire/rod) (GTAW);
15 Plasma arc welding (PAW);

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.
Import WPS list with errors
  1. This error message will appear when you import a file that has one or more errors;
  2. This error is for a duplicate WPS number; 
  3. These are typos (spelling mistakes) or for using terms that WeldTrace does not use;
  4. This error is for a base metal number that does not exist;
  5. The create button will be disabled if there is any error;

Import data when no errors are found

Import WPS list in a csv file

If there are no errors in the uploaded csv file, the warning will not appear and the "Create" button will be enabled. 
  1. The data that has been read from the csv file is shown with no data appearing in red; 
  2. When there are no errors, the button to create the data will be enabled. Click to add the data to the WPS list;
Read the next article: Adding WPS and PQR files in bulk 
Sample Data: You can download the sample WPS template at the end of this article and import it to your trial account. This will give you some idea about the data import process in WeldTrace. Once you have imported the WPS, you may import the welders list and import the sample welders list in this page (Add Welders). 

    • Related Articles

    • WPS (All)

      The WPS (All) page will show the list of WPS created in WeldTrace and BYO WPS and the associated PQRs. List of all the approved WPS Click on this menu to open the WPS & PQR sidebar; The WPS (All) menu - this will include BYO WPS and qualified WPS ...

    • Add a WPS

      Add one WPS at a time Add your own WPS 1 Add your own WPS 2 Add your own WPS 3 WPS Number - Welding Procedure Specification Number. You may use a combination of letters and numbers. The WPS number together with the revision number will be considered ...

    • WPS & PQR Bulk File Upload Process

      The bulk file upload wizard will allow you to upload more than one file at a time and match them with the WPS and PQRs that do not have file attachments. Please note that this method is only to add files to the WPS and PQRs that are created elsewhere ...

    • WPS

      WeldTrace supports these standards for writing code-compliant welding procedures: ASME IX (for all of these methods: Groove & Fillet welds, Corrosion Resistant & Hardfacing Overlay welds, tube to tubesheet joints, Lap & Stud welds), AWS D1.1, AWS ...

    • How to Create a WPS from Multiple PQRs

      This article is about combining PQRs to create a WPS. This article contains the screenshots and the explanation for creating a WPS from more than one PQR for ASME IX. The steps and fields will differ for AWS D1.1, AWS D1.2, AWS D1.5, AWS D1.6, API ...