Data Source Module

Data Source modules are created when an ASCII data file, Excel data file, database file, or other type of tabular data file is loaded into the Network Manager using the File | Import command.

 

Input Modules

Defined from the point coordinates located in the data file.

 

Output Modules

Depending on the type of data imported, the Data Source module may be connected to the Graphics Output Modules, Computational Modules, or WellData Module. An Info Module may also be connected to the output node.

 

Properties

Click on the Data Source module in the Network Manager to select it. The Property Manager displays various data column specification properties for the data source module.  The data source module properties are described below.

 


Select a data set in the
Network Manager
to display its properties in the
Property Manager.

 

The Data Source module contains the following tabs in the Property Manager:

General

 

The General page properties change depending on the Output type selection. The three sections below explain the shared properties, Points properties, and Wells properties respectively.

 

General Options

The following options are presented in the General page regardless of the Output type selection.

 

The properties visible above are displayed regardless of

the Output type selection.

 

File Path

The path of the loaded source file appears next to File path. Click the button to the right of the file path to display the Open dialog. The Open dialog appears. The currently loaded file name is display in the File name section. The path for the current file is shown. Click the Open button to reload the current file.

 

Alternatively browse and select a new file. Click the Open button to load the new file. The dialog closes and the selected file is loaded. If the new file does not display geometry information, a warning message will appear and the original file remains.

 

Worksheet

Click the Edit Worksheet button to display and edit the data in a linked worksheet window. The title bar and worksheet tab will display "Linked to:" followed by the module name and ID. Changes made to the module data will be automatically saved and represented instantly in the viewer window.

 

Notice that the data linked to the module is being edited. The original data file, i.e. the file that was imported, is not changed. The data is saved in the Voxler project .VOXB file. If you wish to save the changes to a separate file (or to overwrite the original data file), use the File | Save Copy As command while viewing the linked worksheet.

 

Output

The Output type option specifies whether the Data Source module contains Points or Wells information.

 

Worksheet Rows

The Worksheet Rows section contains options for specifying which rows are used.

 

Specify the row containing the column titles (i.e. the header row) in the Header row field. If the Header row is incorrectly specified, the column title will not be displayed next to the column letter in the other General page property fields or in the Property Manager for downstream modules. Type the row number into the Header row field, or click the buttons to change the value. The header row value can be any integer between 1 and 1000.

 

Check the Load all rows check box to use all rows in the worksheet, excluding the header row if applicable. Uncheck the Load all rows check box to set the first and last row used in the data file. Set the First row and Last row properties by typing a value into the field or clicking the buttons.

 

General Page - Points

The following options are displayed when the Output type is set to Points.

 


Specify which information is located in the worksheet

on the General page.

 

Worksheet Columns

The Worksheet Columns section of the General page contains options for specifying where information is located in the worksheet. The Worksheet Columns section is displayed when the Output type selection is Points.

 

Automatic Column Assignment

Voxler assigns the data columns automatically upon import. For Points data the X coordinates are assigned to the first column, Y coordinates are assigned to the second column, Z coordinates are assigned to the third column, and the remaining columns are assigned as component columns from left to right. It is unnecessary to reformat your data files in this order, as the coordinate and component columns can be manually specified in the Property Manager.

 

X, Y, and Z Coordinates

Select the column containing the X, Y, and Z coordinates in the X coordinates, Y coordinates, and Z coordinates fields respectively. Clicking the current selection in each of the fields opens a list of columns which contain data. If the data file contains a header row, the header for the column will be displayed after the column letter. For example with the GoldConcentration.dat sample file, Column A: X is one of the columns displayed in the list.

 

Components

The Components section contains options for specifying the number of components and in which column(s) the component data is located.

 

Specify the number of component columns by typing a value or clicking the buttons in the Component columns field. The Component columns value is limited by the number of columns in the data file.

 

Select the appropriate column for each component in the Component-1, Component-2, etc. fields. If the data file contains a header row, the header for the column will be displayed after the column letter. For example with the GoldConcentration.dat sample file, Column D: Gold Concentration is one of the columns displayed in the list. The header information is also passed to downstream modules, which makes selecting the desired component or coordinate column easier.

 

Labels

The Labels section contains options for specifying the number of label columns and which columns will be used for labels.

 

Specify the number of label columns by typing a value or clicking the buttons in the Label columns field. The Label columns value is limited by the number of columns in the data file.

 

Select the appropriate column for each component in the Label-1, Label-2, etc. fields. If the data file contains a header row, the header for the column will be displayed after the column letter. The header information is also passed to downstream modules, which makes selecting the desired label column easier.

 

General Page - Wells

The following options are displayed when the Output type is set to Wells.

 

Specify which well information is included in the worksheet

on the General page.

 

Well Columns

The Well Columns section of the General page contains options for specifying where information is located in the worksheet. The Well Columns section is displayed when the Output type selection is Wells.

 

Automatic Column Assignment

Voxler assigns the data columns automatically upon import. For Wells data the Sheet type property affects the automatic assignment. The automatic assignments are made in the column order, from left to right, specified by the table below. It is unnecessary to reformat your data files to match the following order, as the well data columns can be manually specified in the Property Manager.

 

Order

Collars

Directional Survey

From/To Logs

Logs/Curves

XYZ Path

1

Well Name (ID)

Well Name (ID)

Well Name (ID)

Well Name (ID)

Well Name (ID)

2

Top X (Easting)

Measured Depth

From

Measured Depth

Measured Depth

3

Top Y (Northing)

Azimuth

To

Log-1

X

4

Top Z (Elevation)

Inclination/Dip

Log-1

Log-2

Y

5

Azimuth

 

Log-2

 

Z

6

Dip/Inclination

 

 

 

 

7

Total Depth

 

 

 

 

 

 

 

Sheet Type

The Sheet type property simplifies the General page display by showing only the options pertaining to the selection. Select Collars, Directional Survey, From/To Logs, Logs/Curves, or XYZ Path from the Sheet type list if one of the options is appropriate for the data file. Select All in the Sheet type list to view all of the properties in the General page. The following table shows which properties are found under each Sheet type selection.

 

Sheet Type

Well Columns and Properties Displayed

Collars

Well Name (ID), Top X (Easting), Top Y (Northing), Top Z (Elevation), Azimuth, Vertical direction, Dip, Inclination, Total Depth

Directional Survey

Well Name (ID), Azimuth, Vertical direciton, Dip, Inclination, Measured Depth

From/To Logs

Well Name (ID), From, To, Log columns, Log-#

Logs/Curves

Well Name (ID), Measured Depth, Log columns, Log-#

XYZ Path

Well Name (ID), Measured Depth, Log columns, Log-#, X, Y, Z

 

 

Well Name (ID)

The column that contains the name assigned to a well. The well name is also referred to as Well ID or Borehole Name. The well name is a unique name assigned to each well. This name is used to connect data from multiple imports to the same well.

 

If the column containing the Well Name (ID) contains blanks, that well is not imported.

 

Collars

The Collars section contains the Top X (Easting), Top Y (Northing), and Top Z (Elevation) column options.

Orientation

The Orientation section contains the Azimuth, Dip, and Inclination column options and the Vertical direction property.

Depth

The Depth section contains the Total Depth and Measured Depth column options.

Measurements

The Measurements section contains the From, To, and Log-# column options and the Log columns property.

XYZ Path

The XYZ Path section contains the X, Y, and Z column options.

 

 

 

See Also

Point Source Modules

Point Source Geometry

Geometry Source Modules

Info Module

Lattice Source Modules

Source Modules

Connecting Modules

Introduction to Modules

File | Import