Stokes Buy Help Contact
Help Editing lists of pipes and other objects

Editing lists of pipes and other objects


What is it about?
Where the data is stored
How to edit


What is it about?


In the editing forms of all types of objects, there is a drop-down list at the top with different variants of objects. There is also a list of different types of gas and water in the form of parameters of the pumped fluid.

You can manually fill in the required parameters in the form. But in some cases it is more convenient to choose something from the list. Perhaps these lists are most useful in the forms of pipe parameters and pumped fluid.

When selecting an item from the list, some parameters in the form are assigned values corresponding to the selected items. For example, in the pipe parameters form, the inner diameter and roughness change.


Where the data is stored


The data for these lists are stored in tsv files in the DB folder near the executable file of the program.

The screenshot shows a list of files for the Stock version 22.12.1. The file names contain type of objects and language. The files Scheme_* contain a directory of pumped fluid (water, gas).

Files Pipe_ru_(H2O).tsv и Pipe_ru_(alt_group).tsv contains alternative lists of pipes.
In the Pipe_ru_(alt_group).tsv pipes are sorted differently: first all PE, and then all steel.
In the Pipe_ru_(H2O).tsv the pipes are the same as in a regular Pipe_ru.tsv, but their roughness is greater: 1mm for steel pipes (instead of 0.1 mm) and 0.014 mm for PE (instead of 0.007 mm) — this can be useful if you are calculating water supply.

To use the lists from Pipe_ru_(H2O).tsv or Pipe_ru_(alt_group).tsv, simply rename the corresponding file to Pipe_ru.tsv (or Pipe_en.tsv, if you use English). The original Pipe_ru.tsv before that you need to rename it to something else, for example Pipe_ru_(gas).tsv.


How to edit


TSV format, which is used in reference books, is a simple text format for presenting tables with column separation by tabulation. Any text editor that can work with tabulation symbols is suitable for editing.

For example used Notepad2 (not to be confused with the standard Windows Notepad!). To visually distinguish tab characters from spaces, turn on the mode Show Whitespace (see screenshot) in the Notepad2 menu. Tab characters will be highlighted with a red arrow, and regular spaces with a red dot.

Do not change the first line in files — it is necessary so that Stokes can understand in which column the next rows is which parameter. It will also be useful to you for the same purpose.

The following lines contain drop-down lists. In the first column, the name is everywhere, then the parameter values. All values are set in SI base units — m, kg/m2, Pa, etc. Feet, inches and gallons are used only by savage barbarians.

It is important that the encoding does not accidentally change during the editing — it must be UTF-8.

After editing and saving tsv files, restart Stokes and make sure that there are no errors anywhere and the drop-down lists work correctly. Save copies of edited files so that you don't lose them when installing new versions of Stokes!