ValveTrack has a powerful tool to import new valves into the database. In many projects valve data is received in an Excel sheet and it is often hard to include hundreds of valves without a powerful import tool. The demo video below gives you a demo of the tool.

You can also follow these steps.

The Excel template is downloaded to your Download folder. The filename will typically be: "VT - 4Subsea Demo - Valves Import.xlsx" where "4Subsea Demo" refers to the field.

The Excel template contains all the valves that are currently stored in ValveTrack for the current field:

Headers include units in brackets:

For a complete overview of valve attributes, including definitions, units, and validation rules, see Valve Attributes: Definitions, Units, and Validation

You can simply start editing the Excel sheet and add a new rows:

Validation rules help you with quality assurance. In our example, the second valve has a Max applied torque that is higher than Do not exceed torque:

This will trigger a validation error when uploading the template.

Click on the Upload template button

Select the file and you will get a summary with an expected error message:

It points you directly to row 46 as expected and it gives you a message explaining what to correct.

Correct the error in the Excel sheet and repeat the process - Upload template:

Click on Submit template and the process starts. The imported valves will appear in the Valve list. Do a search and see:

Created for version: 1.1.4