Importing a DB1 data base

Importing a DB1 data base

DRAINS stores information on pipes, pits and overflow routes in two places:
  • in each .drn file containing the information on a system in binary formats,

  • in a file with a .db1 suffix, which is located in the C:\Program Files\Drains\Program or C:\Program Files (x86)\Drains\Program folder on your PC.

You will probably have .db1 (or DB1) files for various regional of Australia, together with a file named Drains.db1, which is opened when a new file is created.  Drains.db1 is not opened when an established DRAINS model is opened; the data base used is that stored within this .drn file. The other .db1 files can be converted into the Drains.db1 file by renaming or copying them.  

This process occurs within DRAINS when a Default data base is selected.

Users can be "trapped" with the wrong data base if they do not consider exactly what is required before entering pipes and pits. For programming reasons, it is not possible to delete pit and pipe data in systems where pits and pipes are present, though this can be done for overflow routes. However, additional data can be readily added to the data base using the Import -> DRAINS Database (DB1) File option in the File menu. When selected, this opens the following dialog box:


While it may not be possible to replace existing data, as is the case here, parts of the new data base can be added to the existing data base.

    • Related Articles

    • Importing data tables from a spreadsheet

      Rainfall hyetographs and stream flow hydrographs can be imported into DRAINS via the Windows Clipboard using the following procedure: (a) Set up the data in a table of values, with the times of the start of each period in one column, and the rainfall ...

    • Default data base dialog box

      This dialog box is used to set up a pit pipe and overflow route data base for a new DRAINS model. When selected from the Project menu, it allows you to choose a pit data base from those that are stored in the C:\Program Files\Drains\Program or the ...

    • Pit Data Base property sheet

      This window allows you to set up a data base of inlet capacity relationships for common pit types or families, with different sizes in each type. This format is required for the design method used in DRAINS. The Add and Properties buttons in the top ...

    • Pit Data Base property sheet (superseded format)

      In early DRAINS models, this window was used to set up a data base of common pit types. It was necessary to input the following information: the name of the pit type (source, applicable slope, etc.) three parameters for the inlet capacity in a sag ...

    • Importing ILSAX files

      The DRAINS procedure for converting the information in existing ILSAX files into DRAINS format is still available. However, it is not recommended as it creates DRAINS files in formats that are no longer current, particularly concerning the pit data ...