Creating a refLoadLevelOne Load file for Well

The information to be stored about the well is taken from the data table. It is

• identifier: "Stratton #" concatenated with column 1.
  (Stratton #1)
• ref_existence_kind: relationship to ref_existence_kind.name = 'actual'
• ref_naming_system: relationship to ref_naming_system.kind = 'local field'

The header is crafted from the above information. The 10 line header appears below:

well
Data taken from Stratton table 2. use g_well_ref
3

identifier	ref_existence_kind	ref_naming_system
	ref_existence_kind.name	ref_naming_system.kind
M	M	O
NDT NAME	NDT NAME	NDT NAME
A40	A40	A40
ENDHEADER		

Each line is tab delimited. The meaning of all the lines is given in detail in refLoadLevelOne documentation. Note the following though:

• The third line has the number of columns.
• Line 5 lists the attributes.
• Line 6 tells how to select the attributes that are relationships. Since column 1 is the identifier, which is a string, it has no entry in column 1.

Now a simple awk file can be written that will extract column 1, build the identifier, and print a line of output. Here is such a file:

{
  if (substr($1,1,4)=="Well") next #skip the header line in the input data table.
  printf("Stratton #%s\tactual\tlocal field\n",$1)
}

Stratton #1     actual  local field
Stratton #2     actual  local field
Stratton #3     actual  local field
Stratton #4     actual  local field
Stratton #5     actual  local field
Stratton #6     actual  local field
Stratton #7     actual  local field
Stratton #8     actual  local field
Stratton #9     actual  local field
Stratton #10    actual  local field
Stratton #11    actual  local field
Stratton #12    actual  local field
Stratton #13    actual  local field
Stratton #14    actual  local field
Stratton #15    actual  local field
Stratton #16    actual  local field
Stratton #17    actual  local field
Stratton #18    actual  local field
Stratton #19    actual  local field
Stratton #20    actual  local field
Stratton #21    actual  local field

When that file is added to the bottom of the header file, we have a file that will load the well entity into Epicentre.