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

Enter data in the 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 in this article: Add a WPS;
  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 can be used in projects;
  7. Enter the PQR details. You can only enter one PQR per WPS through this method. If a WPS has more than one PQR, you can edit a WPS and add another PQR;

Upload the csv file

Importing a WPS list with erroneous data
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. 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 

    • Related Articles

    • Add a WPS

      Add one WPS at a time Add a WPS to WT 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 as unique. If the number of a WPS that ...
    • WPS (All)

      The WPS (All) page will show the list of WPS created in WeldTrace and BYO WPS and the associated PQRs. WPS list Click on this menu to open the WPS & PQR sidebar; The WPS (All) menu - this will include BYO WPS and qualified WPS created in WeldTrace; ...
    • 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

      You can create code compliant WPS and PQR in minutes in WeldTrace. Creating a welding procedure in WeldTrace is a 3-step process. You will have to first create a preliminary WPS (pWPS) - refer this article; Then you need to create a procedure ...
    • 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, but the workflow will be similar. ...